合同与支付管理数据表

1、.：.；合同三级分类表BargainThirdCatalog序号字段称号类型长度默许值可为空备注BTC_IDInt否Identity(,) 主键BM_IDint否录入模板编号BSC_IDInt否二级分类IDBTC_CatalogNamevarchar否合同分类称号BTC_CatalogAbbreviationvarchar否三级类别代码生成的合同号代码BTC_BargainExamineFlowvarchar否审批流描画信息BP_IDInt是打印模板编号ExFlowUrlvarchar是网上审批地址OrderFlowUrlvarchar是设计/营销订单审核URLOddFlowUrlvarcha

2、r是零星业务恳求单审核URLlCostBit否邮件通知本钱lFinanceBit否邮件通知财务lSecretaryBit否邮件通知工程秘书NeedPaymentPlanBit否能否需求付款方案AlertTextvarchar是合同填写提示lPartyBBit否邮件通知合约方StrategyFlowUrlvarchar是战略合同审核URLEASTypeNumbervarchar是对应EAS合同类型编码JingHuaAuditUrlvarchar是JingHuaOrderAuditURLvarchar是JingHuaOddBillAuditURLvarchar是KAuditUrlvarchar是K

3、OrderAuditURLvarchar是KOddBillAuditURLvarchar是KStrategyFlowUrlvarchar是PDCServiceTypevarchar是ForbidInputBit是loperatorBit否邮件通知经办人SMSlOperatorBitFALSE否短信通知经办人SMSlCostBitFALSE否短信通知本钱SMSlFinanceBitFALSE否短信通知财务SMSlSecretaryBitFALSE否短信通知工程秘书SMSlPartyBBitFALSE否短信通知合约方NeedBudgetControlBit否能否需求预算控制DefaultBgtAc

4、tCodevarchar否NeedPEASControlmoney否能否需求立项控制IsCostBargainBit否能否本钱合同PreClearApprovalUrlvarchar否预结算审批地址PermissionEnabledBit否能否开启权限控制NeedLimitPaymentRationBit否能否限制付款合同一级分类表BargainFirstCatalog：序号字段称号类型长度默许值可为空备注BFC_IDInt否Identity(,) 标识列BFC_CatalogNamevarchar否一级分类称号Sitevarcharshenzhen是站点OriginSitevarchar 是

5、timestamptimestamp否合同二级分类表BargainSecondCatalog：序号字段称号类型长度默许值可为空备注BSC_IDInt否Identity(,) 标识列BFC_IDInt否一级分类IDBSC_CatalogNamevarchar否二级分类称号合同表Bargain序号字段称号类型长度默许值可为空备注Bargain_IDInt否Identity，标识列BTC_IDInt否合同三级分类编号BF_IDInt否合同方式编号合同、补充合同、战略合同BA_IDInt否合同区域BT_IDInt否合同类型编号Bargain_FinalStatusvarchar否形状BES_Handl

6、erNameInt否当前审批形状编号，为等待审批，为部门签收，为指点签收，为指点经过，为等待修正，为初始形状Bargain_SerialNumbervarchar否合同号Bargain_ProjectIDInt否合同工程分期编号Bargain_OriginalCatalogIDInt是合同初始化分类编号Bargain_Namevarchar否合同称号Bargain_OwnerIDInt否经办人编号Bargain_OwnerDepartmentIDInt是经办人办理时所在的部门编号，经办人有能够调离部门Bargain_FirstSectionvarchar否甲方单位Bargain_SecondS

7、ectionvarchar否乙方称号Bargain_Copiesint否合同份数Bargain_ThirdSectionvarchar是丙方称号Bargain_FourthSectionvarchar是丁方称号Bargain_PlanPricesMoney是额度Bargain_TotalPricesMoney否合同总价Bargain_UnitPricevarchar是合同单价Bargain_CurrencyTypeVarchar否币种Bargain_FirmSelectInt否单位选择Bargain_FirmSelectRemarkvarchar是单位选择阐明Bargain_PayPromis

8、evarchar否付款商定Bargain_TimeLimitPromisevarchar否期限商定Bargain_Remarktext是需求阐明事项Bargain_DateTimedatetime否合同填写时间Bargain_ParentIDInt是主合同IDBargain_SpecialParentIDInt是战略合同IDBargain_NeedExportbit否合同能否需求导出，零星业务恳求单永远不导出Bargain_IsExportedJHBit否能否导出京华Bargain_IsExportedCBBit否能否导出本钱Bargain_ReadyOnevarchar是预备字段一Barga

9、in_ReadyTwovarchar是预备字段二Bargain_ReadyThreeInt是预备字段三Bargain_ReadyFourInt是预备字段四ExFlowProcIDInt是京华审批IDBargain_CostPropertyvarchar是合同造价性质Bargain_SelectWayvarchar是中标方式FootPriceMoney是最新总价IsCanceledInt是能否取消BargainEffectedDatedatetime是归档日期BargainPriceMemovarchar是合同总价备注BeetMemovarchar是保修款备注Beetdecimal，是保修款比例

10、MarketingBTCIDint是合同的营销三级类别ID，如非营销合同，此字段值为空IsCloseEvaluationBit否能否封锁KInstIDInt是KInstIDPDCOrderIdInt是PDC订单IDPDCOpStatusInt是PDC形状PDCOpTimeDatetime是PDCOpTimeAssetsPurchaseOrderIDInt是IsAnnulBit是能否作废BargainReviseDoneBit是BargainEasExpTimeDatetime是BargainReviseEasExpTimeDatetime是BargainBalanceEasExpTimeDat

11、etime是PrePDCOpStatusInt是PrePDCOpTimedatetime是PreBES_IDInt是PreBargain_FinalStatusvarchar是PreBES_HandlerNameInt是PreBargain_ReadyTwovarchar是PreBargain_SerialNumbervarchar是预结算合同号EASInnerIdvarchar是EASOpStatusint是EASOpTimedatetime是EASNoNeedExportBit是EAS不需求导出IsCloseBitFALSE否能否封锁FeedBackRemarkText否合同归档备注Sig

12、natureRemarktext否合同盖章备注ExchangeRateFloat是汇率timestamptimestamp否NeedLimitPaymentRationBit否能否限制付款LimitPaymentRationMoney否限制付款比例IsFeeSplitBit否能否是费用分摊合同，假设是的话就出如今费用分摊的列表拆迁公司表Bargain_DemolitionCompanies：序号字段称号类型长度默许值可为空备注CompanyIDInt否Identity，标识列Namevarchar否称号IsClosedBit否能否封锁IsDeletedBit否能否被删除IsAuditedBit

13、否能否审核Sitevarchar否所属站点拆迁公司表Bargain_DemolitionHouses：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BargainIDInt否合同编号HouseBuildingNovarchar否房屋栋号HouseNovarchar否房屋号HouseTypevarchar否房间类型HouseQuantityInt否房屋套数CredentialTypevarchar否证件类型CredentialNovarchar否证件编号Linkmanvarchar是联络人Phonevarchar是联络Addressvarchar是DemolitionC

14、ompanyNamevarchar是拆迁公司称号MoveAreadecimal(, )是永迁面积BackmovingAreadecimal(, )是回迁面积BackmovingExchangeAreadecimal(, )是回迁置换面积MoveCompensationFeedecimal(, )是永迁类-货币补偿费用MoveIncentiveFeedecimal(, )是永迁类-奖励费用MoveOneTimeCompensationFeedecimal(, )是永迁类-一次性补偿费用MoveOneTimeCompensationFeeNotevarchar是永迁类-一次性补偿阐明Backmov

15、ingDecorationCompensationFeedecimal(, )是回迁类-装修补偿费用BackmovingMoveHouseFeedecimal(, )是回迁类-搬家费BackmovingAdjunctCompensationFeedecimal(, )是回迁类-附属物业补偿费BackmovingIncentiveFeedecimal(, )是回迁类-奖励金额BackmovingOneTimeCompensationFeedecimal(, )是回迁类-一次性补偿费BackmovingOneTimeCompensationFeeNotevarchar是回迁类-一次性补偿费阐明Ba

16、ckmovingParkingSpaceQuantityInt是回迁类-车位数量TransitionFeeStandarddecimal(, )是过渡费规范(元/月/平米)TransitionAreadecimal(, )是过渡费计算面积TransitionFeeBeginDatedatetime是过渡费起始支付日期TransitionFeeEndDatedatetime是过渡费终了支付日期DeliveryHousesAgreedDatedatetime是拆迁交房商定时间DeliveryHousesRealityDatedatetime是拆迁房实践交房日期BackmovingDatedatet

17、ime是回迁日期BackmovingHouseAreadecimal(, )是回迁房面积BackmovingHouseNovarchar是回迁房房号BackmovingCompensationDifferenceAreavarchar是补差面积BackmovingCompensationDifferenceFeedecimal(,)是补差金额Memovarchar是备注合同审批形状表BargainExamineStatus：序号字段称号类型长度默许值可为空备注BES_IDInt否Identity，标识列Bargain_IDInt否合同编号BES_HandlersIDInt否经办人IDBES_H

18、andlerNameInt否操作称号等待审批、部门签收、指点签收、已完成BES_HandlerRemarkvarchar否操作阐明BES_DateAndTimeDatetime否操作时间k_stepnamevarchar是K审批步骤称号timestamptimestamp否时间戳合同方式表BargainFormat：序号字段称号类型长度默许值可为空备注BF_IDInt否Identity，标识列BF_Namevarchar否称号Sitevarchar是站点编号OriginSitevarchar是初始化站点编号timestamptimestamp否合同模版表BargainModel：序号字段称号类

19、型长度默许值可为空备注BM_IDInt否Identity，标识列BM_Namevarchar否模版称号BM_Pathvarchar否模版途径合同参数表Project_BargainParms：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列Keyvarchar是键Valuenvarchar是键值Sitevarchar是站点Descriptionvarchar是描画OriginSitevarchar是初始化站点编号timestamptimestamp否PDC合同产品分类表BargainPDCProductCatalog：序号字段称号类型长度默许值可为空备注IdInt否Id

20、entity，标识列Enamevarchar否编码Namevarchar否中文名Parentvarchar是父编码PDC合同产品分类关联表BargainPDCProductCatalogUsage：序号字段称号类型长度默许值可为空备注IdInt否Identity，标识列Enamevarchar否编码BTC_IDInt 否归属合同三级分类Sitevarchar否所属公司BSC_IDInt否归属合同二级分类BudgetIDInt否预算编号BudgetCodevarchar是预算编码预结算实例表BargainPreclearing：序号字段称号类型长度默许值可为空备注PreclearingIDInt

21、否Identity，标识列Bargain_IDInt否合同编号PactPriceMoney否合同价钱PreviousTotalPriceMoney否原最新总价CurrentTotalPriceMoney否当前最新总价StateCodeInt否当前形状代码(:未知，：已创建，：审批中，：审批经过，：审批回绝)Reasonvarchar否预结算缘由ApplyUserIDvarchar否经办人编号ApplyDatedatetime否经办时间ProcInstIDInt否K审批实例IDIsLastClearingbit否能否是最终结算ProjectPaymentBalanceXMLvarchar是在审批

22、未经过之前，暂存的结算实例BudgetBillXMLvarchar是预算占用工程XML序列化后的字符串Parametersvarchar是处置参数BudgetSpliteItemsXMLvarchar是预算拆分工程列表XML序列化后的字符串CreateTotalPricemoney否CreateTotalPrice合同打印模版表BargainPrintModel：序号字段称号类型长度默许值可为空备注BP_IDInt否Identity，标识列BP_Namevarchar是模版称号BP_Pathvarchar是模版途径SITEvarchar是站点编号OriginSitevarchar是初始化站点编

23、号合同权限表BargainRightsAdvanced：序号字段称号类型长度默许值可为空备注BRA_IDInt否Identity，标识列BRA_UserIDInt否用户IDBRA_Abbreviatevarchar否合同权限类型Sitevarchar是站点编码OriginSitevarchar是原始站点编码合同方式类表BargainType：序号字段称号类型长度默许值可为空备注BT_IDInt否Identity，标识列BT_Namevarchar否合同方式称号Sitevarchar是站点 编码OriginSitevarchar是初始化站点编码timestamptimestamp否甲方公司表Pr

24、oject_FirstSection：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列Namevarchar是公司称号Sitevarchar是站点编码OriginSitevarchar是初始化站点编码timestamptimestamp否Pdc订单表PDCOrderItem：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列RowNumInt是行号ItemTypevarchar是类型ItemIDvarchar是类型编号ProductNamevarchar否产品称号ProductIDInt是产品编号Categoryvarchar是类别Category

25、IDInt是类别编号Quantitymoney是数量Unitvarchar是单位Pricedecimal(, )是价钱Amountdecimal(, )是金额NeedsDatedatetime是需求日期BargainIdInt否所属合同IDPdcOrderIdInt否PDC订单IDPdc日志表PDCServiceLog：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列InvokeTimedatetime否调用时间InvokeMethodvarchar否调用方法Paramvarchar是参数一Paramvarchar是参数二ReturnValuetext是前往值Serve

26、rURLvarchar否地址sitevarchar是站点编号违约索赔表Project_Deduct：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列DEDUCTTIMESInt否索赔次数STATUSInt否FILLING():等待审批,EXAMINING():正在审批中,EXAMINED():审批完成,RELATEDPAY():已关联到付款单,DEDUCTED():已扣款,EstimateFreeze():预估冻结,Denied():审批回绝DeductAbilityInt否索赔才干-None():未知，主要是老数据无法判读能否可以胜利索赔,Unable():不能胜利索

27、赔,Able():可以胜利索赔DEDUCTAMOUNTMoney否索赔金额DISCRIPTIONvarchar是阐明CREATETIMEdatetime否创建时间CREATORIDvarchar否制单人CREATORNAMEvarchar否制单人姓名COMPLETETIMEdatetime是扣款时间COMPLETEUSERIDvarchar是扣款人IDCOMPLETEUSERNAMEvarchar是扣款人PACTIDvarchar否合同号PAYMENTIDInt是付款单IDPROJECT_PAYMENT_COMPANYvarchar是合约方PROJECTITEMIDInt否工程分期IDDedu

28、ctTypeIDInt是扣款类型IDBewritevarchar是违约情况描画Reasonvarchar是索赔根据OtherExplainvarchar是其它阐明ExamSnInt是网上审批序号DeductCompensationEasExpTimedatetime是KInstIDInt是K网上审批序号DeductTypeInt否索赔类型 确定金额() 还是 预估金额()违约索赔类型表Project_DeductType：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列NAMEvarchar是类型称号EXAMINURLvarchar是审批地址SITEvarchar是站点

29、编码SENDURLvarchar是下发地址OriginSitevarchar是初始化站点编码EXAMINURLOldvarchar是旧审批地址SENDURLOLDvarchar是旧下发地址工程付款结算表Project_Payment_Balance：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BalanceNumbervarchar否结算编号BalanceNamevarchar否结算称号BalanceCostdecimal(, )否结算造价UnitCostdecimal(, )是单位造价ContractNumvarchar否合同编号SettlementTypevar

30、char是结算专业分类BudgetIDInt是预算编号TypistUIDInt是内网制单人UserIDTypistDatedatetime是制单时间OrganizerUIDInt是内网编制人UserIDOrganizeTimedatetime是编制时间ApproverUIDInt是内网审定人UserIDApproveTimedatetime是审定时间BuildingAreavarchar是建筑面积FMonthvarchar是信息价起止月份SelectingCriterionvarchar是取费规范Expvarchar是备注Suppliervarchar是施工单位ComplexFlagInt是能

31、否采用综合价 是，否 默以为是InfoPricedecimal(, )是信息价DocBoxvarchar是资料盒Unitvarchar是单位ProjectIDInt是工程编号BalanceTypevarchar是质保金QuotedPricedecimal(, )是施工报价CheckerWkUIDvarchar是业务审核人userIDFExcuteStatusvarchar否能否最后结算Deductdecimal(, )是已付工程款Deductdecimal(, )是万科垫付款Deductdecimal(, )是工程水电费Deductdecimal(, )是代购资料、设备费Deductdecim

32、al(, )是代购物业投入费用Deductdecimal(, )是零星返修工程费Deductdecimal(, )是扣罚款Deductdecimal(, )是总包配合费Deductdecimal(, )是其他费用DeductMemovarchar是已付工程款备注DeductMemovarchar是万科垫付款备注DeductMemovarchar是工程水电费备注DeductMemovarchar是代购资料、设备费备注DeductMemovarchar是代购物业投入费用备注DeductMemovarchar是零星返修工程费备注DeductMemovarchar是扣罚款备注DeductMemovar

33、char是总包配合费备注DeductMemovarchar是其他费用备注QuotedPriceMemovarchar是施工报价备注Beetdecimal(, )是保修款比例BeetMemovarchar是保修款备注EASInnerIdvarchar是EAS内部编码EASOpStatusInt是EAS开放形状EASOpTimedatetime是EAS开发时间EASNoNeedExportbit是能否不需求导出EAS工程付款结算备注表Project_Payment_BalanceMemo：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BalanceNumbervarcha

34、r否结算编号ProjectNamevarchar否工程称号(合同称号)ZJBGbit是总价包干ZHDJbit是综合单价FLbit是费率LXvarchar是类型LXPdecimal(, )是类型百分数XXJQNInt是信息价起年XXJQYInt是信息价起月XXJZYInt是信息价止月JFXJBit是甲方限价XJCLXFInt是限价资料下浮CBFdecimal(, )是采保费ZBPHFdecimal(, )是总包配合费QTYDvarchar是其它商定ZLZBInt是资料预备JFBZvarchar是计费规范CLJGvarchar是资料价钱GCLvarchar是工程量ZHDJvarchar是综合单价F

35、HGLFvarchar是配合管理费JGCLKCvarchar是甲供资料扣除ZRKKKCvarchar是责任扣款扣除JSSWZXvarchar是结算书完好性JZMJdecimal(, )是建筑面积JZMJ_DWZJdecimal(, )是建筑面积单位造价ZCDdecimal(, )是总长度ZCD_DWZJdecimal(, )是总长度单位造价ZHSdecimal(, )是总户数ZHS_DWZJdecimal(, )是总户数单位造价JSLRHFWJSvarchar是预结算内容或范围简述CZWTvarchar是存在问题QTvarchar是其它JBRInt是经办人IDJBRQdatetime是经办日期

36、FHRInt是复核人IDFHRQdatetime是复核日期ZBBXGInt是目的表相关信息能否已填KKRQvarchar是QFBZvarchar是JGAZvarchar是XJCLvarchar是JGCLvarchar是工程付款结算修正日志表Project_Payment_BalanceModifyLog：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BalanceNumbervarchar否结算编号ModifyContentvarchar是修正内容ModifyReasonvarchar是修正缘由ModifyTimedatetime是修正时间EmployeeNameva

37、rchar是员工姓名合同模块end预算科目实体表Budget_AccountBook：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列ParentIDInt-否父级IDAccountCodevarchar否预算科目代码AccountNamevarchar否预算科目代码称号FinancialActCodevarchar否财务科目代码BudgetObjectTypeIDInt-否预算对象IDControlPloyIDInt-否控制战略IDLevelIDInt-否级别类型IDBudgetPurposeText否预算用途描画FinanceRuleInt否记账规那么TreeLev

38、elInt是树级别IsDetailBit否能否是明细科目ControlMethodIDInt是预算控制方法ID，方法不同计算方式不同Sitenvarchar否站点编号FeesProportionmoney否费用承当比例GroupCodevarchar否科目组代码timestamptimestamp否预算科目设置实体表Budget_AccountBook_Config：序号字段称号类型长度默许值可为空备注AccountCodevarchar否标识列，科目代码Sitevarchar否站点编号IsHideBit否能否隐藏ControlPloyInt否控制战略BudgetObjectTypeInt否控

39、制对象ControlMethodInt否控制方法GroupCodevarchar否科目组代码timestamptimestamp否预算单据表Budget_BudgetBill：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BudgetAccountCodevarchar否预算科目代码FinanceRuleInt-否财务规那么BudgetItemIDvarchar否预算事项IDBudgetItemNamevarchar否预算事项称号BudgetObjectTypeInt否预算对象类型值BudgetObjectValuevarchar否预算对象值BudgetObjectN

40、amevarchar否预算对象称号BTIDvarchar否业务类型IDBSIDvarchar否业务系统IDBOIDvarchar否业务对象IDInitAmountMoney否初始金额FinalAmountMoney否最终金额IsSplitbit否能否拆分预算BillDatedatetimegetdate()否单据日期CreateDatedatetimegetdate()否创建日期Sitevarchar否站点编号OriginalBudgetObjectTypeInt是初始化预算对象类型值OriginalBudgetObjectValuevarchar是初始化预算对象值OriginalBudget

41、ObjectNamevarchar是初始化预算对象称号OriginalModifyDatedatetime是初始化修正日期预算单据项表Budget_BudgetBillItem：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BillIDInt-否单据IDBTIDvarchar否业务类型IDBSIDvarchar否业务系统IDBOIDvarchar否业务对象IDIsDCbit否借贷方向BudgetObjectTypeInt-否预算对象类型值BudgetObjectValuevarchar否预算对象值BudgetObjectNamevarchar否预算对象称号Budget

42、YearInt-否预算年份BudgetMonthInt-否预算月份InitAmountMoney否初始金额FinalAmountMoney否最终金额OriginalBudgetObjectTypeInt是初始化预算对象类型值OriginalBudgetObjectValuevarchar是初始化预算对象值OriginalBudgetObjectNamevarchar是初始化预算对象称号OriginalModifyDatedatetime是初始化修正日期部门相关预算表Budget_Department_Relation：序号字段称号类型长度默许值可为空备注DepartmentIDInt否主键，部

43、门IDBudgetItemIDvarchar否主键，预算事项IDTheYearInt否主键，年份预算费用明细表Budget_BudgetLedger：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BudgetObjectTypeInt否预算对象类型值AccountCodevarchar否科目代码AccountNamevarchar否科目称号BudgetObjectValuevarchar是预算对象值BudgetObjectNamevarchar否预算对象称号BudgetItemIDuniqueidentifiernewid()否预算事项的ID编号BudgetItemN

44、amevarchar否预算事项称号BudgetAmountMoney否预算金额BudgetMonthInt否预算月份BudgetYearInt否预算年度IsLockedBit否能否锁定本预算Sitevarchar否所属站点CreationDateTimedatetimegetdate()否创建日期预算费用明细表Budget_BudgetPlan：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列BudgetObjectTypeInt否预算对象类型值AccountCodevarchar否科目代码AccountNamevarchar否科目称号BudgetObjectValue

45、varchar是预算对象值BudgetObjectNamevarchar否预算对象称号BudgetItemIDuniqueidentifiernewid()否预算事项的ID编号BudgetItemNamevarchar否预算事项称号BudgetAmountMoney否预算金额BudgetMonthInt否预算月份BudgetYearInt否预算年度IsLockedBit否能否锁定本预算Sitevarchar否所属站点CreationDateTimedatetimegetdate()否创建日期预算单据表Budget_PaperBill：序号字段称号类型长度默许值可为空备注IDInt否Identi

46、ty，标识列Titlevarchar否标题Descriptionvarchar否描画DeptIDInt-否部门IDProjectIDInt-否工程IDAmountMoney否金额BillDatedatetimegetdate()否单据日期BillUserIDvarchar否经办人用户IDBillUserNamevarchar否经办人用户名Sitevarchar否站点IsCostBit否能否本钱预算ProjectItemIdInt-否工程分期ID立项分类表PEAS_Category：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列Namenvarchar是分类称号Kurl

47、nvarchar是审批URLSitenvarchar是站点templateText是-添加模板列 用于新建立项时初始化立项内容BudgetTypeInt否预算类型:未设置,:预算内,:预算外立项表PEAS_ProjectEstablishment：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列Namenvarchar是立项称号MoneyMoney是立项金额CurrencyTypenvarchar是币种类型CategoryIdInt是分类IDPlanStartDatedatetime是方案开场日期PlanEndDatedatetime是方案终了日期Description

48、Text是阐明OperatorUserCodenvarchar是创建人CreateDatedatetimegetdate()是创建日期StateInt是审批形状ProjectItemIdInt是工程分期IDSitenvarchar是站点立项记录表PEAS_Record：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列PEASIDInt否BSIDnvarchar否BOIDnvarchar否Moneymoney否金额sitenvarchar否站点IsCancelBit否能否取消预算模块end工程套帐表PROJECT_ACCT_PRO：序号字段称号类型长度默许值可为空备注ID

49、Int否Identity，标识列，流水号AccountSetIdInt否账套流水号ProjectItemIdInt否工程分期编号FOBJIDvarchar否核算工程代码FOBJNAMEvarchar否核算工程称号DETAILNAMEvarchar否E结算ID称号EPAYCODEvarchar否E结算地产工程代码COST_FACCTIDvarchar是本钱“应付帐款会计科目代码保证金表Project_Payment_Bail：序号字段称号类型长度默许值可为空备注PaymentIDInt否主键，付款单IDBillMethodvarchar否计费方法CostOfOwnershipvarchar否费用

50、归属RefundOrChargeUnitvarchar否退款/扣款单位ReceiptNovarchar否收据编号RefundDatedatetime-否退款日期RealRefundDatedatetime-否退款日期BillDatedatetime-否开票日期BillStateInt-否保证金单据形状PaidAmountMoney是实收金额AlertUserIdsvarchar否提示邮件通知用户账户列表AlertTimeMonthsInt否提早提示月份AlertFrequencyInt否提示频率保证金配置表Project_Payment_Bail_Config：序号字段称号类型长度默许值可为空

51、备注Sitevarchar否站点编号，主键Keyvarchar否键，主键Valuevarchar否值，主键表Project_Payment_BusinessClass：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列，流水号Namevarchar否称号Codevarchar否编码Sitevarchar否站点timestamptimestamp否EAS根底数据表EASBaseData：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列，编号BaseDataTypevarchar否根底数据类型InnerIdvarchar否内码Numbervarchar

52、否EAS编码Namevarchar否称号LevelInt否层次IsLeafBit否能否子节点Parentvarchar否父节点编码OrgNumbervarchar否所属组织编码Sitevarchar否站点parentIdInt是父类IDisCostOrgUnitBit是iscompanyorgunitBit是收付明细表PROJECT_EBANKPAYDETAIL：序号字段称号类型长度默许值可为空备注IDInt否Identity，标识列，编号DETAILCODEvarchar否收付明细编号DETAILNAMEvarchar否收付明细称号DETAILIDNAMEvarchar否收付明细称号Site

53、varchar否站点OriginSitevarchar是初始化站点timestamptimestamp否付款单的审批意见表Project_Pay_Suggest：序号字段称号类型长度默许值可为空备注PROJECT_SUGGEST_IDInt否Identity，标识列，编号PROJECT_PAYMENT_IDInt是付款单IDPROJECT_ITEM_TYPEvarchar是审核形状类型PROJECT_SUGGEST_USERIDvarchar是审核用户IDPROJECT_SUGGEST_CONTENTText是审核内容PROJECT_SUGGEST_TIMEdatetime是审核时间支付表PR

54、OJECT_PAYMENT：序号字段称号类型长度默许值可为空备注PROJECT_PAYMENT_IDInt否Identity，标识列，编号PROJECT_ITEM_IDInt是工程分期IDPROJECT_PAYMENT_MAKERvarchar是付款单填写人用户名，如：v-helbPROJECT_USEDEPTIDInt是用款单位IDPROJECT_PAYEEUNITS_IDInt是PROJECT_PAYMENT_COMPANYvarchar是收款单位PROJECT_PAYMENT_EXPLAINvarchar是款项阐明PROJECT_PAYMENT_METHODInt是付款方式PROJECT

55、_PAYMENT_BANKchar是收款银行PROJECT_PAYMENT_ACCOUNTSvarchar是收款帐号PROJECT_PAYMENT_ATTACHchar是附件张数PROJECT_PAYMENT_DECLAREmoney否申报金额PROJECT_PAYMENT_PAYmoney是实践付款金额PROJECT_PAYMENT_MONEYTYPEvarchar是币别PROJECT_PAYMENT_INTIMEdatetime是填单时间PROJECT_PAYMENT_OUTTIMEvarchar是PROJECT_PAYMENT_PACTIDvarchar是合同编号PROJECT_PAYM

56、ENT_CONTENTvarchar是审批形状编码PROJECT_PAYMENT_OUTDATEdatetime是完成时间PROJECT_PAYMENT_TIMEsmalldatetime是PLAN_IDInt是PactNamevarchar是合同称号PactPricemoney是合同造价FootPricemoney是结算造价PayDegreeInt是付款次数PrePlanFundmoney是合同内工程款-上期累计PreAddFundmoney是预期工程款PreWaterCostmoney是水费(上期累计)PreAmercemoney是罚款(上期累计)PreOtherAmercemoney是其

57、他扣款 (上期累计)ThePlanFundmoney是合同内工程款-本期发生TheAddFundmoney是添加工程款-本期发生TheWaterCostmoney是水费(本期发生)TheAmercemoney是罚款(本期发生)TheOtherAmercemoney是其他扣款 (本期发生)PayType_IDInt是付款类型IDPREELECCOSTmoney是电费(上期累计)THEELECCOSTmoney是电费(本期发生)PREASSORTCOSTmoney是配合费(上期累计)THEASSORTCOSTmoney是配合费(本期发生)INVOICEmoney是发票金额NEEDEXPORTTOC

58、OSTtinyint是能否需求导出本钱EXPORTTOCOSTDATEdatetime是NEEDEXPORTTOEBANKtinyint是能否需求导出E结算EXPORTTOEBANKDATEdatetime是EXPORTTOKINGDEEDATEdatetime是导出凭证时间FDATEdatetime是FPAYBILLNUMvarchar是付款单号FNUMfloat是PAYACCOUNTvarchar是付款帐号EBANKDETAILCODEvarchar是E结算收付明细代码EBANKPURPOSEvarchar是E结算目的EBankRemarkvarchar是E结算备注DEBITACCTIDv

59、archar是KINGDEEEBANKCREDITACCTIDvarchar是E结算贷方科目代码KINGDEENOTEBANKCREDITACCTIDvarchar是非E结算贷方科目代码FEXCHRATEfloat是RecBankProvincevarchar是收款行省份RecBankCityvarchar是收款行城市RecBankCityTypevarchar是收款城市类别GeneralLedgerSummaryvarchar是凭证摘要AccountSetInt是帐套IDMergeToContractBit是PayTimeRequiredatetime是付款时间要求InstancyDegre

60、evarchar是紧急程度VirtualPactExportCostAccountIdInt是BusinessTypeIDInt是业务类型IDSitevarchar是站点编码FCLSNAMEvarchar是FOBJIDvarchar是FOBJNAMEvarchar是FCLSNAMEvarchar是FOBJIDvarchar是FOBJNAMEvarchar是LoanIDInt是IsExportPaymentInt是能否导出付款ExportPaymentDatedatetime是IsExportVoucherInt是ExportVoucherDatedatetime是OriginSitevarch