Table of contents
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_OB
The following are the MS Dynamics Business Central ERP attributes that are mapped with the Canonical attributes and their output path.
| Input Element | MS Dynamics Output Path | MS Dyanmics Output Element | Mapping Rules | ||||
|---|---|---|---|---|---|---|---|
| messageBody | – | – | – | ||||
| canonicalPurchaseOrderHeader | – | – | – | ||||
| processingFunctionTypeCode | – | – | – | ||||
| purchaseOrderType | – | – | – | ||||
| acknowledgmentType | – | – | – | ||||
| isAcknowledgmentRequired | – | – | – | ||||
| transactionReferenceIdentifierList | – | – | – | ||||
| b2bTransactionIdentifierType | – | – | – | ||||
| b2bTransactionIdentifierValue | – | vendorOrderNo | Move source to target where b2bTransactionIdentifierType = ORDERNUMBER | ||||
| transactionDate | – | postingDate | where b2bTransactionIdentifierType = PURCHASEORDER | ||||
| lineItemNumber | – | – | – | ||||
| transactionReferenceIdentifierList | – | – | – | ||||
| b2bTransactionIdentifierType | – | – | – | ||||
| b2bTransactionIdentifierValue | – | – | – | ||||
| transactionDate | – | – | – | ||||
| lineItemNumber | – | – | – | ||||
| mpcDates(1) | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| mpcDates(2) | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| mpcDates(3) | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| mpcDates(4) | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| mpcCurrency | – | – | – | ||||
| currencyCode | – | currencyCode | – | ||||
| exchangeRateCurrencyCode | – | – | – | ||||
| exchangeRate | – | – | – | ||||
| validityDate | – | – | – | ||||
| currencyEntityCode | – | – | – | ||||
| manufacturerBusinessInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| supplierBusinessInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactName | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | vendor | id | where companyIdentifierType= COMPANYSITEID | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | vendor | addressLine1 | – | ||||
| address2 | vendor | addressLine2 | – | ||||
| city | vendor | city | – | ||||
| state | vendor | state | – | ||||
| postalCode | vendor | postalCode | – | ||||
| country | vendor | country | – | ||||
| telephone | vendor | phoneNumber | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| customerBusinessInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| shipToLocationInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactName | – | shipToContact | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | locationCode | Where companyIdentifierType= COMPANYSITEID | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | shipToAddressLine1 | – | ||||
| address2 | – | shipToAddressLine2 | – | ||||
| city | – | shipToCity | – | ||||
| state | – | shipToState | – | ||||
| postalCode | – | shipToPostCode | – | ||||
| country | – | shipToCountry | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| shipFromLocationInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| distributorBusinessInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| billToBusinessInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactName | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | payToVendorNo | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| remitToBusinessInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| carrierInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| url | – | – | – | ||||
| district | – | – | – | ||||
| buildingNumber | – | – | – | ||||
| plantNumber | – | – | – | ||||
| floorNumber | – | – | – | ||||
| lscAddressIdentifier | – | – | – | ||||
| village | – | – | – | ||||
| houseNumber | – | – | – | ||||
| township | – | – | – | ||||
| premisesCode | – | – | – | ||||
| mpcOrganizationList | – | – | – | ||||
| organizationType | – | – | – | ||||
| organizationValue | – | – | – | ||||
| creditsAndCharges | – | – | – | ||||
| creditChargeKeyType | – | – | – | ||||
| creditChargeType | – | – | – | ||||
| creditChargeAmount | – | – | – | ||||
| qualifyingAmount | – | – | – | ||||
| creditChargePercentRate | – | – | – | ||||
| percentRateBasisTypeCode | – | – | – | ||||
| creditChargeCurrencyCode | – | – | – | ||||
| creditChargeHandlingCode | – | – | – | ||||
| description | – | – | – | ||||
| unitPriceAmount | – | – | – | ||||
| unitPriceBasisQuantity | – | – | – | ||||
| itemQuantity | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| baseValue | – | – | – | ||||
| deliveryTerms | – | – | – | ||||
| deliveryTermCode | – | – | – | ||||
| description | – | – | – | ||||
| deliveryChargePaymentMethodType | – | – | – | ||||
| fobTransferLocation | – | – | – | ||||
| deliveryTermsConditionCode | – | – | – | ||||
| salesRequirementCode | – | – | – | ||||
| transportationInformation | – | – | – | ||||
| routingSequenceCode (v1) | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| transportMethod | – | – | – | ||||
| shipmentOrderStatusCode | – | – | – | ||||
| freeTextNote | – | – | – | ||||
| textReferenceCode | – | – | – | ||||
| textFunctionCode | – | – | – | ||||
| language | – | – | – | ||||
| textFormatCode | – | – | – | ||||
| freeFormText | – | – | – | ||||
| salesRequirementCode (v3) | – | – | – | ||||
| transportationInformation (v3) | – | – | – | ||||
| routingSequenceCode (v1) | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| transportMethod | – | – | – | ||||
| shipmentOrderStatusCode | – | – | – | ||||
| termsOfPayment | – | – | – | ||||
| CONSTANT[1] | – | – | – | ||||
| termsOfPaymentKey | – | – | – | ||||
| termsOfPaymentTypeCode | paymentTerm | – | – | ||||
| termsOfPaymentDateBasis | – | – | – | ||||
| numberOfDays | – | – | – | ||||
| termsOfPaymentPercent | – | – | – | ||||
| invoicePayablePercent | – | – | – | ||||
| paymentDueDate | – | – | – | ||||
| paymentDeferredToDate | – | – | – | ||||
| paymentDeferredDueAmount | – | – | – | ||||
| description | – | – | – | ||||
| canonicalPurchaseOrderItemDetails | – | – | – | ||||
| lineItemNumber | – | – | – | ||||
| processingFunctionTypeCode | – | – | – | ||||
| isAcknowledgmentRequired | – | – | – | ||||
| productCodesIdentifiers | – | – | – | ||||
| productCodeType | – | – | – | ||||
| productCodeValue | purchaseOrderLines | lineObjectNumber | Where productCodeType = VENDOR | ||||
| productItemCodeType | – | – | – | ||||
| productCodesIdentifiers | – | – | – | ||||
| productCodeType | – | – | – | ||||
| productCodeValue | – | – | – | ||||
| productItemCodeType | – | – | – | ||||
| productCodesIdentifiers | – | – | – | ||||
| productCodeType | – | – | – | ||||
| productCodeValue | – | rsmusLotNo | Where productCodeType = IN_PRODUCT_CODE | ||||
| productItemCodeType | – | – | – | ||||
| productItemInformation | – | – | – | ||||
| productLanguageCode | – | – | – | ||||
| productName | purchaseOrderLines | description | – | ||||
| genericName | – | – | – | ||||
| productDescription | – | – | – | ||||
| longDescription | – | – | – | ||||
| itemQuantity | – | – | – | ||||
| quantityType | – | – | – | ||||
| quantityValue | purchaseOrderLines | quantity | – | ||||
| unitOfMeasure | purchaseOrderLines | unitOfMeasureCode | – | ||||
| orderPricing | – | – | – | ||||
| pricingType | – | – | – | ||||
| pricingAmount | purchaseOrderLines | directUnitCost | PricingType=UNIT | ||||
| currencyCode | – | – | – | ||||
| priceUOM | – | – | – | ||||
| unitPriceBasisQuantity | – | – | – | ||||
| altUOMDenominator | – | – | – | ||||
| altUOMNumerator | – | – | – | ||||
| numberOfUnitsInPriceUOM | – | – | – | ||||
| itemWeight | – | – | – | ||||
| weightType | – | – | – | ||||
| weightValue | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| mpcDates | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| maximumPartialDeliveries | – | – | – | ||||
| materialClass | – | – | – | ||||
| itemCategory | – | lineType | hard Code to ITEM | ||||
| transactionReferenceIdentifierList | – | – | – | ||||
| b2bTransactionIdentifierType | – | – | – | ||||
| b2bTransactionIdentifierValue | – | – | – | ||||
| transactionDate | – | – | – | ||||
| lineItemNumber | – | – | – | ||||
| deliverySchedule | – | – | – | ||||
| scheduledQuantity | – | – | – | ||||
| previouslyScheduledQuantity | – | – | – | ||||
| scheduledDateTime | – | – | – | ||||
| creditsAndCharges | – | – | – | ||||
| creditChargeKeyType | – | – | – | ||||
| creditChargeType | – | – | – | ||||
| creditChargeAmount | purchaseOrderLines | discountAmount | where creditChargeType= DISCOUNT | ||||
| qualifyingAmount | – | – | – | ||||
| creditChargePercentRate | purchaseOrderLines | discountPercent | where creditChargeType= DISCOUNT | ||||
| percentRateBasisTypeCode | – | – | – | ||||
| creditChargeCurrencyCode | – | – | – | ||||
| creditChargeHandlingCode | – | – | – | ||||
| description | – | – | – | ||||
| unitPriceAmount | – | – | – | ||||
| unitPriceBasisQuantity | – | – | – | ||||
| itemQuantity | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| baseValue | – | – | – | ||||
| deliveryTerms | – | – | – | ||||
| deliveryTermCode | – | – | – | ||||
| description | – | – | – | ||||
| deliveryChargePaymentMethodType | – | – | – | ||||
| fobTransferLocation | – | – | – | ||||
| deliveryTermsConditionCode | – | – | – | ||||
| freeTextNote | – | – | – | ||||
| textReferenceCode | – | – | – | ||||
| textFunctionCode | – | – | – | ||||
| language | – | – | – | ||||
| textFormatCode | – | – | – | ||||
| freeFormText | – | – | – | ||||
