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