Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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