datamap master data
DESCRIPTION
Datamap Master DataTRANSCRIPT
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