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.
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 |