An Data Entity Diagram or an Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system.
The below ER diagram illustrates how different Data Sets that are available for you to download relate to each other.
Relationship between the datasets are as following -
1. Purchase Orders[PurchId] -- Purchase Order Lines[PurchId]
2. Purchase Order Lines[SourceDocumentLine] -- Accounting Distribution[SourceDocumentLine]
3. Vendor Invoices[SourceDocumentHeader] -- Accounting Distribution[SourceDocumentHeader]
4. Vendor Invoices[LedgerVoucher] -- Vendor Payments[Voucher]
5. Vendors[AccountNum] -- Vendor Payments[AccountNum]
6. Main Accounts[Account Id] -- Expenditure[MainAccountId]
7. Main Accounts[Account Id] -- Revenue[MainAccountId]
8. Funds[FundName] -- Expenditure[FundName]
9. Funds[FundName] -- Revenue[FundName]