Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,

Advance shipment notice inbound Link Actions Transactions

The Link Action Advance Shipment Notice (ASN) in an ERP system is sent by the seller or shipper to inform the buyer or receiving party of an upcoming delivery. It includes detailed information about the shipment's contents, logistics, and expected delivery date.

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_AdvanceShipNotice_IB_V1
input Elements Output Path Output Element Mapping Notes/Rules
Id - - -
ModifiedOn - - -
ModifiedById - - -
Number #/data/messageBody/canonicalAdvanceShipNoticeHeader/transactionIdentiferList b2bTransactionIdentifierValue Store literal Value. where b2bTransactionIdentifierType= "DELIVERY"
#/data/messageBody/canonicalAdvanceShipNoticeItemDetails/transactionReferenceIdentifierList b2bTransactionIdentifierValue Store literal Value. where b2bTransactionIdentifierType= "INVOICE"and b2bTransactionIdentifierType= "DELIVERY"
StartDate #/data/messageBody/canonicalAdvanceShipNoticeHeader/mpcASNDateRanges plannedStartDate Store literal Value. Where mpcASNDateRangeType= SHIPPED , If inbound payload has has 0001-01-01T00:00:00Z value then do not map.
#/data/messageBody/canonicalAdvanceShipNoticeItemDetails/transactionReferenceIdentifierList transactionDate Store literal Value. b2bTransactionIdentifierType= "INVOICE" If inbound payload has has 0001-01-01T00:00:00Z value then do not map.
UsrCarrierName #/data/messageBody/canonicalAdvanceShipNoticeHeader/carrierInformation businessName Store literal Value.
PrimaryAmount - - -
PrimaryPaymentAmount - - -
RemindToOwner - - -
RemindToOwnerDate - - -
CurrencyRate - - -
Amount - - -
DueDate - - -
PaymentAmount - - -
Notes - - -
AmountWithoutTax - - -
PrimaryAmountWithoutTax - - -
PaymentAmountWithoutTax - - -
PrimaryPaymentAmountWithoutTax - - -
DevatisDueDate - - -
DevatisPurchaseOrderDate #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/transactionReferenceIdentifierList transactionDate Store literal value. Where b2bTransactionIdentifierType= PURCHASEORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map.
DevatisTrueCommerceInvoiceId - - -
DevatisShipDate #/data/messageBody/canonicalAdvanceShipNoticeHeader/transactionReferenceIdentifierList transactionDate Store literal value. Where b2bTransactionIdentifierType= DELIVERY If inbound payload has has 0001-01-01T00:00:00Z value then do not map.
#/data/messageBody/canonicalAdvanceShipNoticeItemDetails/transactionReferenceIdentifierList
UsrNumberTest - - -
UsrGrossWeight #/data/messageBody/canonicalAdvanceShipNoticeHeader/deliveryWeight weightValue Store literal value if present. Where weightType=GROSSWEIGHT
UsrUnitsShipped #/data/messageBody/canonicalAdvanceShipNoticeHeader totalNumberOfPackages Store literal value if present.
UsrAutoNumber - - -
UsrAvailabilityDate - - -
UsrEDIOrderExipreDate - - -
UsrEDIDueByDate - - -
UsrEDITerms - - -
UsrEDIInvoiceNumber - - -
UsrEDIParentIDNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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
UsrEDIParentIDType      
  Description #/data/messageBody/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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
UsrEDITermsBasis      
  Name #/data/messageBody/canonicallAdvanceShipNoticeHeader/termsOfPayment termsOfPaymentDateBasis Convert from sourcepayload to canonical target using enum mapping worksheet if source present, else do not map.
Account - - -
  Id - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation businessName if Account.Name is not empty move Account.Name to target else if DevatisShipToAddress.Name is not empty move DevatisShipToAddress.Name to target
  ModifiedOn - - -
  ModifiedById - - -
  Phone - - -
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address address1 if Order.UsrEDIShipToAddress is not empty move Order.UsrEDIShipToAddress to target else if Account.Addressis not empty move Account.Addressto target else if DevatisShipToAddress.Address is not empty move DevatisShipToAddress.Address to target
  CityName #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address city if Order.UsrEDIShipToCity is not empty move Order.UsrEDIShipToCity to target else if Account.CityName is not empty move Account.CityNameto target else if DevatisShipToAddress.CityName is not empty move DevatisShipToAddress.CityName to target
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address state if Order.UsrEDIShipToState is not empty move Order.UsrEDIShipToState to target else if Account.RegionCode is not empty move Account.RegionCodeto target else if DevatisShipToAddress.RegionCode is not empty move DevatisShipToAddress.RegionCode to target
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address postalCode if Order.UsrEDIShipToPostal is not empty move Order.UsrEDIShipToPostal to target else if Account.Zip is not empty move Account.Zipto target else if DevatisShipToAddress.Zip is not empty move DevatisShipToAddress.Zip to target
  CountryCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address country if Order.UsrEDIShipToCountry is not empty move Order.UsrEDIShipToCountry to target else if Account.CountryCode is not empty move Account.CountryCodeto target else if DevatisShipToAddress.CountryCode is not empty move DevatisShipToAddressCountryCode to targ
  DevatisCustomerNumber - - -
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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
  DevatisIdentificationTypeId - - -
  DevatisIdentificationType #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList companyIdentifierType if UsrEDICustomerIDType.Description is not empty move UsrEDICustomerIDType.Description to target else if Account.DevatisIdentificationType is not empty move Account.DevatisIdentificationType to target else if DevatisShipToAddress.DevatisIdentificationType is not empty move DevatisShipToAddress.DevatisIdentificationTypeto target
  UsrNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation businessName if Supplier.Name is not empty move Supplier.Name to target else if DevatisShipper.Name is not empty move DevatisShipper.Name to target else if DevatisSupplierAddress.Name is not empty move DevatisSupplierAddress.Name to target
  ModifiedOn - - -
  ModifiedById - - -
  Phone - - -
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address address1 if Supplier.Address is not empty move Supplier.Address to target else if DevatisShipper.Address is not empty move DevatisShipper.Addressto target else if DevatisSupplierAddress.Address is not empty move DevatisSupplierAddress.Address to target
  CityName #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address city if Supplier.CityName is not empty move Supplier.CityName to target else if DevatisShipper.CityName is not empty move DevatisShipper.CityNameto target else if DevatisSupplierAddress.CityName is not empty move DevatisSupplierAddress.CityName to target
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address state if Supplier.RegionCode is not empty move Supplier.RegionCode to target else if DevatisShipper.RegionCode is not empty move DevatisShipper.RegionCodeto target else if DevatisSupplierAddress.RegionCode is not empty move DevatisSupplierAddress.RegionCode to target
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address postalCode if Supplier.Zip is not empty move Supplier.Zip to target else if DevatisShipper.Zip is not empty move DevatisShipper.Zipto target else if DevatisSupplierAddress.Zip is not empty move DevatisSupplierAddress.Zip to target
  CountryCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address country if Supplier.CountryCode is not empty move Supplier.CountryCode to target else if DevatisShipper.CountryCode is not empty move DevatisShipper.CountryCodeto target else if DevatisSupplierAddress.CountryCode is not empty move DevatisSupplierAddress.CountryCode to target
  DevatisCustomerNumber - - -
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeItemDetails/transactionReferenceIdentifierList b2bTransactionIdentifierValue Store literal value. Where b2bTransactionIdentifierType= PURCHASEORDER
  DevatisLoadedOn - - -
  DevatisMemo - - -
  DevatisEDILocDescription - - -
  DevatisEDITerms #/data/messageBody/canonicalAdvanceShipNoticeHeader/termsOfPayment numberOfDays 4th element in the string. Store literal Value
  #/data/messageBody/canonicalAdvanceShipNoticeHeader/termsOfPayment termsOfPaymentPercent 1st element in the string . Store literal Value
  #/data/messageBody/canonicalAdvanceShipNoticeHeader/termsOfPayment discountDueNumberOfDays 2nd element in the string.Store literal Value
  #/data/messageBody/canonicalAdvanceShipNoticeHeader/termsOfPayment termsOfPaymentTypeCode Hard Code to BASIC
  UsrAckCodeId - - -
  UsrEstimatedDeliveryDate #/data/messageBody/canonicalAdvanceShipNoticeHeader/mpcASNDateRanges plannedStartDate Store literal value. Where mpcASNDateRangeType= ESTIMATEDDELIVERY If inbound payload has has 0001-01-01T00:00:00Z value then do not map.
  UsrRequestedShipDate - - -
  UsrAutoNumber - - -
  UsrEDIShipToCountry #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address country ifOrder.UsrEDIShipToCountry is not empty moveOrder.UsrEDIShipToCountry to target else if Account.CountryCode is not empty move Account.CountryCodeto target else if DevatisShipToAddress.CountryCode is not empty move DevatisShipToAddress.CountryCode to target
  UsrEDIShipToPostal #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address postalCode ifOrder.UsrEDIShipToPostal is not empty moveOrder.UsrEDIShipToPostal to target else if Account.Zip is not empty move Account.Zipto target else if DevatisShipToAddress.Zip is not empty move DevatisShipToAddress.Zip to target
  UsrEDIShipToState #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address state ifOrder.UsrEDIShipToState is not empty moveOrder.UsrEDIShipToState to target else if Account.RegionCode is not empty move Account.RegionCodeto target else if DevatisShipToAddress.RegionCode is not empty move DevatisShipToAddress.RegionCode to target
  UsrEDIShipToCity #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address city ifOrder.UsrEDIShipToCity is not empty moveOrder.UsrEDIShipToCity to target else if Account.CityName is not empty move Account.CityNameto target else if DevatisShipToAddress.CityName is not empty move DevatisShipToAddress.CityName to target
  UsrEDIShipToAddress #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address address1 ifOrder.UsrEDIShipToAddress is not empty moveOrder.UsrEDIShipToAddress to target else if Account.Addressis not empty move Account.Addressto target else if DevatisShipToAddress.Address is not empty move DevatisShipToAddress.Address to target
  UsrEDIBillToCountry #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address country ifOrder.UsrEDIBillToCountry is not empty move Order. UsrEDIBillToCountry to target else if DevatisParentAccount.CountryCodeis not empty move DevatisParentAccount.CountryCodeto target else if DevatisBillToAddress.CountryCodeis not empty move DevatisBillToAddress.CountryCode to target
  UsrEDIBillToState #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address state ifOrder.UsrEDIBillToState is not empty moveOrder.UsrEDIBillToState to target else if DevatisParentAccount.RegionCodeis not empty move DevatisParentAccount.RegionCodeto target else if DevatisBillToAddress.RegionCodeis not empty move DevatisBillToAddress.RegionCode to target
  UsrEDIBillToCity #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address city ifOrder.UsrEDIBillToCity is not empty move Order.UsrEDIBillToCity to target else if DevatisParentAccount.CityNameis not empty move DevatisParentAccount.CityNameto target else if DevatisBillToAddress.CityNameis not empty move DevatisBillToAddress.CityNameto target
  UsrEDIBillToAddress #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address address1 ifOrder.UsrEDIBillToAddress is not empty moveOrder.UsrEDIBillToAddress to target else if DevatisParentAccount.Addressis not empty move DevatisParentAccount.Addressto target else if DevatisBillToAddress.Addressis not empty move DevatisBillToAddress.Addressto target
  UsrBillToPostal #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address postalCode ifOrder.UsrEDIBillToPostal is not empty moveOrder.UsrEDIBillToPostal to target else if DevatisParentAccount.Zipis not empty move DevatisParentAccount.Zipto target else if DevatisBillToAddress.Zipis not empty move DevatisBillToAddress.Zipto target
  UsrEDICancelIfNotDeliveredDate - - -
  UsrEDIOrderExpiredDate #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/mpcDates dateValue Store literal value if present. Where dateType= "EXPIRATION" If inbound payload has has 0001-01-01T00:00:00Z value then do not map.
  #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/mpcDates epochDateValue convert source to epoch format Where dateType= "EXPIRATION" If inbound payload has has 0001-01-01T00:00:00Z value then do not map. Miliseconds will be rounded off 000.
  UsrEDIParentIDNumber - - -
  UsrEDIParentIDType - - -
    Description - - -
  UsrEDICustomerIDNumber - - -
  UsrEDICustomerIDType - - -
    Description - - -
DevatisParentAccount - - -
  Id - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation businessName if DevatisParentAccount.Name is not empty move DevatisParentAccount.Name to target else if DevatisBillToAddress.Name is not empty move DevatisBillToAddress.Name to target
  ModifiedOn - - -
  ModifiedById - - -
  Phone - - -
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address address1 ifOrder.UsrEDIBillToAddress is not empty moveOrder.UsrEDIBillToAddress to target else if DevatisParentAccount.Addressis not empty move DevatisParentAccount.Addressto target else if DevatisBillToAddress.Addressis not empty move DevatisBillToAddress.Addressto target
  CityName #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address city ifOrder.UsrEDIBillToCity is not empty moveOrder.UsrEDIBillToCity to target else if DevatisParentAccount.CityNameis not empty move DevatisParentAccount.CityNameto target else if DevatisBillToAddress.CityName is not empty move DevatisBillToAddress.CityNameto target
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address state ifOrder.UsrEDIBillToState is not empty moveOrder.UsrEDIBillToState to target else if DevatisParentAccount.RegionCodeis not empty move DevatisParentAccount.RegionCodeto target else if DevatisBillToAddress.RegionCode is not empty move DevatisBillToAddress.RegionCodeto target
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address postalCode ifOrder.UsrEDIBillToPostal is not empty move Order.UsrEDIBillToPostal to target else if DevatisParentAccount.Zipis not empty move DevatisParentAccount.Zipto target else if DevatisBillToAddress.Zip is not empty move DevatisBillToAddress.Zipto target
  CountryCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address country ifOrder.UsrEDIBillToCountry is not empty moveOrder.UsrEDIBillToCountry to target else if DevatisParentAccount.CountryCodeis not empty move DevatisParentAccount.CountryCodeto target else if DevatisBillToAddress.CountryCode is not empty move DevatisBillToAddress.CountryCodeto target
  DevatisCustomerNumber - - -
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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
data/controlFileHeader fileReceiverNumber DevatisParentAccount.DevatisIdentificationType +":"+ .DevatisParentAccount.UsrNumber
Currency - - -
  Id - - -
  ModifiedOn - - -
  ModifiedById - - -
  Name - - -
  ShortName - - -
  Symbol - - -
DevatisShipToAddress - - -
  Id - - -
  AccountId - - -
  CountryName #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address country ifOrder.UsrEDIShipToCountry is not empty moveOrder.UsrEDIShipToCountry to target else if Account.CountryCode is not empty move Account.CountryCodeto target else if DevatisShipToAddress.CountryCode is not empty move DevatisShipToAddress.CountryCode to target
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address state ifOrder.UsrEDIShipToState is not empty moveOrder.UsrEDIShipToState to target else if Account.RegionCode is not empty move Account.RegionCodeto target else if DevatisShipToAddress.RegionCode is not empty move DevatisShipToAddress.RegionCode to target
  CityCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address city ifOrder.UsrEDIShipToCity is not empty moveOrder.UsrEDIShipToCity to target else if Account.CityName is not empty move Account.CityNameto target else if DevatisShipToAddress.CityName is not empty move DevatisShipToAddress.CityName to target
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address address1 ifOrder.UsrEDIShipToAddress is not empty move Order.UsrEDIShipToAddress to target else if Account.Addressis not empty move Account.Addressto target else if DevatisShipToAddress.Address is not empty move DevatisShipToAddress.Address to target
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address postalCode ifOrder.UsrEDIShipToPostal is not empty moveOrder.UsrEDIShipToPostal to target else if Account.Zip is not empty move Account.Zipto target else if DevatisShipToAddress.Zip is not empty move DevatisShipToAddress.Zip to target
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation businessName if Account.Name is not empty move Account.Name to target else if DevatisShipToAddress.Name is not empty move DevatisShipToAddress.Nameto target
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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
  UsrNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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
DevatisBillToAddress - - -
  Id - - -
  AccountId - - -
  CountryCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address country if Order.UsrEDIBillToCountry is not empty move Order.UsrEDIBillToCountry to target else if DevatisParentAccount.CountryCodeis not empty move DevatisParentAccount.CountryCodeto target else if DevatisBillToAddress.CountryCode is not empty move DevatisBillToAddress.CountryCode to target
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address state if Order.UsrEDIBillToState is not empty move Order.UsrEDIBillToState to target else if DevatisParentAccount.RegionCodeis not empty move DevatisParentAccount.RegionCodeto target else if DevatisBillToAddress.RegionCode is not empty move DevatisBillToAddress.RegionCode to target
  CityName #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address city if Order.UsrEDIBillToCity is not empty move Order.UsrEDIBillToCity to target else if DevatisParentAccount.CityNameis not empty move DevatisParentAccount.CityNameto target else if DevatisBillToAddress.CityNameis not empty move DevatisBillToAddress.CityNameto target
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address address1 if Order.UsrEDIBillToAddress is not empty move Order.UsrEDIBillToAddress to target else if DevatisParentAccount.Addressis not empty move DevatisParentAccount.Addressto target else if DevatisBillToAddress.Address is not empty move DevatisBillToAddress.Address to target
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address postalCode if Order.UsrEDIBillToPostal is not empty move Order.UsrEDIBillToPostal to target else if DevatisParentAccount.Zipis not empty move DevatisParentAccount.Zipto target else if DevatisBillToAddress.Zip is not empty move DevatisBillToAddress.Zip to target
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation businessName if DevatisParentAccount.Name is not empty move DevatisParentAccount.Name to target else if DevatisBillToAddress.Name is not empty move DevatisBillToAddress.Name to target
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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
  UsrNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/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/canonicalAdvanceShipNoticeHeader/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
DevatisShipper - - -
  Id - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation businessName if Supplier.Name is not empty move Supplier.Name to target else if DevatisShipper.Name is not empty move DevatisShipper.Name to target else if DevatisSupplierAddress.Name is not empty move DevatisSupplierAddress.Namee to target
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address address1 if Supplier.Address is not empty move Supplier.Address to target else if DevatisShipper.Address is not empty move DevatisShipper.Addressto target else if DevatisSupplierAddress.Address is not empty move DevatisSupplierAddress.Address to target
  CityName #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address city if Supplier.CityName is not empty move Supplier.CityName to target else if DevatisShipper.CityName is not empty move DevatisShipper.CityNameto target else if DevatisSupplierAddress.CityName is not empty move DevatisSupplierAddress.CityName to target
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address state if Supplier.RegionCode is not empty move Supplier.RegionCode to target else if DevatisShipper.RegionCode is not empty move DevatisShipper.RegionCodeto target else if DevatisSupplierAddress.RegionCodeis not empty move DevatisSupplierAddress.RegionCodeto target
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address postalCode if Supplier.Zip is not empty move Supplier.Zip to target else if DevatisShipper.Zip is not empty move DevatisShipper.Zipto target else if DevatisSupplierAddress.Zip is not empty move DevatisSupplierAddress.Zip to target
  CountryCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address country if Supplier.CountryCode is not empty move Supplier.CountryCode to target else if DevatisShipper.CountryCode is not empty move DevatisShipper.CountryCodeto target else if DevatisSupplierAddress.CountryCodeis not empty move DevatisSupplierAddress.CountryCodeto target
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList companyIdentifierValue Store literal value if present. if Supplier.UsrNumberis not empty move Supplier.UsrNumberto target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to 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
  DevatisIdentificationTypeId - - -
  DevatisIdentificationType #/data/messageBody/canonicalAdvanceShipNoticeHeader/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 Store literal value if present. if Supplier.UsrNumberis not empty move Supplier.UsrNumberto target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to 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
DevatisSupplierAddress - - -
  Id - - -
  CountryCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address country if Supplier.CountryCode is not empty move Supplier.CountryCode to target else if DevatisShipper.CountryCode is not empty move DevatisShipper.CountryCodeto target else if DevatisSupplierAddress.CountryCode is not empty move DevatisSupplierAddress.CountryCode to target
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address state if Supplier.RegionCode is not empty move Supplier.RegionCode to target else if DevatisShipper.RegionCode is not empty move DevatisShipper.RegionCodeto target else if DevatisSupplierAddress.RegionCode is not empty move DevatisSupplierAddress.RegionCode to target
  CityName #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address city if Supplier.CityName is not empty move Supplier.CityName to target else if DevatisShipper.CityName is not empty move DevatisShipper.CityNameto target else if DevatisSupplierAddress.CityName is not empty move DevatisSupplierAddress.CityName to target
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address address1 if Supplier.Address is not empty move Supplier.Address to target else if DevatisShipper.Address is not empty move DevatisShipper.Addressto target else if DevatisSupplierAddress.Address is not empty move DevatisSupplierAddress.Address to target
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/address postalCode if Supplier.Zip is not empty move Supplier.Zip to target else if DevatisShipper.Zip is not empty move DevatisShipper.Zipto target else if DevatisSupplierAddress.Zip is not empty move DevatisSupplierAddress.Zip to target
  AccountId      
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation businessName if Supplier.Name is not empty move Supplier.Name to target else if DevatisShipper.Name is not empty move DevatisShipper.Name to target else if DevatisSupplierAddress.Name is not empty move DevatisSupplierAddress.Name to target
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList companyIdentifierValue Store literal value if present. if Supplier.UsrNumberis not empty move Supplier.UsrNumberto target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to 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
  DevatisIdentificationType #/data/messageBody/canonicalAdvanceShipNoticeHeader/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 Store literal value if present. if Supplier.UsrNumberis not empty move Supplier.UsrNumberto target else if DevatisShipper.UsrNumber is not empty move DevatisShipper.UsrNumber to 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/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation/address country Store literal value if present.
  RegionCode #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation/address state Store literal value if present.
  CityName #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation/address city Store literal value if present.
  Address #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation/address address1 Store literal value if present.
  Zip #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation/address postalCode Store literal value if present.
  AccountId      
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromBusinessInformation businessName Store literal value if present.
  DevatisIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation/mpcCompanyLocationIdentifierList companyIdentifierValue if DevatisShipperAddress.UsrNumber is not empty move DevatisShipperAddress.UsrNumber to target else if DevatisShipperAddress.DevatisIdentificationNumber is not empty move DevatisShipperAddress.DevatisIdentificationNumber to target
  DevatisIdentificationType #/data/messageBody/canonicalAdvanceShipNoticeHeader/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 else if DevatisShipperAddress.DevatisIdentificationNumber is not empty move DevatisShipperAddress.DevatisIdentificationNumber to target
UsrShipmentTrackingType - - -
  Id - - -
  Name - - -
  Description - - -
UsrEquipmentType - - -
  Id - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/transportationEquipment equipmentType If source = "CN" hard code "CONTAINER" to target If source = "RR" hard code "RAILCAR" to target If source = "VE" hard code "SHIP" to target If source = "TL" hard code "TRAILER" to target Else do not map.
  Description - - -
UsrShipmentStatus - - -
  Id - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader deliveryStatus If source = "CC", hard code "COMPLETED" to target. Else do not map.
  Description - - -
UsrReferenceIdentification - - -
  Id - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader/transactionReferenceIdentifierList b2bTransactionIdentifierType If source = "BM", hard code "BOL"
  Description - - -
UsrIdentificationNumber #/data/messageBody/canonicalAdvanceShipNoticeHeader/transactionReferenceIdentifierList b2bTransactionIdentifierValue Store literal value. Where b2bTransactionIdentifierType=BOL
UsrTransportationMethod - - -
  Id - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader transportMethod Store liretal value from enum list.
  Description - - -
UsrTransactionType - - -
  Id - - -
  CreatedOn - - -
  CreatedById - - -
  ModifiedOn - - -
  ModifiedById - - -
  Name #/data/messageBody/canonicalAdvanceShipNoticeHeader dropShipIndicator Most likely value if used: - AS = Advance ship notice IF AS= True else False
  Description - - -
  ProcessListeners - - -
InvoiceProduct - - -
  Id - - -
  Name - - -
  Notes - - -
  DeliveryDate - - -
  Quantity #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/itemQuantity quantityValue Store literal value where quantityType = ITEM.
  PrimaryPrice - - -
  Price - - -
  PrimaryAmount - - -
  Amount - - -
  PrimaryDiscountAmount - - -
  DiscountAmount - - -
  DiscountPercent - - -
  PrimaryTaxAmount - - -
  TaxAmount - - -
  PrimaryTotalAmount - - -
  TotalAmount - - -
  DiscountTax - - -
  InvoiceId - - -
  DevatisLot - - -
  #/data/messageBody/canonicalAdvanceShipNoticeItemDetails lotNumber Store literal value.
  DevatisExpirationDate - - -
  DevatisShipped - - -
  DevatisOrdered - - -
  DevatisBackOrder - - -
  Unit - - -
    Name - - -
    ShortName #/data/messageBody/packagingAggregation/packagedProduct/itemQuantity unitOfMeasure Store literal value if present. Where qunatityType=ITEM
  UsrLineNumber #/data/messageBody/canonicalAdvanceShipNoticeItemDetails lineItemNumber Store literal value if present.
  Product - - -
    Name #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/productItemInformation productDescription Store literal value if present.
    Code #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/productCodeIdentifiers productCodeValue Store literal value if present. Where productCodeType=US_NDC542 Remove - from incmoming value.
DevatisShipTracking - - -
UsrYNQ messagebody/canonicalAdvanceShipNoticeHeader/statusConditionsResponse freeFormText Store literal value if present.

SAP HANA ERP

The following are the SAP HANA ERP attributes that are mapped with the Canonical attributes and their output path.

  • Transform Name:
    • STD_LA_MPL_Sap_Hana_AdvanceShipNotice_IB_V1
Input Element Output Path Output Element Mapping Rules
DeliveryDocument #/data/messageBody/canonicalAdvanceShipNoticeHeader/transactionReferenceIdentifierList b2bTransactionIdentifierValue "Store literal value if present. where b2bTransactionIdentifierType= DELIVERY"
ActualGoodsMovementDate - - -
BillingDocumentType - - -
BillOfLading #/data/messageBody/canonicalAdvanceShipNoticeHeader/transactionReferenceIdentifierList b2bTransactionIdentifierValue Store literal value if present where b2bTransactionIdentifierType=BOL
CreatedByUser #/data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList companyIdentifierValue Store literal value if present. Where companyIdentifierType=COMPANYID
data/controlFileHeader fileSenderNumber COMPANYID +"":""+ .CreatedByUser"
CreationDate #data/controlFileHeader fileDateTime "Concatenate source CreationDate + into target in XML date time format YYYY-MM-DDTHH:MM:SS.nnn. If CreationDate present but CreationTime is not present, convert source to date format YYYY-MM-DD."
CreationTime #data/controlFileHeader fileDateTime "Concatenate source CreationDate + into target in XML date time format YYYY-MM-DDTHH:MM:SS.nnn. If CreationDate present but CreationTime is not present, convert source to date format YYYY-MM-DD."
DeliveryDate #/data/messageBody/canonicalAdvanceShipNoticeHeader/mpcASNDateRanges plannedEndDate(1) -
DocumentDate
#/data/messageBody/canonicalAdvanceShipNoticeHeader/mpcASNDateRanges
#/data/messageBody/canonicalAdvanceShipNoticeItemDetails/transactionReferenceIdentifierList
-
PlannedStartDate(1)
transactionDate
epochTransactionDate
-
"Convert from IDoc date to canonical date format YYYY-MM-DD if source present. where b2bTransactionIdentiferType=DELIVERY b2bTransactionIdentiferValue=DeliveryDocument"
HeaderGrossWeight #/data/messageBody/canonicalAdvanceShipNoticeHeader/deliveryWeight weightValue Store literal value if present. Where wightType=GROSSWEIGHT
OrderID - - -
ShippingPoint #/data/messageBody/canonicalAdvanceShipNoticeHeader shippingReceivingPoint Store literal value if present.
ShipToParty
#/data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList
data/controlFileHeader
companyIdentifierValue
fileReceiverNumber
Store literal value, where companyIdentiferType = COMPANYID"
"COMPANYID +"":""+ .ShipToParty "
TransactionCurrency - - Hard Code to USD
Items: - - -
  DeliveryDocumentItem #/data/messageBody/canonicalAdvanceShipNoticeItemDetails lineItemNumber Store literal value if present.
  Material #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/productCodesIdentifiers productCodeValue Store ltieral value. where productCodeType=SUPPLIER
  ActualDeliveredQtyInBaseUnit #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/itemQuantity quantityValue Store literal value if present. where quantityType=DELIVERED where unitOfMeasures=PC
  ActualDeliveryQuantity #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/itemQuantity quantityValue Store literal value if present. where quantityType=DELIVERY where unitOfMeasures=PC
  OriginalDeliveryQuantity #/data/messageBody/canonicalAdvanceShipNoticeItemDetails/itemQuantity quantityValue Store literal value if present. where quantityType=ITEM where unitOfMeasures=PC
  Batch - - -
  GoodsMovementType - - Hard Code to 601
  Plant: #/data/messageBody/canonicalAdvanceShipNoticeItemDetails plantDescription Store literal value if present.

Tag end