【正文】 合同三級分類表（BargainThirdCatalog）序號字段名稱類型長度默認值可為空備注1BTC_IDInt8否Identity(1,1) 主鍵2BM_IDint8否錄入模板編號3BSC_IDInt8否二級分類ID4BTC_CatalogNamevarchar50否合同分類名稱5BTC_CatalogAbbreviationvarchar50否三級類別代碼（生成的合同號代碼）6BTC_BargainExamineFlowvarchar6000否審批流描述信息7BP_IDInt8是打印模板編號8ExFlowUrlvarchar200‘’是網(wǎng)上審批地址9OrderFlowUrlvarchar200‘’是設(shè)計/營銷訂單審核URL10OddFlowUrlvarchar200‘’是零星業(yè)務(wù)申請單審核URL11TellCostBit40否郵件通知成本12TellFinanceBit40否郵件通知財務(wù)13TellSecretaryBit40否郵件通知項目秘書14NeedPaymentPlanBit40否是否需要付款計劃15AlertTextvarchar500是合同填寫提示16TellPartyBBit41否郵件通知合約方17StrategyFlowUrlvarchar200是戰(zhàn)略合同審核URL18EASTypeNumbervarchar50是對應(yīng)EAS合同類型編碼19JingHuaAuditUrlvarchar500是20JingHuaOrderAuditURLvarchar500是21JingHuaOddBillAuditURLvarchar500是22K2AuditUrlvarchar500是23K2OrderAuditURLvarchar500是24K2OddBillAuditURLvarchar500是25K2StrategyFlowUrlvarchar500是26PDCServiceTypevarchar1000是27ForbidInputBit40是28TelloperatorBit40否郵件通知經(jīng)辦人29SMSTellOperatorBit4FALSE否短信通知經(jīng)辦人30SMSTellCostBit4FALSE否短信通知成本31SMSTellFinanceBit4FALSE否短信通知財務(wù)32SMSTellSecretaryBit4FALSE否短信通知項目秘書33SMSTellPartyBBit4FALSE否短信通知合約方34NeedBudgetControlBit40否是否需要預(yù)算控制35DefaultBgtActCodevarchar500‘’否36NeedPEASControlmoney0否是否需要立項控制37IsCostBargainBit40否是否成本合同38PreClearApprovalUrlvarchar500‘’否預(yù)結(jié)算審批地址39PermissionEnabledBit40否是否開啟權(quán)限控制40NeedLimitPaymentRationBit40否是否限制付款合同一級分類表（BargainFirstCatalog）：序號字段名稱類型長度默認值可為空備注1BFC_IDInt4否Identity(1,1) 標(biāo)識列2BFC_CatalogNamevarchar50否一級分類名稱3Sitevarchar5039。shenzhen39。是站點4OriginSitevarchar50 是5timestamptimestamp否合同二級分類表（BargainSecondCatalog）：序號字段名稱類型長度默認值可為空備注1BSC_IDInt4否Identity(1,1) 標(biāo)識列2BFC_IDInt4否一級分類ID3BSC_CatalogNamevarchar50否二級分類名稱合同表（Bargain）序號字段名稱類型長度默認值可為空備注1Bargain_IDInt4否Identity（1，1）標(biāo)識列2BTC_IDInt4否合同三級分類編號3BF_IDInt4否合同形式編號（合同補充合同戰(zhàn)略合同7）4BA_IDInt4否合同區(qū)域5BT_IDInt4否合同類型編號6Bargain_FinalStatusvarchar100否狀態(tài)7BES_HandlerNameInt4否當(dāng)前審批狀態(tài)編號，1為等待審批，2為部門簽收，3為領(lǐng)導(dǎo)簽收，4為領(lǐng)導(dǎo)通過，5為等待修改，0為初始狀態(tài)8Bargain_SerialNumbervarchar100否合同號9Bargain_ProjectIDInt4否合同項目分期編號10Bargain_OriginalCatalogIDInt4是合同初始化分類編號11Bargain_Namevarchar100否合同名稱12Bargain_OwnerIDInt4否經(jīng)辦人編號13Bargain_OwnerDepartmentIDInt4是經(jīng)辦人辦理時所在的部門編號，經(jīng)辦人有可能調(diào)離部門14Bargain_FirstSectionvarchar200否甲方單位15Bargain_SecondSectionvarchar200否乙方名稱16Bargain_Copiesint4否合同份數(shù)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是戰(zhàn)略合同ID31Bargain_NeedExportbit2否合同是否需要導(dǎo)出，零星業(yè)務(wù)申請單永遠不導(dǎo)出32Bargain_IsExportedJHBit2否是否導(dǎo)出京華33Bargain_IsExportedCBBit2否是否導(dǎo)出成本34Bargain_ReadyOnevarchar100是預(yù)備字段一35Bargain_ReadyTwovarchar100是預(yù)備字段二36Bargain_ReadyThreeInt4是預(yù)備字段三37Bargain_ReadyFourInt4是預(yù)備字段四38ExFlowProcIDInt4是京華審批ID39Bargain_CostPropertyvarchar50是合同造價性質(zhì)40Bargain_SelectWayvarchar50是中標(biāo)方式41FootPriceMoney是最新總價42IsCanceledInt40是是否取消43BargainEffectedDatedatetime是歸檔日期44BargainPriceMemovarchar200是合同總價備注45BeetMemovarchar200是保修款備注46Beetdecimal18，0是保修款比例47MarketingBTCIDint40是合同的營銷三級類別ID，如非營銷合同，此字段值為空48IsCloseEvaluationBit0否是否關(guān)閉49K2InstIDInt4是K2InstID50PDCOrderIdInt4是PDC訂單ID51PDCOpStatusInt4是PDC狀態(tài)52PDCOpTimeDatetime是PDCOpTime53AssetsPurchaseOrderIDInt4是54IsAnnulBit20是是否作廢55BargainReviseDoneBit20是56BargainEasExpTimeDatetime是57BargainReviseEasExpTimeDatetime是58BargainBalanceEasExpTimeDatetime是59PrePDCOpStatusInt4是60PrePDCOpTimedatetime是61PreBES_IDInt4是62PreBargain_FinalStatusvarchar100是63PreBES_HandlerNameInt4是64PreBargain_ReadyTwovarchar100是65PreBargain_SerialNumbervarchar100是預(yù)結(jié)算合同號66EASInnerIdvarchar100是67EASOpStatusint4是68EASOpTimedatetime是69EASNoNeedExportBit是EAS不需要導(dǎo)出70IsCloseBitFALSE否是否關(guān)閉71FeedBackRemarkText‘’否合同歸檔備注72SignatureRemarktext‘’否合同蓋章備注73ExchangeRateFloat是匯率74timestamptimestamp否75NeedLimitPaymentRationBit0否是否限制付款76LimitPaymentRationMoney1否限制付款比例77IsFeeSplitBit0否是否是費用分攤合同，如果是的話就出現(xiàn)在費用分攤的列表拆遷公司表（Bargain_DemolitionCompanies）：序號字段名稱類型長度默認值可為空備注1CompanyIDInt4否Identity（1，1）標(biāo)識列2Namevarchar1000否名稱3IsClosedBit0否是否關(guān)閉4IsDeletedBit