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