用友数据表字段二.docx

1、用友数据表字段二用友数据表字段二 Ap_CloseBill收付款单主表bFromBankAp_CloseBill收付款单主表银行导入标志bit44bPrePayAp_CloseBill收付款单主表预收预付标志bit127bReceivedAp_CloseBill收付款单主表是否接收bit37bSendAp_CloseBill收付款单主表是否发送标志bit36bStartFlagAp_CloseBill收付款单主表期初标志bit128bSureAp_CloseBill收付款单主表银行确认标志bit46bToBankAp_CloseBill收付款单主表导出银行标志bit45cBankAp_Clos

2、eBill收付款单主表对方银行varchar41cBankAccountAp_CloseBill收付款单主表银行账号varchar17cCancelManAp_CloseBill收付款单主表核销人varchar125cCancelNoAp_CloseBill收付款单主表现结线索varchar40cCheckManAp_CloseBill收付款单主表审核人varchar101cCodeAp_CloseBill收付款单主表结算科目编码varchar30cCoVouchIDAp_CloseBill收付款单主表对应单据号varchar14cCoVouchTypeAp_CloseBill收付款单主表对应

3、单据类型varchar13cDefine1Ap_CloseBill收付款单主表自定义项1varchar49cDefine10Ap_CloseBill收付款单主表自定义项10varchar58cDefine11Ap_CloseBill收付款单主表自定义项11varchar59cDefine12Ap_CloseBill收付款单主表自定义项12varchar60cDefine13Ap_CloseBill收付款单主表自定义项13varchar61cDefine14Ap_CloseBill收付款单主表自定义项14varchar62cDefine15Ap_CloseBill收付款单主表自定义项15int6

4、3cDefine16Ap_CloseBill收付款单主表自定义项16float64cDefine2Ap_CloseBill收付款单主表自定义项2varchar50cDefine3Ap_CloseBill收付款单主表自定义项3varchar51cDefine4Ap_CloseBill收付款单主表自定义项4datetime52cDefine5Ap_CloseBill收付款单主表自定义项5int53cDefine6Ap_CloseBill收付款单主表自定义项6datetime54cDefine7Ap_CloseBill收付款单主表自定义项7float55cDefine8Ap_CloseBill收付款

5、单主表自定义项8varchar56cDefine9Ap_CloseBill收付款单主表自定义项9varchar57cDeptCodeAp_CloseBill收付款单主表部门编码varchar7cDigestAp_CloseBill收付款单主表摘要varchar16cDwCodeAp_CloseBill收付款单主表单位编码varchar6cexch_nameAp_CloseBill收付款单主表币种名称varchar18cFlagAp_CloseBill收付款单主表应收应付标志varchar35cItem_ClassAp_CloseBill收付款单主表项目大类编码varchar9cItemCode

6、Ap_CloseBill收付款单主表项目编码varchar10cNatBankAp_CloseBill收付款单主表本单位银行名称varchar42cNatBankAccountAp_CloseBill收付款单主表本单位银行账号varchar43cNoteNoAp_CloseBill收付款单主表票据号varchar12cOperatorAp_CloseBill收付款单主表录入人varchar100Ap_CloseBill Ap_CloseBill收付款单主表订单号varchar15cOrderNocPersonAp_CloseBill收付款单主表业务员编码varchar8cPreCodeAp_C

7、loseBill收付款单主表预收付科目编码varchar31cPZidAp_CloseBill收付款单主表凭证线索号varchar34cRPManAp_CloseBill收付款单主表出纳签字人varchar126csItemCodeAp_CloseBill收付款单主表结算科目项目varchar38cSrcFlagAp_CloseBill收付款单主表结算单来源varchar33cSSCodeAp_CloseBill收付款单主表结算方式编码varchar11cVouchIDAp_CloseBill收付款单主表单据编号varchar3cVouchTypeAp_CloseBill收付款单主表单据类型编

8、码varchar1dVouchDateAp_CloseBill收付款单主表单据日期datetime4iAmountAp_CloseBill收付款单主表本币金额money20iAmount_fAp_CloseBill收付款单主表原币金额money21iExchRateAp_CloseBill收付款单主表汇率float19iIDAp_CloseBill收付款单主表主表标识int0iPayForOtherAp_CloseBill收付款单主表代付标志bit132iPeriodAp_CloseBill收付款单主表会计期间tinyint5iRAmountAp_CloseBill收付款单主表本币余额mone

9、y22iRAmount_fAp_CloseBill收付款单主表原币余额money23VT_IDAp_CloseBill收付款单主表单据模版号int47bPrePayAp_CloseBills收付款单子表预收预付标志bit4cCusVenAp_CloseBills收付款单子表客户或供应商编码varchar5cDepCodeAp_CloseBills收付款单子表部门编码varchar13cKmAp_CloseBills收付款单子表科目编码varchar10cPersonCodeAp_CloseBills收付款单子表业务员编码varchar14cXmAp_CloseBills收付款单子表项目编码va

10、rchar12cXmClassAp_CloseBills收付款单子表项目大类编码varchar11iAmtAp_CloseBills收付款单子表本币金额money7iAmt_fAp_CloseBills收付款单子表原币金额money6IDAp_CloseBills收付款单子表子表标识int2iIDAp_CloseBills收付款单子表主表标识int1iRAmtAp_CloseBills收付款单子表本币余额money9iRAmt_fAp_CloseBills收付款单子表原币余额money8iTypeAp_CloseBills收付款单子表款项类型号tinyint3Ap_Detail应收应付明细账A

11、uto_IDAp_Detail应收应付明细账自动编号int1bPrePayAp_Detail应收应付明细账预收预付标志bit35cCancelNoAp_Detail应收应付明细账处理标识符varchar33cCodeAp_Detail应收应付明细账科目编码varchar13cCoVouchIDAp_Detail应收应付明细账对应单据号varchar38cCoVouchTypeAp_Detail应收应付明细账对应单据类型varchar37cDefine1Ap_Detail应收应付明细账自定义项1varchar40cDefine10Ap_Detail应收应付明细账自定义项10varchar49cD

12、efine11Ap_Detail应收应付明细账自定义项11varchar52cDefine12Ap_Detail应收应付明细账自定义项12varchar53cDefine13Ap_Detail应收应付明细账自定义项13varchar54cDefine14Ap_Detail应收应付明细账自定义项14varchar55cDefine15Ap_Detail应收应付明细账自定义项15int56cDefine16Ap_Detail应收应付明细账自定义项16float57cDefine2Ap_Detail应收应付明细账自定义项2varchar41cDefine3Ap_Detail应收应付明细账自定义项3v

13、archar42cDefine4Ap_Detail应收应付明细账自定义项4datetime43cDefine5Ap_Detail应收应付明细账自定义项5int44cDefine6Ap_Detail应收应付明细账自定义项6datetime45cDefine7Ap_Detail应收应付明细账自定义项7float46cDefine8Ap_Detail应收应付明细账自定义项8varchar47cDefine9Ap_Detail应收应付明细账自定义项9varchar48cDeptCodeAp_Detail应收应付明细账部门编码varchar9cDigestAp_Detail应收应付明细账摘要varcha

14、r19cDwCodeAp_Detail应收应付明细账单位编码varchar8Ap_Detail应收应付明细账cexch_nameAp_Detail应收应付明细账币种名称varchar21cFlagAp_Detail应收应付明细账应收应付标志varchar39cInvCodeAp_Detail应收应付明细账存货编码varchar11cItem_ClassAp_Detail应收应付明细账项目大类编码varchar14cItemCodeAp_Detail应收应付明细账项目编码varchar15cOrderNoAp_Detail应收应付明细账销售订单号varchar29cPayCodeAp_Detai

15、l应收应付明细账付款条件编码varchar31cPersonAp_Detail应收应付明细账职员编码varchar10cProcStyleAp_Detail应收应付明细账处理方式varchar32cPZidAp_Detail应收应付明细账凭证线索号varchar34csignAp_Detail应收应付明细账单据正负标识varchar16cSSCodeAp_Detail应收应付明细账结算方式编码varchar30cVouchIDAp_Detail应收应付明细账单据编号varchar5cVouchSTypeAp_Detail应收应付明细账单据小类varchar4cVouchTypeAp_Detai

16、l应收应付明细账单据类型编码varchar3dRegDateAp_Detail应收应付明细账记账日期datetime7dVouchDateAp_Detail应收应付明细账单据日期datetime6iBVidAp_Detail应收应付明细账发票子表标识int12iCAmountAp_Detail应收应付明细账贷方金额money24iCAmount_fAp_Detail应收应付明细账贷方原币金额money26iCAmount_sAp_Detail应收应付明细账贷方数量float28iClosesIDAp_Detail应收应付明细账结算单子表标识int50iCoClosesIDAp_Detail应收

17、应付明细账对应结算子表标识int51iDAmountAp_Detail应收应付明细账借方金额money23iDAmount_fAp_Detail应收应付明细账借方原币金额money25iDAmount_sAp_Detail应收应付明细账借方数量float27iExchRateAp_Detail应收应付明细账汇率float22iFlagAp_Detail应收应付明细账是否正常标志tinyint36ino_idAp_Detail应收应付明细账凭证编号smallint18iPeriodAp_Detail应收应付明细账会计期间tinyint2iPriceAp_Detail应收应付明细账单价float2

18、0isignseqAp_Detail应收应付明细账凭证表制单期间tinyint17Ap_Note应收应付票据登记簿主表Auto_IDAp_Note应收应付票据登记簿主表自动编号int1bStartFlagAp_Note应收应付票据登记簿主表期初标志bit24cBankAp_Note应收应付票据登记簿主表承兑银行varchar5cCodeAp_Note应收应付票据登记簿主表科目编码varchar12cDeptCodeAp_Note应收应付票据登记簿主表部门编码varchar7cDigestAp_Note应收应付票据登记簿主表摘要varchar11cDwCodeAp_Note应收应付票据登记簿主表

19、开票单位编码varchar6cEndorserAp_Note应收应付票据登记簿主表背书单位编码varchar16cFlagAp_Note应收应付票据登记簿主表应收应付标志varchar25cItem_ClassAp_Note应收应付票据登记簿主表项目大类编码varchar9cItemCodeAp_Note应收应付票据登记簿主表项目编码varchar10cLinkAp_Note应收应付票据登记簿主表主表标识varchar2cOperatorAp_Note应收应付票据登记簿主表操作员varchar23cPersonAp_Note应收应付票据登记簿主表业务员编码varchar8cVouchIDAp_

20、Note应收应付票据登记簿主表票据编号varchar4cVouchTypeAp_Note应收应付票据登记簿主表票据种类varchar3dExpireDateAp_Note应收应付票据登记簿主表到期日期datetime19dReceiptDateAp_Note应收应付票据登记簿主表收到日期datetime20dSignDateAp_Note应收应付票据登记簿主表签发日期datetime18iAmountAp_Note应收应付票据登记簿主表票据面值money13iCloseIDAp_Note应收应付票据登记簿主表对应结算单主表识int26iEndorAmountAp_Note应收应付票据登记簿主表

21、背书金额money17iRAmountAp_Note应收应付票据登记簿主表票据余额money15iRateAp_Note应收应付票据登记簿主表面值利率float14VT_IDAp_Note应收应付票据登记簿主表单据模版号int27Ap_Note_Sub应收应付票据登记簿子表cBankAp_Note_Sub应收应付票据登记簿子表银行名称varchar7cCancelNoAp_Note_Sub应收应付票据登记簿子表处理标识符varchar11cCodeAp_Note_Sub应收应付票据登记簿子表结算科目编码varchar9cCoVouchIDAp_Note_Sub应收应付票据登记簿子表对应结算单号

22、varchar13cCoVouchTypeAp_Note_Sub应收应付票据登记簿子表对应结算单类型varchar12cFlagAp_Note_Sub应收应付票据登记簿子表应收应付标志varchar15cLinkAp_Note_Sub应收应付票据登记簿子表主表标识varchar1cOperatorAp_Note_Sub应收应付票据登记簿子表操作员varchar10cProcStyleAp_Note_Sub应收应付票据登记簿子表处理方式varchar2cPZidAp_Note_Sub应收应付票据登记簿子表凭证线索号varchar14dDateAp_Note_Sub应收应付票据登记簿子表处理日期d

23、atetime3iAmountAp_Note_Sub应收应付票据登记簿子表金额money6iBsTypeAp_Note_Sub应收应付票据登记簿子表背书类型tinyint17IDAp_Note_Sub应收应付票据登记簿子表子表标识int16iDisctIntrestAp_Note_Sub应收应付票据登记簿子表贴现率real8iExpenseAp_Note_Sub应收应付票据登记簿子表费用金额money5iIntrestAp_Note_Sub应收应付票据登记簿利息money4Ap_Vouch应付应收单主表Auto_IDAp_Vouch应付应收单主表自动编号int1bd_cAp_Vouch应付应收

24、单主表借贷方向bit16bStartFlagAp_Vouch应付应收单主表期初标志bit27cCheckManAp_Vouch应付应收单主表审核人varchar23cCodeAp_Vouch应付应收单主表科目编码varchar13cCoVouchTypeAp_Vouch应付应收单主表对应单据类型varchar24cDefine1Ap_Vouch应付应收单主表自定义项1varchar30cDefine10Ap_Vouch应付应收单主表自定义项10varchar39cDefine11Ap_Vouch应付应收单主表自定义项11varchar46cDefine12Ap_Vouch应付应收单主表自定义项12varchar