用友财务软件主要数据表字段含义.doc

《用友财务软件主要数据表字段含义.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、用友财务软件主要数据表字段含义rdrecords:收发记录子表AutoID:autoID自动编号automatismidentification(identity)ID:ID与收发记录主表关联项cInvCode:cinvoicecode存货编号inventroyiNum:inumber件数iQuantity:iquantity数量iUnitCost:iunitcost单价iPrice:iprice金额iAPrice:iappraiseprice暂估金额iPUnitCost:iplanunitcost计划单价/售价iPPrice:iplanprice计划金额/售价金

2、额cBatch:cbatch批号cObjCode:cobjectcode成本对象（材料出库单）cVouchCode:cvouchercode对应入库单子表自动编号cFree1:cfree1自由项1cFree2:......iFlag:iflag标志（存货核算用0-未暂估未报销1-暂估2-报销）dSDate:dsettledate结算日期iTax:itax税额（采购用）iSQuantity:isettlequantity结算数量（受托代销）iSNum:isettlenumber累计结算件数（受托代销）iMoney:imoney累计结算金额iSOutQuantity:

3、isendoutquantity累计出库数量iSOutNum:isentoutnumber累计出库件数iFNum:ifactnumber实际件数iFQuantity:ifactquantity实际数量dVDate:d***date失效日期*/-------------------------------------------------------------------------------------------------------------------salebillvouch:销售发票主表SBVID:salebill(voucher)ID销售发票

4、IDcSBVCode:csalebill(voucher)code发票号cVouchType:cvouchertype单据类型(26,27,28,29)cSTCode:csaletypecode销售类型dDate:ddate日期cSaleOut:csaleout销售出库单号字符串cRdCode:creceive&delivercode收发类别编号cDepCode:cdepartmentcode部门编号cPersonCode:cpersoncode职员编号cSOCode:csaleordercode销售订单号cCusCode:ccustomercode客户编码cPa

5、yCode:cpaymentcode付款条件编码cexch_name:c***name外币名称exoteric(extra)cashcMemo:cmemo备注iExchRate:cexchangerate汇率iTaxRate:itaxrate税率bReturnFlag:breturnflag负发票标志（TRUE-负发票FALSE-正发票）cBCode:cbankcode本单位开户银行编号cBillVer:cbillversion发票版别cVoucherType:cvouchertype凭证类别cVoucherCode:cvouchercode凭证号cMaker:c

6、maker制单cInvalider:cinvalider作废cVerifier:cverifier审核cBusTupe:cbusinesstype业务类型（普通/受托）bFirst:bfirst是否期初TRUE-是期初bInvalid:binvalid是否有效TRUE-有效bVisible:bvisible是否可见TRUE-可见iNetLock:inetlock网络控制字段citem_class:iitemclass项目大类编号citemcode:citemcode项目编码cHeadCode:cheadcode科目编码bDisFlag:bdiscountflag整

7、单打折标志cDefine1:cdefine1自定义字段1......cDefine10:......bPayMent:bpayment是否现结*/-------------------------------------------------------------------------------------------------------------------salebillvouchs:销售发票子表SBVID:salebill(voucher)ID销售发票主表IDAutoID:autoID自动编号automatismidentification(i

8、denti