用友财务软件主要数据表字段含义VIP免费

用友财务软件主要数据表字段含义rdrecords:收发记录子表AutoID:autoID自动编号automatismidentification(identity)ID:ID与收发记录主表关联项cInvCode:cinvoicecode存货编号inventroyiNum:inumber件数iQuantity:iquantity数量iUnitCost:iunitcost单价iPrice:iprice金额iAPrice:iappraiseprice暂估金额iPUnitCost:iplanunitcost计划单价/售价iPPrice:iplanprice计划金额/售价金额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:isendoutquantity累计出库数量iSOutNum:isentoutnumber累计出库件数iFNum:ifactnumber实际件数iFQuantity:ifactquantity实际数量dVDate:d***date失效日期*/-------------------------------------------------------------------------------------------------------------------salebillvouch:销售发票主表SBVID:salebill(voucher)ID销售发票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客户编码cPayCode: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:cmaker制单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整单打折标志cDefine1:cdefine1自定义字段1......cDefine10:......bPayMent:bpayment是否现结*/-------------------------------------------------------------------------------------------------------------------salebillvouchs:销售发票子表SBVID:salebill(voucher)ID销售发票主表IDAutoID:autoID自动编号automatismidentification(identity)cWhCode:cwarehousecode仓库编号cInvCode:cinvoicecode存货编码inventroyiQuantity:iquantity数量iNum:inumber件数iQuotePrice:iquoteprice报价（单价，是否含税参看帐套参数）iUnitPrice:iunitprice单价（原币，无税）iTaxUnitPrice:itaxunitprice含税单价（原币）iMoney:imoney金额（原币，无税）iTax:itax税额（原币）iSum:isum价税合计（原币）iDisCount:idiscount折扣额（原币）iNatUnitPrice:inativeunitprice单价（本币，无税）iNatMoney:inativemoney金额（本币，无税）iNatTax:inativetax税额（本币）iNatSum:inativesum价税合计（本币）iNatDisCount:inativediscount折扣额（本币）iSBVID:isalebill(voucher)ID原销售单（发票）主表ID号iMoneySum:imoneysum本币累计收款iExchSum:i***sum原币累计收款cClue:cclue总帐系统线索号cIncomeSub:cincomesubject销售收入科目编号cTaxSub:ctaxsubject销售税金科目编号dSignDate:dsigndate凭证日期cMemo:cmemo备注iBatch:ibatch批号（收发记录主表ID）cBatch:cbatch批号bsettleall:bsettleall是否收款结算完毕cFree1:cfree1自由项1cFree2:......*/------------------------------------...