by Mike.Sheen » Thu Sep 28, 2017 2:16 pm
CR_BatchPayLines.CR_TransID -> CR_Trans.TransID
then CR_Trans.SourceID links to different tables, depending on the CR_Trans.Source:
For example, when CR_Trans.Source == "Creditor Sourced Purchase"
then CR_Trans.SourceID -> CR_BatchTranLines.ReceiptLineID, CR_BatchTranLines.JB_JobStages_RecID -> JB_JobStages.RecID, JB_JobStages.JB_Stages_RecID -> JB_Stages.RecID and so on.
Make sense?
Mike Sheen
Chief Software Engineer
Jiwa Financials
If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution