Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,
Purchase order inbound Link Action APIs
The Link Action Purchase Order (PO) in an ERP system 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.
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_PurchaseOrder_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 | |
| 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 | – | – | – | |
| payToVendorId | – | – | – | |
| 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 | – | – | – | |
| buyFromAddressLine2 | – | – | ||
| buyFromCity | – | – | – | |
| buyFromCountry | – | – | – | |
| buyFromState | – | – | – | |
| buyFromPostCode | – | – | – | |
| payToAddressLine1 | – | – | – | |
| payToAddressLine2 | – | – | – | |
| payToCity | – | – | – | |
| payToCountry | – | – | – | |
| payToState | – | – | – | |
| payToPostCode | – | – | – | |
| 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 | – | – | – | |
| purchaser | – | – | – | |
| requestedReceiptDate | – | – | – | |
| discountAmount | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges
|
creditChargeAmount | Where creditChargeType= DISCOUNT | |
| discountAppliedBeforeTax | – | – | – | |
| totalAmountExcludingTax | – | – | – | |
| totalTaxAmount | – | – | – | |
| totalAmountIncludingTax | – | – | – | |
| fullyReceived | – | – | – | |
| status | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| vendor | ||||
| @odata.etag | – | – | – | |
| id | – | – | – | |
| number | – | – | – | |
| 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 | – | – | – | |
| taxRegistrationNumber | – | – | – | |
| currencyId | – | – | – | |
| currencyCode | – | – | – | |
| irs1099Code | – | – | – | |
| paymentTermsId | – | – | – | |
| paymentMethodId | – | – | – | |
| taxLiable | – | – | – | |
| blocked | – | – | – | |
| balance | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| dimensionValue | – | – | – | |
| currency | ||||
| @odata.etag | – | – | – | |
| id | – | – | – | |
| code | – | – | – | |
| displayName | – | – | – | |
| symbol | – | – | – | |
| amountDecimalPlaces | – | – | – | |
| amountRoundingPrecision | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| shipmentMethod | – | – | – | |
| purchaseOrderLines | – | |||
| @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 | – | – | – | |
| 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 | – | – | – | |
| amountExcludingTax | – | – | – | |
| taxCode | – | – | – | |
| taxPercent | – | – | – | |
| totalTaxAmount | – | – | – | |
| amountIncludingTax | – | – | – | |
| invoiceDiscountAllocation | – | – | – | |
| netAmount | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing
|
pricingAmount | where pricingType=NET | |
| netTaxAmount | – | – | – | |
| netAmountIncludingTax | – | – | – | |
| expectedReceiptDate | – | – | – | |
| receivedQuantity | – | – | – | |
| invoicedQuantity | – | – | – | |
| invoiceQuantity | – | – | – | |
| receiveQuantity | – | – | – | |
| itemVariantId | – | – | – | |
| locationId | – | – | – | |
| attachments | – | – | – | |
| dimensionSetLines | ||||
| @odata.etag | – | – | – | |
| id | – | – | – | |
| code | – | – | – | |
| consolidationCode | – | – | – | |
| parentId | – | – | – | |
| parentType | – | – | – | |
| displayName | – | – | – | |
| valueId | – | – | – | |
| valueCode | – | – | – | |
| valueConsolidationCode | – | – | – | |
| valueDisplayName | – | – | – | |
Tag end
