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

用友财务软件主耍数据表字段含义Y用友财务软件主要数据表字段含义/* 目录：L SO_SOMain2. SO_SODet.a订s3. dispatchlist4. dispatchlists5. rdrecord6. rcirecords7. salebillvouch8. salebillvouchs9. alclosebill10. code11- gl_accsum12. gl_accvouch销售订单主表销售订单子表发货单、委托代销结算单主表 发货单、委托代销结算单了表 收发记录主表收发记录了表销竹发票主表销伟发票了表收付款结算表科目表科目总账凭证及明细账*/*字段名称英文助记字段含义*/*S0 SOMain销售订单主表cSTcodec sale type code销伟类型编码dDatecl date受订口期cSOCodec sale order code订单号cCusCodec customer code客户编号cDepCodec department code部门编号cPersonCodec person code职员编号cSCCodec sale consignment code发运方式编码carrycCusOAddressc customer address发货地址address of customercPayCodec 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整单打折标志cDefinelc define 1白定义字段1*/cDefinelO/*SO SODetails :销售订单子表自动编号automaAutoTD: auto IDtism identification(identity)cSOCodecsale order code订单号clnvCodecinvoice code存货编号inventrovdPreDatedprevious date预发口期pre-iQuantityiquantity数量iNuminumber件数iQuotePriceiquote price报价（单价，是否含税参看帐套参数）i5 itPriceiunit price单价（原币,无税）iTaxlJnitPriceitax unit price含税单价（原币）lMoneyimoney金额（原币，无税）iTaxitax税额（原币）iSumisum价税合计（原币）iDisCountidiscount折扣额（原币）iNatlJnitPriceinative unit price单价（木币，无税）iNatMoneyinative money金额（木币，无税）iNat.Taxinative tax税额（木币）iNat.Suminative sum价税合计（木币）iNatDisCountinative discount折扣额（本币）i FHNumiFH （拼音“发货”）number累计发货件数iFIIQuantityiFII （拼音“发货”）quantity累计发货数量iFHMoneyiFH （拼音“发货”）money累计发货金额（原币）iKPQuantityiKP （拼音“开票”）quantity累计开票数量iKPNumiKP （拼音“开票”）number累计开票数量iKPMoneyiKP （拼音“开票”）money累计开票金额（原币）cMemocmemo备注cFreelcfree 1自由项1cFree2.*/*dispatchlist发货单、委托代销结算单主表DLIDdispatch_list. ID自动编号identification( identity)cDLCodecdispatch list code发货单号、结算单号cVouchTypecvoucher type单据类型（05, 07）cSTCodecsale type code销售类型编码dDatecldate发货II期、结算II期cRdCodecreceive & deliver code收发类别编号cDepCodecdepartment code部门编号cPersonCodecperson code职员编号SBVIDsale bill(voucher) ID发票ID号cSBVCodecsale bill (voucher) code发票号cSOCodecsale order code订单号cCusCodeccustomer code客户编号cPayCodecpayment code付款条件编码cSOCodecsale consignment code发运方式编码cShipAddresscshiper address发往地址cexch namec* name外币名称exoteric(extra) cashiExchRatecexchange rate汇率iTaxRate1tax rate税率bFirst.bfirst期初标志bReturnFlagbreturn flag退货标志（True-退货，Rdse-发货）bSettleAllbsettie all全部结算完毕标志（True-完毕False 未完毕）cMemocmemo备注cSaleOutcsale out出库单号字符串bDisFlagbdiscount flag整单打折标志cDefinelcdefine 1白定义字段1cDefinelOcVerifiercverifier审核cMakercmaker制单iNetLock1net lock网络控制子段*/Adispatchlists:发货单、委托代销结算单子表AutoIDauto IDH动编号automatism identification(identity)DLIDclispatch_list ID发货单、结算单主表ID号iCorlDi * ID原发货单ID号cargooriginalcWhCodec warehouse code仓库编号cTnvCodec invoice code存货编码inventroyiQuantityi quantity数量iNumi number件数iQuotePricei quote price报价（单价，是否含税参看帐套参数）iUnitPricei unit price单价（原币，无税）ITaxUnitPricei tax unit price含税单价（原币）iMoneyi money金额（原币，无税）订axitax税额（原币）iSumisum价税合计（原帀）iDisCountidiscount折扣额（原币）iNatUnitPriceinative unit price单价（木币，无税）iNat.Moneyinative money金额（木币，无税）iNatTaxinative tax税额（本币）iNatSuminative sum价税合计（木币）iNatDisCountinative cliscount折扣额（本币）iSettleNumisettle number结算件数iSettleQua nt.ityisettle quantity结算数量iBatchibatch批号（收发记录主表ID）cBatchcbatch批号bSettleAllbsettie all全部结算完毕标志（True-完毕False -未完毕）cMemocmemo备注cFreelcfree 1白由项1cFree2 */*rdrecord收发记录主表IDID白动编号bRdFlagbreceive & deliver flag收发标志（入库单-收TRUE,出库单-发 FALSE)cVouchTypecvoucher type单据类型（01、08、09、10、11、32)cBusTypecbusiness type业务类型（具体说明见文档）cSourcecsource单据来源（具体说明见文档）cBusCodecbusiness code对应业务单号（其他出、入库单）cWhCodecwarehouse code仓库编号dDatecldate出、入库LI期cCodeccode出、入库单号cRdCodecreceive & deliver code收发类别编号cDepCodecdepartment code部门编号cPersonCodecperson code职员编号cPTCodec* type code采购类型编码（采购入库单）pickcSTCodecsale type code销伟类型编码（销何出库单）cCusCodeccustomer code客户编号cVenCodec* code供应商编号cOrclerCodecorder code订单号（采购入库单）cARVCodecarrive voucher code到货单号（采购入库单）cBillCodecbill code发票号（采购入库单、销何出库单）cDLCodecdi spatch i ist code发货单号（销售出库单）cProBatchcproduce batch生产批号（产成品入库单、材料出库单）cHandlerchandler经手人cMemocmemo备注传递标志cAccountercaccounter记帐人cMakercmaker制单人iNetLock1net lock网络控制字段cDefinelcdefine 1白定义字段1cDefinelO.*/SBVID cSBVCode cVouchTypesale bill(voucher) ID c sale bill(voucher) c voucher type销伟发票IDcode发票号单据类型（26,27,28,29）/records :收发记录了表AutolD:auto ID自动编号automatism identification(identity)ID: ID与收发记录主表关联项clnvCode:c invoice code存货编号inventroyiNum:i number件数iQuantity :i quantity数量iUnitCost :i unit cost单价iPrice: iprice金额iAPrice:i appraise price暂估金额iPUnitCost :i plan unit cost计划单价/售价iPPrice:i plan price计划金额/售价金额cBatch:c batch批号cObjCodec object code成木对象（材料出库单）cVouchCode:c voucher code对应入库单了表自动编号cFreel:c free 1H由项1cFree2:iFlag: iflag标志（存货核算用0未暂佔未报销1 暂估2报销）dSDate:d settle date结算口期iTax: itax税额（采购用）iSQuantity :i settle quantity结算数量（受托代销）iSNum:i settle number累计结算件数（受托代销）iMoney:i money累计结算金额iSOutQuantity:i send out quantity累计出库数量iSOutNum:i sent out number累计出库件数iFNum:i fact number实际件数iFQuantity :i fact quantity实际数量dVDate:d * date失效口期*/*salebillvouch:销售发票主表cSTCode : c sale type code销信类型dDate : d date口期cSaleOut : c sale out销售出库单号字符串cRdCode : c receive & deliver code 收发类别编号cDepCode:c department code部门编号cPersonCode:c person code职员编号cSOCode:c sale order code销售订单号cCusCode:c customer code客户编码cPayCode:c payment code付款条件编码cexch_ name:c * name外币名称cMemo:c memo备注iExchRate :c exchange rate汇率iTaxRate:i tax rate税率exoteric(extra) cashbRetur nFlag cBCodeb return flag c bank code负发票标志（TRUE负发票FALSE-正发票） 木单位开户银行编号cBillVer : c bill version发票版别cVoucherType : c voucher type cVoucherCode : c voucher code凭证类别凭证号cMaker : c maker制单clnvalider : c invalider作废c verifier审核业务类型（普通/受托）bFirst:b firstblnvalid:b invalidbVisible:b visibleiNetLock:i net lockcitem_class:i item classcitemcode:c item codecHeadCode:c head codebDisFlag: b discount flagcDefi ne1:c define 1cVerifier cBusTupec business type是否期初TRUE-是期初是否有效TRUE-有效是否可见TRUE-可见网络控制字段项日大类编号项目编码科目编码整单打折标志白定义字段1cDefinelObPayMentb payment是否现结*/*salebillvouchs:销售发票子表SBVID:sale bill(voucher) ID销售发票主表IDAuto ID:auto IDH动编号automatism identification(identity)cWhCode:c warehouse code仓库编号cln vCode:c invoice code存货编码inventroyiQuantity:i quantity数量iNum:i number件数iQuotePrice:i quote price报价（单价，是否含税参看帐套参数）iUnitPrice :i unit price单价（原币，无税）iTaxUnitPricei tax unit price含税单价（原币）iMoney:i money金额（原币，无税）iTax: itax税额（原币）iSum:i sum价税合计（原币）iDisCount:i discount折扣额（原币）iNatUnitPricei native unit price单价（本币，无税）iNatMoney:i native money金额（本币，无税）iNatTax:i native tax税额（木币）iNatSum:i native sum价税合计（木币）iNatDisCount:i native discount折扣额（本币）iSBVID:i sale bill(voucher)ID 原销售单（发票）主表ID号iMoneySum:i money sum本币累计收款iExchSum:i * sum原币累计收款eClue:c clue总帐系统线索号cln comeSub:c income subject销传收入科目编号cTaxSub:c tax subject销伟税金科目编号dSig nDated sign date凭证LI期cMemo:c memo备注i Batch:i batch批号（收发记录主表ID）cBatch:c batch批号bsettleall :b settle all是否收款结算完毕cFreel:c free 1自由项1cFree2:*/al_closebill :收付款结算表AutolD:auto ID自动编号cVouchType:c voucher type单据类型（”48“:收款单，”49”:付款单）c Vouch ID:c voucher ID结算单号dVouchDate:d voucher date收/付款日期iPeriod:i period收/付款期间cDwCode:c * code客户/供应商编码cDepCode:c department code部门编号cPersonCode: c person code职员编号citem_classi item class项目大类编号citemcode:c item code项目编码cSSCode:c sale settle code结算方式cNoteNo:c note no.应收应付票据编号cCoVouchType:c corresponding voucher type 对应票据类型(50”,”51”)cCoVouchlD:c correspondingvoucher ID对应应收应付票据号dCoVouchDate:d * voucher date支票发生口期眦字段用于总帐）checkcureDigest:c digest摘要cBankAccount:c bank account银行帐号cexch_ name:c * name币种iExchRate :c exchange rate汇率iAmount:i amount本币金额iAmount_f :i amount_former原币金额iRAmount:i remainder amount木币余额iRAmount_fi remainder amount_former 原币余额cOperator:c operator录入人cCancelMan:c cancel man核销人cRPMan:c recieve & payman出纳人签字bPrePay:b previous pay预收预付标志（True:预收或预付，False:结算单）pre-bStartFlag :b start flag期初标志（True:期初，False:否）cOrderNo:c order no.订单号（用于业务模块）cCode:c code科目编码（结算科冃）cPreCode:c previous code预收/付科目编码pre-iPayForOther:i pay for other代付标志（0:正常；1：代他人付款；2：被代付）cSrcFlag:c source flag结算单来源（”或NULL:出纳录入,”A“:应收应付录入,C表示票据编号为cPzID: c Pz（拼音“凭证”）IeFlag: c flagD生成凭证时的线索号应收应付标志（“AFT:应收，”AP“:应付,空:其他）/*code:科目表i_id:i id自动编号（用于编辑时的唯一标识）cclass:Cclass科目类型（根据企业类型定义科目分类）cclass_e nglc class english科目类型英文名称cclassa nyc class analysis财务分析类型cclassany_engl :c class analysis english财务分析类型英文名称ccode:Ccode科H编码（按科H编码原则进行编码,v主表关联项）ccode_namec code name科目名称ccode_englc code english科目英文名称igrade:Igrade科日级次（必须与科目编码相匹配）bproperty:td property科目性质（False：来源True:占用）cbookjypec book type帐页格式（金额式擞量金额式，外币金额式，数最外币式）cbook_type_e ng I:c book type english帐页格式英文名称chelp:Chelp科目助记码cexch_ namec * name外币名称（与外币主表关联）exchangecmeasurec mersure计量单位bperson:t）person个人往来核算（不能与其他辅助核算同时设置）bcus:bcustomer客户往来核算（可与部门，项目核算同时设置）bsup:bsupporter供应商往来核算（可与部门,项目核算同时设置）bdept:bdepartment部门核算（可与客户，供应商，项日核算同时设置）bitem:bitem项目核算何与客户，供应商，部门核算同时设置）casstem:class itemue）br:*be:cgather:c gather或上级汇总科目）bend:bendbexchangeb exchangebcash:bcash目设置此属性）bbank:bbank目设置此属性）bused:busedbd_c:bdirectiondbegin:dbegindend:dend项目大类（与项目大类主表tem关联，当bitem=Tr口记帐book of account银行帐？是否汇总打印（打印凭证）（Null_不汇总，其它为本级是否末级科目是否参与汇兑损益计算是否出纳（现金）科H何指定上级科H，自动对下级科 是否出纳（银行）科目（可指定上级科目，白动对下级科 银行帐科目是否启用银行帐科目对帐方向True:借方,False:贷方银行帐科目启用时间银行帐科目对帐截止日期itrans : i trans期间损益:1_木年利润，销伟成本:2_库存商品/3_销售收入/4_销伟成木汇兑损益:5_入帐科目transactionbclose: b closecother: c other目是占可制单由帐套参数决定） iotherused : i other used 0_已使用）bcDefine1: b c define 1科目是否封存（已封存科目不能制单）受控科目（科目受其他系统的控制，系统ID名,受控科其它系统是否使用（由其它系统填写,0_未使用，非自定义字段1bcDefinelO : */*gl_accsum i_id : ccode cexch_ name iperiod : cbegi nd_c:科H总账i idc code:c * namei period:c begi n di recti on自动编号（期初录入时的唯一标识） 科目编码（与科目主表关联） 外币币名（与外币主表关联）会计期间（1-12）金额期初方向（借，贷,mb=0时为平）cbegin d_c_e ngl : c begi n di recti on en glish 金额期初力同（央文）mb:money beginmd:money debitme: money creditcendd_c : c end di recti on金额期初（空时写0,mb=0）金额借方合计（空时写0）金额贷方合计（空时写0）金额期末方向（借，贷,me=0时为平）cen dd_c_e ngl : c end directi on english 金额期末方向（英文）me: money end金额期末（空时写0,me=0）mb_f : money begin foreign外币期初（空时写 0,mbv0 时:mb_f=0_；卜币与金额同方向,m b_f v0_夕卜币与金额反方向）md_f: money debit foreign外币借方合计（空时写0）mc_f: money credit foreign外币贷方合计（空时写0）me_f : money end foreign 金额同方向,me_f0_夕卜币与金额反方向）外币期末（空时写0,me0时:me=0_外币与nb_s:numberbegin额同方向,nb_svO_数量与金额反方向） nd_s:numberdebitnc_s:numbercredit数最期初（空时写0,mb0时:nb_s=0_数最与金数量借方合计（空时写0） 数量贷方合计（空时写0）ne_snumber end数量期末（空时写0,me0时:ne_s=0_数量与金额同方向,ne_sv0_数量与金额反方向）*/*gl_accvouch :凭证及明细账Lid: i idH动编号（录入时的唯一标识）iperiod : i period会计期间,0为期初往来明细帐,21为期初待核银行帐,20为银行帐 科目调整前余额,1-12为凭证及明细帐csign:c sign凭证类别字（rtiT期初可输入未定义凭证类别，故未与凭证主表关联）isignseq:i sign sequenee凭证类别排序号（由系统赋值，期初时可为null）ino_id:i no. id凭证号（由系统分配凭证号，期初时可为null）inid: in id行号（由系统赋值，期初时为1）dbill_date :d bill date制单U期（可提供U期在有限范围内的修改）idoc:i document附单据数cbill: cbill制单人ccheck:c check审核人ebook:c book记帐人ibook:i book是否记帐（0_cbook空/未记帐,1_cbook非空/己记帐,建索引用）ccashier:c cashier出纳人iflag: iflag标志:null_有效凭证,1_作废凭证,2_有错凭证（作废凭证可取消作废/进行凭证整理）ctextl:c text 1凭证头白定义项1ctext2:c text 2凭证头自定义项2edigest:c digest摘要ccode:c code科日编码（与科日主表关联）cexch_ name:c * name外币名称（与外币主表关联）md:money debit金额借方me:money credit金额贷方md_f:money debit foreign外币借方金额（若无外币，写0）mc_f:money credit foreign外帀贷方金额（若无外帀,写0）nfrat:n foreign rate汇率（若无外币，写0）nd_s:number debit数量借方（若无数量，写0）nc_s:number credit数量贷方（若无数量，写0）csettle:c settle结算方式（由于期初可输入未定义结算方式，故未与结算方式主表关联）cnd:c note id票号dt_date:d take place date票号发生口期cdeptjd:cdepartment idcpers on_id:c person idccusjd:ccustomer idcsupjd:csupporter idcitemd:citem idcitem_classc item classcname:cn ameccode_equalc code equaliflagbank : i flag bank 间2二手工两清期间） if lag Pers on: i flag pers on间2二手工两清期间） bdelete : b delete部门编码（与部门目录表关联）个人编码（与职员H录表关联）客户编码（与客户目录表关联）供应商编码（与供应商目录表关联） 项目编码（与项目目录表关联）项目大类（与大类主表关联） 业务员对方科目银行帐两清标志（Null,未达, =自动两清期往来帐两清标志（Null_未达,v112 = H动两清期coutaccsetc out account set外部凭证帐套号ioutyear : i out year外部凭证会计年度银行帐核销标書外部凭证系统名称（ID）doutbilldate : d out bill date ioutperiod: i out periodcoutsign: c out signcoutnojdc out note iddoutdated out datecoutb川sign : c out bill sign外部凭证制单LI期 外部凭证会计期间 外部凭证业务类型外部凭证业务号外部凭证单据日期外部凭证单据类型coutid : c out id外部凭证单据号coutsysname : c out system namecoutsysver : c out system version外部凭证系统版木号bvouchedit : b bvouchAddordele: e_不可增删） bvouchm on eyhold: 值,False_可不保值）bvalueedit: b value edit改,False_不可修改）bcodeedit: b code edit改）ccodecontrol : c code control凭证是否可修改（True_可修改,False_不可修改）voucher eidtb voucher add or delete凭证分录是否可增删（True_XT增删,Falsb voucher money hold凭证合计金额是否保值仃rue必须保分录数值（金额/数量/外币）是否可修改（True_可修分录科目是否可修改仃rue_可修改,False_不可修分录受控科目（Null_均不可用严二均可用,!_指定不可用,ID_指定可用）bPCSedit : b person customer supporter edit分录往来项（个人/客户/供应商）是占 可修改（Tr u e_可修改,Fa I se_不可修改）bDeptedit : b department edit分录部门是否可修改（True_可修改False_不可修改）bltemedit : b item edit分录项目是否可修改（True!修改,False_不可修改）bCusSupInput : b customer supporter input分录往来项（客户/供应商）是占必输仃ru e_必输,False_不必输）cDefinel : b c define 1自定义字段 12 :35789cDefinelO : 7注：c文木型i数值型d日期型b布尔型