Purchase order inbound APIs
A Purchase Order (PO) in MS Dynamics Business Central ERP is created by a buyer to procure goods or services from a vendor or supplier. It outlines the details of the purchase, such as the items, quantities, prices, delivery terms, and payment terms.
- Transform Name:
- STD_MSDynamics_Business_Central_PurchaseOrder_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 | Not mapped | Not mapped | – | |
| @odata.etag | Not mapped | Not mapped | – | |
| id | Not mapped | Not mapped | – | |
| number | data/messageBody/canonicalPurchaseOrderItemDetails/transactionReferenceIdentifierList
|
b2btransactionIdentifierValue | where b2bTransactionIdentifierType = PURCHASEORDER | |
| orderDate | data/messageBody/canonicalPurchaseOrderHeader/transactionReferenceIdentifierList
|
transactionDate | where b2bTransactionIdentifierType = PURCHASEORDER | |
| postingDate | data/messageBody/canonicalPurchaseOrderHeader/transactionReferenceIdentifierList
|
transactionDate | where b2bTransactionIdentifierType = PURCHASEORDER | |
| vendorId | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/mpcCompanyIdentiferList
|
companyIdentiferValue | where companyIdentifierType= COMPANYID | |
| vendorNumber | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/mpcCompanyIdentiferList
|
companyIdentiferValue | where companyIdentifierType= COMPANYID | |
| vendorName | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation
|
businessName | – | |
| payToName | Not mapped | Not mapped | – | |
| payToVendorId | Not mapped | Not mapped | – | |
| payToVendorNumber | data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | where companyIdentifierType = COMPANYID | |
| shipToName | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
businessName | – | |
| shipToContact | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/companyLocationContactInformation/contactName
|
contactName | – | |
| buyFromAddressLine1 | Not mapped | Not mapped | – | |
| buyFromAddressLine2 | Not mapped | Not mapped | ||
| buyFromCity | Not mapped | Not mapped | – | |
| buyFromCountry | Not mapped | Not mapped | – | |
| buyFromState | Not mapped | Not mapped | – | |
| buyFromPostCode | Not mapped | Not mapped | – | |
| payToAddressLine1 | Not mapped | Not mapped | – | |
| payToAddressLine2 | Not mapped | Not mapped | – | |
| payToCity | Not mapped | Not mapped | – | |
| payToCountry | Not mapped | Not mapped | – | |
| payToState | Not mapped | Not mapped | – | |
| payToPostCode | Not mapped | Not mapped | – | |
| 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 | Not mapped | Not mapped | – | |
| shortcutDimension2Code | Not mapped | Not mapped | – | |
| currencyId | Not mapped | Not mapped | – | |
| currencyCode | data/messageBody/canonicalPurchaseOrderHeader/mpcCurrency
|
currencyCode | – | |
| pricesIncludeTax | Not mapped | Not mapped | – | |
| paymentTermsId | Not mapped | Not mapped | – | |
| shipmentMethodId | Not mapped | Not mapped | – | |
| purchaser | Not mapped | Not mapped | – | |
| requestedReceiptDate | Not mapped | Not mapped | – | |
| discountAmount | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges
|
creditChargeAmount | Where creditChargeType= DISCOUNT | |
| discountAppliedBeforeTax | Not mapped | Not mapped | – | |
| totalAmountExcludingTax | Not mapped | Not mapped | – | |
| totalTaxAmount | Not mapped | Not mapped | – | |
| totalAmountIncludingTax | Not mapped | Not mapped | – | |
| fullyReceived | Not mapped | Not mapped | – | |
| status | Not mapped | Not mapped | – | |
| lastModifiedDateTime | Not mapped | Not mapped | – | |
| vendor | ||||
| @odata.etag | Not mapped | Not mapped | – | |
| id | Not mapped | Not mapped | – | |
| number | Not mapped | Not mapped | – | |
| displayName | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation
|
businessName | – | |
| addressLine1 | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
address1 | – | |
| addressLine2 | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
address2 | – | |
| city | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
city | – | |
| state | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
state | – | |
| country | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
country | – | |
| postalCode | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
postalCode | – | |
| phoneNumber | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/companyLocationContactInformation
|
contactPhone | – | |
data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/companyLocationContactInformation
|
contactEmail | – | ||
| website | Not mapped | Not mapped | – | |
| taxRegistrationNumber | Not mapped | Not mapped | – | |
| currencyId | Not mapped | Not mapped | – | |
| currencyCode | Not mapped | Not mapped | – | |
| irs1099Code | Not mapped | Not mapped | – | |
| paymentTermsId | Not mapped | Not mapped | – | |
| paymentMethodId | Not mapped | Not mapped | – | |
| taxLiable | Not mapped | Not mapped | – | |
| blocked | Not mapped | Not mapped | – | |
| balance | Not mapped | Not mapped | – | |
| lastModifiedDateTime | Not mapped | Not mapped | – | |
| dimensionValue | Not mapped | Not mapped | – | |
| currency | ||||
| @odata.etag | Not mapped | Not mapped | – | |
| id | Not mapped | Not mapped | – | |
| code | Not mapped | Not mapped | – | |
| displayName | Not mapped | Not mapped | – | |
| symbol | Not mapped | Not mapped | – | |
| amountDecimalPlaces | Not mapped | Not mapped | – | |
| amountRoundingPrecision | Not mapped | Not mapped | – | |
| lastModifiedDateTime | Not mapped | Not mapped | – | |
| shipmentMethod | Not mapped | Not mapped | – | |
| purchaseOrderLines | – | |||
| @odata.etag | Not mapped | Not mapped | – | |
| id | Not mapped | Not mapped | – | |
| documentId | Not mapped | Not mapped | – | |
| sequence | data/messageBody/canonicalPurchaseOrderItemDetails
|
lineItemNumber | – | |
| itemId | Not mapped | Not mapped | – | |
| accountId | Not mapped | Not mapped | – | |
| lineType | Not mapped | Item | Hard Code to Item | |
| lineObjectNumber | data/messageBody/canonicalPurchaseOrderItemDetails/productCodesIdentifiers
|
productCodeValue | where productCodeType=CUSTOMER | |
| description | data/messageBody/canonicalPurchaseOrderItemDetails/productItemInformation
|
productName | – | |
| description2 | Not mapped | Not mapped | – | |
| unitOfMeasureId | Not mapped | Not mapped | – | |
| unitOfMeasureCode | Not mapped | Not mapped | – | |
| quantity | data/messageBody/canonicalPurchaseOrderItemDetails/itemQuantity
|
quantityValue | where quantity Type = ITEM | |
| directUnitCost | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing |
pricingAmount | where pricingType=UNIT | |
| discountAmount | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges |
creditChargeAmount | creditChargeType= DISCOUNT | |
| discountPercent | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges
|
creditChargePercentRate | creditChargeType= DISCOUNT | |
| discountAppliedBeforeTax | Not mapped | Not mapped | – | |
| amountExcludingTax | Not mapped | Not mapped | – | |
| taxCode | Not mapped | Not mapped | – | |
| taxPercent | Not mapped | Not mapped | – | |
| totalTaxAmount | Not mapped | Not mapped | – | |
| amountIncludingTax | Not mapped | Not mapped | – | |
| invoiceDiscountAllocation | Not mapped | Not mapped | – | |
| netAmount | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing
|
pricingAmount | where pricingType=NET | |
| netTaxAmount | Not mapped | Not mapped | – | |
| netAmountIncludingTax | Not mapped | Not mapped | – | |
| expectedReceiptDate | Not mapped | Not mapped | – | |
| receivedQuantity | Not mapped | Not mapped | – | |
| invoicedQuantity | Not mapped | Not mapped | – | |
| invoiceQuantity | Not mapped | Not mapped | – | |
| receiveQuantity | Not mapped | Not mapped | – | |
| itemVariantId | Not mapped | Not mapped | – | |
| locationId | Not mapped | Not mapped | – | |
| attachments | Not mapped | Not mapped | – | |
| dimensionSetLines | ||||
| @odata.etag | Not mapped | Not mapped | – | |
| id | Not mapped | Not mapped | – | |
| code | Not mapped | Not mapped | – | |
| consolidationCode | Not mapped | Not mapped | – | |
| parentId | Not mapped | Not mapped | – | |
| parentType | Not mapped | Not mapped | – | |
| displayName | Not mapped | Not mapped | – | |
| valueId | Not mapped | Not mapped | – | |
| valueCode | Not mapped | Not mapped | – | |
| valueConsolidationCode | Not mapped | Not mapped | – | |
| valueDisplayName | Not mapped | Not mapped | – | |
