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 |