Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
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. Register now
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