| Entity Name | Attribute Names | Primary Key | Foreign Keys | Parent Business Rule |
| AccYear | ACONUM (PK) (FK) | ACONUM | ACONUM References: Company | An AccYear many GroupFiles. |
| AYEARNO (PK) | AYEARNO | An AccYear many ChartAcs. | ||
| AST_DATE | An AccYear many ActivityGroups. | |||
| AEN_DATE | An AccYear many Activitys. | |||
| An AccYear many SubLedgers. | ||||
| An AccYear many ItemSalesTaxs. | ||||
| An AccYear many Jobs. | ||||
| An AccYear many Items. | ||||
| An AccYear many Analysis. | ||||
| An AccYear many PurchOrders. | ||||
| An AccYear many PurchOrderLines. | ||||
| An AccYear many Receivings. | ||||
| An AccYear many ReceivingLines. | ||||
| An AccYear many PurchDebitNotes. | ||||
| An AccYear many PurchDebitLines. | ||||
| An AccYear many IssueJobs. | ||||
| An AccYear many IssueJobLines. | ||||
| An AccYear many JobReturns. | ||||
| An AccYear many JobRetLines. | ||||
| An AccYear many IssueSubConts. | ||||
| An AccYear many IssueSubLines. | ||||
| An AccYear many ItemsTags. | ||||
| An AccYear many SalesOrders. | ||||
| An AccYear many SalesOrderLines. | ||||
| An AccYear many SalesMemos. | ||||
| An AccYear many SalesSettleLines. | ||||
| An AccYear many SalesMemoLines. | ||||
| An AccYear many SalesCrNotes. | ||||
| An AccYear many SalesCrLines. | ||||
| An AccYear many SalesCrSettleLines. | ||||
| An AccYear many Vouchers. | ||||
| An AccYear many VoucherLines. | ||||
| Activity | ACCODE (PK) | ACCODE | ACONUM AYRNO References: AccYear | An Activity many PurchOrders. |
| ADESC | ASUBGRP References: ActivityGroup | An Activity many PurchOrderLines. | ||
| ABUDGDR | An Activity many Receivings. | |||
| ABUDGCR | An Activity many ReceivingLines. | |||
| AOPDR | An Activity many PurchDebitNotes. | |||
| AOPCR | An Activity many Vouchers. | |||
| ADR | An Activity many VoucherLines. | |||
| ACR | ||||
| ASUBGRP (FK) | ||||
| ACONUM (FK) | ||||
| AYRNO (FK) | ||||
| ALEVEL | ||||
| ActivityGroup | AGGRP (PK) | AGGRP | AGCONUM AGYRNO References: AccYear | An ActivityGroup many Activit(ies). |
| AGDESCRIBE | ||||
| AGDRBAL | ||||
| AGCRBAL | ||||
| AGCONUM (FK) | ||||
| AGYRNO (FK) | ||||
| AGLEVEL | ||||
| Analysis | ANALYS (PK) | ANALYS | ACONUM AYRNO References: AccYear | |
| ADESCRIBE | ||||
| ACONUM (FK) | ||||
| AYRNO (FK) | ||||
| CashRegs | REGNUM (PK) | REGNUM | RSHOP References: Shop | |
| RDESC | ||||
| RSHOP (FK) | ||||
| RSALES | ||||
| RLEVEL | ||||
| ChartAcs | GAC_HEAD (PK) (IE2) | GAC_HEAD | GCONUM GYRNO References: AccYear | A ChartAcs many SubLedgers. |
| GDESC | GSUBGRP References: GroupFile | A ChartAcs many Jobs. | ||
| GOPDR | A ChartAcs many Items. | |||
| GOPCR | A ChartAcs many Items. | |||
| GDR | A ChartAcs many Items. | |||
| GCR | A ChartAcs many SettleMents. | |||
| GBUDGDR | A ChartAcs many PurchOrders. | |||
| GBUDGCR | A ChartAcs many PurchOrderLines. | |||
| GGROUP (IE2) | A ChartAcs many Receivings. | |||
| GSUBYN | A ChartAcs many ReceivingLines. | |||
| GTYPE | A ChartAcs many PurchDebitNotes. | |||
| GSUBGRP (FK) | A ChartAcs many Vouchers. | |||
| GCONUM (FK) | A ChartAcs many VoucherLines. | |||
| GYRNO (FK) | A ChartAcs many VoucherLines. | |||
| GLEVEL | A ChartAcs many PSAllocations. | |||
| A ChartAcs many PSAllocLines. | ||||
| Company | CCONUM (PK) | CCONUM | A Company many AccYears. | |
| CCONAME | A Company many PWords. | |||
| CTYPE | A Company many ItemLocns. | |||
| CADD1 | A Company many ItemSections. | |||
| CADD2 | A Company many ItemGroups. | |||
| CCITY | A Company many ItemUnits. | |||
| CZIP | A Company many Prefers. | |||
| CSTATE | A Company many CustProfiles. | |||
| CREGION | A Company many CustPrefs. | |||
| CCOUNTRY | A Company many CustHistorys. | |||
| CLANG | A Company many PSAllocations. | |||
| CSECTOR | ||||
| CCOSHORT | ||||
| CLOCSTAX | ||||
| CSTSTAX | ||||
| CCTSTAX | ||||
| CITAX | ||||
| CESTAB | ||||
| CPHONE | ||||
| CFAX | ||||
| CEMAIL | ||||
| CWWW | ||||
| CCERT | ||||
| CustHistory | CPHONE (PK) (FK) | CPHONE | CPHONE References: CustProfile | |
| CMEMONO (PK) | CMEMONO | CCONUM References: Company | ||
| CDATE | PWUSER References: PWord | |||
| CAMT | ||||
| CENTRYDATE | ||||
| CENTRYBY | ||||
| CCONUM (FK) | ||||
| PWUSER (FK) | ||||
| CustPrefs | CPHONE (PK) (FK) | CPHONE | CPHONE References: CustProfile | |
| CPREFS (PK) (FK) | CPREFS | CPREFS References: Prefers | ||
| CNOTES | CCONUM References: Company | |||
| CENTRYDATE | PWUSER References: PWord | |||
| CENTRYBY | ||||
| CCONUM (FK) | ||||
| PWUSER (FK) | ||||
| CustProfile | CUSTPHONE (PK) | CUSTPHONE | CUSTNUM CACHEAD SubLedger | A CustProfile many CustPrefs. |
| CUSTNUM (FK) | CCONUM References: Company | A CustProfile many SalesOrders. | ||
| CACHEAD (FK) | A CustProfile many SalesMemos. | |||
| CNAME | A CustProfile many SalesMemoLines. | |||
| CGENDER | A CustProfile many CustHistorys. | |||
| CSPOUSE | ||||
| CDOB | ||||
| CANIVERS | ||||
| CADDRESS | ||||
| CADDRESS2 | ||||
| CCITY | ||||
| CSTATE | ||||
| CPOSTAL | ||||
| CCOUNTRY | ||||
| CEMAIL | ||||
| CMOBILE | ||||
| CWPHONE | ||||
| CBESTTIME | ||||
| CENTRYDATE | ||||
| CENTRYBY | ||||
| CCONUM (FK) | ||||
| Department | DNUM (PK) | DNUM | A Department many PurchOrders. | |
| DDESC | A Department many Receivings. | |||
| DADDRESS | A Department many IssueJobs. | |||
| DLEVEL | A Department many JobReturns. | |||
| A Department many IssueSubConts. | ||||
| A Department many SalesMemos. | ||||
| GroupFile | RSUBGRP (PK) | RSUBGRP | RCONUM RYRNO References: AccYear | A GroupFile many ChartAcs. |
| RDESCRIBE | ||||
| RDRBAL | ||||
| RCRBAL | ||||
| RCONUM (FK) | ||||
| RYRNO (FK) | ||||
| RLEVEL | ||||
| IssueJob | ISSNO (PK) | ISSNO | ISSJOB References: Jobs | A IssueJob many IssueJobLines. |
| ISSJOB (FK) | ISSDEPT References: Department | A IssueJob many JobReturns. | ||
| ISSWHOUSE (FK) | ISSWHOUSE References: Warehouse | A IssueJob many IssueSubLines. | ||
| ISSDEPT (FK) | ISCONUM ISYRNO References: AccYear | |||
| ISSDESC | PWUSER References: PWord | |||
| ISDATE | ||||
| IENTRYDATE | ||||
| IENTRYBY | ||||
| IMDFYDATE | ||||
| IMDFYBY | ||||
| ISNOTES | ||||
| ISHASH | ||||
| ISCONUM (FK) | ||||
| ISYRNO (FK) | ||||
| PWUSER (FK) | ||||
| ILEVEL | ||||
| IssueJobLines | ISSNO (PK) (FK) | ISSNO | ISITEM References: Items | |
| ISSEQ (PK) | ISSEQ | ISSNO References: IssueJob | ||
| ISDESC | ISCONUM ISYRNO References: AccYear | |||
| ISITEM (FK) | ||||
| ISQTY | ||||
| ISRATE | ||||
| ISAMT | ||||
| ISNOTES | ||||
| ISCONUM (FK) | ||||
| ISYRNO (FK) | ||||
| IssueSubCont | ISSNO (PK) | ISSNO | ISSUPP ISAC_HEAD References: SubLedger | |
| ISSDESC | ISSDEPT References: Department | |||
| ISAC_HEAD (FK) | ISSWHOUSE References: Warehouse | |||
| ISSUPP (FK) | ISCONUM ISYRNO References: AccYear | |||
| ISSHIP | PWUSER References: PWord | |||
| ISSWHOUSE (FK) | ||||
| ISSDEPT (FK) | ||||
| ISDATE | ||||
| ISRECDUE | ||||
| IENTRYDATE | ||||
| IENTRYBY | ||||
| IMDFYDATE | ||||
| IMDFYBY | ||||
| ISNOTES | ||||
| ISHASH | ||||
| ISCONUM (FK) | ||||
| ISYRNO (FK) | ||||
| PWUSER (FK) | ||||
| ILEVEL | ||||
| IssueSubLines | ISSNO (PK) (FK) | ISSNO | ISITEM References: Items | |
| ISSEQ (PK) | ISSEQ | ISSNO References: IssueJob | ||
| ISDESC | ISCONUM ISYRNO References: AccYear | |||
| ISITEM (FK) | ||||
| ISQTY | ||||
| ISRATE | ||||
| ISAMT | ||||
| ISNOTES | ||||
| ISCONUM (FK) | ||||
| ISYRNO (FK) | ||||
| ItemGroup | IGROUP (PK) | IGROUP | ICONUM References: Company | A ItemGroup many Items. |
| IGDESC | ||||
| IGOPVAL | ||||
| IGRCVAL | ||||
| IGISVAL | ||||
| ICONUM (FK) | ||||
| ILEVEL | ||||
| ItemLocn | LOCN (PK) | LOCN | LCONUM Company | A ItemLocn many ItemsTags. |
| LOCNDESC | ||||
| LAREA | ||||
| LCONUM (FK) | ||||
| LLEVEL | ||||
| Items | INAME (PK) (IE1) | INAME | ICONUM IYRNO References: AccYear | A Items many PurchOrderLines. |
| IDESC | IGROUP References: ItemGroup | A Items many ReceivingLines. | ||
| IGROUP (FK) (IE1) | ISALES References: ChartAcs | A Items many IssueJobLines. | ||
| IUOM (FK) | IPURCH References: ChartAcs | A Items many JobRetLines. | ||
| IPPRICE | ISTOCK References: ChartAcs | A Items many IssueSubLines. | ||
| ISPRICE1 | IUOM References: ItemUnits | A Items many ItemsTags. | ||
| ISPRICE2 | A Items many VoucherLines. | |||
| ISPRICE3 | ||||
| ISPRICE4 | ||||
| ISPRICE5 | ||||
| IOPQTY | ||||
| IRCQTY | ||||
| ISLQTY | ||||
| IOPVAL | ||||
| IRCVAL | ||||
| ISLVAL (IE2) | ||||
| ISALES (FK) | ||||
| IPURCH (FK) | ||||
| ISTOCK (FK) | ||||
| INETVAL | ||||
| ISLRATE | ||||
| IAVERATE | ||||
| IMINSTK | ||||
| ISAFESTK | ||||
| IRELVL | ||||
| IEOQ | ||||
| ILRDATE | ||||
| ILIDATE | ||||
| ICONUM (FK) | ||||
| IYRNO (FK) | ||||
| ILEVEL | ||||
| ItemSalesTax | STYPE (PK) | STYPE | SCONUM SYRNO References: AccYear | A ItemSalesTax many ItemsTags. |
| SDESC | ||||
| SPERC | ||||
| SCONUM (FK) | ||||
| SYRNO (FK) | ||||
| SLEVEL | ||||
| ItemSection | SECTION (PK) | SECTION | SCONUM References: Company | A ItemSection many ItemsTags. |
| SDESC | ||||
| SCONUM (FK) | ||||
| SLEVEL | ||||
| ItemsTag | TAGNO (PK) | TAGNO | TCONUM TYRNO References: AccYear | A ItemsTag many SalesMemoLines. |
| TRRNO (FK) | TRRNO References: Receiving | |||
| TRRSEQ | TITEM References: Items | |||
| TITEM (FK) | TSUPPLIER TAC_HEAD References: SubLedger | |||
| TSTAX (FK) | TUOM References: ItemUnits | |||
| TLOCN (FK) | TLOCN References: ItemLocn | |||
| TSECTION (FK) | TSECTION References: ItemSection | |||
| TUOM (FK) | TSTAX References: ItemSalesTax | |||
| TMAKE | ||||
| TMODEL | ||||
| TOPQTY | ||||
| TSOLDQTY | ||||
| TRETQTY | ||||
| TOPVAL | ||||
| TSPRICE1 | ||||
| TSPRICE2 | ||||
| TSPRICE3 | ||||
| TSPRICE4 | ||||
| TSPRICE5 | ||||
| TRECDATE | ||||
| TISSDATE | ||||
| TRETDATE | ||||
| TAC_HEAD (FK) | ||||
| TSUPPLIER (FK) | ||||
| TDOC | ||||
| TRETDOC | ||||
| TCONUM (FK) | ||||
| TYRNO (FK) | ||||
| ItemUnits | UNAME (PK) | UNAME | UCONUM References: Company | A ItemUnits many Items. |
| UDESC | A ItemUnits many ItemsTags. | |||
| UCONV | ||||
| UFACTOR | ||||
| UCONUM (FK) | ||||
| ULEVEL | ||||
| JobRetLines | JRNO (PK) (FK) | JRNO | JRITEM References: Items | |
| JRSEQ (PK) | JRSEQ | JRNO References: JobReturn | ||
| JRDESC | JRCONUM JRYRNO References: AccYear | |||
| JRITEM (FK) | ||||
| JRQTY | ||||
| JRRATE | ||||
| JRAMT | ||||
| JRNOTES | ||||
| JRCONUM (FK) | ||||
| JRYRNO (FK) | ||||
| JobReturn | JRNO (PK) | JRNO | JRISSNO References: IssueJob | A JobReturn many JobRetLines. |
| JRISSNO (FK) | JOB References: Jobs | |||
| JOB (FK) | JDEPT References: Department | |||
| JWHOUSE (FK) | JWHOUSE References: Warehouse | |||
| JDEPT (FK) | JRCONUM JRYRNO References: AccYear | |||
| JDESC | PWUSER References: PWord | |||
| JDATE | ||||
| JENTRYDATE | ||||
| JENTRYBY | ||||
| JMDFYDATE | ||||
| JMDFYBY | ||||
| JRHASH | ||||
| JRNOTES | ||||
| JRCONUM (FK) | ||||
| JRYRNO (FK) | ||||
| PWUSER (FK) | ||||
| JLEVEL | ||||
| Jobs | JOBNUM (PK) | JOBNUM | JAC_HEAD References: ChartAcs | A Jobs many IssueJobs. |
| JOBDESC | JCONUM JYRNO References: AccYear | A Jobs many JobReturns. | ||
| JDRAWNO | ||||
| JAC_HEAD (FK) | ||||
| JOPVAL | ||||
| JRCVAL | ||||
| JRDVAL | ||||
| JCONUM (FK) | ||||
| JYRNO (FK) | ||||
| JLEVEL | ||||
| Originate | ONO (PK) | ONO | A Originate many SalesOrders. | |
| OWHERE | ||||
| Prefers | PREFNO (PK) | PREFNO | PCONUM References: Company | A Prefers many CustPrefs. |
| PDESC | ||||
| PGENDER | ||||
| PCONUM (FK) | ||||
| PSAllocation | PAACHEAD (PK) (FK) | PAACHEAD | PAACHEAD References: ChartAcs | A PSAllocation many PSAllocLines. |
| PASUPP (PK) (FK) | PASUPP | PASUPP PAACHEAD References: SubLedger | ||
| PAINVOICE (PK) | PAINVOICE | PACONUM References: Company | ||
| PAVCHRNUM | ||||
| PADATE | ||||
| PASTATUS | ||||
| PACONUM (FK) | ||||
| PSAllocLines | PAACHEAD (PK) (FK) | PAACHEAD | PAACHEAD References: ChartAcs | |
| PAACHEAD (PK) (FK) | PAACHEAD | PASUPP PAACHEAD References: SubLedger | ||
| PASUPP (PK) (FK) | PASUPP | PVCHRNUM References: Vouchers | ||
| PASUPP (PK) (FK) | PASUPP | PAACHEAD PASUPP PAINVOICE References: PSAllocation | ||
| PAINVOICE (PK) (FK) | PAINVOICE | |||
| PSEQ (PK) | PSEQ | |||
| PVCHRNUM (FK) | ||||
| PDATE | ||||
| PDR | ||||
| PCR | ||||
| PACONUM | ||||
| PurchDebitLines | DLNOTE (PK) (FK) | DLNOTE | DLNOTE References: PurchDebitNote | |
| DLSEQ (PK) | DLSEQ | DLPNO DLPSEQNO References: PurchOrderLines | ||
| DLPNO (FK) | DLRRNO DLRRSEQ References: ReceivingLines | |||
| DLPSEQNO (FK) | DCONUM DYRNO References: AccYear | |||
| DLRRNO (FK) | ||||
| DLRRSEQ (FK) | ||||
| DLITEM | ||||
| DLQTYORD | ||||
| DLQTYREC | ||||
| DLQTYRET | ||||
| DLRATE | ||||
| DLAMT | ||||
| DCONUM (FK) | ||||
| DYRNO (FK) | ||||
| PurchDebitNote | DNOTE (PK) | DNOTE | DRRNO References: Receiving | A PurchDebitNote many PurchDebitLines. |
| DRRNO (FK) | DNACHEAD References: ChartAcs | |||
| DDATE | DRRSUP DNACHEAD References: SubLedger | |||
| DRRDATE | DNACTIVITY References: Activity | |||
| DRRPONO | DCONUM DYRNO References: AccYear | |||
| DRRWHOUSE | PWUSER References: PWord | |||
| DRRDEPT | ||||
| DRRSUP (FK) | ||||
| DNACHEAD (FK) | ||||
| DNACTIVITY (FK) | ||||
| DRRAMT | ||||
| DENTRYBY | ||||
| DRNOTES | ||||
| DCONUM (FK) | ||||
| PWUSER (FK) | ||||
| DYRNO (FK) | ||||
| PurchOrder | PONUM (PK) (IE1) | PONUM | PODEPT References: Department | A PurchOrder many PurchOrderLines. |
| PODATE | POWHOUSE References: Warehouse | A PurchOrder many Receivings. | ||
| POWHOUSE (FK) | PCONUM PYRNO References: AccYear | |||
| PODEPT (FK) | POACHEAD References: ChartAcs | |||
| POACHEAD (FK) | POSUPP POACHEAD References: SubLedger | |||
| POSUPP (FK) (IE1) | POACTIVITY References: Activity | |||
| POACTIVITY (FK) | PWUSER References: PWord | |||
| PODETAIL | ||||
| POSHIP | ||||
| PODUEON | ||||
| PENTRYDATE | ||||
| PENTRYBY | ||||
| PMDFYDATE | ||||
| PMDFYBY | ||||
| PONOTES | ||||
| POTAMT | ||||
| PCONUM (FK) | ||||
| PYRNO (FK) | ||||
| PRECV | ||||
| PLEVEL | ||||
| PWUSER (FK) | ||||
| PurchOrderLines | POLNUM (PK) (FK) (IE1) | POLNUM | POAC_HEAD References: ChartAcs | A PurchOrderLines many ReceivingLines. |
| POSEQ (PK) | POSEQ | POSUPP POAC_HEAD References: SubLedger | A PurchOrderLines many PurchDebitLines. | |
| PODATE | POACTIVITY References: Activity | |||
| POSUPP (FK) (IE2 IE1) | POLNUM References: PurchOrder | |||
| POAC_HEAD (FK) | POITEM References: Items | |||
| POACTIVITY (FK) | PCONUM PYRNO References: AccYear | |||
| POITEM (FK) (IE2) | ||||
| POQTY | ||||
| PORATE | ||||
| POAMT | ||||
| PONOTES | ||||
| PRECV | ||||
| PCONUM (FK) | ||||
| PYRNO (FK) | ||||
| PWord | PWUSER (PK) | PWUSER | PWCONUM References: Company | A PWord many PurchOrders. |
| PWWORD | A PWord many Receivings. | |||
| USERNAME | A PWord many PurchDebitNotes. | |||
| PWLEVEL | A PWord many IssueJobs. | |||
| PWCONUM (FK) | A PWord many JobReturns. | |||
| A PWord many IssueSubConts. | ||||
| A PWord many CustPrefs. | ||||
| A PWord many SalesOrders. | ||||
| A PWord many SalesMemos. | ||||
| A PWord many SalesCrNotes. | ||||
| A PWord many CustHistorys. | ||||
| A PWord many Vouchers. | ||||
| Receiving | RRNO (PK) | RRNO | RRPONO References: PurchOrder | A Receiving many ReceivingLines. |
| RRPONO (FK) | RRDEPT References: Department | A Receiving many PurchDebitNotes. | ||
| RRPODATE | RRWHOUSE References: Warehouse | A Receiving many ItemsTags. | ||
| RRWHOUSE (FK) | RRACHEAD References: ChartAcs | |||
| RRDEPT (FK) | RRSUPP RRACHEAD References: SubLedger | |||
| RRDATE | RRACTIVITY References: Activity | |||
| RRPAYDUE | RCONUM RYRNO References: AccYear | |||
| RRINVOICE | PWUSER References: PWord | |||
| RRVOUCHER | ||||
| RRSUPP (FK) | ||||
| RRACHEAD (FK) | ||||
| RRACTIVITY (FK) | ||||
| RRDETAIL | ||||
| RRSHIP | ||||
| RENTRYDATE | ||||
| RENTRYBY | ||||
| RMDFYDATE | ||||
| RMDFYBY | ||||
| RRTAMT | ||||
| RRNOTES | ||||
| RCONUM (FK) | ||||
| RYRNO (FK) | ||||
| RLEVEL | ||||
| PWUSER (FK) | ||||
| ReceivingLines | RRLNO (PK) (FK) | RRLNO | RRAC_HEAD References: ChartAcs | A ReceivingLines many PurchDebitLines. |
| RRSEQ (PK) | RRSEQ | RRSUPP RRAC_HEAD References: SubLedger | ||
| RRPONO (FK) | RRACTIVITY References: Activity | |||
| RRPOSEQ (FK) | RRLNO References: Receiving | |||
| RRINVOICE | RRPONO RRPOSEQ References: PurchOrderLines | |||
| RRVOUCHER | RRITEM References: Items | |||
| RRDATE | RCONUM RYRNO References: AccYear | |||
| RRAC_HEAD (FK) | ||||
| RRACTIVITY (FK) | ||||
| RRSUPP (FK) | ||||
| RRITEM (FK) | ||||
| RRQTYORDER | ||||
| RRQTYRECD | ||||
| RRQTYSHORT | ||||
| RRQTYRET | ||||
| RRRATE | ||||
| RRAMT | ||||
| RRMARKUP | ||||
| RRSRATE | ||||
| RRNOTES | ||||
| RCONUM (FK) | ||||
| RYRNO (FK) | ||||
| SalesCrLines | CLNOTE (PK) (FK) | CLNOTE | CLNOTE References: SalesMemo | |
| CLSEQ (PK) | CLSEQ | CSLNO CSLSEQ References: SalesMemoLines | ||
| CSLNO (FK) | CCONUM CYRNO References: AccYear | |||
| CSLSEQ (FK) | ||||
| CLTAGNO | ||||
| CLQTY | ||||
| CLRATE | ||||
| CLAMT | ||||
| CLTAX | ||||
| CLDISC | ||||
| CLGROSS | ||||
| CCONUM (FK) | ||||
| CYRNO (FK) | ||||
| SalesCrNote | CNOTE (PK) | CNOTE | CMEMONO References: SalesMemo | |
| CMEMONO (FK) | CCONUM CYRNO References: AccYear | |||
| CMEMDATE | PWUSER References: PWord | |||
| CDATE | ||||
| CCUST | ||||
| CENTRYDATE | ||||
| CENTRYBY | ||||
| CCONUM (FK) | ||||
| PWUSER (FK) | ||||
| CYRNO (FK) | ||||
| SalesCrSettleLines | CLNOTE (PK) (FK) | CLNOTE | CLNOTE References: SalesMemo | |
| CLSEQ (PK) | CLSEQ | CSLNO CSLSEQ References: SalesSettleLines | ||
| CSLNO (FK) | CCONUM CYRNO References: AccYear | |||
| CSLSEQ (FK) | ||||
| CLSETTLE | ||||
| CCHECKNO | ||||
| CROUTING | ||||
| CCARDNO | ||||
| CAUTHORZ | ||||
| CEXPMM | ||||
| CEXPYR | ||||
| CLAMT | ||||
| CCONUM (FK) | ||||
| CYRNO (FK) | ||||
| SalesMemo | MEMONO (PK) | MEMONO | MDEPT References: Department | A SalesMemo many SalesSettleLines. |
| MCUST (FK) | MCUST References: CustProfile | A SalesMemo many SalesMemoLines. | ||
| MSORDER | MSHOPNO References: Shop | A SalesMemo many SalesCrNotes. | ||
| MDATE | MCONUM MYRNO References: AccYear | A SalesMemo many SalesCrLines. | ||
| MCASHADV | PWUSER References: PWord | A SalesMemo many SalesCrSettleLines. | ||
| MTAMT | ||||
| MENTRYDATE | ||||
| MENTRYBY | ||||
| MMDFYDATE | ||||
| MMDFYBY | ||||
| MNOTES | ||||
| MSHOPNO (FK) | ||||
| MDEPT (FK) | ||||
| MREGNO | ||||
| MCONUM (FK) | ||||
| MYRNO (FK) | ||||
| PWUSER (FK) | ||||
| MLEVEL | ||||
| SalesMemoLines | MEMOLNO (PK) (FK) | MEMOLNO | MEMOLNO References: SalesMemo | A SalesMemoLines many SalesCrLines. |
| MEMOSEQ (PK) | MEMOSEQ | MTAGNO References: ItemsTag | ||
| MCUST (FK) | MCUST References: CustProfile | |||
| MTAGNO (FK) | MCONUM MYRNO References: AccYear | |||
| MUOM | ||||
| MQTY | ||||
| MRATE | ||||
| MSTAX | ||||
| MDISC | ||||
| MAMT | ||||
| MDELIVRD | ||||
| MSHIPADDR1 | ||||
| MSHIPADDR2 | ||||
| MSHIPCITY | ||||
| MSHIPSTATE | ||||
| MSHIPZIP | ||||
| MSHIPCNTY | ||||
| MSHIPPHONE | ||||
| MCONUM (FK) | ||||
| MYRNO (FK) | ||||
| SalesOrder | SONO (PK) | SONO | SCUST References: CustProfile | |
| SORIGIN (FK) | SORIGIN References: Originate | |||
| SCUST (FK) | SCONUM SYRNO References: AccYear | |||
| SDATE | SSETTLE References: SettleMent | |||
| SSETTLE (FK) | PWUSER References: PWord | |||
| SCHECKNO | ||||
| SROUTING | ||||
| SCARDNO | ||||
| SAUTHORZ | ||||
| SEXPMM | ||||
| SEXPYR | ||||
| SBILLADDR1 | ||||
| SBILLADDR2 | ||||
| SBILLCITY | ||||
| SBILLSTATE | ||||
| SBILLZIP | ||||
| SBILLCNTY | ||||
| SBILLPHONE | ||||
| SCONUM (FK) | ||||
| SYRNO (FK) | ||||
| SENTRYDATE | ||||
| PWUSER (FK) | ||||
| SENTRYBY | ||||
| SalesOrderLines | SONO | SCONUM SYRNO References: AccYear | ||
| SSEQ | ||||
| SCUST | ||||
| SDATE | ||||
| STAGNO | ||||
| SUOM | ||||
| SQTY | ||||
| SRATE | ||||
| SSTAX | ||||
| SDISC | ||||
| SAMT | ||||
| SSHIPADDR1 | ||||
| SSHIPADDR2 | ||||
| SSHIPCITY | ||||
| SSHIPSTATE | ||||
| SSHIPZIP | ||||
| SSHIPCNTY | ||||
| SSHIPPHONE | ||||
| SCONUM (FK) | ||||
| SYRNO (FK) | ||||
| SENTRYDATE | ||||
| SENTRYBY | ||||
| SalesSettleLines | MEMOSNO (PK) (FK) | MEMOSNO | MEMOSNO References: SalesMemo | A SalesSettleLines many SalesCrSettleLines. |
| MEMOSEQ (PK) | MEMOSEQ | MSETTLE References: SettleMent | ||
| MPREFS | MCONUM MYRNO References: AccYear | |||
| MSETTLE (FK) | ||||
| MCHECKNO | ||||
| MROUTING | ||||
| MCARDNO | ||||
| MAUTHORZ | ||||
| MEXPMM | ||||
| MEXPYR | ||||
| MAMT | ||||
| MBILLADDR1 | ||||
| MBILLADDR2 | ||||
| MBILLCITY | ||||
| MBILLSTATE | ||||
| MBILLZIP | ||||
| MBILLCNTY | ||||
| MBILLPHONE | ||||
| MCONUM (FK) | ||||
| MYRNO (FK) | ||||
| SettleMent | STYPE (PK) | STYPE | SAC_HEAD References: ChartAcs | A SettleMent many SalesOrders. |
| SDESC | A SettleMent many SalesSettleLines. | |||
| SPERC | ||||
| SAC_HEAD (FK) | ||||
| SSALES | ||||
| SLEVEL | ||||
| Shop | SHOPNUM (PK) | SHOPNUM | A Shop many CashRegs. | |
| SDESC | A Shop many SalesMemos. | |||
| SADDRESS | ||||
| SPHONE | ||||
| SFAX | ||||
| SMANAGER | ||||
| SSALES | ||||
| SLEVEL | ||||
| SubLedger | SNAME (PK) | SNAME | SCONUM SYRNO References: AccYear | A SubLedger many CustProfiles. |
| SAC_HEAD (PK) (FK) | SAC_HEAD | SAC_HEAD References: ChartAcs | A SubLedger many PurchOrders. | |
| SDESC | A SubLedger many PurchOrderLines. | |||
| SADD1 | A SubLedger many Receivings. | |||
| SADD2 | A SubLedger many ReceivingLines. | |||
| SCITY | A SubLedger many PurchDebitNotes. | |||
| SSTATE | A SubLedger many IssueSubConts. | |||
| SZIP | A SubLedger many ItemsTags. | |||
| SFAX | A SubLedger many Vouchers. | |||
| SLTAXNO | A SubLedger many VoucherLines. | |||
| SSTAXNO | A SubLedger many PSAllocations. | |||
| SCTAXNO | A SubLedger many PSAllocLines. | |||
| SCONTACT | ||||
| SPHONE | ||||
| SEMAIL | ||||
| SOPDR | ||||
| SOPCR | ||||
| SDR | ||||
| SCR | ||||
| SCONUM (FK) | ||||
| SYRNO (FK) | ||||
| SLEVEL | ||||
| VoucherLines | VLRNO (PK) (FK) (IE9 IE8 IE7 IE6 IE5) | VLRNO | VCONUM VYRNO References: AccYear | |
| VLSEQ (PK) (IE5) | VLSEQ | VLRNO References: Vouchers | ||
| VLTYPE | VAC_HEAD References: ChartAcs | |||
| VLINVNO | VACTIVITY References: Activity | |||
| VLDATE (IE9 IE8 IE7 IE6 IE5 IE4) | VBKREF References: ChartAcs | |||
| VAC_HEAD (FK) (IE6 IE2) | VSUBLED VAC_HEAD References: SubLedger | |||
| VACTIVITY (FK) | VITEM References: Items | |||
| VDR | ||||
| VCR | ||||
| VSUBLED (FK) (IE7 IE2) | ||||
| VITEM (FK) (IE8) | ||||
| VRATE | ||||
| VQNTY | ||||
| VANALYS (IE10 IE9) | ||||
| VBKREF (FK) | ||||
| VCONUM (FK) | ||||
| VYRNO (FK) | ||||
| Vouchers | VRNO (PK) (IE2 IE1) | VRNO | VCONUM VYRNO References: AccYear | A Vouchers many VoucherLines. |
| VTYPE (IE2 IE1) | VBKREF References: ChartAcs | A Vouchers many PSAllocLines. | ||
| VDATE (IE1) | VACTIVITY References: Activity | |||
| VCHECK | VSUBREF VBKREF References: SubLedger | |||
| VDETAILS | PWUSER References: PWord | |||
| VNARRATION | ||||
| VINVNO | ||||
| VIDATE | ||||
| VDELYNOTE | ||||
| VORDER | ||||
| VCDR | ||||
| VCCR | ||||
| VBKREF (FK) | ||||
| VSUBREF (FK) | ||||
| VACTIVITY (FK) | ||||
| VENTRYBY | ||||
| VMDFYDATE | ||||
| VMDFYBY | ||||
| VCONUM (FK) | ||||
| PWUSER (FK) | ||||
| VYRNO (FK) | ||||
| Warehouse | WNUM (PK) | WNUM | A Warehouse many PurchOrders. | |
| WDESC | A Warehouse many Receivings. | |||
| WADDRESS | A Warehouse many IssueJobs. | |||
| WLEVEL | A Warehouse many JobReturns. | |||
| A Warehouse many IssueSubConts. | ||||