Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
SuiteQL: Are nextTransactionLineLink and previousTransactionLineLink tables identical or different?
I've run the following queries:
select * from previoustransactionlinelink
where nextdoc = 278091;
Result:
{
"links": [],
"foreignamount": "5.44",
"lastmodifieddate": "3/31/2021",
"linktype": "Payment",
"nextdoc": "278091",
"nextline": "1",
"nexttype": "CustPymt",
"previousdoc": "443422",
"previousline": "1",
"previoustype": "Journal"
},
{
"links": [],
"foreignamount": "112.75",
"lastmodifieddate": "10/12/2020",
"linktype": "Payment",
"nextdoc": "278091",
"nextline": "1",
"nexttype": "CustPymt",
"previousdoc": "222466",
"previousline": "0",
"previoustype": "CustInvc"
}
select * from nexttransactionlinelink
where nextdoc = 278091;
Result:
{
"links": [],
"foreignamount": "112.75",
"lastmodifieddate": "10/12/2020",
"linktype": "Payment",
"nextdoc": "278091",
"nextline": "1",
"nexttype": "CustPymt",
"previousdoc": "222466",
"previousline": "0",
"previoustype": "CustInvc"
}
Does anyone know why the 112.75 link appears in both tables, but the 5.44 link only appears in previoustransactionlinelink? I was previously under the impression that the two tables were essentially identical, and that you could use either. However it doesnt seem to be this way