| Entity Name | Primary Key | Child Business Rule |
| AccYear | ACONUM | An AccYear is associated with exactly one Company. |
| AYEARNO | ||
| Activity | ACCODE | An Activity is associated with exactly one AccYear. |
| An Activity is associated with exactly one ActivityGroup. | ||
| ActivityGroup | AGGRP | An ActivityGroup is associated with exactly one AccYear. |
| Analysis | ANALYS | An Analysis is associated with exactly one AccYear. |
| CashRegs | REGNUM | A CashRegs is associated with exactly one Shop. |
| ChartAcs | GAC_HEAD | A ChartAcs is associated with exactly one AccYear. |
| A ChartAcs is associated with exactly one GroupFile. | ||
| Company | CCONUM | |
| CustHistory | CPHONE | A CustHistory is associated with exactly one CustProfile. |
| CMEMONO | A CustHistory is associated with exactly one Company. | |
| A CustHistory is associated with exactly one PWord. | ||
| CustPrefs | CPHONE | A CustPrefs is associated with exactly one CustProfile. |
| CPREFS | A CustPrefs is associated with exactly one Prefers. | |
| A CustPrefs is associated with exactly one Company. | ||
| A CustPrefs is associated with exactly one PWord. | ||
| CustProfile | CUSTPHONE | A CustProfile is associated with zero or one SubLedgers. |
| A CustProfile is associated with exactly one Company. | ||
| Department | DNUM | |
| GroupFile | RSUBGRP | A GroupFile is associated with exactly one AccYear. |
| IssueJob | ISSNO | A IssueJob is associated with exactly one Jobs. |
| A IssueJob is associated with exactly one Department. | ||
| A IssueJob is associated with exactly one Warehouse. | ||
| A IssueJob is associated with exactly one AccYear. | ||
| A IssueJob is associated with exactly one PWord. | ||
| IssueJobLines | ISSNO | A IssueJobLines is associated with zero or one Items. |
| ISSEQ | A IssueJobLines is associated with exactly one IssueJob. | |
| A IssueJobLines is associated with exactly one AccYear. | ||
| IssueSubCont | ISSNO | A IssueSubCont is associated with exactly one SubLedger. |
| A IssueSubCont is associated with exactly one Department. | ||
| A IssueSubCont is associated with exactly one Warehouse. | ||
| A IssueSubCont is associated with exactly one AccYear. | ||
| A IssueSubCont is associated with exactly one PWord. | ||
| IssueSubLines | ISSNO | A IssueSubLines is associated with zero or one Items. |
| ISSEQ | A IssueSubLines is associated with exactly one IssueJob. | |
| A IssueSubLines is associated with exactly one AccYear. | ||
| ItemGroup | IGROUP | A ItemGroup is associated with exactly one Company. |
| ItemLocn | LOCN | A ItemLocn is associated with exactly one Company. |
| Items | INAME | A Items is associated with exactly one AccYear. |
| A Items is associated with exactly one ItemGroup. | ||
| A Items is associated with exactly one ChartAcs. | ||
| A Items is associated with exactly one ChartAcs. | ||
| A Items is associated with exactly one ChartAcs. | ||
| A Items is associated with exactly one ItemUnits. | ||
| ItemSalesTax | STYPE | A ItemSalesTax is associated with exactly one AccYear. |
| ItemSection | SECTION | A ItemSection is associated with exactly one Company. |
| ItemsTag | TAGNO | A ItemsTag is associated with exactly one AccYear. |
| A ItemsTag is associated with exactly one Receiving. | ||
| A ItemsTag is associated with exactly one Items. | ||
| A ItemsTag is associated with zero or one SubLedgers. | ||
| A ItemsTag is associated with zero or one ItemUnits. | ||
| A ItemsTag is associated with exactly one ItemLocn. | ||
| A ItemsTag is associated with exactly one ItemSection. | ||
| A ItemsTag is associated with exactly one ItemSalesTax. | ||
| ItemUnits | UNAME | A ItemUnits is associated with exactly one Company. |
| JobRetLines | JRNO | A JobRetLines is associated with zero or one Items. |
| JRSEQ | A JobRetLines is associated with exactly one JobReturn. | |
| A JobRetLines is associated with exactly one AccYear. | ||
| JobReturn | JRNO | A JobReturn is associated with exactly one IssueJob. |
| A JobReturn is associated with exactly one Jobs. | ||
| A JobReturn is associated with exactly one Department. | ||
| A JobReturn is associated with exactly one Warehouse. | ||
| A JobReturn is associated with exactly one AccYear. | ||
| A JobReturn is associated with exactly one PWord. | ||
| Jobs | JOBNUM | A Jobs is associated with exactly one ChartAcs. |
| A Jobs is associated with exactly one AccYear. | ||
| Originate | ONO | |
| Prefers | PREFNO | A Prefers is associated with exactly one Company. |
| PSAllocation | PAACHEAD | A PSAllocation is associated with exactly one ChartAcs. |
| PASUPP | A PSAllocation is associated with exactly one SubLedger. | |
| PAINVOICE | A PSAllocation is associated with exactly one Company. | |
| PSAllocLines | PAACHEAD | A PSAllocLines is associated with exactly one ChartAcs. |
| PAACHEAD | A PSAllocLines is associated with exactly one SubLedger. | |
| PASUPP | A PSAllocLines is associated with exactly one Vouchers. | |
| PASUPP | A PSAllocLines is associated with exactly one PSAllocation. | |
| PAINVOICE | ||
| PSEQ | ||
| PurchDebitLines | DLNOTE | A PurchDebitLines is associated with exactly one PurchDebitNote. |
| DLSEQ | A PurchDebitLines is associated with exactly one PurchOrderLines. | |
| A PurchDebitLines is associated with zero or one ReceivingLines. | ||
| A PurchDebitLines is associated with exactly one AccYear. | ||
| PurchDebitNote | DNOTE | A PurchDebitNote is associated with exactly one Receiving. |
| A PurchDebitNote is associated with exactly one ChartAcs. | ||
| A PurchDebitNote is associated with zero or one SubLedgers. | ||
| A PurchDebitNote is associated with exactly one Activity. | ||
| A PurchDebitNote is associated with exactly one AccYear. | ||
| A PurchDebitNote is associated with exactly one PWord. | ||
| PurchOrder | PONUM | A PurchOrder is associated with exactly one Department. |
| A PurchOrder is associated with exactly one Warehouse. | ||
| A PurchOrder is associated with exactly one AccYear. | ||
| A PurchOrder is associated with exactly one ChartAcs. | ||
| A PurchOrder is associated with exactly one SubLedger. | ||
| A PurchOrder is associated with exactly one Activity. | ||
| A PurchOrder is associated with exactly one PWord. | ||
| PurchOrderLines | POLNUM | A PurchOrderLines is associated with exactly one ChartAcs. |
| POSEQ | A PurchOrderLines is associated with exactly one SubLedger. | |
| A PurchOrderLines is associated with exactly one Activity. | ||
| A PurchOrderLines is associated with exactly one PurchOrder. | ||
| A PurchOrderLines is associated with exactly one Items. | ||
| A PurchOrderLines is associated with exactly one AccYear. | ||
| PWord | PWUSER | A PWord is associated with exactly one Company. |
| Receiving | RRNO | A Receiving is associated with exactly one PurchOrder. |
| A Receiving is associated with exactly one Department. | ||
| A Receiving is associated with exactly one Warehouse. | ||
| A Receiving is associated with exactly one ChartAcs. | ||
| A Receiving is associated with exactly one SubLedger. | ||
| A Receiving is associated with exactly one Activity. | ||
| A Receiving is associated with exactly one AccYear. | ||
| A Receiving is associated with exactly one PWord. | ||
| ReceivingLines | RRLNO | A ReceivingLines is associated with exactly one ChartAcs. |
| RRSEQ | A ReceivingLines is associated with exactly one SubLedger. | |
| A ReceivingLines is associated with exactly one Activity. | ||
| A ReceivingLines is associated with exactly one Receiving. | ||
| A ReceivingLines is associated with zero or one PurchOrderLines. | ||
| A ReceivingLines is associated with zero or one Items. | ||
| A ReceivingLines is associated with exactly one AccYear. | ||
| SalesCrLines | CLNOTE | A SalesCrLines is associated with exactly one SalesMemo. |
| CLSEQ | A SalesCrLines is associated with zero or one SalesMemoLines. | |
| A SalesCrLines is associated with exactly one AccYear. | ||
| SalesCrNote | CNOTE | A SalesCrNote is associated with exactly one SalesMemo. |
| A SalesCrNote is associated with exactly one AccYear. | ||
| A SalesCrNote is associated with exactly one PWord. | ||
| SalesCrSettleLines | CLNOTE | A SalesCrSettleLines is associated with exactly one SalesMemo. |
| CLSEQ | A SalesCrSettleLines is associated with zero or one SalesSettleLines. | |
| A SalesCrSettleLines is associated with exactly one AccYear. | ||
| SalesMemo | MEMONO | A SalesMemo is associated with exactly one Department. |
| A SalesMemo is associated with zero or one CustProfiles. | ||
| A SalesMemo is associated with exactly one Shop. | ||
| A SalesMemo is associated with exactly one AccYear. | ||
| A SalesMemo is associated with exactly one PWord. | ||
| SalesMemoLines | MEMOLNO | A SalesMemoLines is associated with exactly one SalesMemo. |
| MEMOSEQ | A SalesMemoLines is associated with zero or one ItemsTags. | |
| A SalesMemoLines is associated with zero or one CustProfiles. | ||
| A SalesMemoLines is associated with exactly one AccYear. | ||
| SalesOrder | SONO | A SalesOrder is associated with exactly one CustProfile. |
| A SalesOrder is associated with exactly one Originate. | ||
| A SalesOrder is associated with exactly one AccYear. | ||
| A SalesOrder is associated with exactly one SettleMent. | ||
| A SalesOrder is associated with exactly one PWord. | ||
| SalesOrderLines | A SalesOrderLines is associated with exactly one AccYear. | |
| SalesSettleLines | MEMOSNO | A SalesSettleLines is associated with exactly one SalesMemo. |
| MEMOSEQ | A SalesSettleLines is associated with exactly one SettleMent. | |
| A SalesSettleLines is associated with exactly one AccYear. | ||
| SettleMent | STYPE | A SettleMent is associated with exactly one ChartAcs. |
| Shop | SHOPNUM | |
| SubLedger | SNAME | A SubLedger is associated with exactly one AccYear. |
| SAC_HEAD | A SubLedger is associated with exactly one ChartAcs. | |
| VoucherLines | VLRNO | A VoucherLines is associated with exactly one AccYear. |
| VLSEQ | A VoucherLines is associated with exactly one Vouchers. | |
| A VoucherLines is associated with exactly one ChartAcs. | ||
| A VoucherLines is associated with exactly one Activity. | ||
| A VoucherLines is associated with exactly one ChartAcs. | ||
| A VoucherLines is associated with zero or one SubLedgers. | ||
| A VoucherLines is associated with zero or one Items. | ||
| Vouchers | VRNO | A Vouchers is associated with exactly one AccYear. |
| A Vouchers is associated with zero or one ChartAcs. | ||
| A Vouchers is associated with exactly one Activity. | ||
| A Vouchers is associated with zero or one SubLedgers. | ||
| A Vouchers is associated with exactly one PWord. | ||
| Warehouse | WNUM | |