**wss 1/10/23

Used with ESM Cube drill down, when user requests more details on a general ledger account.  If the line item source is linked to a sub-system, the relationships defined here
are used to obtain the underlying source records

Header portion shows the high level relationship between General Ledger Actual to the sub-systems including Inventory, Payroll and Billing & Accounts receivable.
Please note some sites will have multiple instances of Inventory if they have difference inventory source tagging. (Stores, Pharmacy and so on)

Join conditions tell the system how data maps from the Table Lookup Table to the Subsystem Table. These must be fixed fields and cannot be formulas.

Minimum join conditions typically include a minimum of:
Cost Centre, Secondary, Period of activity (Which is both Fiscal year and GL period).   Any other fields provide more granular matching to the sub-system.