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