【正文】 yIdInt4是分類(lèi)ID6PlanStartDatedatetime是計(jì)劃開(kāi)始日期7PlanEndDatedatetime是計(jì)劃結(jié)束日期8DescriptionText是說(shuō)明9OperatorUserCodenvarchar50是創(chuàng)建人10CreateDatedatetimegetdate()是創(chuàng)建日期11StateInt4是審批狀態(tài)12ProjectItemIdInt4是項(xiàng)目分期ID13Sitenvarchar50是站點(diǎn)立項(xiàng)記錄表（PEAS_Record）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1IDInt4否Identity（1，1）標(biāo)識(shí)列2PEASIDInt4否3BSIDnvarchar50否4BOIDnvarchar50否5Moneymoney否金額6sitenvarchar50否站點(diǎn)7IsCancelBit0否是否取消預(yù)算模塊end項(xiàng)目套帳表（PROJECT_ACCT_PRO）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1IDInt4否Identity（1，1）標(biāo)識(shí)列，流水號(hào)2AccountSetIdInt4否賬套流水號(hào)3ProjectItemIdInt4否項(xiàng)目分期編號(hào)4FOBJID1varchar80‘’否核算項(xiàng)目代碼15FOBJNAME1varchar80‘’否核算項(xiàng)目名稱(chēng)16DETAILNAMEvarchar50‘’否E結(jié)算ID名稱(chēng)7EPAYCODEvarchar10‘’否E結(jié)算地產(chǎn)項(xiàng)目代碼8COST_FACCTIDvarchar100是成本“應(yīng)付帳款”會(huì)計(jì)科目代碼保證金表（Project_Payment_Bail）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1PaymentIDInt4否主鍵，付款單ID2BillMethodvarchar500‘’否計(jì)費(fèi)方法3CostOfOwnershipvarchar500‘’否費(fèi)用歸屬4RefundOrChargeUnitvarchar1000‘’否退款/扣款單位5ReceiptNovarchar100‘’否收據(jù)編號(hào)6RefundDatedatetime190011否退款日期7RealRefundDatedatetime190011否退款日期8BillDatedatetime190011否開(kāi)票日期9BillStateInt41否保證金單據(jù)狀態(tài)10PaidAmountMoney是實(shí)收金額11AlertUserIdsvarchar500‘’否提醒郵件通知用戶(hù)賬戶(hù)列表12AlertTimeMonthsInt43否提前提醒月份13AlertFrequencyInt43否提醒頻率保證金配置表（Project_Payment_Bail_Config）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1Sitevarchar100否站點(diǎn)編號(hào)，主鍵2[Key]varchar100否鍵，主鍵3Valuevarchar100否值，主鍵表（Project_Payment_BusinessClass）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1IDInt4否Identity（1，1）標(biāo)識(shí)列，流水號(hào)2Namevarchar50‘’否名稱(chēng)3Codevarchar50‘’否編碼4Sitevarchar100‘’否站點(diǎn)5timestamptimestamp否EAS基礎(chǔ)數(shù)據(jù)表（EASBaseData）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1IDInt4否Identity（1，1）標(biāo)識(shí)列，編號(hào)2BaseDataTypevarchar50‘’否基礎(chǔ)數(shù)據(jù)類(lèi)型3InnerIdvarchar100‘’否內(nèi)碼4Numbervarchar200‘’否EAS編碼5Namevarchar1000‘’否名稱(chēng)6[Level]Int40否層次7IsLeafBit0否是否子節(jié)點(diǎn)8Parentvarchar100‘’否父節(jié)點(diǎn)編碼9OrgNumbervarchar100‘’否所屬組織編碼10Sitevarchar50‘’否站點(diǎn)11parentIdInt4是父類(lèi)ID12isCostOrgUnitBit是13ispanyorgunitBit是收付明細(xì)表（PROJECT_EBANKPAYDETAIL）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1IDInt4否Identity（1，1）標(biāo)識(shí)列，編號(hào)2DETAILCODEvarchar10否收付明細(xì)編號(hào)3DETAILNAMEvarchar50否收付明細(xì)名稱(chēng)4DETAILIDNAMEvarchar50否收付明細(xì)名稱(chēng)5Sitevarchar50否站點(diǎn)6OriginSitevarchar50是初始化站點(diǎn)7timestamptimestamp否付款單的審批意見(jiàn)表（Project_Pay_Suggest）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1PROJECT_SUGGEST_IDInt4否Identity（1，1）標(biāo)識(shí)列，編號(hào)2PROJECT_PAYMENT_IDInt4是付款單ID3PROJECT_ITEM_TYPEvarchar3是審核狀態(tài)類(lèi)型4PROJECT_SUGGEST_USERIDvarchar15是審核用戶(hù)ID5PROJECT_SUGGEST_CONTENTText是審核內(nèi)容6PROJECT_SUGGEST_TIMEdatetime是審核時(shí)間支付表（PROJECT_PAYMENT）：序號(hào)字段名稱(chēng)類(lèi)型長(zhǎng)度默認(rèn)值可為空備注1PROJECT_PAYMENT_IDInt4否Identity（1，1）標(biāo)識(shí)列，編號(hào)2PROJECT_ITEM_IDInt4是項(xiàng)目分期ID3PROJECT_PAYMENT_MAKERvarchar50是付款單填寫(xiě)人用戶(hù)名，如：vhelb4PROJECT_USEDEPTIDInt4是用款單位ID5PROJECT_PAYEEUNITS_IDInt4是6PROJECT_PAYMENT_COMPANYvarchar200是收款單位7PROJECT_PAYMENT_EXPLAINvarchar2000是款項(xiàng)說(shuō)明8PROJECT_PAYMENT_METHODInt4是付款方式9PROJECT_PAYMENT_BANKchar200是收款銀行10PROJECT_PAYMENT_ACCOUNTSvarchar200是收款帳號(hào)11PROJECT_PAYMENT_ATTACHchar100是附件張數(shù)12PROJECT_PAYMENT_DECLAREmoney0否申報(bào)金額13PROJECT_PAYMENT_PAYmoney是實(shí)際付款金額14PROJECT_PAYMENT_MONEYTYPEvarchar12是幣別15PROJECT_PAYMENT_INTIMEdatetime是填單時(shí)間16PROJECT_PAYMENT_OUTTIMEvarchar20是17PROJECT_PAYMENT_PACTIDvarchar50是合同編號(hào)18PROJECT_PAYMENT_CONTENTvarchar3是審批狀態(tài)編碼19PROJECT_PAYMENT_OUTDATEdatetime是完成時(shí)間20PROJECT_PAYMENT_TIMEsmalldatetime是21PLAN_IDInt4是22PactNamevarchar500是合同名稱(chēng)23PactPricemoney0是合同造價(jià)24FootPricemoney0是結(jié)算造價(jià)25PayDegreeInt41是付款次數(shù)26PrePlanFundmoney0是合同內(nèi)工程款上期累計(jì)27PreAddFundmoney0是預(yù)期工程款28PreWaterCostmoney0是水費(fèi)(上期累計(jì))29PreAmercemoney0是罰款(上期累計(jì))30PreOtherAmercemoney0是其他扣款 (上期累計(jì))31ThePlanFundmoney0是合同內(nèi)工程款本期發(fā)生32TheAddFundmoney0是增加工程款本期發(fā)生33TheWaterCostmoney0是水費(fèi)(本期發(fā)生)34TheAmercemoney0是罰款(本期發(fā)生)35TheOtherAmercemoney0是其他扣款 (本期發(fā)生)36PayType_IDInt40是付款類(lèi)型ID37PREELECCOSTmoney0是電費(fèi)(上期累計(jì))38THEELECCOSTmoney0是電費(fèi)(本期發(fā)生)39PREASSORTCOSTmoney0是配合費(fèi)(上期累計(jì))40THEASSORTCOSTmoney0是配合費(fèi)(本期發(fā)生)41INVOICEmoney0是發(fā)票金額42NEEDEXPORTTOCOSTtinyint是是否需要導(dǎo)出成本43EXPORTTOCOSTDATEdatetime是44NEEDEXPORTTOEBANKtinyint是是否需要導(dǎo)出E結(jié)算45EXPORTTOEBANKDATEdatetime是46EXPORTTOKINGDEEDATEdatetime是導(dǎo)出憑證時(shí)間47FDATEdatetime是48FPAYBILLNUMvarchar50是付款單號(hào)49FNUMfloat是50PAYACCOUNTvarchar50是付款帳號(hào)51EBANKDETAILCODEvarchar10是E結(jié)算收付明細(xì)代碼52EBANKPURPOSEvarchar50是E結(jié)算目的53EBankRemarkvarchar100是E結(jié)算備注54DEBITACCTIDvarchar50是55KINGDEEEBANKCREDITACCTIDvarchar50是E結(jié)算貸方科目代碼56KINGDEENOTEBANKCREDITACCTIDvarchar50是非E結(jié)算貸方科目代碼57FEXCHRATEfloat是58RecBankProvincevarchar50是收款行省份59RecBankCi