用友几个数据表对照关系（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)