datamap master data

5
E1 / OTM Integration Corporation (Parent Address) Data Mapping Oracle Property Confidential 07/04/2015 Page 1 of5 EnterpriseOne OTM F011 F01!0 F0101 "taging Alias Description Type "i#e $%&ef Alias $"D 'ocation Type "i#e Co ents X X X PA8 Parent AddressBook Number MATH 8 No 4280 o!at"onX"d Transm"ss"onBod#$%ogXM&'ement$o!at"on$o!at"on%"d$%"d$X"d (A)*HA)2 50 +T,+MA-N o!at"on ,oma"n *HA) 50 No &1 ,oma"nName Transm"ss"onBod#$%'ogXM&'ement$o!at"on$o!at"on%"d$%"d$,oma"nName (A)*HA)2 50 X APH Parent AB .Name A' a *HA) 40 No -nternat"ona' *or orat"on o!at"onName Transm"ss"onBod#$%'ogXM&'ement$o!at"on$o!at"onName (A)*HA)2 120 X +T+*)+ o!at"on )o'e *HA) 40 No "*IPF&OM/"*IPTO o!at"on)o'e Transm"ss"onBod#$%'ogXM&'ement$o!at"on$o!at"on)o'e$o!at"on)o'e%"d$%"d$X"d (A)*HA)2 50 X X APH Parent AB .Name A' a *HA) 40 No -nternat"ona' *or orat"on *or orat"onName Transm"ss"onBod#$%'ogXM&'ement$o!at"on$*or orat"on$*or orat"onName (A)*HA)2 120 X A,,1 Address "ne 1 *HA) 40 No 10 H"g 'and )oad Address "ne . e 1 Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$Address"nes$Address"ne (A)*HA)2 55 X A,,2 Address "ne 2 *HA) 40 No Address "ne . e 2 Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$Address"nes$Address"ne (A)*HA)2 55 X A,,3 Address "ne 3 *HA) 40 No Address "ne . e 3 Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$Address"nes$Address"ne (A)*HA)2 55 X A,,4 Address "ne 4 *HA) 40 No Address "ne . e 4 Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$Address"nes$Address"ne (A)*HA)2 55 X *T 1 *"t# *HA) 25 No +' e *"t# Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$*"t# (A)*HA)2 40 X *+ N *ount# *HA) 25 No Ara a oe 6one1 Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$6one1 (A)*HA)2 30 X A,, tate *HA) 3 No Pro "n!e *ode Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$Pro "n!e*ode (A)*HA)2 5 X A,,6 6"*ode Posta *HA) 12 No 99895 Posta' *ode Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$Posta'*ode (A)*HA)2 15 X *T) *ountr# *ode :++;*N< *HA) 3 es *ountr#*ode3%-, Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Address$*ountr#*ode3%"d$%"d$X"d (A)*HA)2 2 *+ NT) =*+,&2 X +TT)N*+, +TM Transa!t"on *ode *HA) 3 No I+ Transa!t"on*ode Transm"ss"onBod#$%'ogXM&'ement$o!at"on$Transa!t"on*ode (A)*HA)2 2 E,a ple Data (-ard coded .al es olded)

Upload: cvkraj

Post on 04-Nov-2015

213 views

Category:

Documents


0 download

DESCRIPTION

Datamap Master Data

TRANSCRIPT

Corporation (Parent Address)EnterpriseOneOTMF0116F0150F0101StagingAliasDescriptionTypeSizeX-RefExample Data (hard coded values bolded)AliasXSD LocationTypeSizeCommentsXXXPA8Parent Address Book NumberMATH8No4280LocationXidTransmissionBody.GLogXMLElement.Location.LocationGid.Gid.XidVARCHAR250OTDOMAINLocation DomainCHAR50NoE1DomainNameTransmissionBody.GlogXMLElement.Location.LocationGid.Gid.DomainNameVARCHAR250XALPHParent AB - Name AlphaCHAR40NoInternational CorporationLocationNameTransmissionBody.GlogXMLElement.Location.LocationNameVARCHAR2120XOTLOCROLLocation RoleCHAR40No"SHIPFROM/SHIPTO"LocationRoleTransmissionBody.GlogXMLElement.Location.LocationRole.LocationRoleGid.Gid.XidVARCHAR250XXALPHParent AB - Name AlphaCHAR40NoInternational CorporationCorporationNameTransmissionBody.GlogXMLElement.Location.Corporation.CorporationNameVARCHAR2120XADD1Address Line 1CHAR40No10 Highland RoadAddress Line - Seq 1TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD2Address Line 2CHAR40NoAddress Line - Seq 2TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD3Address Line 3CHAR40NoAddress Line - Seq 3TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD4Address Line 4CHAR40NoAddress Line - Seq 4TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XCTY1CityCHAR25NoOlpeCityTransmissionBody.GlogXMLElement.Location.Address.CityVARCHAR240XCOUNCountyCHAR25NoArapahoeZone1TransmissionBody.GlogXMLElement.Location.Address.Zone1VARCHAR230XADDSStateCHAR3NoKSProvince CodeTransmissionBody.GlogXMLElement.Location.Address.ProvinceCodeVARCHAR25XADDZZip Code PostaCHAR12No66865Postal CodeTransmissionBody.GlogXMLElement.Location.Address.PostalCodeVARCHAR215XCTRCountry Code (OO|CN)CHAR3YesUSCountryCode3GIDTransmissionBody.GlogXMLElement.Location.Address.CountryCode3Gid.Gid.XidVARCHAR22COUNTRY_CODE2XOTTRNCODOTM Transaction CodeCHAR3No"IU"TransactionCodeTransmissionBody.GlogXMLElement.Location.TransactionCodeVARCHAR22

&C&"Arial,Bold"&14E1 / OTM Integration&A Data Mapping&L&"Arial,Bold"Oracle Property Confidential&C&D&RPage &P of &N

Customer LocationEnterpriseOneOTMF0116F0006F0101F0150StagingAliasDescriptionTypeSizeX-RefExample Data (hard coded values bolded)AliasXSD LocationTypeSizeCommentsXAN8Customer Number (AB# of search type C)MATH8No4281LocationXidTransmissionBody.GlogXMLElement.Location.LocationGid.XidVARCHAR250OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.Location.LocationGid.Gid.DomainNameVARCHAR250XALPHCustomer - Name AlphaCHAR40NoUS WarehouseLocationNameTransmissionBody.GlogXMLElement.Location.LocationNameVARCHAR250XOTLOCROLLocation RoleCHAR40No"SHIPFROM/SHIPTO"LocationRoleTransmissionBody.GlogXMLElement.Location.LocationRole.LocationRoleGid.Gid.XidVARCHAR250XPA8Parent Address Book NumberMATH8No4280ParentLocationGidTransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.XidVARCHAR250OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.DomainNameVARCHAR250XADD1Address Line 1CHAR40No10 Highland RoadAddress Line - Seq 1TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD2Address Line 2CHAR40NoAddress Line - Seq 2TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD3Address Line 3CHAR40NoAddress Line - Seq 3TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD4Address Line 4CHAR40NoAddress Line - Seq 4TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XCTY1CityCHAR25NoOlpeCityTransmissionBody.GlogXMLElement.Location.Address.CityVARCHAR240XCOUNCountyCHAR25NoArapahoeZone1TransmissionBody.GlogXMLElement.Location.Address.Zone1VARCHAR230XADDSStateCHAR3NoKSProvince CodeTransmissionBody.GlogXMLElement.Location.Address.ProvinceCodeVARCHAR25XADDZZip Code PostalCHAR12No66865Postal CodeTransmissionBody.GlogXMLElement.Location.Address.PostalCodeVARCHAR215XCTRCountry Code (OO|CN)CHAR3YesUSCountryCode3GIDTransmissionBody.GlogXMLElement.Location.Address.CountryCode3Gid.Gid.XidVARCHAR22COUNTRY_CODE2XOTTRNCODOTM Transaction CodeCHAR3No"IU"TransactionCodeTransmissionBody.GlogXMLElement.Location.Location.TransactionCodeVARCHAR22Company Currency XML labelNo"COMPANY_CURRENCY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCRCDCurrency CodeCHAR3YesUSDLocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101Company XML LabelNo"COMPANY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCOCompanyCHAR5No42100LocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101

&C&"Arial,Bold"&14E1 / OTM Integration&A Data Mapping&L&"Arial,Bold"Oracle Property Confidential&C&D&RPage &P of &N

Carrier LocationEnterpriseOneOTMF0150F0116F0006F0101StagingAliasDescriptionTypeSizeX-RefExample Data (hard coded values bolded)AliasXSD LocationTypeSizeCommentsXCARSCarrier Number (AB# of search type TC)MATH8No8555LocationXidTransmissionBody.GlogXMLElement.Location.GID.XidVARCHAR50OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.Location.LocationGid.Gid.DomainNameVARCHAR250XALPHCarrier - Name AlphaCHAR40NoNational ExpressLocationNameTransmissionBody.GlogXMLElement.Location.LocationNameVARCHAR250XOTLOCROLLocation RoleCHAR40No"CARRIER"LocationRoleTransmissionBody.GlogXMLElement.Location.LocationRole.LocationRoleGid.Gid.xidVARCHAR250XPA8Parent Address Book NumberMATH8No4280ParentLocationGidTransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.XidVARCHAR250OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.DomainNameVARCHAR250XADD1Address Line 1CHAR40No10 Highland RoadAddress Line - Seq 1TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD2Address Line 2CHAR40NoAddress Line - Seq 2TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD3Address Line 3CHAR40NoAddress Line - Seq 3TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD4Address Line 4CHAR40NoAddress Line - Seq 4TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XCTY1CityCHAR25NoOlpeCityTransmissionBody.GlogXMLElement.Location.Address.CityVARCHAR240XCOUNCountyCHAR25NoArapahoeZone1TransmissionBody.GlogXMLElement.Location.Address.Zone1VARCHAR230XADDSStateCHAR3NoKSProvince CodeTransmissionBody.GlogXMLElement.Location.Address.ProvinceCodeVARCHAR25XADDZZip Code PostaCHAR12No66865Postal CodeTransmissionBody.GlogXMLElement.Location.Address.PostalCodeVARCHAR215XCTRCountry Code (OO|CN)CHAR3YesUSCountryCode3GIDTransmissionBody.GlogXMLElement.Location.Address.CountryCode3Gid.Gid.XidVARCHAR22COUNTRY_CODE2XOTSPFLGService Provider (IsAllowTender) - NewCHAR2No"Y"IsAllowTenderTransmissionBody.GlogXMLElement.Location.ServiceProvider.IsAllowTenderVARCHAR22SCACStandard Carrier Alpha CodeCHAR4NATXTransactionCodeService Provider AliasVARCHAR24E1 will need the SCAC field back during Transportation ConfirmationCAMDAuto PayCHAR11Auto Payment FlagVARCHAR21XOTTRNCODOTM Transaction CodeCHAR3No"IU"TransactionCodeTransmissionBody.GlogXMLElement.Location.Location.TransactionCodeVARCHAR22Company Currency XML labelNo"COMPANY_CURRENCY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCRCDCurrency CodeCHAR3YesUSDLocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101Company XML LabelNo"COMPANY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCOCompanyCHAR5No42100LocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101

&C&"Arial,Bold"&14E1 / OTM Integration&A Data Mapping&L&"Arial,Bold"Oracle Property Confidential&C&D&RPage &P of &N

Facilities LocationEnterpriseOneOTMF0116F0006F0101F0150StagingAliasDescriptionTypeSizeX-RefExample Data (hard coded values bolded)AliasXSD LocationTypeSizeCommentsXAN8Branch Plant AB Number (search type F)MATH8No27LocationXidTransmissionBody.GlogXMLElement.Location.GID.XidVARCHAR50OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.Location.LocationGid.Gid.DomainNameVARCHAR250XALPHBranch Plant - Name AlphaCHAR40NoEastern Area DistributionLocationNameTransmissionBody.GlogXMLElement.Location.LocationNameVARCHAR250XOTLOCROLLocation RoleCHAR40NoSHIPFROM/SHIPTOLocationRoleTransmissionBody.GlogXMLElement.Location.LocationRole.LocationRoleGid.Gid.xidVARCHAR250XPA8Parent Address Book NumberMATH8No4280ParentLocationGidTransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.Xid (Domain)VARCHAR250OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.DomainNameVARCHAR250XADD1Address Line 1CHAR40No444 Industry PkwyAddress Line - Seq 1TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD2Address Line 2CHAR40NoAddress Line - Seq 2TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD3Address Line 3CHAR40NoAddress Line - Seq 3TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD4Address Line 4CHAR40NoAddress Line - Seq 4TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XCTY1CityCHAR25NoNewarkCityTransmissionBody.GlogXMLElement.Location.Address.CityVARCHAR240XCOUNCountyCHAR25NoArapahoeZone1TransmissionBody.GlogXMLElement.Location.Address.Zone1VARCHAR230XADDSStateCHAR3NoNJProvince CodeTransmissionBody.GlogXMLElement.Location.Address.ProvinceCodeVARCHAR25XADDZZip Code PostalCHAR12No70095Postal CodeTransmissionBody.GlogXMLElement.Location.Address.PostalCodeVARCHAR215XCTRCountry Code (OO|CN)CHAR3YesUSCountryCode3GIDTransmissionBody.GlogXMLElement.Location.Address.CountryCode3Gid.Gid.XidVARCHAR22COUNTRY_CODE2Company Currency XML labelNo"COMPANY_CURRENCY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCRCDCurrency CodeCHAR3YesUSDLocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101Company XML LabelNo"COMPANY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCOCompanyCHAR5No42100LocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101

&C&"Arial,Bold"&14E1 / OTM Integration&A Data Mapping&L&"Arial,Bold"Oracle Property Confidential&C&D&RPage &P of &N

Supplier LocationEnterpriseOneOTMF0116F0006F0101F0150StagingAliasDescriptionTypeSizeX-RefExample Data (hard coded values bolded)AliasXSD LocationTypeSizeCommentsXAN8Customer Number (AB# of search type V)MATH8No4281LocationXidTransmissionBody.GlogXMLElement.Location.GID.XidVARCHAR50OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.Location.LocationGid.Gid.DomainNameVARCHAR250XALPHCustomer - Name AlphaCHAR40NoUS WarehouseLocationNameTransmissionBody.GlogXMLElement.Location.LocationNameVARCHAR250XOTLOCROLLocation Role - NewCHAR40NoSHIPFROM/SHIPTOLocationRoleTransmissionBody.GlogXMLElement.Location.LocationRole.LocationRoleGid.Gid.xidVARCHAR250XPA8Parent Address Book NumberMATH8No4280ParentLocationGidTransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.Xid (Domain)VARCHAR250OTDOMAINLocation DomainCHAR50NoE1DomainName (Location)TransmissionBody.GlogXMLElement.Location.ParentLocationGid.LocationGid.Gid.DomainNameVARCHAR250XADD1Address Line 1CHAR40No10 Highland RoadAddress Line - Seq 1TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD2Address Line 2CHAR40NoAddress Line - Seq 2TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD3Address Line 3CHAR40NoAddress Line - Seq 3TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XADD4Address Line 4CHAR40NoAddress Line - Seq 4TransmissionBody.GlogXMLElement.Location.Address.AddressLines.AddressLineVARCHAR255XCTY1CityCHAR25NoOlpeCityTransmissionBody.GlogXMLElement.Location.Address.CityVARCHAR240XCOUNCountyCHAR25NoArapahoeZone1TransmissionBody.GlogXMLElement.Location.Address.Zone1VARCHAR230XADDSStateCHAR3NoKSProvince CodeTransmissionBody.GlogXMLElement.Location.Address.ProvinceCodeVARCHAR25XADDZZip Code PostaCHAR12No66865Postal CodeTransmissionBody.GlogXMLElement.Location.Address.PostalCodeVARCHAR215XCTRCountry Code (OO|CN)CHAR3YesUSCountryCode3GIDTransmissionBody.GlogXMLElement.Location.Address.CountryCode3Gid.Gid.XidVARCHAR22COUNTRY_CODE2Company Currency XML labelNo"COMPANY_CURRENCY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCRCDCurrency CodeCHAR3YesUSDLocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101Company XML LabelNo"COMPANY"LocationRefnumQualifierGidTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumQualifierGid.Gid.XidVARCHAR250XCOCompanyCHAR5No42100LocationRefnumValueTransmissionBody.GlogXMLElement.Location.LocationRefnum.LocationRefnumValueVARCHAR2101

&C&"Arial,Bold"&14E1 / OTM Integration&A Data Mapping&L&"Arial,Bold"Oracle Property Confidential&C&D&RPage &P of &N