用友几个数据表对照关系(UF several data tables contrast).doc
文本预览下载声明
用友几个数据表对照关系(UF several data tables contrast)
Several data relationships
Rdrecord.id =rdreocrds.id
Salebillvouchs.sbvid =salebillvouch.sbvid
Salebillvouch.cdlcode=dispatchlist.cdlcode --- Invoice No.
Salebillvouch.csaleout=rdrecord.ccode --- outbound document number
Dispatchlist.dlid =rdrecord.cdlcode - the delivery of single table identification
Dispatchlist.sbvid =salebillvouch.sbvid --- invoice master table identification
Dispatchlists.idlsid =dispatchlists.autoid - shipping list identification
Dispatchlists.idlsid =rdrecords.idlsid - shipping list identification
Salebillvouchs.rdsid =rdrecords.autoid - send and receive record sub table identifier
Salebillvouchs.idlsid =dispatchlists.idlsid--- shipping list sub table identifier
Ia_subsidiary.id =rdrecords.autoid - send and receive record sub table identifier
Vouchernumber.cardnumber=voucherhistory.cardnumber=voucherprefabricate.cardnumber
Ia_subsidiary.cpzid=gl_accvouch.coutno_id
Ap_detail.ibvid =purbillvouchs.id /salebillvouchs.autoid
Function network control table ua_task
Site network control table ua_tasklog
General ledger system name table GL_msysname
Report query item setting table rpt_flddef
Report query condition setting table rpt_fltdef
Report query Settings table rpt_glbdef
Automatic transfer definition table: gl_bautotran 10_ custom transfer, 20_ corresponding carry over, 30_ period profit and loss carry over
The inventory estimated material balance sheet balances = purchase estimated balance sheet of the balance of storage period = Zangu account ledger balances
Stock initial estimate = the beginning of the balance sheet of the material = the certificate generated by the red letter entry form when inventory is made
The provisional estimate of the material balance sheet of the inventory = the purchase storage form (temporary estimate) when the inventory is made up (part of the purchase order) (i.e.: the purchase warehouse receipt portion, the remainder of the settlement after settlement of the inventory)
显示全部