Field-level mapping for carriers

This section depicts the conversion of the Sterling Selling and Fulfillment Foundation input XML to the Parcel Carrier Adapters input XML. It also explains the mapping that is done between the input XML that is passed to the Parcel Carrier Adapters, and the input required for individual carrier servers.

Table 1. Field-level mapping forSterling Selling and Fulfillment Foundation XMLs published to corresponding sterling parcel carrier adapter
Sterling Parcel Carrier Adapter Attribute Database Attribute
UPSPLD/PackageLevelDetail@UOMWeight Shipment.Carrier.Locale.WeightUOM
UPSPLD/PackageLevelDetail@PackageActualWeight Container.Container_Gross_Weight
UPSPLD/PackageLevelDetail@UOMDim Shipment.Carrier.Locale.DimensionUOM
UPSPLD/PackageLevelDetail@PackageLength Container.PackageLength
UPSPLD/PackageLevelDetail@ShipmentNumber Shipment.ShipmentNo
UPSPLD/PackageLevelDetail@PackageTrackingNumber Container.Tracking_No
UPSPLD/PackageLevelDetail@SatDeliveryInd Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "SATDELI" exist, then the value is set to "1"
UPSPLD/PackageLevelDetail@CurrencyCode Shipment.Currency
UPSPLD/PackageLevelDetail@DeclaredValueInsurance Container.Declared_Value
UPSPLD/PackageLevelDetail@ShipmentCODCurrencyCode Shipment.Currency
UPSPLD/PackageLevelDetail@CODAmount Container.COD_Amount
UPSPLD/PackageLevelDetail@CODFundsInd Shipment.COD_Pay_Method
UPSPLD/AccessorialRecord@HazMat Shipment.HazardousMaterialFlag
UPSPLD/CommodityRecord@PartNumber Container.ContainerDetail.Item.Item_Id
UPSPLD/CommodityRecord@LineQuantity Container.ContainerDetail.Quantity
UPSPLD/CommodityRecord@LineQtyUOM Container.ContainerDetail.UOM
UPSPLD/CommodityRecord@CommodityWeight Container.ContainerDetail.OrderLine.Item_Weight * Container.ContainerDetail.Quantity
UPSPLD/CommodityRecord@LineUnitAmtPrice Container.ContainerDetail.OrderLine.Unit_Price * Container.ContainerDetail.Quantity
UPSPLD/CommodityRecord@LineMerchDesc1 Container.ContainerDetail.Item.Description
UPSPLD/CommodityRecord@LineOriginCountry Container. ContainerDetail.Item.Country_Of_Origin
UPSPLD/CommodityRecord@CommodityCode Container.ContainerDetail.Item.Harmonized_Code
UPSPLD/CommodityRecord@LineLicenseInfo Container.Export_License_No
UPSPLD/CommodityRecord@LineLicenseExpDate Container.Export_License_Exp_Date
UPSPLD/CommodityRecord@ECCN Container.ContainerDetail.Item.ECCN
UPSPLD/InternationalRecord@ShipmentInsuranceDeclaredValue Container.Declared_Value
UPSPLD/InternationalRecord@UltimateDestCountry Shipment.ShipToPersonInfo.Country
UPSPLD/InternationalRecord@DescriptionOfGoods Container.ContainerDetail.Item.NMFC_Code or Container. ContainerDetail.Item.NMFC_Class
UPSPLD/ExtraFieldsRecord@SunDeliveryInd Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "SUNDELI" exist, then the value is set to "1"
UPSPLD/PackageLevelDetail@ConsigneeCompanyName Shipment.ShipToPersonInfo.Company
UPSPLD/PackageLevelDetail@ConsigneeAttention Shipment.ShipToPersonInfo.Name
UPSPLD/PackageLevelDetail@ConsigneeAddress1 Shipment.ShipToPersonInfo.Address_Line1
UPSPLD/PackageLevelDetail@ConsigneeAddress2 Shipment.ShipToPersonInfo.Address_Line2
UPSPLD/PackageLevelDetail@ConsigneeAddress3 Shipment.ShipToPersonInfo.Address_Line3
UPSPLD/PackageLevelDetail@ConsigneeCity Shipment.ShipToPersonInfo.City
UPSPLD/PackageLevelDetail@ConsigneeStateProv Shipment.ShipToPersonInfo.State
UPSPLD/PackageLevelDetail@ConsigneePostalCode Shipment.ShipToPersonInfo.Zip_Code
UPSPLD/PackageLevelDetail@ResInd If Shipment.ShipToPersonInfo.Company is "Blank", then value "1" is passed. Otherwise, value "0" is passed.
UPSPLD/PackageLevelDetail@ConsigneePhone Shipment.ShipToPersonInfo.Day_Phone
UPSPLD/PackageLevelDetail@ConsigneeCountry Shipment.ShipToPersonInfo.Country
UPSPLD/PackageLevelDetail@ConsigneeUPSAcctNumber Shipment.CustCarrier_Account_No
UPSPLD/PackageLevelDetail@ShipperAccountNumber Container.Manifest.Manifest.Shipper_Account_No
UPSPLD/PackageLevelDetail@ShipmentChgType Shipment.FreightTerms.ChargesPaidBy. If this value is "BUYER", then the Parcel Carrier Adapters attribute is set to "COL". Otherwise, it is set to "PRE"
UPSPLD/PackageLevelDetail@PickupDate Container.Manifest.Manifest_Date
UPSPLD/ExtraFieldsRecord@ThermalLabelPrinterID PrinterId for Carrier Label Document Id (FEDX_CARRIER_LABEL or UPSN_CARRIER_LABEL)
UPSPLD/PackageLevelDetail@UPSServiceType Shipment.SCAC.SCACAndService.Electronic_Code
UPSPLD/AdvisoryInformationRecord@SNEmailAddress Destination1 Shipment.ShipTo.PersonInfo.EmailId
UPSPLD/AdvisoryInformationRecord@SNCompanyName1 Shipment.ShipToPersonInfo.Company
UPSPLD/AdvisoryInformationRecord@SNAttnName1 Shipment.ShipToPersonInfo.Name
UPSPLD/AdvisoryInformationRecord@SNContactPhone1 Shipment.ShipToPersonInfo.Day_Phone
UPSPLD/PackageLevelDetail@DCISType Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "DELCONF" exist, then the value is set to "1"
UPSPLD/PackageLevelDetail@DCISType Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "DELCONF" exist, then the value is set to "2"
UPSPLD/PackageLevelDetail@DCISType Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "DELCONF" exist, then the value is set to "A"
UPSPLD/AlternatePartyRecord@CompanyName Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.Company
UPSPLD/AlternatePartyRecord@Address1 Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.Address_Line1
UPSPLD/AlternatePartyRecord@Address2 Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.Address_Line2
UPSPLD/AlternatePartyRecord@Address3 Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.Address_Line3
UPSPLD/AlternatePartyRecord@City Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.City
UPSPLD/AlternatePartyRecord@StateProv Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.State
UPSPLD/AlternatePartyRecord@PostalCode Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.Zip_Code
UPSPLD/AlternatePartyRecord@Country Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.Country
UPSPLD/AlternatePartyRecord@Phone Shipment.ShipNode.SCACEX.THIRDPARTYORGANIZ ATION.Phone
UPSPLD/AlternatePartyRecord@ID_AcctNumber Shipment.ShipNode.SCACEX.Account1
UPSPLD/PackageLevelDetail@NOfNSequence Sequence of Container within the shipment
UPSPLD/PackageLevelDetail@NOfNTotal Total no of containers in shipment
ShipperCompanyName Shipment.ShipFrom.Country
ShipperAddress1 Shipment.ShipFrom.Address1
ShipperAddress2 Shipment.ShipFrom.Address2
ShipperCity Shipment.ShipFrom.ShipperCity
ShipperState Shipment.ShipFrom.ShipperState
ShipperPostalCode Shipment.ShipFrom.ShipperPostalCode
ConsigneeCompanyName Shipment.ShipToPersonInfo.Company
ConsigneeAddress1 Shipment.ShipToPersonInfo.Address_Line1
ConsigneeAddress2 Shipment.ShipToPersonInfo.Address_Line2
ConsigneeCity Shipment.ShipToPersonInfo.City
ConsigneeStateProv Shipment.ShipToPersonInfo.State
ConsigneePostalCode Shipment.ShipToPersonInfo.Zip_Code
ConsigneePhone Shipment.ShipToPersonInfo.Day_Phone
ConsigneeUPSAcctNumber Shipment.CustCarrier_Account_No
PackageActualWeight Container.Container_Gross_Weight
ShipmentChgType Shipment.FreightTerms.ChargesPaidBy. If this value is "BUYER", then the Parcel Carrier Adapters attribute is set to "COL". Otherwise, it is set to "PRE"
PickupDate Container.Manifest.Manifest_Date
DeclaredValueInsurance Container.Declared_Value
CODInd NA
ShipperContactName Shipment.ShipFrom.ShipperContactName
ConsigneeCountry Shipment.ShipToPersonInfo.Country
CODAmount Container.COD_Amount
PackageHeight Container.PackageHeight
PackageWidth Container.PackageWidth
PackageLength Container.PackageLength
UltimateDestCountry Shipment.ShipToPersonInfo.Country
DescriptionOfGoods Container.ContainerDetail.Item.NMFC_Code or Container. ContainerDetail.Item.NMFC_Class
LineOriginCountry Container.ContainerDetail.Item.Country_Of_Origin
LineQuantity Container.ContainerDetail.Quantity
ShipperCountry Shipment.ShipNodePersonInfo.Country
InvoiceLineTotals Sum of ContainerDetail.Quantity* Unit_Price from OrderLine
ShipperPhoneNumber Shipment.ShipFrom.ShipperPhoneNumber
ResInd If Shipment.ShipToPersonInfo.Company is set to "Blank", then the value is set to "1". Otherwise, it is set to "0"
ShipperAccountNumber Container.Manifest.Manifest.Shipper_Account_No
ThermalLabelPrinterID PrinterId for Carrier Label Document Id (FEDX_CARRIER_LABEL or UPSN_CARRIER_LABEL)
ShipperEIN Container.Manifest.Ship_Node.Export_Taxpayer_Id
SNEmailAddressDestination1 Shipment.ShipTo.PersonInfo.EmailId
SunDeliveryInd Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "SUNDELI" exist, then the value is set to "1"
SatDeliveryInd Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "SATDELI" exist, then the value is set to "1"
UPSServiceType Shipment.SCAC.SCACAndService.Electronic_Code
ShipperCompanyName Shipment.ShipFrom.Country
ShipperAddress1 Shipment.ShipFrom.Address1
ShipperAddress2 Shipment.ShipFrom.Address2
ShipperCity Shipment.ShipFrom.ShipperCity
ShipperState Shipment.ShipFrom.ShipperState
ShipperPostalCode Shipment.ShipFrom.ShipperPostalCode
ConsigneeCompanyName Shipment.ShipToPersonInfo.Company
ConsigneeAddress1 Shipment.ShipToPersonInfo.Address_Line1
ConsigneeAddress2 Shipment.ShipToPersonInfo.Address_Line2
ConsigneeCity Shipment.ShipToPersonInfo.City
ConsigneeStateProv Shipment.ShipToPersonInfo.State
ConsigneePostalCode Shipment.ShipToPersonInfo.Zip_Code
ConsigneePhone Shipment.ShipToPersonInfo.Day_Phone
ConsigneeUPSAcctNumber Shipment.CustCarrier_Account_No
PackageActualWeight Container.Container_Gross_Weight
ShipmentChgType Shipment.FreightTerms.ChargesPaidBy. If this value is "BUYER", then the Parcel Carrier Adapters attribute is set to "COL". Otherwise, it is set to "PRE"
PickupDate Container.Manifest.Manifest_Date
DeclaredValueInsurance Container.Declared_Value
CODInd  
ShipperContactName Shipment.ShipFrom.ShipperContactName
ConsigneeCountry Shipment.ShipToPersonInfo.Country
CODAmount Container.COD_Amount
PackageHeight Container.PackageHeight
PackageWidth Container.PackageWidth
PackageLength Container.PackageLength
UltimateDestCountry Shipment.ShipToPersonInfo.Country
DescriptionOfGoods Container.ContainerDetail.Item.NMFC_Code or Container. ContainerDetail.Item.NMFC_Class
LineOriginCountry Container.ContainerDetail.Item.Country_Of_Origin
LineQuantity Container.ContainerDetail.Quantity
ShipperCountry Shipment.ShipNodePersonInfo.Country
InvoiceLineTotals Sum of ContainerDetail.Quantity* Unit_Price from OrderLine
ShipperPhoneNumber Shipment.ShipFrom.ShipperPhoneNumber
ResInd If Shipment.ShipToPersonInfo.Company is set to "Blank", then the value is set to "1". Otherwise, it is set to "0"
ShipperAccountNumber Container.Manifest.Manifest.Shipper_Account_No
ThermalLabelPrinterID PrinterId for Carrier Label Document Id (FEDX_CARRIER_LABEL or UPSN_CARRIER_LABEL)
ShipperEIN Container.Manifest.Ship_Node.Export_Taxpayer_Id
SNEmailAddressDestination1 Shipment.ShipTo.PersonInfo.EmailId
SunDeliveryInd Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "SUNDELI" exist, then the value is set to "1"
SatDeliveryInd Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "SATDELI" exist, then the value is set to "1"
UPSServiceType Shipment.SCAC.SCACAndService.Electronic_Code
Configuration for ShipperAccountNumber. 1:1 mapping between ShipperAccountNumber and Shipping Key. One installation can have multiple meter numbers. Each meter number has a corresponding Shipping Key. Container.Manifest.Manifest.Shipper_Account_No
ShipperAccountNumber Container.Manifest.Manifest.Shipper_Account_No
PickUpDate Container.Manifest.Manifest_Date
UPSServiceType Shipment.SCAC.SCACAndService.Electronic_Code
PackageActualWeight Container.Container_Gross_Weight
DescriptionOfGoods Container.ContainerDetail.Item.NMFC_Code or Container. ContainerDetail.Item.NMFC_Class
PackageLength Container.PackageLength
PackageWidth Container.PackageWidth
PackageHeight Container.PackageHeight
Declared Value Insurance Container.Declared_Value
SatDeliveryInd Shipment.SpecialServiceRef.SpecialServiceCode. If a special service with value "SATDELI" exist, then the value is set to "1"
ShipmentChgType Shipment.FreightTerms.ChargesPaidBy. If this value is "BUYER", then the Parcel Carrier Adapters attribute is set to "COL". Otherwise, it is set to "PRE"
ConsigneeUPSAcctNumber Shipment.CustCarrier_Account_No
CODAmount Container.COD_Amount
SenderPhone Shipment.ShipNodePersonInfo.Day_Phone
ConsigneeCompanyName Shipment.ShipToPersonInfo.Company
ConsigneeAddress1 Shipment.ShipToPersonInfo.Address_Line1
ConsigneeAddress2 Shipment.ShipToPersonInfo.Address_Line2
ConsigneeCity Shipment.ShipToPersonInfo.City
ConsigneeStateProv Shipment.ShipToPersonInfo.State
ConsigneeCountry Shipment.ShipToPersonInfo.Country
ConsigneePostalCode Shipment.ShipToPersonInfo.Zip_Code
ConsigneeCompanyName Shipment.ShipToPersonInfo.Company
ConsigneePhone Shipment.ShipToPersonInfo.Day_Phone