合同与支付管理数据表

1、.：.；合同三级分类表BargainThirdCatalog序号字段称号类型长度默许值可为空备注1BTC_IDInt8否Identity(1,1) 主键2BM_IDint8否录入模板编号3BSC_IDInt8否二级分类ID4BTC_CatalogNamevarchar50否合同分类称号5BTC_CatalogAbbreviationvarchar50否三级类别代码生成的合同号代码6BTC_BargainExamineFlowvarchar6000否审批流描画信息7BP_IDInt8是打印模板编号8ExFlowUrlvarchar200是网上审批地址9OrderFlowUrlvarchar200

2、是设计/营销订单审核URL10OddFlowUrlvarchar200是零星业务恳求单审核URL11TellCostBit40否邮件通知本钱12TellFinanceBit40否邮件通知财务13TellSecretaryBit40否邮件通知工程秘书14NeedPaymentPlanBit40否能否需求付款方案15AlertTextvarchar500是合同填写提示16TellPartyBBit41否邮件通知合约方17StrategyFlowUrlvarchar200是战略合同审核URL18EASTypeNumbervarchar50是对应EAS合同类型编码19JingHuaAuditUrlva

3、rchar500是20JingHuaOrderAuditURLvarchar500是21JingHuaOddBillAuditURLvarchar500是22K2AuditUrlvarchar500是23K2OrderAuditURLvarchar500是24K2OddBillAuditURLvarchar500是25K2StrategyFlowUrlvarchar500是26PDCServiceTypevarchar1000是27ForbidInputBit40是28TelloperatorBit40否邮件通知经办人29SMSTellOperatorBit4FALSE否短信通知经办人30SM

4、STellCostBit4FALSE否短信通知本钱31SMSTellFinanceBit4FALSE否短信通知财务32SMSTellSecretaryBit4FALSE否短信通知工程秘书33SMSTellPartyBBit4FALSE否短信通知合约方34NeedBudgetControlBit40否能否需求预算控制35DefaultBgtActCodevarchar500否36NeedPEASControlmoney0否能否需求立项控制37IsCostBargainBit40否能否本钱合同38PreClearApprovalUrlvarchar500否预结算审批地址39PermissionEn

5、abledBit40否能否开启权限控制40NeedLimitPaymentRationBit40否能否限制付款合同一级分类表BargainFirstCatalog：序号字段称号类型长度默许值可为空备注1BFC_IDInt4否Identity(1,1) 标识列2BFC_CatalogNamevarchar50否一级分类称号3Sitevarchar50shenzhen是站点4OriginSitevarchar50 是5timestamptimestamp否合同二级分类表BargainSecondCatalog：序号字段称号类型长度默许值可为空备注1BSC_IDInt4否Identity(1,1)

6、标识列2BFC_IDInt4否一级分类ID3BSC_CatalogNamevarchar50否二级分类称号合同表Bargain序号字段称号类型长度默许值可为空备注1Bargain_IDInt4否Identity1，1标识列2BTC_IDInt4否合同三级分类编号3BF_IDInt4否合同方式编号合同1、补充合同3、战略合同74BA_IDInt4否合同区域5BT_IDInt4否合同类型编号6Bargain_FinalStatusvarchar100否形状7BES_HandlerNameInt4否当前审批形状编号，1为等待审批，2为部门签收，3为指点签收，4为指点经过，5为等待修正，0为初始形状8

7、Bargain_SerialNumbervarchar100否合同号9Bargain_ProjectIDInt4否合同工程分期编号10Bargain_OriginalCatalogIDInt4是合同初始化分类编号11Bargain_Namevarchar100否合同称号12Bargain_OwnerIDInt4否经办人编号13Bargain_OwnerDepartmentIDInt4是经办人办理时所在的部门编号，经办人有能够调离部门14Bargain_FirstSectionvarchar200否甲方单位15Bargain_SecondSectionvarchar200否乙方称号16Barga

8、in_Copiesint4否合同份数17Bargain_ThirdSectionvarchar200是丙方称号18Bargain_FourthSectionvarchar300是丁方称号19Bargain_PlanPricesMoney是额度20Bargain_TotalPricesMoney否合同总价21Bargain_UnitPricevarchar50是合同单价22Bargain_CurrencyTypeVarchar10否币种23Bargain_FirmSelectInt4否单位选择24Bargain_FirmSelectRemarkvarchar50是单位选择阐明25Bargain_

9、PayPromisevarchar300否付款商定26Bargain_TimeLimitPromisevarchar100否期限商定27Bargain_Remarktext是需求阐明事项28Bargain_DateTimedatetime否合同填写时间29Bargain_ParentIDInt4是主合同ID30Bargain_SpecialParentIDInt4是战略合同ID31Bargain_NeedExportbit2否合同能否需求导出，零星业务恳求单永远不导出32Bargain_IsExportedJHBit2否能否导出京华33Bargain_IsExportedCBBit2否能否导出

10、本钱34Bargain_ReadyOnevarchar100是预备字段一35Bargain_ReadyTwovarchar100是预备字段二36Bargain_ReadyThreeInt4是预备字段三37Bargain_ReadyFourInt4是预备字段四38ExFlowProcIDInt4是京华审批ID39Bargain_CostPropertyvarchar50是合同造价性质40Bargain_SelectWayvarchar50是中标方式41FootPriceMoney是最新总价42IsCanceledInt40是能否取消43BargainEffectedDatedatetime是归档

11、日期44BargainPriceMemovarchar200是合同总价备注45BeetMemovarchar200是保修款备注46Beetdecimal18，0是保修款比例47MarketingBTCIDint40是合同的营销三级类别ID，如非营销合同，此字段值为空48IsCloseEvaluationBit0否能否封锁49K2InstIDInt4是K2InstID50PDCOrderIdInt4是PDC订单ID51PDCOpStatusInt4是PDC形状52PDCOpTimeDatetime是PDCOpTime53AssetsPurchaseOrderIDInt4是54IsAnnulBit

12、20是能否作废55BargainReviseDoneBit20是56BargainEasExpTimeDatetime是57BargainReviseEasExpTimeDatetime是58BargainBalanceEasExpTimeDatetime是59PrePDCOpStatusInt4是60PrePDCOpTimedatetime是61PreBES_IDInt4是62PreBargain_FinalStatusvarchar100是63PreBES_HandlerNameInt4是64PreBargain_ReadyTwovarchar100是65PreBargain_Serial

13、Numbervarchar100是预结算合同号66EASInnerIdvarchar100是67EASOpStatusint4是68EASOpTimedatetime是69EASNoNeedExportBit是EAS不需求导出70IsCloseBitFALSE否能否封锁71FeedBackRemarkText否合同归档备注72SignatureRemarktext否合同盖章备注73ExchangeRateFloat是汇率74timestamptimestamp否75NeedLimitPaymentRationBit0否能否限制付款76LimitPaymentRationMoney1否限制付款比

14、例77IsFeeSplitBit0否能否是费用分摊合同，假设是的话就出如今费用分摊的列表拆迁公司表Bargain_DemolitionCompanies：序号字段称号类型长度默许值可为空备注1CompanyIDInt4否Identity1，1标识列2Namevarchar1000否称号3IsClosedBit0否能否封锁4IsDeletedBit0否能否被删除5IsAuditedBit0否能否审核6Sitevarchar500否所属站点拆迁公司表Bargain_DemolitionHouses：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BargainID

15、Int4否合同编号3HouseBuildingNovarchar100否房屋栋号4HouseNovarchar100否房屋号5HouseTypevarchar200否房间类型6HouseQuantityInt4否房屋套数7CredentialTypevarchar100否证件类型8CredentialNovarchar100否证件编号9Linkmanvarchar200是联络人10Phonevarchar200是联络11Addressvarchar1000是12DemolitionCompanyNamevarchar200是拆迁公司称号13MoveAreadecimal(10, 3)是永迁面积

16、14BackmovingAreadecimal(10, 3)是回迁面积15BackmovingExchangeAreadecimal(10, 3)是回迁置换面积16MoveCompensationFeedecimal(10, 2)是永迁类-货币补偿费用17MoveIncentiveFeedecimal(10, 2)是永迁类-奖励费用18MoveOneTimeCompensationFeedecimal(10, 2)是永迁类-一次性补偿费用19MoveOneTimeCompensationFeeNotevarchar2000是永迁类-一次性补偿阐明20BackmovingDecorationCo

17、mpensationFeedecimal(10, 2)是回迁类-装修补偿费用21BackmovingMoveHouseFeedecimal(10, 2)是回迁类-搬家费22BackmovingAdjunctCompensationFeedecimal(10, 2)是回迁类-附属物业补偿费23BackmovingIncentiveFeedecimal(10, 2)是回迁类-奖励金额24BackmovingOneTimeCompensationFeedecimal(10, 2)是回迁类-一次性补偿费25BackmovingOneTimeCompensationFeeNotevarchar2000是

18、回迁类-一次性补偿费阐明26BackmovingParkingSpaceQuantityInt4是回迁类-车位数量27TransitionFeeStandarddecimal(10, 2)是过渡费规范(元/月/平米)28TransitionAreadecimal(10, 3)是过渡费计算面积29TransitionFeeBeginDatedatetime是过渡费起始支付日期30TransitionFeeEndDatedatetime是过渡费终了支付日期31DeliveryHousesAgreedDatedatetime是拆迁交房商定时间32DeliveryHousesRealityDateda

19、tetime是拆迁房实践交房日期33BackmovingDatedatetime是回迁日期34BackmovingHouseAreadecimal(10, 3)是回迁房面积35BackmovingHouseNovarchar100是回迁房房号36BackmovingCompensationDifferenceAreavarchar100是补差面积37BackmovingCompensationDifferenceFeedecimal(10,2)是补差金额38Memovarchar2000是备注合同审批形状表BargainExamineStatus：序号字段称号类型长度默许值可为空备注1BES_

20、IDInt4否Identity1，1标识列2Bargain_IDInt4否合同编号3BES_HandlersIDInt4否经办人ID4BES_HandlerNameInt4否操作称号等待审批、部门签收、指点签收、已完成5BES_HandlerRemarkvarchar8000否操作阐明6BES_DateAndTimeDatetime否操作时间7k2_stepnamevarchar200是K2审批步骤称号8timestamptimestamp否时间戳合同方式表BargainFormat：序号字段称号类型长度默许值可为空备注1BF_IDInt4否Identity1，1标识列2BF_Namevarc

21、har50否称号3Sitevarchar50是站点编号4OriginSitevarchar50是初始化站点编号5timestamptimestamp否合同模版表BargainModel：序号字段称号类型长度默许值可为空备注1BM_IDInt4否Identity1，1标识列2BM_Namevarchar50否模版称号3BM_Pathvarchar100否模版途径合同参数表Project_BargainParms：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2Keyvarchar50是键3Valuenvarchar250是键值4Sitevarchar50是站点5

22、Descriptionvarchar100是描画6OriginSitevarchar50是初始化站点编号7timestamptimestamp否PDC合同产品分类表BargainPDCProductCatalog：序号字段称号类型长度默许值可为空备注1IdInt4否Identity1，1标识列2Enamevarchar50否编码3Namevarchar100否中文名4Parentvarchar50是父编码PDC合同产品分类关联表BargainPDCProductCatalogUsage：序号字段称号类型长度默许值可为空备注1IdInt4否Identity1，1标识列2Enamevarchar5

23、0否编码3BTC_IDInt 4否归属合同三级分类4Sitevarchar50否所属公司5BSC_IDInt40否归属合同二级分类6BudgetIDInt40否预算编号7BudgetCodevarchar100是预算编码预结算实例表BargainPreclearing：序号字段称号类型长度默许值可为空备注1PreclearingIDInt4否Identity1，1标识列2Bargain_IDInt4否合同编号3PactPriceMoney否合同价钱4PreviousTotalPriceMoney否原最新总价5CurrentTotalPriceMoney否当前最新总价6StateCodeInt4

24、否当前形状代码(0:未知，1：已创建，2：审批中，3：审批经过，4：审批回绝)7Reasonvarchar2000否预结算缘由8ApplyUserIDvarchar50否经办人编号9ApplyDatedatetime否经办时间10ProcInstIDInt4否K2审批实例ID11IsLastClearingbit否能否是最终结算12ProjectPaymentBalanceXMLvarchar5000是在审批未经过之前，暂存的结算实例13BudgetBillXMLvarchar5000是预算占用工程XML序列化后的字符串14Parametersvarchar500是处置参数15BudgetSp

25、liteItemsXMLvarchar8000是预算拆分工程列表XML序列化后的字符串16CreateTotalPricemoney否CreateTotalPrice合同打印模版表BargainPrintModel：序号字段称号类型长度默许值可为空备注1BP_IDInt4否Identity1，1标识列2BP_Namevarchar50是模版称号3BP_Pathvarchar50是模版途径4SITEvarchar50是站点编号5OriginSitevarchar50是初始化站点编号合同权限表BargainRightsAdvanced：序号字段称号类型长度默许值可为空备注1BRA_IDInt4否I

26、dentity1，1标识列2BRA_UserIDInt4否用户ID3BRA_Abbreviatevarchar20否合同权限类型4Sitevarchar50是站点编码5OriginSitevarchar50是原始站点编码合同方式类表BargainType：序号字段称号类型长度默许值可为空备注1BT_IDInt4否Identity1，1标识列2BT_Namevarchar50否合同方式称号3Sitevarchar50是站点 编码4OriginSitevarchar50是初始化站点编码5timestamptimestamp否甲方公司表Project_FirstSection：序号字段称号类型长度默

27、许值可为空备注1IDInt4否Identity1，1标识列2Namevarchar50是公司称号3Sitevarchar50是站点编码4OriginSitevarchar50是初始化站点编码5timestamptimestamp否Pdc订单表PDCOrderItem：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2RowNumInt4是行号3ItemTypevarchar200是类型4ItemIDvarchar100是类型编号5ProductNamevarchar100否产品称号6ProductIDInt4是产品编号7Categoryvarchar200是类别

28、8CategoryIDInt4是类别编号9Quantitymoney是数量10Unitvarchar100是单位11Pricedecimal(18, 2)是价钱12Amountdecimal(18, 2)是金额13NeedsDatedatetime是需求日期14BargainIdInt4否所属合同ID15PdcOrderIdInt4否PDC订单IDPdc日志表PDCServiceLog：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2InvokeTimedatetime否调用时间3InvokeMethodvarchar200否调用方法4Param1varcha

29、r5000是参数一5Param2varchar5000是参数二6ReturnValuetext是前往值7ServerURLvarchar200否地址8sitevarchar30是站点编号违约索赔表Project_Deduct：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2DEDUCTTIMESInt4否索赔次数3STATUSInt4否FILLING(0):等待审批,EXAMINING(1):正在审批中,EXAMINED(2):审批完成,RELATEDPAY(3):已关联到付款单,DEDUCTED(4):已扣款,EstimateFreeze(5):预估冻结,D

30、enied(6):审批回绝4DeductAbilityInt40否索赔才干-None(0):未知，主要是老数据无法判读能否可以胜利索赔,Unable(1):不能胜利索赔,Able(2):可以胜利索赔5DEDUCTAMOUNTMoney否索赔金额6DISCRIPTIONvarchar2000是阐明7CREATETIMEdatetime否创建时间8CREATORIDvarchar50否制单人9CREATORNAMEvarchar50否制单人姓名10COMPLETETIMEdatetime是扣款时间11COMPLETEUSERIDvarchar50是扣款人ID12COMPLETEUSERNAMEva

31、rchar50是扣款人13PACTIDvarchar50否合同号14PAYMENTIDInt4是付款单ID15PROJECT_PAYMENT_COMPANYvarchar200是合约方16PROJECTITEMIDInt4否工程分期ID17DeductTypeIDInt4是扣款类型ID18Bewritevarchar500是违约情况描画19Reasonvarchar500是索赔根据20OtherExplainvarchar500是其它阐明21ExamSnInt40是网上审批序号22DeductCompensationEasExpTimedatetime是23K2InstIDInt4是K2网上审

32、批序号24DeductTypeInt40否索赔类型 确定金额(0) 还是 预估金额(1)违约索赔类型表Project_DeductType：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2NAMEvarchar50是类型称号3EXAMINURLvarchar300是审批地址4SITEvarchar50是站点编码5SENDURLvarchar300是下发地址6OriginSitevarchar50是初始化站点编码7EXAMINURLOldvarchar300是旧审批地址8SENDURLOLDvarchar300是旧下发地址工程付款结算表Project_Payme

33、nt_Balance：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BalanceNumbervarchar50否结算编号3BalanceNamevarchar500否结算称号4BalanceCostdecimal(18, 2)否结算造价5UnitCostdecimal(18, 2)是单位造价6ContractNumvarchar50否合同编号7SettlementTypevarchar50是结算专业分类8BudgetIDInt4是预算编号9TypistUIDInt4是内网制单人UserID10TypistDatedatetime是制单时间11Organiz

34、erUIDInt4是内网编制人UserID12OrganizeTimedatetime是编制时间13ApproverUIDInt4是内网审定人UserID14ApproveTimedatetime是审定时间15BuildingAreavarchar50是建筑面积16FMonthvarchar50是信息价起止月份17SelectingCriterionvarchar50是取费规范18Expvarchar500是备注19Suppliervarchar50是施工单位20ComplexFlagInt4是能否采用综合价 1是，2否 默以为是21InfoPricedecimal(18, 0)是信息价22D

35、ocBoxvarchar100是资料盒23Unitvarchar100是单位24ProjectIDInt4是工程编号25BalanceTypevarchar50是质保金26QuotedPricedecimal(18, 2)是施工报价27CheckerWkUIDvarchar50是业务审核人userID28FExcuteStatusvarchar501否能否最后结算29Deduct1decimal(18, 2)是已付工程款30Deduct2decimal(18, 2)是万科垫付款31Deduct3decimal(18, 2)是工程水电费32Deduct4decimal(18, 2)是代购资料、设

36、备费33Deduct5decimal(18, 2)是代购物业投入费用34Deduct6decimal(18, 2)是零星返修工程费35Deduct7decimal(18, 2)是扣罚款36Deduct8decimal(18, 2)是总包配合费37Deduct9decimal(18, 2)是其他费用38Deduct1Memovarchar200是已付工程款备注39Deduct2Memovarchar200是万科垫付款备注40Deduct3Memovarchar200是工程水电费备注41Deduct4Memovarchar200是代购资料、设备费备注42Deduct5Memovarchar200是

37、代购物业投入费用备注43Deduct6Memovarchar200是零星返修工程费备注44Deduct7Memovarchar200是扣罚款备注45Deduct8Memovarchar200是总包配合费备注46Deduct9Memovarchar200是其他费用备注47QuotedPriceMemovarchar200是施工报价备注48Beetdecimal(18, 2)是保修款比例49BeetMemovarchar200是保修款备注50EASInnerIdvarchar100是EAS内部编码51EASOpStatusInt4是EAS开放形状52EASOpTimedatetime是EAS开发时

38、间53EASNoNeedExportbit是能否不需求导出EAS工程付款结算备注表Project_Payment_BalanceMemo：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BalanceNumbervarchar50否结算编号3ProjectNamevarchar200否工程称号(合同称号)4ZJBGbit是总价包干5ZHDJbit是综合单价6FLbit是费率7LXvarchar50是类型8LXPdecimal(18, 2)是类型百分数9XXJQNInt4是信息价起年10XXJQYInt4是信息价起月11XXJZYInt4是信息价止月12JFXJ

39、Bit是甲方限价13XJCLXFInt4是限价资料下浮14CBFdecimal(18, 2)是采保费15ZBPHFdecimal(18, 2)是总包配合费16QTYDvarchar50是其它商定17ZLZBInt4是资料预备18JFBZvarchar50是计费规范19CLJGvarchar50是资料价钱20GCLvarchar50是工程量21ZHDJ1varchar50是综合单价122FHGLFvarchar50是配合管理费23JGCLKCvarchar50是甲供资料扣除24ZRKKKCvarchar50是责任扣款扣除25JSSWZXvarchar50是结算书完好性26JZMJdecimal(

40、18, 2)是建筑面积27JZMJ_DWZJdecimal(18, 2)是建筑面积单位造价28ZCDdecimal(18, 2)是总长度29ZCD_DWZJdecimal(18, 2)是总长度单位造价30ZHSdecimal(18, 2)是总户数31ZHS_DWZJdecimal(18, 2)是总户数单位造价32JSLRHFWJSvarchar300是预结算内容或范围简述33CZWTvarchar300是存在问题34QTvarchar300是其它35JBRInt4是经办人ID36JBRQdatetime是经办日期37FHRInt4是复核人ID38FHRQdatetime是复核日期39ZBBXG

41、Int4是目的表相关信息能否已填40KKRQvarchar50是41QFBZvarchar300是42JGAZvarchar300是43XJCLvarchar300是44JGCLvarchar300是工程付款结算修正日志表Project_Payment_BalanceModifyLog：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BalanceNumbervarchar50否结算编号3ModifyContentvarchar300是修正内容4ModifyReasonvarchar300是修正缘由5ModifyTimedatetime是修正时间6Employ

42、eeNamevarchar50是员工姓名合同模块end预算科目实体表Budget_AccountBook：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2ParentIDInt4-1否父级ID3AccountCodevarchar100否预算科目代码4AccountNamevarchar200否预算科目代码称号5FinancialActCodevarchar100否财务科目代码6BudgetObjectTypeIDInt4-1否预算对象ID7ControlPloyIDInt4-1否控制战略ID8LevelIDInt4-1否级别类型ID9BudgetPurpos

43、eText否预算用途描画10FinanceRuleInt4否记账规那么11TreeLevelInt4是树级别12IsDetailBit0否能否是明细科目13ControlMethodIDInt40是预算控制方法ID，方法不同计算方式不同14Sitenvarchar50否站点编号15FeesProportionmoney1否费用承当比例16GroupCodevarchar500否科目组代码17timestamptimestamp否预算科目设置实体表Budget_AccountBook_Config：序号字段称号类型长度默许值可为空备注1AccountCodevarchar500否标识列，科目代码

44、2Sitevarchar50否站点编号3IsHideBit0否能否隐藏4ControlPloyInt40否控制战略5BudgetObjectTypeInt40否控制对象6ControlMethodInt40否控制方法7GroupCodevarchar500否科目组代码8timestamptimestamp否预算单据表Budget_BudgetBill：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BudgetAccountCodevarchar100否预算科目代码3FinanceRuleInt4-1否财务规那么4BudgetItemIDvarchar50否预

45、算事项ID5BudgetItemNamevarchar500否预算事项称号6BudgetObjectTypeInt40否预算对象类型值7BudgetObjectValuevarchar50否预算对象值8BudgetObjectNamevarchar500否预算对象称号9BTIDvarchar100否业务类型ID10BSIDvarchar100否业务系统ID11BOIDvarchar100否业务对象ID12InitAmountMoney0否初始金额13FinalAmountMoney0否最终金额14IsSplitbit0否能否拆分预算15BillDatedatetimegetdate()否单据日

46、期16CreateDatedatetimegetdate()否创建日期17Sitevarchar50否站点编号18OriginalBudgetObjectTypeInt4是初始化预算对象类型值19OriginalBudgetObjectValuevarchar50是初始化预算对象值20OriginalBudgetObjectNamevarchar500是初始化预算对象称号21OriginalModifyDatedatetime是初始化修正日期预算单据项表Budget_BudgetBillItem：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BillIDIn

47、t4-1否单据ID3BTIDvarchar100否业务类型ID4BSIDvarchar100否业务系统ID5BOIDvarchar100否业务对象ID6IsDCbit1否借贷方向7BudgetObjectTypeInt4-1否预算对象类型值8BudgetObjectValuevarchar50否预算对象值9BudgetObjectNamevarchar500否预算对象称号10BudgetYearInt4-1否预算年份11BudgetMonthInt4-1否预算月份12InitAmountMoney0否初始金额13FinalAmountMoney0否最终金额14OriginalBudgetObj

48、ectTypeInt4是初始化预算对象类型值15OriginalBudgetObjectValuevarchar50是初始化预算对象值16OriginalBudgetObjectNamevarchar500是初始化预算对象称号17OriginalModifyDatedatetime是初始化修正日期部门相关预算表Budget_Department_Relation：序号字段称号类型长度默许值可为空备注1DepartmentIDInt4否主键，部门ID2BudgetItemIDvarchar50否主键，预算事项ID3TheYearInt4否主键，年份预算费用明细表Budget_BudgetLedg

49、er：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BudgetObjectTypeInt4否预算对象类型值3AccountCodevarchar100否科目代码4AccountNamevarchar200否科目称号5BudgetObjectValuevarchar200是预算对象值6BudgetObjectNamevarchar200否预算对象称号7BudgetItemIDuniqueidentifiernewid()否预算事项的ID编号8BudgetItemNamevarchar200否预算事项称号9BudgetAmountMoney0否预算金额10Bu

50、dgetMonthInt4否预算月份11BudgetYearInt4否预算年度12IsLockedBit0否能否锁定本预算13Sitevarchar50否所属站点14CreationDateTimedatetimegetdate()否创建日期预算费用明细表Budget_BudgetPlan：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2BudgetObjectTypeInt4否预算对象类型值3AccountCodevarchar100否科目代码4AccountNamevarchar200否科目称号5BudgetObjectValuevarchar200是预算

51、对象值6BudgetObjectNamevarchar200否预算对象称号7BudgetItemIDuniqueidentifiernewid()否预算事项的ID编号8BudgetItemNamevarchar200否预算事项称号9BudgetAmountMoney0否预算金额10BudgetMonthInt4否预算月份11BudgetYearInt4否预算年度12IsLockedBit0否能否锁定本预算13Sitevarchar50否所属站点14CreationDateTimedatetimegetdate()否创建日期预算单据表Budget_PaperBill：序号字段称号类型长度默许值可

52、为空备注1IDInt4否Identity1，1标识列2Titlevarchar500否标题3Descriptionvarchar8000否描画4DeptIDInt4-1否部门ID5ProjectIDInt4-1否工程ID6AmountMoney0否金额7BillDatedatetimegetdate()否单据日期8BillUserIDvarchar100否经办人用户ID9BillUserNamevarchar500否经办人用户名10Sitevarchar50否站点11IsCostBit0否能否本钱预算12ProjectItemIdInt4-1否工程分期ID立项分类表PEAS_Category：

53、序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2Namenvarchar255是分类称号3K2urlnvarchar255是审批URL4Sitenvarchar50是站点5templateText是2021-12-29添加模板列 用于新建立项时初始化立项内容6BudgetTypeInt40否预算类型0:未设置,1:预算内,2:预算外立项表PEAS_ProjectEstablishment：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2Namenvarchar255是立项称号3MoneyMoney是立项金额4CurrencyT

54、ypenvarchar50是币种类型5CategoryIdInt4是分类ID6PlanStartDatedatetime是方案开场日期7PlanEndDatedatetime是方案终了日期8DescriptionText是阐明9OperatorUserCodenvarchar50是创建人10CreateDatedatetimegetdate()是创建日期11StateInt4是审批形状12ProjectItemIdInt4是工程分期ID13Sitenvarchar50是站点立项记录表PEAS_Record：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列2PEA

55、SIDInt4否3BSIDnvarchar50否4BOIDnvarchar50否5Moneymoney否金额6sitenvarchar50否站点7IsCancelBit0否能否取消预算模块end工程套帐表PROJECT_ACCT_PRO：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列，流水号2AccountSetIdInt4否账套流水号3ProjectItemIdInt4否工程分期编号4FOBJID1varchar80否核算工程代码15FOBJNAME1varchar80否核算工程称号16DETAILNAMEvarchar50否E结算ID称号7EPAYCODE

56、varchar10否E结算地产工程代码8COST_FACCTIDvarchar100是本钱“应付帐款会计科目代码保证金表Project_Payment_Bail：序号字段称号类型长度默许值可为空备注1PaymentIDInt4否主键，付款单ID2BillMethodvarchar500否计费方法3CostOfOwnershipvarchar500否费用归属4RefundOrChargeUnitvarchar1000否退款/扣款单位5ReceiptNovarchar100否收据编号6RefundDatedatetime1900-1-1否退款日期7RealRefundDatedatetime190

57、0-1-1否退款日期8BillDatedatetime1900-1-1否开票日期9BillStateInt4-1否保证金单据形状10PaidAmountMoney是实收金额11AlertUserIdsvarchar500否提示邮件通知用户账户列表12AlertTimeMonthsInt43否提早提示月份13AlertFrequencyInt43否提示频率保证金配置表Project_Payment_Bail_Config：序号字段称号类型长度默许值可为空备注1Sitevarchar100否站点编号，主键2Keyvarchar100否键，主键3Valuevarchar100否值，主键表Projec

58、t_Payment_BusinessClass：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列，流水号2Namevarchar50否称号3Codevarchar50否编码4Sitevarchar100否站点5timestamptimestamp否EAS根底数据表EASBaseData：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列，编号2BaseDataTypevarchar50否根底数据类型3InnerIdvarchar100否内码4Numbervarchar200否EAS编码5Namevarchar1000否称号6Leve

59、lInt40否层次7IsLeafBit0否能否子节点8Parentvarchar100否父节点编码9OrgNumbervarchar100否所属组织编码10Sitevarchar50否站点11parentIdInt4是父类ID12isCostOrgUnitBit是13iscompanyorgunitBit是收付明细表PROJECT_EBANKPAYDETAIL：序号字段称号类型长度默许值可为空备注1IDInt4否Identity1，1标识列，编号2DETAILCODEvarchar10否收付明细编号3DETAILNAMEvarchar50否收付明细称号4DETAILIDNAMEvarchar5

60、0否收付明细称号5Sitevarchar50否站点6OriginSitevarchar50是初始化站点7timestamptimestamp否付款单的审批意见表Project_Pay_Suggest：序号字段称号类型长度默许值可为空备注1PROJECT_SUGGEST_IDInt4否Identity1，1标识列，编号2PROJECT_PAYMENT_IDInt4是付款单ID3PROJECT_ITEM_TYPEvarchar3是审核形状类型4PROJECT_SUGGEST_USERIDvarchar15是审核用户ID5PROJECT_SUGGEST_CONTENTText是审核内容6PROJEC