Table of contents
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 | – | – | – | |
