合同与支付管理数据表

合同三级分类表（BargainThirdCatalog）序号字段名称类型长度默认值可为空备注1BTC_IDInt8否Identity(1,1)主键2BM_IDint8否录入模板编号3BSC_IDInt8否二级分类ID4BTC_CatalogNamevarchar50否合同分类名称5BTC_CatalogAbbreviationvarchar50否三级类别代码（生成的合同号代码）6BTC_BargainExamineFlowvarchar6000否审批流描述信息7BP_IDInt8是打印模板编号8ExFlowUrlvarchar200‘’是网上审批地址9OrderFlowUrlvarchar200‘’是设计/营销订单审核URL10OddFlowUrlvarchar200‘’是零星业务申请单审核URL11TellCostBit40否邮件通知成本12TellFinanceBit40否邮件通知财务13TellSecretaryBit40否邮件通知项目秘书14NeedPaymentPlanBit40否是否需要付款计划15AlertTextvarchar500是合同填写提示16TellPartyBBit41否邮件通知合约方17StrategyFlowUrlvarchar200是战略合同审核URL18EASTypeNumbervarchar50是对应EAS合同类型编码19JingHuaAuditUrlvarchar500是20JingHuaOrderAuditURLvarchar500是21JingHuaOddBillAuditURLvarchar500是22K2AuditUrlvarchar500是23K2OrderAuditURLvarchar500是24K2OddBillAuditURLvarchar500是25K2StrategyFlowUrlvarchar500是26PDCServiceTypevarchar1000是27ForbidInputBit40是28TelloperatorBit40否邮件通知经办人29SMSTellOperatorBit4FALSE否短信通知经办人30SMSTellCostBit4FALSE否短信通知成本31SMSTellFinanceBit4FALSE否短信通知财务32SMSTellSecretaryBit4FALSE否短信通知项目秘书33SMSTellPartyBBit4FALSE否短信通知合约方34NeedBudgetControlBit40否是否需要预算控制35DefaultBgtActCodevarchar500‘’否36NeedPEASControlmoney0否是否需要立项控制37IsCostBargainBit40否是否成本合同38PreClearApprovalUrlvarchar500‘’否预结算审批地址39PermissionEnabledBit40否是否开启权限控制40NeedLimitPaymentRationBit40否是否限制付款合同一级分类表（BargainFirstCatalog）：序号字段名称类型长度默认值可为空备注1BFC_IDInt4否Identity(1,1)标识列2BFC_CatalogNamevarchar50否一级分类名称3Sitevarchar50'shenzhen'是站点4OriginSitevarchar50是5timestamptimestamp否合同二级分类表（BargainSecondCatalog）：序号字段名称类型长度默认值可为空备注1BSC_IDInt4否Identity(1,1)标识列2BFC_IDInt4否一级分类ID3BSC_CatalogNamevarchar50否二级分类名称合同表（Bargain）序号字段名称类型长度默认值可为空备注1Bargain_IDInt4否Identity（1，1）标识列2BTC_IDInt4否合同三级分类编号3BF_IDInt4否合同形式编号（合同1、补充合同3、战略合同7）4BA_IDInt4否合同区域5BT_IDInt4否合同类型编号6Bargain_FinalStatusvarchar100否状态7BES_HandlerNameInt4否当前审批状态编号，1为等待审批，2为部门签收，3为领导签收，4为领导通过，5为等待修改，0为初始状态8Bargain_SerialNumbervarchar100否合同号9Bargain_ProjectIDInt4否合同项目分期编号10Bargain_OriginalCatalogIDInt4是合同初始化分类编号11Bargain_Namevarchar100否合同名称12Bargain_OwnerIDInt4否经办人编号13Bargain_OwnerDepartmentIDInt4是经办人办理时所在的部门编号，经办人有可能调离部门14Bargain_FirstSectionvarchar200否甲方单位15Bargain_SecondSectionvarchar200否乙方名称16Bargain_Copiesint4否合同份数17Bargain_ThirdSectionvarchar200是丙方名称18Bargain_FourthSectionvarchar300是丁方名称19Bargain_PlanPricesMoney是额度20Bargain_TotalPricesMoney否合同总价21Bargain_UnitPricevarchar50是合同单价22Bargain_CurrencyTypeVarchar10否币种23Bargain_FirmSelectInt4否单位选择24Bargain_FirmSelectRemarkvarchar50是单位选择说明25Bargain_PayPromisevarchar300否付款约定26Bargain_TimeLimitPromisevarchar100否期限约定27Bargain_Remarktext是需要说明事项28Bargain_DateTimedatetime否合同填写时间29Bargain_ParentIDInt4是主合同ID30Bargain_SpecialParentIDInt4是战略合同ID31Bargain_NeedExportbit2否合同是否需要导出，零星业务申请单永远不导出32Bargain_IsExportedJHBit2否是否导出京华33Bargain_IsExportedCBBit2否是否导出成本34Bargain_ReadyOnevarchar100是预备字段一35Bargain_ReadyTwovarchar100是预备字段二36Bargain_ReadyThreeInt4是预备字段三37Bargain_ReadyFourInt4是预备字段四38ExFlowProcIDInt4是京华审批ID39Bargain_CostPropertyvarchar50是合同造价性质40Bargain_SelectWayvarchar50是中标方式41FootPriceMoney是最新总价42IsCanceledInt40是是否取消43BargainEffectedDatedatetime是归档日期44BargainPriceMemovarchar200是合同总价备注45BeetMemovarchar200是保修款备注46Beetdecimal18，0是保修款比例47MarketingBTCIDint40是合同的营销三级类别ID，如非营销合同，此字段值为空48IsCloseEvaluationBit0否是否关闭49K2InstIDInt4是K2InstID50PDCOrderIdInt4是PDC订单ID51PDCOpStatusInt4是PDC状态52PDCOpTimeDatetime是PDCOpTime53AssetsPurchaseOrderIDInt4是54IsAnnulBit20是是否作废55BargainReviseDoneBit20是56BargainEasExpTimeDatetime是57BargainReviseEasExpTimeDatetime是58BargainBalanceEasExpTimeDatetime是59PrePDCOpStatusInt4是60PrePDCOpTimedatetime是61PreBES_IDInt4是62PreBargain_FinalStatusvarchar100是63PreBES_HandlerNameInt4是64PreBargain_ReadyTwovarchar100是65PreBargain_SerialNumbervarchar100是预结算合同号66EASInnerIdvarchar100是67EASOpStatusint4是68EASOpTimedatetime是69EASNoNeedExportBit是EAS不需要导出70IsCloseBitFALSE否是否关闭71FeedBackRemarkText‘’否合同归档备注72SignatureRemarktext‘’否合同盖章备注73ExchangeRateFloat是汇率74timestamptimestamp否75NeedLimitPaymentRationBit0否是否限制付款76LimitPaymentRationMoney1否限制付款比例77IsFeeSplitBit0否是否是费用分摊合同，如果是的话就出现在费用分摊的列表拆迁公司表（Bargain_DemolitionCompanies）：序号字段名称类型长度默认值可为空备注1CompanyIDInt4否Identity（1，1）标识列2Namevarchar1000否名称3IsClosedBit0否是否关闭4IsDeletedBit0否是否被删除5IsAuditedBit0否是否审核6Sitevarchar500否所属站点拆迁公司表（Bargain_DemolitionHouses）：序号字段名称类型长度默认值可为空备注1IDInt4否Identity（1，1）标识列2BargainIDInt4否合同编号3HouseBuildingNovarchar100否房屋栋号4HouseNovarchar100否房屋号5HouseTypevarchar200否房间类型6HouseQuantityInt4否房屋套数7CredentialTypevarchar100否证件类型8CredentialNovarchar100否证件编号9Linkmanvarchar200是联系人10Phonevarchar200是联系电话11Addressvarchar1000是联系地址12DemolitionCompanyNamevarchar200是拆迁公司名称13MoveAreadecimal(10,3)是永迁面积14BackmovingAreadecimal(10,3)是回迁面积15BackmovingExchangeAreadecimal(10,3)是回迁置换面积16MoveCompensationFeedecimal(10,2)是永迁类-货币补偿费用17MoveIncentiveFeedecimal(10,2)是永迁类-奖励费用18MoveOneTimeCompensationFeedecimal(10,2)是永迁类-一次性补偿费用19MoveOneTimeCompensationFeeNotevarchar2000是永迁类-一次性补偿说明20BackmovingDecorationCompensationFeedecimal(10,2)是回迁类-装修补偿费用21BackmovingMoveHouseFeedecimal(10,2)是回迁类-搬家费22BackmovingAdjunctCompensationFeedecimal(10,2)是回迁类-附属物业补偿费23BackmovingIncentiveFeedecim