用友财务软件主要数据表字段含义 docx文档格式.docx

1、c payment code付款条件编码cexch_namec * name外币名称exoteric（extra） cashiExchRatec exchange rate汇率iTaxRatei tax rate税率iMoneyi monev定金cMemoc memo备注iStatusi status订单状态cMakerc maker制单人cVerifierc verifier审核人eCloserc closer关闭人bDisFlagb discount flag整单打折标志cDefinelO自动编号automa/*SO SODetails :AutoTD : auto IDtism iden

2、tification（identity）csale order codeclnvCodeinvoice code存货编号inventrovdPreDatedprevious date预发口期pre-iQuantityiquantity数量iNumnumber件数iQuotePricequote price报价（单价，是否含税参看帐套参数）i5 itPriceunit price单价（原币,无税）iTaxlJnitPricetax unit price含税单价（原币）lMoneymoney金额（原币，无税）iTaxtax税额（原币）iSumsum价税合计（原币）iDisCountdiscount

3、折扣额（原币）iNatlJnitPricenative unit price单价（木币，无税）iNatMoneynative money金额（木币，无税）iNat.Taxnative tax税额（木币）iNat.Sumnative sum价税合计（木币）iNatDisCountnative discount折扣额（本币）i FHNumFH （拼音“发货”）累计发货件数iFIIQuantityFII （拼音“发货”）累计发货数量iFHMoney累计发货金额（原币）iKPQuantityKP （拼音“开票”）累计开票数量iKPNumiKPMoney累计开票金额（原币）memocFreelfree

4、1自由项1cFree2.*/*dispatchlist发货单、委托代销结算单主表DLIDdispatch_list. IDidentification（ identity）cDLCodedispatch list code发货单号、结算单号cVouchTypevoucher type单据类型（05, 07）cSTCodesale type code销售类型编码cldate发货II期、结算II期cRdCodereceive & deliver code收发类别编号department codeperson codeSBVIDsale bill（voucher） ID发票ID号cSBVCodesa

5、le bill （voucher） code发票号customer codepayment codesale consignment codecShipAddressshiper address发往地址cexch name* nameexchange rate1tax ratebFirst.bfirst期初标志bReturnFlagreturn flag退货标志（True-退货，Rdse-发货）bSettleAllsettie all全部结算完毕标志（True-完毕False 未完毕）cSaleOutsale out出库单号字符串discount flagcDefineldefine 1白定义

6、字段1verifier审核maker制单iNetLocknet lock网络控制子段*/Adispatchlists:发货单、委托代销结算单子表AutoIDauto IDH动编号clispatch_list ID发货单、结算单主表ID号iCorlDi * ID原发货单ID号cargooriginalcWhCodec warehouse code仓库编号cTnvCodec invoice code存货编码royi quantityi numberi quote priceiUnitPricei unit price单价（原币，无税）ITaxUnitPricei tax unit pricei m

7、oney订ax价税合计（原帀）iNatUnitPriceiNat.MoneyiNatTax税额（本币）iNatSumnative cliscountiSettleNumsettle number结算件数iSettleQua nt.itysettle quantity结算数量iBatchbatch批号（收发记录主表ID）cBatch批号全部结算完毕标志（True-完毕False -未完毕）白由项1 */*rdrecord收发记录主表ID白动编号bRdFlag deliver flag收发标志（入库单-收TRUE,出库单-发 FALSE）单据类型（01、08、09、10、11、32）cBusTyp

8、ebusiness type业务类型（具体说明见文档）cSourcesource单据来源（具体说明见文档）cBusCodebusiness code对应业务单号（其他出、入库单）warehouse code出、入库LI期cCodecode出、入库单号cPTCode* type code采购类型编码（采购入库单）pick销伟类型编码（销何出库单）cVenCode* code供应商编号cOrclerCodeorder code订单号（采购入库单）cARVCodearrive voucher code到货单号（采购入库单）cBillCodebill code发票号（采购入库单、销何出库单）di sp

9、atch i ist code发货单号（销售出库单）cProBatchproduce batch生产批号（产成品入库单、材料出库单）cHandlerhandler经手人备注传递标志cAccounteraccounter记帐人网络控制字段SBVID cSBVCode cVouchType/records :AutolD :自动编号 automatism identification（identity）ID : ID 与收发记录主表关联项clnvCode :存货编号 inventroyiNum :iQuantity :iUnitCost :i unit cost单价iPrice : iprice金

10、额iAPrice :i appraise price暂估金额iPUnitCost :i plan unit cost计划单价/售价iPPrice :i plan price计划金额/售价金额cBatch :c batchcObjCodec object code成木对象（材料出库单）cVouchCode:c voucher code 对应入库单了表自动编号cFreel :c free 1H由项1cFree2 :iFlag :flag标志（存货核算用0未暂佔未报销1 暂估2报销）dSDate :d settle date结算口期iTax :税额（采购用）iSQuantity :i settle

11、quantity结算数量（受托代销）iSNum :i settle number累计结算件数（受托代销）iMoney :累计结算金额iSOutQuantityi send out quantity 累计出库数量iSOutNumi sent out number 累计出库件数iFNum :i fact number实际件数iFQuantity :i fact quantity实际数量dVDate :d * date失效口期*/sale bill（voucher） ID c sale bill（voucher） c voucher type销伟发票IDcode发票号单据类型（26,27,28,29

12、）/*salebillvouch:销售发票主表cSTCode : c sale type code 销信类型dDate : d date 口期cSaleOut : c sale out 销售出库单号字符串销售订单号客户编码cexch_ namecMemo :iExchRate :iTaxRate :exoteric（extra） cashbRetur nFlag cBCodeb return flag c bank code负发票标志（TRUE负发票FALSE-正发票） 木单位开户银行编号cBillVer : c bill version发票版别cVoucherType : c voucher

13、 type cVoucherCode : c voucher code凭证类别凭证号cMaker : c makerclnvalider : c invalider作废c verifier 审核业务类型（普通/受托）bFirst :b firstblnvalidb invalidbVisibleb visiblei net lockcitem_classi item classcitemcodec item codecHeadCodec head code b discount flagcDefi ne1c define 1是否期初TRUE-是期初是否有效TRUE-有效是否可见TRUE-可见项

14、日大类编号项目编码科目编码cVerifier cBusTupec business typecRdCode : c receive & deliver code 收发类别编号bPayMentb payment是否现结*/*salebillvouchs:销售发票子表销售发票主表IDAuto IDH动编号 automatism identification（idenc warehouse code 仓库编号cln vCode存货编码 inventroyiUnitPrice :iTaxUnitPricetax 税额（原币）iSum :i sumiDisCount :i discounti nativ

15、e unit price单价（本币，无税）i native money金额（本币，无税）iNatTax :i native taxiNatSum :i native sumi native discountiSBVID :i sale bill（voucher）ID 原销售单（发票）主表ID号iMoneySumi money sum本币累计收款iExchSumi * sum原币累计收款eClue :c clue总帐系统线索号cln comeSubc income subject 销传收入科目编号cTaxSub :c tax subject销伟税金科目编号dSig nDated sign dat

16、e凭证LI期i Batch :i batchbsettleall :b settle all是否收款结算完毕*/al_closebill :c voucher type单据类型（”48“:收款单，”49”:付款单）c Vouch ID :c voucher ID结算单号dVouchDated voucher date收/付款日期iPeriod :i period收/付款期间cDwCodec * code客户/供应商编码c department code 部门编号 c person code项目大类编号citemcode :cSSCodec sale settle code 结算方式cNoteN

17、o :c note no.应收应付票据编号cCoVouchTypec corresponding voucher type 对应票据类型（50”,”51”）cCoVouchlDc correspondingvoucher ID对应应收应付票据号dCoVouchDated * voucher date 支票发生口期眦字段用于总帐）checkcureDigest :c digest摘要cBankAccountc bank account银行帐号币种iAmount :i amount本币金额iAmount_f :i amount_former原币金额iRAmount :i remainder amount 木币余额iRAmount_fi remainder amount_former 原币余额cOperator :c operator录入人cCancelManc cancel man核销人cRPMan :c recieve & payman 出纳人签字bPrePay :b previous pay预收预付标志（True:预收或预付，False:结算单）pre-bStartFlag :b start flag期初标志（True:期初，False:否