Table of contents
A sales order functions as the seller’s official confirmation of the customer’s purchase. A sales order is an agreement outlining the goods or services to be delivered to the customer, confirming the terms of the sale.
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_SalesOrder_IB
Guidelines | MS Dynamics Field Input Element | Mapped Canonical Path | Target Output Element | Mapping Rules | |
|---|---|---|---|---|
| @odata.context | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| number | data/messageBody/canonicalPurchaseOrderItemDetails/transactionReferenceIdentifierList | b2btransactionIdentifierValue | where b2bTransactionIdentifierType = PURCHASEORDER | |
| externalDocumentNumber | data/messageBody/canonicalPurchaseOrderItemDetails/transactionReferenceIdentifierList | b2btransactionIdentifierValue | where b2bTransactionIdentifierType = PURCHASEORDER | |
| orderDate | data/messageBody/canonicalPurchaseOrderHeader/transactionReferenceIdentifierList | transactionDate | where b2bTransactionIdentifierType = PURCHASEORDER | |
| postingDate | – | – | – | |
| customerId | – | – | Not mapped | |
| customerNumber | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList | companyIdentifierValue | where companyIdentifierType = COMPANYID | |
| customerName | – | – | – | |
| billToName | Required. data.messageBody/canonicalPurchaseOrderHeader/billToLocationInformation/companyLocationContactInformation | businessName | – | |
| billToCustomerId | – | – | Not mapped | |
| billToCustomerNumber | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList | companyIdentifierValue | where companyIdentifierType = COMPANYID | |
| shipToName | Required.data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation | businessName | – | |
| shipToContact | data.messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/companyLocationContactInformation/contactName | – | ||
| sellToAddressLine1 | – | – | – | |
| sellToAddressLine2 | – | – | – | |
| sellToCity | – | – | – | |
| sellToCountry | – | – | – | |
| sellToState | – | – | – | |
| sellToPostCode | – | – | – | |
| billToAddressLine1 | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address | billToAddressLine1 | – | |
| billToAddressLine2 | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address | billToAddressLine2 | – | |
| billToCity | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address | billToCity | – | |
| billToCountry | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address | billToCountry | – | |
| billToState | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address | billToState | – | |
| billToPostCode | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address | billToPostCode | – | |
| shipToAddressLine1 | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address | shipToAddressLine1 | – | |
| shipToAddressLine2 | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address | shipToAddressLine2 | – | |
| shipToCity | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address | shipToCity | – | |
| shipToCountry | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address | shipToCountry | – | |
| shipToState | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address | shipToState | – | |
| shipToPostCode | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address | shipToPostCode | – | |
| shortcutDimension1Code | – | – | – | |
| shortcutDimension2Code | – | – | – | |
| currencyID | – | – | – | |
| currencyCode | data/messageBody/canonicalPurchaseOrderHeader/mpcCurrency | currencycode | – | |
| pricesIncludeTax | – | – | – | |
| paymentTermsId | – | – | – | |
| shipmentMethodId | – | – | – | |
| salesperson | – | – | – | |
| partialShipping | – | – | – | |
| requestedDeliveryDate | data/messageBody/canonicalPurchaseOrderHeader/mpcDates data/messageBody/canonicalPurchaseOrderItemDetails/deliverySchedule | dateValue scheduleDateTime | Where dateType = DELIVERYREQUSETED | |
| discountAmount | data/messageBody/canonicalPurchaseOrderHeader/creditsAndCharges | creditChargeAmount | creditChargeType= DISCOUNT | |
| discountAppliedBeforeTax | – | – | – | |
| totalAmountExcludingTax | – | – | – | |
| totalTaxAmount | – | – | – | |
| totalAmountIncludingTax | – | – | – | |
| fullyShipped | – | – | – | |
| status | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| phoneNumber | – | – | – | |
| – | – | – | ||
| customer | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| number | – | – | – | |
| displayName | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address | businessName | – | |
| type | – | – | – | |
| addressLine1 | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address | address1 | – | |
| addressLine2 | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address | address2 | – | |
| city | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address | city | – | |
| state | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address | state | – | |
| country | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address | country | – | |
| postalCode | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address | postalCode | – | |
| phoneNumber | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/companyLocationContactInformation | contactPhone | – | |
data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/companyLocationContactInformation | contactEmail | – | ||
| website | – | – | – | |
| salespersonCode | – | – | – | |
| balanceDue | – | – | – | |
| creditLimit | – | – | – | |
| taxLiable | – | – | – | |
| taxAreaId | – | – | – | |
| taxAreaDisplayName | – | – | – | |
| taxRegistrationNumber | – | – | – | |
| currencyId | – | – | – | |
| currencyCode | – | – | – | |
| paymentTermsId | – | – | – | |
| shipmentMethodId | – | – | – | |
| paymentMethodId | – | – | – | |
| blocked | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| dimensionValue | – | – | – | |
| currency | – | – | – | |
| paymentTerm | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| code | data/messageBody/canonicalPurchaseOrderHeader/termsOfPayment | description | – | |
| displayName | – | – | – | |
| dueDateCalculation | – | – | – | |
| discountDateCalculation | – | – | – | |
| discountPercent | data/messageBody/canonicalPurchaseOrderHeader/termsOfPayment | termsOfPaymentPercent | – | |
| calculateDiscountOnCreditMemos | – | – | ||
| lastModifiedDateTime | – | – | – | |
| shipmentMethod | – | – | – | |
| dimensionSetLines | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| code | – | – | – | |
| consolidationCode | – | – | – | |
| parentId | – | – | – | |
| parentType | – | – | – | |
| displayName | – | – | – | |
| valueId | – | – | – | |
| valueCode | – | – | – | |
| valueConsolidationCode | – | – | – | |
| valueDisplayName | – | – | – | |
| salesOrderLines | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| documentId | – | – | – | |
| sequence | data/messageBody/canonicalPurchaseOrderItemDetails | lineItemNumber | – | |
| itemId | – | – | – | |
| accountId | – | – | – | |
| lineType | – | Item | Hard Code to Item | |
| lineObjectNumber | data/messageBody/canonicalPurchaseOrderItemDetails/productCodesIdentifiers | productCodeValue | where productCodeType=CUSTOMER | |
| description | data/messageBody/canonicalPurchaseOrderItemDetails/productItemInformation | productName | – | |
| description2 | – | – | – | |
| unitOfMeasureId | – | – | – | |
| unitOfMeasureCode | data/messageBody/canonicalPurchaseOrderItemDetails/itemQuantity | unitOfMeasure | Only Each and Case are allowed | |
| quantity | data/messageBody/canonicalPurchaseOrderItemDetails/itemQuantity data/messageBody/canonicalPurchaseOrderItemDetails/deliverySchedule | quantityValue scheduledQuantity | where quantity Type = ITEM | |
| unitPrice | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing | pricingAmount | where pricingType=NET | |
| discountAmount | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges | creditChargeAmount | creditChargeType= DISCOUNT | |
| discountPercent | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges | creditChargePercentRate | creditChargeType= DISCOUNT | |
| discountAppliedBeforeTax | – | – | – | |
| amountExcludingTax | – | – | – | |
| taxCode | – | – | – | |
| taxPercent | – | – | – | |
| totalTaxAmount | – | – | – | |
| amountIncludingTax | – | – | – | |
| invoiceDiscountAllocation | – | – | – | |
| netAmount | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing | pricingAmount | where pricingType=NET | |
| netTaxAmount | – | – | – | |
| netAmountIncludingTax | – | – | – | |
| shipmentDate | – | – | – | |
| shippedQuantity | – | – | – | |
| invoicedQuantity | – | – | – | |
| invoiceQuantity | – | – | – | |
| shipQuantity | – | – | – | |
| itemVariantId | – | – | – | |
| locationId | – | – | – | |
| vendor | – | – | – | |
| @odata.context | – | – | – | |
| id | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/mpcCompanyIdentiferList | companyIdentiferValue | where companyIdentifierType = COMPANYID | |
| systemVersion | – | – | – | |
| timestamp | – | – | – | |
| name | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation | businessName | – | |
| displayName | – | – | – | |
| businessProfileId | – | – | – | |
| systemCreatedAt | – | – | – | |
| systemCreatedBy | – | – | – | |
| systemModifiedAt | – | – | – | |
| systemModifiedBy | – | – | – | |
