Tracelink University ## Breadcrumb 1. [Home](/) 2. [Resources](/resources/resource-center) 3. [TraceLink University](/resources/tracelink-university) # Advance shipment notice inbound Link Actions Transactions - [Download PDF](/node/627966/pdf) - [Share](#) - [ LinkedIn ](https://www.linkedin.com/shareArticle?mini=true&url=https://www.tracelink.com/resources/tracelink-university/advance-shipment-notice-inbound-link-actions-transactions&title=Advance shipment notice inbound Link Actions Transactions&summary=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. &source=TraceLink "LinkedIn") - [ Facebook ](https://www.facebook.com/share.php?u=https://www.tracelink.com/resources/tracelink-university/advance-shipment-notice-inbound-link-actions-transactions&t=Advance shipment notice inbound Link Actions Transactions "Facebook") - [ Mail ](mailto:?subject=Advance shipment notice inbound Link Actions Transactions+|+TraceLink&body=https://www.tracelink.com/resources/tracelink-university/advance-shipment-notice-inbound-link-actions-transactions "Mail") - [ Twitter ](https://twitter.com/intent/tweet?text=Advance shipment notice inbound Link Actions Transactions https://www.tracelink.com/resources/tracelink-university/advance-shipment-notice-inbound-link-actions-transactions&via=TraceLink "Twitter") #### Table of contents 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 [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Guidelines](#) input Elements Output Path Output Element Mapping Notes/Rules Id - - - ModifiedOn - - - ModifiedById - - - Number `#/data/messageBody/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 [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Guidelines](#) 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. ![](/sites/default/files/tech_comms/mpl/Content/Resources/Images/global_images/note_tip_24x24.png) Review TraceLink's [API: Terms of Use](https://www.tracelink.com/legal-and-trust/api-terms-of-use) #### Table of contents ##### Related Content [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-idoc) ##### Forecast plan (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-idoc) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-x12) ##### Forecast plan (X12) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-x12) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-response-idoc) ##### Forecast plan response (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with downstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-response-idoc)