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