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 APIs
The posted sales shipment in MS Dynamics Business Central ERP 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.
- Transform Name:
- STD_MSDynamics_Business_Central_PostedSalesShipment_IB
The following are the MS Dynamics Business Central ERP attributes that are mapped with the Canonical attributes and their output path.
| 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
