內(nèi)容教程說明sgm basic.edw data feed interface spec-onstar

SGMBASIC.EDWProjectOnStarInterfaceCurrentDateLastLastUpdatedJunYangDateApprovedBy&RevisionDateRevisionBriefDescriptionof2008-12-YangInitial2009-02-JunUpdatedbasedonShanghaiOnStarversionInterfaceSpec(2.3.2,2.3.3,2.3.4)2009-02-JunUpdateddatatypeofbirth_date,delivery_dateforCDR,inordertoallowpossibleemptyvaluefortheelementsTableof介 目 參考資 符號和規(guī) 方案說 接口結(jié)構(gòu) 接口數(shù) 數(shù)據(jù)范 數(shù)據(jù)內(nèi) 數(shù)據(jù)格 數(shù)據(jù)容 功能需 接口頻 數(shù)據(jù)映 數(shù)據(jù)交 資源備 備份流 備份規(guī) 重處 出錯處 非功能需 介作為新立的SanghaiOnstr公的合伙伴，GM會就一數(shù)據(jù)對方。一批SGMEDWEDWSGMEDW向nstaEWDWSGM本文檔的目的就是為了描述SGM與ShanghaiOnstar間的數(shù)據(jù)接口，包括方案說明，接口的功目參考資《FeedDataSharingAgreementwithSGMV1.0.doc《LogicalData 《PhysicalData _EDS2Onstar.xls符號和規(guī)方案說數(shù)據(jù)流方式送到SGMFTP/SFTP服務(wù)器上。數(shù)據(jù)提供方接口數(shù)VehicleFactoryFeed(車輛VehicleFactorydatafeed（車輛包括本地車和進(jìn)口車數(shù)據(jù)。灰色文字由EDW產(chǎn)生；onstar車輛的MEID/ESN&StationhFieldCREATIONDatethedatafilewasNMessageSequenceNumberforthedataFEEDCFeedNamerequired:FEEDCFeedsource:FEED1CForF=Full,6Ne.g.Thecountofthenumberofrecordsinthefileforthisplant.(REQUIRED)CThevehicleidentificationnumber.(REQUIRED)(NOTNULL)MobileEquipmentIdentifier(MEID)/ElectronicSerialNumber(ESN)CTheMobileEquipmentIdentifier(MEID)numberORtheElectronicSerialNumber(ESN)fortheVehicleCommunicationPlatform(VCP).FormatmustbesameasSTID(inthiscase,Decimal).CThestationidentifier(e.g.serialnumber)fortheVehicleInterfacePlatform(VCP).FormatmustbesameasESN(inthiscase,Decimal).PAINTCOLOR3CTheprimarypaintcolorcodeofthevehicle.Alpha-numeric.SOSresponsiblefortranslatingtocommonpaintcolorforusebytheadvisors.CDateTimestampofacompletedpassingend-of-line(DVT)test.Example PleasenotespacebetweenDDandHH.Layoutmustbein24hourformat(REQUIRED)Call-offdatafeed（車輛拷車日期FieldCreationNMessageSequenceCFeedNamerequired:CFeedsource:1CForF=Full,6Ne.g.Thecountofthenumberofrecordsinthefileforthisplant.(REQUIRED)CThevehicleidentificationnumber.(REQUIRED)(NOTNULL)CDateTimestampofdealercall-offvehicle.Example[ PleasenotespacebetweenDDandHH.Layoutmustbein24hourformat(REQUIRED)DealerDatafeed（經(jīng)銷商主數(shù)據(jù)）FieldCREATIONCreationNMessageSequenceFEEDCFeedNamerequired:FEEDCFeedSource:FEED1CForF=Full,RECORD6Nfrom0toTransaction1CRequired.IndicatesthetypeofprocessingValues–A–C–D–Delete.F–FullLoadSelling2CRequired.MarketingSourceofthesite.CHforCHINADealer7CRequired.Anidentifyingnumberassignedtoeachdealershipbythedivisions.IncorporatedNameCRequired.LegalnameofthebusinessDealerBriefCRequired.DealershortCRequired.DealerCZip/PostalCRequired.DealeraddressespostalCountry2CRequired.ISOstandardforcountrycode.CNforChinaCRequired.DealerphoneCRequired.Dealerfax4CRequired.DealerFieldCreationNSequenceCFeedNamerequired:CFeedsource:1CForF=Full,RECORD6Nfrom0to1CRequired.IndicatesthetypeofprocessingValues–A–C–D–Delete.F–FullLoadNRequired.Typeofcustomer.BusinessorCRequired.VehicleownerNRequired.VehicleownerCRequired.OwnerCRequired.OwnermobileCRequired.OwnerphoneCRequired.IdentificationCRequired.Owner’sdateofCRequired.Contact’sCRequired.CityofthecontactCRequired..State/provinceoftheCRequired.StreetaddressoftheCRequired.ContactaddressespostalCRequired.ContactmobilephoneCRequired.VehicleVin7CRequired.Codeofthedealershipwherevehicleissold.FieldCRequired.NameofthesalesCRequired.LicenseplateCRequired.VehicledeliveryCRequired.VehiclebrandnameinCRequired.VehiclebrandnameinCRequired.TypeofVehiclesinCRequired.TypeofVehiclesinCommonFeedXSD文件：FeedHeadSchemaVehicleFactorydatafeed（車輛）XMLSchema結(jié)構(gòu)：XSD文件：FactoryFeedSchemaCall-offdatafeed（車輛拷車日期）XMLSchema結(jié)構(gòu)：XSD文件：Call-offFeedSchemaDealerDatafeed（經(jīng)銷商主數(shù)據(jù)）XMLSchemaDealerFeedSchemaCustomerDeliveryRecordFeed（CDR，經(jīng)銷商向客戶移交車輛的信息）XMLSchemaCDRFeedSchemaVehicleFactorydatafeed（車輛年NewCall-offdatafeed（車輛拷車日期年NewDealerDatafeed（經(jīng)銷商主數(shù)據(jù)年Dealer年New接口頻VehicleFactoryFeed（車輛全量：ThefullCDRextractofSGMChinaCDRinformationwillbegeneratedCustomerDeliveryRecord數(shù)據(jù)交數(shù)據(jù)交互流數(shù)據(jù)交互規(guī)時 初始導(dǎo) 每日導(dǎo)部署階 上線 外，ETL會保證存入FtpServer上的每個文件的內(nèi)容完整；在字段級別，要求提供的字段，即便 ShanghaiOnstar也具備讀寫權(quán)限ShanghaiOnstarShanghaiOnstar將文件取走之后，負(fù)責(zé)從SGMFTP/SFTP服務(wù)器上刪除，這樣正常情況下，F(xiàn)TP 內(nèi)容。ShanghaiOnstar將文件取走之后，不需要在SGMFTP/SFTP服務(wù)器上作刪除。資源備備份流備份規(guī)在SGMFTP/SFTP服務(wù)器上無需備份。異常處出錯處如果由于ETL服務(wù)器的出錯而導(dǎo)致ShanghaiOnstarBDIF服務(wù)器沒有從FTP/SFTP服務(wù)器上獲得文件，由ShanghaiOnstar通知SGM，SGMETL服務(wù)器將負(fù)責(zé)重新生成文件；如果由于ShanghaiOnstarBDIF服務(wù)器的出錯而