1、說明：v 紅色部分不用加到數據庫中，java代碼里有即可，代碼參照三星程序；要記錄所有修改過的文件。v 黑色部分要加入到數據庫中，java代碼里也要有。表名字段名格式注釋mainAgentHandlerCodeVARCHAR2(20)北京中介協議號GroupCode上海團車號UsbKey北京中介卡號ComputerIp北京中介卡機器地址RiskFlag險種標志InsuredCustomerKindVARCHAR2(10)客戶性質ItemCarExtPayMethod繳費方式SALES_CHANNEL_CODE銷售渠道機構代碼KindCode投保險種CarKindPlatVARCHAR2(4)平

2、臺車輛種類LastPolicyNo上年保單號VehicleOwnerNatureCHAR(1)車主性質NewVehicleFlagVARCHAR2(1)全國平臺是否新車標志 1.新車 0.非新車PmQueryNo交管車輛查詢碼BusiQuestionAnswer投保查詢校驗ChgOwnerFlagVARCHAR2(1)過戶車輛標志 1.過戶車 0.未過戶車LoanVehicleFlagVARCHAR2(1)是否車貸投保多年標志TaxRelifFlag車船稅標志CarPO_Category行駛證車輛類型TaxPayerCertIType納稅人證件類型TaxPayerCertICode納稅人證件號

3、碼PayNO完稅憑證號Department開具稅務機關CIInsureDemandBusiLastYearEndDateDATE上一商業險保險止期CarKindPlat平臺車輛種類CheckCode校驗碼ChgOwnerFlagVARCHAR2(1)過戶車輛標志 1.過戶車 0.未過戶車ClaimRecordEndDateVARCHAR2(19)賠款記錄系數計算區間終點ClaimRecordStartDateVARCHAR2(19)賠款記錄系數計算區間起點ComputerIPVARCHAR2(25)北京中介卡機器地址IsCommissionTaxVARCHAR2(1)是否屬代征車船稅車輛Las

4、tProducerCodeVARCHAR2(2)上張保單銷售渠道代碼LoanVehicleFlagVARCHAR2(1)是否車貸投保多年標志ModelVARCHAR2(64)車輛型號-交管PayMethodVARCHAR2(2)繳費支付方式PeccancyRecordEndDateVARCHAR2(19)交通違法記錄系數計算區間終點PeccancyRecordStartDateVARCHAR2(19)交通違法記錄系數計算區間起點PmQueryNoVARCHAR2(20)交管車輛查詢碼POCategoryVARCHAR2(10)行駛證車輛類型ProConfirmEndDateVARCHAR2(1

5、9)預確認有效期止ProconfirmSequenceNoVARCHAR2(50)投保預確認碼ProConfirmStartDateVARCHAR2(19)預確認有效期起Question問題描述(問題(參考答案)RenewalFlagCHAR(1)轉保業務標志SearchSequenceNoVARCHAR2(20)車型查詢碼TaxFlagVARCHAR2(5)車船稅標志TaxpayerCertiCode納稅人證件號碼TaxpayerCertiTypeVARCHAR2(5)納稅人證件類型UseTypeSourceVARCHAR2(2)使用性質來源VehicleIdVARCHAR2(14)機動車序

6、號VehicleStyleDescVARCHAR2(100)車輛類型描述VehicleTypeVARCHAR2(3)交管車輛種類代碼PrpDagentUsbKeyVARCHAR2(50)北京中介卡號CIEndorDemandClaimRecordEndDateVARCHAR2(19)賠款記錄系數計算區間終點ClaimRecordStartDateVARCHAR2(19)賠款記錄系數計算區間起點DrawReasonVARCHAR2(2)退保原因LastProducerCodeVARCHAR2(2)上張保單銷售渠道代碼ModelVARCHAR2(64)車輛型號PeccancyRecordEndDa

7、teVARCHAR2(19)交通違法記錄系數計算區間終點PeccancyRecordStartDateVARCHAR2(19)交通違法記錄系數計算區間起點TaxAmendDeclareVARCHAR2(2)TaxAmendPremiumVARCHAR2(20)VINVARCHAR2(17)車輛識別代號ciInsureDemandLossDecisionCodeVARCHAR2(10)決定書編號DecisionTypeCodeVARCHAR2(1)決定書類型DriverLicenseNoVARCHAR2(18)違法駕駛員駕駛證號JurisdictionAgencyCodeVARCHAR2(10)

8、違法處理機關代碼LicensePlateNoVARCHAR2(15)號牌號碼LicensePlateTypeCodeVARCHAR2(2)號牌種類代碼PeccancySortVARCHAR2(2)違章種類ViolationCodeVARCHAR2(22)違法編號ViolationSequenceNUMBER(2)序號CIInsureDemandPayBusiOrBZVARCHAR2(1)區分是交強險還是商業險理賠標志 1-交強險 2-商業險CaseIDVARCHAR2(30)結案編號ClaimCoverSNNUMBER(15)按理賠條數ClaimNotificationNoVARCHAR2(3

9、0)報案號EffectiveDateVARCHAR2(19)起保日期ExpireDateVARCHAR2(19)終保日期PolicyNoVARCHAR2(50)保單號CIInsureValidBankPaymentTimeVARCHAR2(19)銀行交易時間WarrantNoVARCHAR2(50)憑證號碼v 新增表（參照三星表結構）：APPOINTMENTCARDv 相關文件：(參照三星程序，將文件轉換成utf-8的格式后再合到代碼中）modulescomponentcomsinosoftprpallschemaAppointmentCardSchema.javamodulescompone

10、ntcomsinosoftprpallblsvrtbBLAppointmentCard.javamodulescomponentcomsinosoftprpalldbsvrtbDBAppointmentCard.javamodulescomponentcomsinosoftprpalluiUIAppointmentCardUpload.javamoduleswebappsprpallcommonciUIAppointmentCardQueryListExport.jspmoduleswebappsprpallcommonciUploadAppointmentCard.jspv 新增表（參照三星表結構）：CIEndorDemandProfitv 相關文件：(參照三星程序，將文件轉換成utf-8的格式后再合到代碼中）modulescomponentcomsinosoftindivciblsvrBLCIEndorDemandProfit.javamodulescomponentcomsinosoftindivcischemaCIEn