Tracelink University ## Breadcrumb 1. [Home](/) 2. [Resources](/resources/resource-center) 3. [TraceLink University](/resources/tracelink-university) # Warehouse ship order inbound Link Action Transactions - [Download PDF](/node/628036/pdf) - [Share](#) - [ LinkedIn ](https://www.linkedin.com/shareArticle?mini=true&url=https://www.tracelink.com/resources/tracelink-university/warehouse-ship-order-inbound-link-action-transactions&title=Warehouse ship order inbound Link Action Transactions&summary=The Link Action Warehouse Ship Order in an ERP system is a structured transaction received by the ERP system, instructing a warehouse or 3PL to ship specific products to a customer or destination. &source=TraceLink "LinkedIn") - [ Facebook ](https://www.facebook.com/share.php?u=https://www.tracelink.com/resources/tracelink-university/warehouse-ship-order-inbound-link-action-transactions&t=Warehouse ship order inbound Link Action Transactions "Facebook") - [ Mail ](mailto:?subject=Warehouse ship order inbound Link Action Transactions+|+TraceLink&body=https://www.tracelink.com/resources/tracelink-university/warehouse-ship-order-inbound-link-action-transactions "Mail") - [ Twitter ](https://twitter.com/intent/tweet?text=Warehouse ship order inbound Link Action Transactions https://www.tracelink.com/resources/tracelink-university/warehouse-ship-order-inbound-link-action-transactions&via=TraceLink "Twitter") #### Table of contents The Link Action Warehouse Ship Order in an ERP system is a structured transaction received by the ERP system, instructing a warehouse or 3PL to ship specific products to a customer or destination. It contains details about the items to be picked, packed, and shipped. ## Creatio ERP The following are the Creatio ERP attributes that are mapped with the Canonical attributes and their output path. - **Transform Name**: - STD\_Transform\_MPL\_Creatio\_WarehouseShipOrder\_IB\_V1 [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Guidelines](#) Input Elements Output Path Output Element Mapping Notes/Rules Id - - - ModifiedOn - - - ModifiedById - - - Number `#/data/messageBody/canonicalWarehouseShipOrderHeader/transactionReferenceIdentifierList` b2bTransactionIdentifierValue Store literal Value. Where b2bTransactionIdentifierType= WAREHOUSESHIPPINGORDER StartDate `#data/messageBody/canonicalWarehouseShipOrderHeader/mpcASNDateRanges` plannedStartDate Store literal Value. Where mpcAsnDateRangeType= REQUESTEDDELIVERY if UsrRequestedShipDate is not empty move UsrRequestedShipDate to target else ifStartDate is not empty move start date to target. If inbound payload has has 0001-01-01T00:00:00Z value then do not map. `#data/messageBody/canonicalWarehouseShipOrderHeader/transactionIdentiferList` transactionDate Store literal Value. Where b2BTransactionIdentiferType= WAREHOUSESHIPPINGORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. PrimaryAmount - - - Order Type Code `#/data/messageBody/canonicalWarehouseShipOrderHeader` processingFunctionTypeCode Hard code to CREATE PrimaryPaymentAmount - - - RemindToOwner - - - RemindToOwnerDate - - - CurrencyRate - - - Amount - - - DueDate - - - PaymentAmount - - - Notes - - - AmountWithoutTax - - - PrimaryAmountWithoutTax - - - PaymentAmountWithoutTax - - - PrimaryPaymentAmountWithoutTax - - - DevatisDueDate - - - DevatisPurchaseOrderDate `#data/messageBody/canonicalWarehouseShipOrderHeader/mpcASNDateRanges` plannedStartDate Store literal value. Where mpcAsnDateRangeType=PURCHASEORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. `#data/messageBody/canonicalWarehouseShipOrderHeader/transactionIdentiferList` transactionDate Store literal Value. Where b2BTransactionIdentiferType= PURCHASEORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. DevatisTrueCommerceInvoiceId - - - DevatisShipDate - - - UsrNumberTest - - - UsrGrossWeight - - - UsrUnitsShipped - - - UsrAutoNumber - - - UsrAvailabilityDate - - - UsrEDIOrderExipreDate - - - UsrEDIDueByDate - - - UsrEDITerms - - - UsrEDIInvoiceNumber - - - UsrEDIParentIDNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue If UsrEDIParentIDNumber is not empty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisBillToAddress.UsrNumberris not empty move DevatisBillToAddress.UsrNumberto target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target else if DevatisBillToAddress.DevatisIdentificationNumberis not empty move DevatisBillToAddress.DevatisIdentificationNumberto target UsrEDIParentIDType - - - Description `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if UsrEDIParentIDType.Description is not empty move UsrEDIParentIDType.Description to target else if DevatisParentAccount.DevatisIdentifcationType is not empty Move DevatisParentAccount.DevatisIdentifcationType to target else if DevatisBillToAddress.DevatisIdentificationTypeis not empty move DevatisBillToAddress.DevatisIdentificationTypeto target UsrEDICustomerIDNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if UsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty moveAccount.UsrNumber to target else if DevatisShipToAddress.UsrNumber is not empty move DevatisShipToAddress.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target else if DevatisShipToAddress.DevatisIdentificationNumber is not empty move DevatisShipToAddress.DevatisIdentificationNumberto target UsrEDICustomerIDType - - - Description `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if UsrEDICustomerIDType.Description is not empty move UsrEDICustomerIDType.Description to target else if Account.DevatisIdentifcationType is not empty Move Account.DevatisIdentifcationType to target elseif DevatisShipToAddess.DevatisIdentifcationType is not empty moveDevatisShipToAddess.DevatisIdentifcationType to target UsrEDI3PLReceiver `data/customFields` name This will be the field name UsrEDI3PLReceiver `data/customFields` value Store literal value if present. Account - - - Id - - - Name `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipToLocationInformation` businessName if Account.Name is not emptymove Account.Name to target else if DevatisShipToAddress.Name is not empty move DevatisShipToAddress.Name to target ModifiedOn - - - ModifiedById - - - Phone `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` telephone if Account.Phone is not emptymove Account.Phone to target else if DevatisShipToAddress.Phone is not empty move DevatisShipToAddress.Phone Name to target Address `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` address1 if UsrEDIShipToAddress is not emptymove UsrEDIShipToAddress to target else ifAccount.Address is not emptymoveAccount.Address to target else if DevatisShipToAddress.Addressis not emptymove DevatisShipToAddress.Address to target CityName `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` city if Order.UsrEDIShipToCity is not emptymove Order.UsrEDIShipToCity to target else ifAccount.CityName is not emptymoveAccount.CityName to target else if DevatisShipToAddress.CityNameis not emptymove DevatisShipToAddress.CityName to target RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` state if Order.UsrEDIShipToState is not emptymove Order.UsrEDIShipToState to target else ifAccount.RegionCode is not emptymoveAccount.RegionCode to target else if DevatisShipToAddress.RegionCodeis not emptymove DevatisShipToAddress.RegionCode to target Zip `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` postalCode if Order.UsrEDIShipToPostal is not emptymove Order.UsrEDIShipToPostale to target else ifAccount.Zip is not emptymoveAccount.Zip to target else if DevatisShipToAddress.Zipis not emptymove DevatisShipToAddress.Zip to target CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` country if Order.UsrEDIShipToCountry is not emptymove Order.UsrEDIShipToCountry to target else ifAccount.CountryCode is not emptymoveAccount.CountryCode to target else if DevatisShipToAddress.CountryCodeis not emptymove DevatisShipToAddress.CountryCode to target DevatisCustomerNumber - - - DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if UsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty moveAccount.UsrNumber to target else if DevatisShipToAddress.UsrNumber is not empty move DevatisShipToAddress.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target else if DevatisShipToAddress.DevatisIdentificationNumber is not empty move DevatisShipToAddress.DevatisIdentificationNumberto target DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if UsrEDICustomerIDType.Description is not empty move UsrEDICustomerIDType.Description to target if Account.DevatisIdentificationType is not empty move Account.DevatisIdentificationType to target else if DevatisShipToAddress.DevatisIdentificationType is not empty move DevatisShipToAddress.DevatisIdentificationTypeto target DevatisIdentificationTypeId - - - UsrNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if UsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty moveAccount.UsrNumber to target else if DevatisShipToAddress.UsrNumber is not empty move DevatisShipToAddress.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target else if DevatisShipToAddress.DevatisIdentificationNumber is not empty move DevatisShipToAddress.DevatisIdentificationNumberto target Supplier - - - Id - - - Name `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation` businessName if Supplier.Name is not emptymove Supplier.Name to target else ifDevatisShipper.Name is not emptymoveDevatisShipper.Name to target else if DevatisSupplierAddress.Name is not emptymove DevatisSupplierAddress.Name to target ModifiedOn - - - ModifiedById - - - Phone `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` telephone if Supplier.Phone is not emptymove Supplier.Phone to target Address `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` address1 if Supplier.Address is not emptymove Supplier.Address to target else if DevatisShipper.Address is not empty move DevatisShipper.Address to target else if DevatisSupplierAddress.Address is not empty move DevatisSupplierAddress.Address to target CityName `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` city if Supplier.CityName is not emptymove Supplier.CityName to target else if DevatisShipper.CityName is not empty move DevatisShipper.CityName to target else if DevatisSupplierAddress.CityName is not empty move DevatisSupplierAddress.CityName to target RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` state if Supplier.RegionCode is not emptymove Supplier.RegionCode to target else if DevatisShipper.RegionCode is not empty move DevatisShipper.RegionCode to target else if DevatisSupplierAddress.RegionCode is not empty move DevatisSupplierAddress.RegionCode to target Zip `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` postalCode if Supplier.Zip is not emptymove Supplier.Zip to target else if DevatisShipper.Zip is not empty move DevatisShipper.Zip to target else if DevatisSupplierAddress.Zip is not empty move DevatisSupplierAddress.Zip to target CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` country if Supplier.CountryCode is not emptymove Supplier.CountryCode to target else if DevatisShipper.CountryCode is not empty move DevatisShipper.CountryCode to target else if DevatisSupplierAddress.CountryCode is not empty move DevatisSupplierAddress.CountryCode to target DevatisCustomerNumber - - - DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if Supplier.UsrNumber is not empty moveSupplier.UsrNumber to target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to target else if DevatisSupplierAddress.UsrNumber is not empty move DevatisSupplierAddress.UsrNumberto target else if supplier.DevatisIdentificationNumber is not empty move supplier.DevatisIdentificationNumber to target else if DevatisShipper.DevatisIdentificationNumber is not empty move DevatisShipper.DevatisIdentificationNumber to target else if DevatisSupplierAddress.DevatisIdentificationNumber is not empty move DevatisSupplierAddress.DevatisIdentificationNumberto target DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if Supplier.DevatisIdentificationType is not empty move Supplier.DevatisIdentificationType to target else if DevatisShipper.DevatisIdentificationType is not empty move DevatisShipper.DevatisIdentificationType to target else if DevatisSupplierAddress.DevatisIdentificationType is not empty move DevatisSupplierAddress.DevatisIdentificationTypeto target UsrNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if Supplier.UsrNumber is not empty moveSupplier.UsrNumber to target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to target else if DevatisSupplierAddress.UsrNumber is not empty move DevatisSupplierAddress.UsrNumberto target else if supplier.DevatisIdentificationNumber is not empty move supplier.DevatisIdentificationNumber to target else if DevatisShipper.DevatisIdentificationNumber is not empty move DevatisShipper.DevatisIdentificationNumber to target else if DevatisSupplierAddress.DevatisIdentificationNumber is not empty move DevatisSupplierAddress.DevatisIdentificationNumberto target `data/controlFileHeader` fileSenderNumber Supplier.DevatisIdentificationType +":"+ .Supplier.UsrNumber Order - - - Id - - - ModifiedOn - - - ModifiedById - - - Number - - - AccountId - - - Date - - - StatusId - - - PaymentStatusId - - - DeliveryStatusId - - - DueDate - - - ActualDate - - - CurrencyId - - - CurrencyRate - - - Amount - - - PaymentAmount - - - PrimaryAmount - - - PrimaryPaymentAmount - - - SourceOrderId - - - Notes - - - DeliveryTypeId - - - PaymentTypeId - - - ReceiverName - - - Comment - - - DevatisParentAccountId - - - DevatisCustomerPurchaseOrderNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/transactionReferenceIdentifierList` b2bTransactionIdentifierValue Store literal Value. where b2bTransactionIdentifierType=PURCHASEORDER DevatisLoadedOn - - - DevatisMemo - - - DevatisEDILocDescription - - - DevatisEDITerms - - - UsrAckCodeId - - - UsrEstimatedDeliveryDate - - - UsrAutoNumber - - - UsrEDIShipToCountry `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` country if Order.UsrEDIShipToCountry is not emptymove Order.UsrEDIShipToCountry to target else ifAccount.CountryCode is not emptymoveAccount.CountryCode to target else if DevatisShipToAddress.CountryCodeis not emptymove DevatisShipToAddress.CountryCode to target UsrEDIShipToPostal `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` postalCode if Order.UsrEDIShipToPostal is not emptymove Order.UsrEDIShipToPostale to target else ifAccount.Zip is not emptymoveAccount.Zip to target else if DevatisShipToAddress.Zipis not emptymove DevatisShipToAddress.Zip to target UsrEDIShipToState `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` state if Order.UsrEDIShipToState is not emptymove Order.UsrEDIShipToState to target else ifAccount.RegionCode is not emptymoveAccount.RegionCode to target else if DevatisShipToAddress.RegionCodeis not emptymove DevatisShipToAddress.RegionCode to target UsrEDIShipToCity `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` city if Order.UsrEDIShipToCity is not emptymove Order.UsrEDIShipToCity to target else ifAccount.CityName is not emptymoveAccount.CityName to target else if DevatisShipToAddress.CityNameis not emptymove DevatisShipToAddress.CityName to target UsrEDIShipToAddress `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` address1 if UsrEDIShipToAddress is not emptymove UsrEDIShipToAddress to target else ifAccount.Address is not emptymoveAccount.Address to target else if DevatisShipToAddress.Addressis not emptymove DevatisShipToAddress.Address to target UsrEDIBillToCountry `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` country if Order.UsrEDIBillToCountry is not emptymove Order.UsrEDIBillToCountry to target else ifDevatisParentAccount.CountryCode is not emptymoveDevatisParentAccount.CountryCode to target else if DevatisBillToAddress.CountryCodeis not emptymove DevatisBillToAddress.CountryCode to target UsrEDIBillToState `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` state if Order.UsrEDIBillToState is not emptymoveOrder.UsrEDIBillToState to target else ifDevatisParentAccount.RegionCode is not emptymoveDevatisParentAccount.RegionCode to target else if DevatisBillToAddress.RegionCodeis not emptymove DevatisBillToAddress.RegionCode to target UsrEDIBillToCity `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` city if Order.UsrEDIBillToCity is not emptymoveOrder.UsrEDIBillToCity to target else ifDevatisParentAccount.CityName is not emptymoveDevatisParentAccount.CityName to target else if DevatisBillToAddress.CityNameis not emptymove DevatisBillToAddress.CityName to target UsrEDIBillToAddress `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` address1 if Order.UsrEDIBillToAddress is not emptymoveOrder.UsrEDIBillToAddress to target else ifDevatisParentAccount.Address is not emptymoveDevatisParentAccount.Address to target else if DevatisBillToAddress.Addresssis not emptymove DevatisBillToAddress.Address to target UsrBillToPostal `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` postalCode if Order.UsrEDIBillToPostal is not emptymove Order.UsrEDIBillToPostal to target else ifDevatisParentAccount.Zip is not emptymoveDevatisParentAccount.Zip to target else if DevatisBillToAddress.Zipis not emptymove DevatisBillToAddress.Zip to target UsrEDICancelIfNotDeliveredDate - - - UsrEDIOrderExpiredDate - - - UsrEDIParentIDNumber - - - UsrEDIParentIDType - - - Description - - - UsrEDICustomerIDNumber - - - UsrEDICustomerIDType - - - Description - - - DevatisParentAccount - - - Id - - - Name `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation` businessName if DevatisParentAccount.Name is not emptymove DevatisParentAccount.Name to target else ifDevatisBillToAddress.Name is not emptymoveDevatisBillToAddress.Name to target ModifiedOn - - - ModifiedById - - - Phone `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` telephone if DevatisParentAccount.Phone is not emptymove DevatisParentAccount.Phone to target Address `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` address1 if Order.UsrEDIBillToAddress is not emptymoveOrder.UsrEDIBillToAddress to target else ifDevatisParentAccount.Address is not emptymoveDevatisParentAccount.Address to target else if DevatisBillToAddress.Addresssis not emptymove DevatisBillToAddress.Address to target CityName `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` city if Order.UsrEDIBillToCity is not emptymoveOrder.UsrEDIBillToCity to target else ifDevatisParentAccount.CityName is not emptymoveDevatisParentAccount.CityName to target else if DevatisBillToAddress.CityNameis not emptymove DevatisBillToAddress.CityName to target RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` state if Order.UsrEDIBillToState is not emptymoveOrder.UsrEDIBillToState to target else ifDevatisParentAccount.RegionCode is not emptymoveDevatisParentAccount.RegionCode to target else if DevatisBillToAddress.RegionCodeis not emptymove DevatisBillToAddress.RegionCode to target Zip `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` postalCode if Order.UsrEDIBillToPostal is not emptymove Order.UsrEDIBillToPostal to target else ifDevatisParentAccount.Zip is not emptymoveDevatisParentAccount.Zip to target else if DevatisBillToAddress.Zipis not emptymove DevatisBillToAddress.Zip to target CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` country if Order.UsrEDIBillToCountry is not emptymove Order.UsrEDIBillToCountry to target else ifDevatisParentAccount.CountryCode is not emptymoveDevatisParentAccount.CountryCode to target else if DevatisBillToAddress.CountryCodeis not emptymove DevatisBillToAddress.CountryCode to target DevatisCustomerNumber - - - DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue If UsrEDIParentIDNumber is not emapty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisBillToAddress.UsrNumberris not empty move DevatisBillToAddress.UsrNumberto target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target else if DevatisBillToAddress.DevatisIdentificationNumberis not empty move DevatisBillToAddress.DevatisIdentificationNumberto target DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if UsrEDIParentIDType.Description is not empty move UsrEDIParentIDType.Description to target else if DevatisParentAccount.DevatisIdentifcationType is not empty Move DevatisParentAccount.DevatisIdentifcationType to target else if DevatisBillToAddress.DevatisIdentificationTypeis not empty move DevatisBillToAddress.DevatisIdentificationTypeto target UsrNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue If UsrEDIParentIDNumber is not emapty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisBillToAddress.UsrNumberris not empty move DevatisBillToAddress.UsrNumberto target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target else if DevatisBillToAddress.DevatisIdentificationNumberis not empty move DevatisBillToAddress.DevatisIdentificationNumberto target Currency - - - Id - - - ModifiedOn - - - ModifiedById - - - Name - - - ShortName - - - Symbol - - - DevatisShipToAddress - - - Id - - - AccountId - - - CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` country if Order.UsrEDIShipToCountry is not emptymove Order.UsrEDIShipToCountry to target else ifAccount.CountryCode is not emptymoveAccount.CountryCode to target else if DevatisShipToAddress.CountryCodeis not emptymove DevatisShipToAddress.CountryCode to target RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` state if Order.UsrEDIShipToState is not emptymove Order.UsrEDIShipToState to target else ifAccount.RegionCode is not emptymoveAccount.RegionCode to target else if DevatisShipToAddress.RegionCodeis not emptymove DevatisShipToAddress.RegionCode to target CityName `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` city if Order.UsrEDIShipToCity is not emptymove Order.UsrEDIShipToCity to target else ifAccount.CityName is not emptymoveAccount.CityName to target else if DevatisShipToAddress.CityNameis not emptymove DevatisShipToAddress.CityName to target Address `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` address1 if UsrEDIShipToAddress is not emptymove UsrEDIShipToAddress to target else ifAccount.Address is not emptymoveAccount.Address to target else if DevatisShipToAddress.Addressis not emptymove DevatisShipToAddress.Address to target Zip `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/address` postalCode if Order.UsrEDIShipToPostal is not emptymove Order.UsrEDIShipToPostale to target else ifAccount.Zip is not emptymoveAccount.Zip to target else if DevatisShipToAddress.Zipis not emptymove DevatisShipToAddress.Zip to target Name `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipToLocationInformation` businessName if Account.Name is not emptymove Account.Name to target else if DevatisShipToAddress.Name is not empty move DevatisShipToAddress.Name to target DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if UsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty moveAccount.UsrNumber to target else if DevatisShipToAddress.UsrNumber is not empty move DevatisShipToAddress.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target else if DevatisShipToAddress.DevatisIdentificationNumber is not empty move DevatisShipToAddress.DevatisIdentificationNumberto target DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if UsrEDICustomerIDType.Description is not empty move UsrEDICustomerIDType.Description to target else if Account.DevatisIdentifcationType is not empty Move Account.DevatisIdentifcationType to target elseif DevatisShipToAddess.DevatisIdentifcationType is not empty moveDevatisShipToAddess.DevatisIdentifcationType to target UsrNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if UsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty moveAccount.UsrNumber to target else if DevatisShipToAddress.UsrNumber is not empty move DevatisShipToAddress.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target else if DevatisShipToAddress.DevatisIdentificationNumber is not empty move DevatisShipToAddress.DevatisIdentificationNumberto target DevatisBillToAddress - - - Id - - - AccountId - - - CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` country if Order.UsrEDIBillToCountry is not emptymove Order.UsrEDIBillToCountry to target else ifDevatisParentAccount.CountryCode is not emptymoveDevatisParentAccount.CountryCode to target else if DevatisBillToAddress.CountryCodeis not emptymove DevatisBillToAddress.CountryCode to target RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` state if Order.UsrEDIBillToState is not emptymoveOrder.UsrEDIBillToState to target else ifDevatisParentAccount.RegionCode is not emptymoveDevatisParentAccount.RegionCode to target else if DevatisBillToAddress.RegionCodeis not emptymove DevatisBillToAddress.RegionCode to target CityName `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` city if Order.UsrEDIBillToCity is not emptymoveOrder.UsrEDIBillToCity to target else ifDevatisParentAccount.CityName is not emptymoveDevatisParentAccount.CityName to target else if DevatisBillToAddress.CityNameis not emptymove DevatisBillToAddress.CityName to target Address `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` address1 if Order.UsrEDIBillToAddress is not emptymoveOrder.UsrEDIBillToAddress to target else ifDevatisParentAccount.Address is not emptymoveDevatisParentAccount.Address to target else if DevatisBillToAddress.Addresssis not emptymove DevatisBillToAddress.Address to target Zip `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/address` postalCode if Order.UsrEDIBillToPostal is not emptymove Order.UsrEDIBillToPostal to target else ifDevatisParentAccount.Zip is not emptymoveDevatisParentAccount.Zip to target else if DevatisBillToAddress.Zipis not emptymove DevatisBillToAddress.Zip to target Name `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation` businessName if DevatisParentAccount.Name is not emptymove DevatisParentAccount.Name to target else ifDevatisBillToAddress.Name is not emptymoveDevatisBillToAddress.Name to target DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue If UsrEDIParentIDNumber is not emapty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisBillToAddress.UsrNumberris not empty move DevatisBillToAddress.UsrNumberto target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target else if DevatisBillToAddress.DevatisIdentificationNumberis not empty move DevatisBillToAddress.DevatisIdentificationNumberto target DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if UsrEDIParentIDType.Description is not empty move UsrEDIParentIDType.Description to target else if DevatisParentAccount.DevatisIdentifcationType is not empty Move DevatisParentAccount.DevatisIdentifcationType to target else if DevatisBillToAddress.DevatisIdentificationTypeis not empty move DevatisBillToAddress.DevatisIdentificationTypeto target UsrNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue If UsrEDIParentIDNumber is not emapty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisBillToAddress.UsrNumberris not empty move DevatisBillToAddress.UsrNumberto target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target else if DevatisBillToAddress.DevatisIdentificationNumberis not empty move DevatisBillToAddress.DevatisIdentificationNumberto target DevatisShipper - - - Id - - - Name `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation` businessName if Supplier.Name is not emptymove Supplier.Name to target else ifDevatisShipper.Name is not emptymoveDevatisShipper.Name to target else if DevatisSupplierAddress.Name is not emptymove DevatisSupplierAddress.Name to target Address `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` address1 if Supplier.Address is not emptymove Supplier.Address to target else if DevatisShipper.Address is not empty move DevatisShipper.Address to target else if DevatisSupplierAddress.Address is not empty move DevatisSupplierAddress.Address to target CityName `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` city if Supplier.CityName is not emptymove Supplier.CityName to target else if DevatisShipper.CityName is not empty move DevatisShipper.CityName to target else if DevatisSupplierAddress.CityName is not empty move DevatisSupplierAddress.CityName to target RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` state if Supplier.RegionCode is not emptymove Supplier.RegionCode to target else if DevatisShipper.RegionCode is not empty move DevatisShipper.RegionCode to target else if DevatisSupplierAddress.RegionCode is not empty move DevatisSupplierAddress.RegionCode to target Zip `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` postalCode if Supplier.Zip is not emptymove Supplier.Zip to target else if DevatisShipper.Zip is not empty move DevatisShipper.Zip to target else if DevatisSupplierAddress.Zip is not empty move DevatisSupplierAddress.Zip to target CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` country if Supplier.CountryCode is not emptymove Supplier.CountryCode to target else if DevatisShipper.CountryCode is not empty move DevatisShipper.CountryCode to target else if DevatisSupplierAddress.CountryCode is not empty move DevatisSupplierAddress.CountryCode to target DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if Supplier.UsrNumber is not empty moveSupplier.UsrNumber to target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to target else if DevatisSupplierAddress.UsrNumber is not empty move DevatisSupplierAddress.UsrNumberto target else if supplier.DevatisIdentificationNumber is not empty move supplier.DevatisIdentificationNumber to target else if DevatisShipper.DevatisIdentificationNumber is not empty move DevatisShipper.DevatisIdentificationNumber to target else if DevatisSupplierAddress.DevatisIdentificationNumber is not empty move DevatisSupplierAddress.DevatisIdentificationNumberto target DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierType if Supplier.DevatisIdentificationType is not empty move Supplier.DevatisIdentificationType to target if DevatisShipper.DevatisIdentificationTypeis not empty move DevatisShipper.DevatisIdentificationTypeto target if DevatisSupplierAddress.DevatisIdentificationType is not empty move DevatisSupplierAddress.DevatisIdentificationType to target DevatisIdentificationTypeId - - - UsrNumber `data/controlFileHeader` fileReceiverNumber DevatisShipper.DevatisIdentificationType +":"+ .DevatisShipper.UsrNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if Supplier.UsrNumber is not empty moveSupplier.UsrNumber to target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to target else if DevatisSupplierAddress.UsrNumber is not empty move DevatisSupplierAddress.UsrNumberto target else if supplier.DevatisIdentificationNumber is not empty move supplier.DevatisIdentificationNumber to target else if DevatisShipper.DevatisIdentificationNumber is not empty move DevatisShipper.DevatisIdentificationNumber to target else if DevatisSupplierAddress.DevatisIdentificationNumber is not empty move DevatisSupplierAddress.DevatisIdentificationNumberto target DevatisSupplierAddress - - - Id - - - CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` country if Supplier.CountryCode is not emptymove Supplier.CountryCode to target else if DevatisShipper.CountryCode is not empty move DevatisShipper.CountryCode to target else if DevatisSupplierAddress.CountryCode is not empty move DevatisSupplierAddress.CountryCode to target RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` state if Supplier.RegionCode is not emptymove Supplier.RegionCode to target else if DevatisShipper.RegionCode is not empty move DevatisShipper.RegionCode to target else if DevatisSupplierAddress.RegionCode is not empty move DevatisSupplierAddress.RegionCode to target CityName `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` city if Supplier.CityName is not emptymove Supplier.CityName to target else if DevatisShipper.CityName is not empty move DevatisShipper.CityName to target else if DevatisSupplierAddress.CityName is not empty move DevatisSupplierAddress.CityName to target Address `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` address1 if Supplier.Address is not emptymove Supplier.Address to target else if DevatisShipper.Address is not empty move DevatisShipper.Address to target else if DevatisSupplierAddress.Address is not empty move DevatisSupplierAddress.Address to target Zip `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/address` postalCode if Supplier.Zip is not emptymove Supplier.Zip to target else if DevatisShipper.Zip is not empty move DevatisShipper.Zip to target else if DevatisSupplierAddress.Zip is not empty move DevatisSupplierAddress.Zip to target AccountId - - - Name `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation` businessName if Supplier.Name is not emptymove Supplier.Name to target else ifDevatisShipper.Name is not emptymoveDevatisShipper.Name to target else if DevatisSupplierAddress.Name is not emptymove DevatisSupplierAddress.Name to target DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if Supplier.UsrNumber is not empty move Supplier.UsrNumber to target els if DevatisShipper.UsrNumberis not empty move DevatisShipper.UsrNumberto target else if DevatisSupplierAddress.UsrNumber is not empty move DevatisShipperAddress.UsrNumber to target else if Supplier.DevatisIdentificationNumber is not empty move Supplier.DevatisIdentificationNumber to target else if DevatisShipper.DevatisIdentificationNumber is not empty move DevatisShipper.DevatisIdentificationNumber to target else if DevatisSupplierAddress.DevatisIdentificationNumber is not empty move DevatisSupplierAddress.DevatisIdentificationNumber to target DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierType Store literal value if present. if Supplier.DevatisIdentificationType is not empty move Supplier.DevatisIdentificationType to target if DevatisShipper.DevatisIdentificationType is not empty move DevatisShipper.DevatisIdentificationType to target if DevatisSupplierAddress.DevatisIdentificationType is not empty move DevatisSupplierAddress.DevatisIdentificationType to target UsrNumber `#/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if Supplier.UsrNumber is not empty move Supplier.UsrNumber to target els if DevatisShipper.UsrNumberis not empty move DevatisShipper.UsrNumberto target else if DevatisSupplierAddress.UsrNumber is not empty move DevatisSupplierAddress.UsrNumber to target else if Supplier.DevatisIdentificationNumber is not empty move Supplier.DevatisIdentificationNumber to target else if DevatisShipper.DevatisIdentificationNumber is not empty move DevatisShipper.DevatisIdentificationNumber to target else if DevatisSupplierAddress.DevatisIdentificationNumber is not empty move DevatisSupplierAddress.DevatisIdentificationNumber to target DevatisShipperAddress - - - Id - - - CountryCode `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation/address` country Store literal value if present. RegionCode `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation/address` state Store literal value if present. CityName `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation/address` city Store literal value if present. Address `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation/address` address1 Store literal value if present. Zip `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation/address` postalCode Store literal value if present. AccountId - - - Name `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation` businessName Store literal value if present. DevatisIdentificationNumber `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue Store literal value if present. - - - DevatisIdentificationType `#/data/messageBody/canonicalWarehouseShipOrderHeaderr/shipFromLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierType Store literal value if present. UsrNumber `#/data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue if DevatisShipperAddress.UsrNumber is not empty move DevatisShipperAddress.UsrNumber to target UsrShipmentTrackingType - - - Id - - - Name - - - Description - - - UsrEquipmentType - - - Id - - - Name - - - Description - - - UsrShipmentStatus - - - Id - - - Name - - - Description - - - UsrReferenceIdentification - - - Id - - - Name - - - Description - - - UsrShippingMethod - - - Id - - - Name - - - Description - - - UsrTransportationMethod - - - Id - - - Name - - - Description - - - UsrTransactionType - - - Id - - - CreatedOn - - - CreatedById - - - ModifiedOn - - - ModifiedById - - - Name - - - Description - - - ProcessListeners - - - InvoiceProduct - - - Id - - - Name - - - Notes - - - DeliveryDate - - - Quantity `#data/messageBody/canonicalWarehouseShipOrderItemDetails/itemQuantity` quantityValue Store literal value where quantityType = DELIVERED PrimaryPrice - - - Price - - - PrimaryAmount - - - Amount - - - PrimaryDiscountAmount - - - DiscountAmount - - - DiscountPercent - - - PrimaryTaxAmount - - - TaxAmount - - - PrimaryTotalAmount - - - TotalAmount - - - DiscountTax - - - InvoiceId - - - DevatisLot `#data/messageBody/canonicalWarehouseShipOrderItemDetails` lotNumber Store literal value if present. DevatisExpirationDate - - - DevatisShipped - - - DevatisOrdered - - - DevatisBackOrder - - - Unit - - - - - - Name - - - - - - ShortName `#data/messageBody/canonicalWarehouseShipOrderItemDetails/itemQuantity` unitOfMeasure Store literal value if present. UsrLineNumber `#/data/messageBody/canonicalWarehouseShipOrderItemDetails` lineItemNumber Store literal value if present. Product - - - - - - Name `#data/messageBody/canonicalWarehouseShipOrderItemDetails/productItemInformation` productDescription Store literal value if present. Code `#/data/messageBodycanonicalWarehouseShipOrderItemDetails/productCodeIdentifiers` productCodeValue Store literal value if present. Where productCodeType=US\_NDC542 Remove - from incmoming value. DevatisShipTracking - - - UsrRequestedShipDate `#data/messageBody/canonicalWarehouseShipOrderHeader/mpcASNDateRanges` plannedStartDate Store literal value. mpcAsnDateRangeType=REQUESTEDDELIVERY if UsrRequestedShipDate is not empty move UsrRequestedShipDate to target else ifStartDate is not empty move start date to target. If inbound payload has has 0001-01-01T00:00:00Z value then do not map. UsrShipNotBeforeThanDate `#data/messageBody/canonicalWarehouseShipOrderHeader/mpcASNDateRanges` plannedStartDate Store literal value. mpcAsnDateRangeType=SHIPNOTBEFORE If inbound payload has has 0001-01-01T00:00:00Z value then do not map. UsrShipNotLaterThanDate `#data/messageBody/canonicalWarehouseShipOrderHeader/mpcASNDateRanges` plannedStartDate Store literal value. mpcAsnDateRangeType =SHIPNOTLATER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. UsrDeliveryNoLaterThanDate `#data/messageBody/canonicalWarehouseShipOrderHeader/mpcASNDateRanges` plannedStartDate Store literal value. mpcAsnDateRangeType=DELIVERNOLATER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. UsrEstimatedDeliveryDate `#data/messageBody/canonicalWarehouseShipOrderHeader/mpcASNDateRanges` plannedStartDate Store literal value. Where mpcAsnDateRangeType= ESTIMATEDDELIVERY ![](/sites/default/files/tech_comms/mpl/Content/Resources/Images/global_images/note_tip_24x24.png) Review TraceLink's [API: Terms of Use](https://www.tracelink.com/legal-and-trust/api-terms-of-use) #### Table of contents ##### Related Content [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-idoc) ##### Forecast plan (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-idoc) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-x12) ##### Forecast plan (X12) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-x12) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-response-idoc) ##### Forecast plan response (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with downstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-response-idoc)