Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,
Posted sales shipment inbound Link Action APIs
The Link Action Posted Sales Shipment in an ERP system records the details of goods or services that have been shipped or delivered to a customer. It is generated after a sales order is fulfilled and serves as a confirmation of the delivery.
MS Dynamics Business Central ERP
The following are the MS Dynamics Business Central ERP attributes that are mapped with the Canonical attributes and their output path.
- Transform Name:
- STD_MSDynamics_Business_Central_PostedSalesShipment_IB
Guidelines
| MS Dynamics Field Input Element | Mapped Canonical Path | Target Output Element | Mapping Rules | |
|---|---|---|---|---|
| @odata.context | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| number | data/messageBody/canonicalAdvanceShipNoticeHeader/transactionReferenceIdentifierList
|
b2bTransactionIdentifierValue | where b2bTransactionIdentifierType= DELIVERY | |
| externalDocumentNumber | data/messageBody/canonicalAdvanceShipNoticeHeader/transactionReferenceIdentifierList
|
b2bTransactionIdentifierValue | Hard code "PURCHASEORDER" to target instance of transactionReferenceIdentifierList | |
| invoiceDate | – | – | – | |
| postingDate | – | – | – | |
| dueDate | – | – | – | |
| shippingAgentCode | – | – | – | |
| customerId | – | – | – | |
| customerNumber | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
data/messageBody/canonicalAdvanceShipNoticeHeader/shipToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | where companyIdentifierType=COMPANYID where companyIdentifierType=COMPANYSITEID |
|
| customerName | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation
|
businessName | – | |
| billToCustomerId | – | – | – | |
| billToName | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation
|
businessName | – | |
| billToCustomerNumber | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | where companyIdentifierType=COMPANYID | |
| locationCode | data/messageBody/canonicalAdvanceShipNoticeHeader/shipFromLocationInformation
|
companyIdentifierValue | companyIdentifierType=COMPANYSITEID | |
| shipToName | data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation
|
businessName | – | |
| shipToContact | data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/companyLocationContactInformation
|
contactName | – | |
| sellToAddressLine1 | – | – | – | |
| sellToAddressLine2 | – | – | – | |
| sellToCity | – | – | – | |
| sellToCountry | – | – | – | |
| sellToState | – | – | – | |
| sellToPostCode | – | – | – | |
| billToAddressLine1 | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address
|
address1 | – | |
| billToAddressLine2 | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address
|
address2 | – | |
| billToCity | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address
|
city | – | |
| billToCountry | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address
|
country | – | |
| billToState | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address
|
state | – | |
| billToPostCode | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address
|
postalCode | – | |
| shipToAddressLine1 | data/messageBody/canonicalAdvanceShipNoticeHeader/billToBusinessInformation/address
|
address1 | – | |
| shipToAddressLine2 | data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address
|
address2 | – | |
| shipToCity | data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address
|
city | – | |
| shipToCountry | data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address
|
country | – | |
| shipToState | data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address
|
state | – | |
| shipToPostCode | data/messageBody/canonicalAdvanceShipNoticeHeader/shipToLocationInformation/address
|
postalCode | – | |
| currencyCode | data/messageBody/canonicalAdvanceShipNoticeHeader/deliveryExportData
|
currencyCode | Select first value from the array | |
| orderNumber | – | – |
– |
|
| paymentTermsCode | – | – | – | |
| shipmentMethodCode | – | – | – | |
| salesperson | – | – | – | |
| pricesIncludeTax | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| phoneNumber | – | – | – | |
| – | – | – | ||
| customer | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| number | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | where companyIdentifierType=COMPANYID | |
| displayName | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation
|
businessName | – | |
| type | – | – | – | |
| addressLine1 | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/address
|
address1 | – | |
| addressLine2 | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/address
|
address2 | – | |
| city | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/address
|
city | – | |
| state | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/address
|
state | – | |
| country | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/address
|
country | – | |
| postalCode | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/address
|
postalCode | – | |
| phoneNumber | data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
contactPhone | – | |
data/messageBody/canonicalAdvanceShipNoticeHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
contactEmail | – | ||
| website | – | – | – | |
| salespersonCode | – | – | – | |
| balanceDue | – | – | – | |
| creditLimit | – | – | – | |
| taxLiable | – | – | – | |
| taxAreaId | – | – | – | |
| taxAreaDisplayName | – | – | – | |
| taxRegistrationNumber | – | – | – | |
| currencyId | – | – | – | |
| currencyCode | – | – | – | |
| paymentTermsId | – | – | – | |
| shipmentMethodId | – | – | – | |
| paymentMethodId | – | – | – | |
| blocked | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| salesShipmentLines | – | |||
| @odata.etag | – | – | – | |
| id | – | – | – | |
| documentId | – | – | – | |
| documentNo | – | – | – | |
| sequence | data/messageBody/canonicalAdvanceShipNoticeItemDetails/
|
lineItemNumber | Hard Code to Item | |
| lineType | – | Item | Hard Code to Item | |
| lineObjectNumber | data/messageBody/canonicalAdvanceShipNoticeItemDetails/productCodesIdentifiers
|
productCodeValue | Where productCodeType = VENDOR | |
| description | data/messageBody/canonicalAdvanceShipNoticeItemDetails/productItemInformation
|
productName | – | |
| description2 | – | – | – | |
| unitOfMeasureCode | data/messageBody/canonicalAdvanceShipNoticeItemDetails/itemQuantity
|
unitOfMeasure | – | |
| unitPrice | – | – | – | |
| quantity | data/messageBody/canonicalAdvanceShipNoticeItemDetails/itemQuantity
|
quantityValue | hard code to quantityType = DELIVERED and quantityType=ITEM | |
| discountPercent | – | – | – | |
| taxPercent | – | – | – | |
| shipmentDate | canonicalAdvanceShipNoticeHeader/ transactionReferenceIdentifierList
|
transactionDate | where b2bTransactionIdentifierType = DELIVERY | |
| dimensionSetLines | – | |||
| @odata.etag | – | – | – | |
| id | – | – | – | |
| code | – | – | – | |
| consolidationCode | – | – | – | |
| parentId | – | – | – | |
| parentType | – | – | – | |
| displayName | – | – | – | |
| valueId | – | – | – | |
| valueCode | – | – | – | |
| valueConsolidationCode | – | – | – | |
| valueDisplayName | – | – | – | |
| vendor | – | |||
| @odata.context | – | – | – | |
| id | .data.controlFileHeader
|
fileSenderNumber | – | |
| systemVersion | – | – | – | |
| timestamp | – | – | – | |
| name | – | – | – | |
| displayName | data/messageBody/canonicalAdvanceShipNoticeHeader/supplierBusinessInformation
|
businessName | – | |
| businessProfileId | – | – | – | |
| systemCreatedAt | – | – | – | |
| systemCreatedBy | – | – | – | |
| systemModifiedAt | – | – | – | |
| systemModifiedBy | – | – | – | |
Tag end
