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
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 | ||
Review TraceLink's API: Terms of Use