Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,
Purchase order outbound 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_OB
Guidelines
| Input Element | MS Dynamics Output Path | MS Dynamics 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 | – | – | – | ||||
Creatio ERP
The following are the Creatio ERP attributes that are mapped with the Canonical attributes and their output path.
- Transform Name:
- STD_Transform_MPL_Creatio_PurchaseOrder_OB_V1
Guidelines
| Input Element | Creatio Output Path | Output Element | Mapping Rules | ||||||
|---|---|---|---|---|---|---|---|---|---|
| JSON | - | - | - | ||||||
| id | - | - | - | ||||||
| schemaId | - | - | - | ||||||
| schemaVersion | - | - | - | ||||||
| dataVersion | - | - | - | ||||||
| objectType | - | - | - | ||||||
| createdByUserId | - | - | - | ||||||
| creationDateTime | - | - | - | ||||||
| lastUpdatedByUserId | - | - | - | ||||||
| lastUpdatedDateTime | - | - | - | ||||||
| currentBaseState | - | - | - | ||||||
| currentSubState | - | - | - | ||||||
| subWorkflowName | - | - | - | ||||||
| contextualOwnerId | - | - | - | ||||||
| ownerId | - | - | - | ||||||
| data | - | - | - | ||||||
| controlFileHeader | - | - | - | ||||||
| linkIdentifier | - | - | - | ||||||
| b2bTransactionTypeName | - | - | - | ||||||
| fileReceiverNumber | - | - | - | ||||||
| fileSenderNumber | - | - | - | ||||||
| fileDateTime(1) | - | - | - | ||||||
| fileDateTime(2) | - | - | - | ||||||
| sapControlFileHeader | - | - | - | ||||||
| senderMessagePartnerTypeCode | - | - | - | ||||||
| sapMessageCode | - | - | - | ||||||
| receiverMessageLogicalAddress | - | - | - | ||||||
| sapMessageUsageCode | - | - | - | ||||||
| senderSystemPort | - | - | - | ||||||
| senderMessagePartnerFunction | - | - | - | ||||||
| serializationSequentialIdentifier | - | - | - | ||||||
| sapClientIdentifier | - | - | - | ||||||
| idocReleaseNumber | - | - | - | ||||||
| sapMessageFunctionCode | - | - | - | ||||||
| receiverSystemPort | - | - | - | ||||||
| senderMessageLogicalAddress | - | - | - | ||||||
| sapEDIControlExtension | - | - | - | ||||||
| interchangeControlIdentifier | - | - | - | ||||||
| ediMessageVersionCode | - | - | - | ||||||
| archiveReferenceIdentifier | - | - | - | ||||||
| ediStandardCode | - | - | - | ||||||
| transactionControlIdentifier | - | - | - | ||||||
| ediTransactionType | - | - | - | ||||||
| groupControlIdentifier | - | - | - | ||||||
| edifactControlFileHeader | - | - | - | ||||||
| edifactMessageHeader | - | - | - | ||||||
| controllingAgency | - | - | - | ||||||
| messageControlNumber | - | - | - | ||||||
| ediMessageVersionCode | - | - | - | ||||||
| messageReleaseNumber | - | - | - | ||||||
| associationCode | - | - | - | ||||||
| edifactInterchangeHeader | - | - | - | ||||||
| applicationReferenceIdentifier | - | - | - | ||||||
| recipientPasswordType | - | - | - | ||||||
| syntaxEncodingIdentifier | - | - | - | ||||||
| usageIndicator | - | - | - | ||||||
| isAcknowledgmentRequired | - | - | - | ||||||
| syntaxEncodingVersionString | - | - | - | ||||||
| interchangeAgreementIdentifier | - | - | - | ||||||
| recipientPasswordValue | - | - | - | ||||||
| edifactFileSenderType | - | - | - | ||||||
| edifactEnvelopePartyType | - | - | - | ||||||
| edifactFileReceiverType | - | - | - | ||||||
| edifactEnvelopePartyType | - | - | - | ||||||
| edifactEnvelopeTrailerSegments | - | - | - | ||||||
| trailerSegmentType | - | - | - | ||||||
| trailerSegmentIdentifier | - | - | - | ||||||
| trailerSegmentCount | - | - | - | ||||||
| edifactGroupHeader | - | - | - | ||||||
| controllingAgency | - | - | - | ||||||
| ediMessageVersionCode | - | - | - | ||||||
| groupReceiverNumber | - | - | - | ||||||
| groupSenderNumber | - | - | - | ||||||
| groupTime | - | - | - | ||||||
| messageReleaseNumber | - | - | - | ||||||
| groupDate | - | - | - | ||||||
| groupControlNumber | - | - | - | ||||||
| edifactFileSenderType | - | - | - | ||||||
| edifactEnvelopePartyType | - | - | - | ||||||
| edifactFileReceiverType | - | - | - | ||||||
| edifactEnvelopePartyType | - | - | - | ||||||
| x12ControlFileHeader | - | - | - | ||||||
| x12TransactionSetEnvelope | - | - | - | ||||||
| transactionSetControlNumber | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| implementationConventionReference | - | - | - | ||||||
| x12InterchangeControlEnvelope | - | - | - | ||||||
| interchangeControlIdentifier | - | - | - | ||||||
| securityInformationType | - | - | - | ||||||
| usageIndicator | - | - | - | ||||||
| isAcknowledgmentRequired | - | - | - | ||||||
| componentSeparator | - | - | - | ||||||
| interchangeControlVersion(1) | - | - | - | ||||||
| interchangeControlVersion(2) | - | - | - | ||||||
| interchangeControlVersion(3) | - | - | - | ||||||
| repetitionSeparator | - | - | - | ||||||
| authorizationInformationType | - | - | - | ||||||
| securityInformationValue | - | - | - | ||||||
| authorizationInformationValue | - | - | - | ||||||
| fileSenderType | - | - | - | ||||||
| ediEnvelopePartyType | - | - | - | ||||||
| ediInterchangePartyValue | - | - | - | ||||||
| fileReceiverType | - | - | - | ||||||
| ediEnvelopePartyType | - | - | - | ||||||
| ediInterchangePartyValue | - | - | - | ||||||
| x12FunctionalGroupControlEnvelope | - | - | - | ||||||
| ediMessageVersionCode | - | - | - | ||||||
| groupReceiverNumber | - | - | - | ||||||
| groupSenderNumber | - | - | - | ||||||
| groupTime | - | - | - | ||||||
| groupDate | - | - | - | ||||||
| x12AgencyCode | - | - | - | ||||||
| groupControlNumber | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| x12TrailerSegments (1) | - | - | - | ||||||
| trailerSegmentType | - | - | - | ||||||
| trailerSegmentIdentifier | - | - | - | ||||||
| trailerSegmentCount | - | - | - | ||||||
| COUNT [Count Segments in ST-SE] | - | - | - | ||||||
| CONSTANT [001] | - | - | - | ||||||
| x12TrailerSegments (2) | - | - | - | ||||||
| trailerSegmentType | - | - | - | ||||||
| trailerSegmentIdentifier | - | - | - | ||||||
| trailerSegmentCount | - | - | - | ||||||
| x12TrailerSegments (3) | - | - | - | ||||||
| trailerSegmentType | - | - | - | ||||||
| trailerSegmentIdentifier | - | - | - | ||||||
| trailerSegmentCount | - | - | - | ||||||
| messageBody | - | - | - | ||||||
| canonicalPurchaseOrderHeader | - | - | - | ||||||
| acknowledgmentType | - | - | - | ||||||
| processingFunctionTypeCode | - | - | - | ||||||
| purchaseOrderType | Order | UsrEDIPoTypeId | Convert from source Canonical List to target Creatio Payload | ||||||
| isAcknowledgmentRequired | - | - | - | ||||||
| freeTextNote(1) | - | - | - | ||||||
| CONSTANT[ZZ] | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| textReferenceCode | - | - | - | ||||||
| freeTextNote(2) | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| CONSTANT[L1] | - | - | - | ||||||
| transactionReferenceIdentifierList (1) | - | - | - | ||||||
| b2bTransactionIdentifierValue | Order | DevatisCustomerPurchaseOrderNumber | Store literal Value where b2bTransactionIdentifierType= PURCHASEORDER | ||||||
| b2bTransactionIdentifierValue | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| transactionDate | - | - | - | ||||||
| lineItemNumber | - | - | - | ||||||
| b2bTransactionIdentifierType | - | - | - | ||||||
| transactionReferenceIdentifierList (2) | - | - | - | ||||||
| b2bTransactionIdentifierValue | - | - | - | ||||||
| b2bTransactionIdentifierValue | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| transactionDate | - | - | - | ||||||
| lineItemNumber | - | - | - | ||||||
| b2bTransactionIdentifierType | - | - | - | ||||||
| transactionReferenceIdentifierList (3) | - | - | - | ||||||
| b2bTransactionIdentifierValue | - | - | - | ||||||
| b2bTransactionIdentifierValue | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| transactionDate | - | - | - | ||||||
| lineItemNumber | - | - | - | ||||||
| b2bTransactionIdentifierType | - | - | - | ||||||
| transactionReferenceIdentifierList (4) | - | - | - | ||||||
| b2bTransactionIdentifierValue | Order | Number | PO Number at Devatis .This can be Supplier reference number. | ||||||
| transactionDate | - | - | - | ||||||
| lineItemNumber | - | - | - | ||||||
| b2bTransactionIdentifierType | - | - | - | ||||||
| taxes | - | - | - | ||||||
| country | - | - | - | ||||||
| taxRate | - | - | - | ||||||
| vatIndicator | - | - | - | ||||||
| taxExemptCode | - | - | - | ||||||
| taxCurrencyCode | - | - | - | ||||||
| taxPercent | - | - | - | ||||||
| taxRegistrationCode | - | - | - | ||||||
| taxAmount | - | - | - | ||||||
| taxType | - | - | - | ||||||
| taxJurisdictionCode | - | - | - | ||||||
| mpcCurrency | - | - | - | ||||||
| exchangeRateCurrencyCode | - | - | - | ||||||
| currencyEntityCode | - | - | - | ||||||
| exchangeRate | - | - | - | ||||||
| validityDate | - | - | - | ||||||
| currencyCode | Order | CurrencyID | Will always map 1st occurance. Store liiteral value , If value not present then hard code USD. | ||||||
| deliveryTerms | - | - | - | ||||||
| deliveryChargePaymentMethodType | Order | PaymentTypeId | Store the value from Delivery Charge Payment Method Type field and if the value is not present for Delivery Charge Payment Method Type, then "PaymentTypeId" Hard Code = PP | ||||||
| fobTransferLocation | Order | DevatisLocEDIId | If source is SHIPPINGDESTINATION then map as DE else do not map. where deliveryChargePaymentMethodType = PP | ||||||
| description | Order | DevatisEDILocDescription | Store literal Value where deliveryChargePaymentMethodType = PP | ||||||
| deliveryTermCode | - | - | - | ||||||
| creditsAndCharges | - | - | - | ||||||
| itemQuantity | - | - | - | ||||||
| creditChargeType | - | - | - | ||||||
| creditChargeCurrencyCode | - | - | - | ||||||
| unitOfMeasure | - | - | - | ||||||
| description | - | - | - | ||||||
| creditChargeHandlingCode | - | - | - | ||||||
| creditChargeKeyType | - | - | - | ||||||
| unitPriceAmount | - | - | - | ||||||
| creditChargeAmount | - | - | - | ||||||
| percentRateBasisTypeCode | - | - | - | ||||||
| qualifyingAmount | - | - | - | ||||||
| unitPriceBasisQuantity | - | - | - | ||||||
| baseValue | - | - | - | ||||||
| creditChargePercentRate | - | - | - | ||||||
| termsOfPayment | - | - | - | ||||||
| paymentDueDate | - | - | - | ||||||
| termsOfPaymentTypeCode | - | - | - | ||||||
| termsOfPaymentPercent | - | - | - | ||||||
| paymentDeferredToDate | - | - | - | ||||||
| description | - | - | - | ||||||
| termsOfPaymentDateBasis | - | - | - | ||||||
| discountDueDate | - | - | - | ||||||
| discountDueNumberOfDays | - | - | - | ||||||
| numberOfDays | - | - | - | ||||||
| paymentDeferredDueAmount | - | - | - | ||||||
| termsOfPaymentKey | - | - | - | ||||||
| invoicePayablePercent | - | - | - | ||||||
| dayOfMonth | - | - | - | ||||||
| mpcDates | - | - | - | ||||||
| dateValue | Order | Date | Format Should be yyyy-MM-dd'T'HH:mm:ssZ Where dateType=PURCHASEORDER | ||||||
| dateType | - | - | - | ||||||
| timeZone | - | - | - | ||||||
| mpcDates | - | - | - | ||||||
| dateValue | Order | UsrRequestedShipDate | Format Should be yyyy-MM-dd'T'HH:mm:ssZ SWhere dateType= SHIPMENTREQUESTED | ||||||
| dateType | - | - | - | ||||||
| timeZone | - | - | - | ||||||
| mpcDates | - | - | - | ||||||
| dateValue | Order | UsrEstimatedDeliveryDate | Format Should be yyyy-MM-dd'T'HH:mm:ssZ Where dateType= ESTIMATEDDELIVERY | ||||||
| dateType | - | - | - | ||||||
| timeZone | - | - | - | ||||||
| mpcDates | - | - | - | ||||||
| dateValue | Order | UsrEDICancelIfNotDeliveredDate | Format Should be yyyy-MM-dd'T'HH:mm:ssZ Where dateType=CANCELBY | ||||||
| dateType | - | - | - | ||||||
| timeZone | - | - | - | ||||||
| mpcDates | - | - | - | ||||||
| dateValue | Order | DueDate | Store literal Value Where dateType=DELIVERYREQUESTED | ||||||
| dateType | - | - | - | ||||||
| timeZone | - | - | - | ||||||
| shipToLocationInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList(1) | - | - | - | ||||||
| companyIdentifierType | - | UsrEDICustomerIDTypeId | Store literal Value. | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | Order | AccountId | Store literal Value. Store 0th element. | ||||||
| companyIdentifierValue | - | UsrEDICustomerIDNumber | Store literal Value. Store 0th element. | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | Order | DeliveryAddress | Store literal Value | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| customerBusinessInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | Order | DevatisParentAccountId | Store literal Value. Store 0th element. | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| billToBusinessInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | UsrEDIParentIDTypeId | Store literal Value. | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | UsrEDIParentIDNumber | Store literal Value. Store 0th element. | ||||||
| address | - | - | - | ||||||
| country | Order | UsrEDIBillToCountry | store literal value | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | Order | UsrEDIBillToAddress | store literal value | ||||||
| address2 | - | - | - | ||||||
| city | Order | UsrEDIBillToCity | store literal value | ||||||
| postalCode | Order | UsrEDIBillToPostal | store literal value | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | Order | UsrEDIBillToState | store literal value | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| supplierBusinessInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | Order | ReceiverName | store literal value | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | Order | UsrSupplierId | Store literal Value. Store 0th element. | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | Order | ContactNumber | store literal value. Check for this first and if this value is address.telephoen not present then map contactPhone | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | Order | ContactNumber | store literal value | ||||||
| shipFromLocationInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | Order | UsrShipperId | Store literal Value. Store 0th element. | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| carrierInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | - | - | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| storeNumberBusinessInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | - | - | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| orderedByBusinessInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | - | - | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| billToShipToBusinessInformation | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| businessName | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | - | - | ||||||
| address | - | - | - | ||||||
| country | Order | UsrEDIShipToCountry | store literal value | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address1 | Order | UsrEDIShipToAddress | store literal value | ||||||
| address2 | - | - | - | ||||||
| city | Order | UsrEDIShipToCity | store literal value | ||||||
| postalCode | Order | UsrEDIShipToPostal | store literal value | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | Order | UsrEDIShipToState | store literal value | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| distributorBusinessInformation | - | - | - | ||||||
| businessName | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | - | - | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| address1 | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| freeTextNote | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| textReferenceCode | - | - | - | ||||||
| language | - | - | - | ||||||
| textFunctionCode | - | - | - | ||||||
| textFormatCode | - | - | - | ||||||
| creditChargePercentRate | - | - | - | ||||||
| mpcOrganizationList | - | - | - | ||||||
| organizationType | - | - | - | ||||||
| organizationValue | - | - | - | ||||||
| canonicalPurchaseOrderItemDetails | - | - | - | ||||||
| materialClass | - | - | - | ||||||
| itemCategory | - | - | - | ||||||
| isAcknowledgmentRequired | - | - | - | ||||||
| processingFunctionTypeCode | - | - | - | ||||||
| lineItemNumber | - | - | - | ||||||
| maximumPartialDeliveries | - | - | - | ||||||
| itemQuantity (1) | - | - | - | ||||||
| quantityType | - | - | - | ||||||
| unitOfMeasure | OrderProduct | UnitId | where quantityType = ITEM. | ||||||
| quantityValue | OrderProduct | Quantity | where quantityType = ITEM.Need to take 0th element | ||||||
| itemQuantity (2) | - | - | - | ||||||
| quantityType | - | - | - | ||||||
| unitOfMeasure | - | - | - | ||||||
| quantityValue | - | - | - | ||||||
| itemQuantity (3) | - | - | - | ||||||
| quantityType | - | - | - | ||||||
| unitOfMeasure | - | - | - | ||||||
| quantityValue | - | - | - | ||||||
| orderPricing | - | - | - | ||||||
| priceUOM | - | - | - | ||||||
| numberOfUnitsInPriceUOM | - | - | - | ||||||
| pricingAmount | OrderProduct | Price | where pricingType=UNIT | ||||||
| altUOMDenominator | - | - | - | ||||||
| currencyCode | - | - | - | ||||||
| unitPriceBasisQuantity | - | - | - | ||||||
| altUOMNumerator | - | - | - | ||||||
| pricingType | - | - | - | ||||||
| productCodesIdentifiers | - | - | - | ||||||
| productCodeValue | OrderProduct | ProductId | productCodeType=US_NDC542 | ||||||
| productCodeType | - | - | - | ||||||
| productItemInformation | - | - | - | ||||||
| maxTemperature | - | - | - | ||||||
| packSize | - | - | - | ||||||
| strength | - | - | - | ||||||
| genericName | - | - | - | ||||||
| dosageForm | - | - | - | ||||||
| packType | - | - | - | ||||||
| lscEmVSDosageFormEn | - | - | - | ||||||
| productName | - | - | - | ||||||
| temperatureScale | - | - | - | ||||||
| manufacturer | - | - | - | ||||||
| lscProductItemInformationIdentifier | - | - | - | ||||||
| productCode | - | - | - | ||||||
| marketDosageForm | - | - | - | ||||||
| composition | - | - | - | ||||||
| minTemperature | - | - | - | ||||||
| productLanguageCode | - | - | - | ||||||
| isLightSensitive | - | - | - | ||||||
| lscEmvsDosageFormDE | - | - | - | ||||||
| productDescription | - | - | - | ||||||
| [CONSTANT VALUE] | - | - | - | ||||||
| remarks | - | - | - | ||||||
| manufacturerIdentifier | - | - | - | ||||||
| regulatoryCompanyIdentifierType | - | - | - | ||||||
| regulatoryCompanyIdentifier | - | - | - | ||||||
| shelfLife | - | - | - | ||||||
| shelfLifeValue | - | - | - | ||||||
| shelfLifeUOT | - | - | - | ||||||
| taxes | - | - | - | ||||||
| country | - | - | - | ||||||
| taxRate | - | - | - | ||||||
| vatIndicator | - | - | - | ||||||
| taxExemptCode | - | - | - | ||||||
| taxCurrencyCode | - | - | - | ||||||
| taxPercent | - | - | - | ||||||
| taxRegistrationCode | - | - | - | ||||||
| taxAmount | - | - | - | ||||||
| taxType | - | - | - | ||||||
| taxJurisdictionCode | - | - | - | ||||||
| creditsAndCharges | - | - | - | ||||||
| itemQuantity | - | - | - | ||||||
| creditChargeType | - | - | - | ||||||
| creditChargeCurrencyCode | - | - | - | ||||||
| unitOfMeasure | - | - | - | ||||||
| description | - | - | - | ||||||
| creditChargeHandlingCode | - | - | - | ||||||
| creditChargeKeyType | - | - | - | ||||||
| unitPriceAmount | - | - | - | ||||||
| creditChargeAmount | OrderProduct | DiscountAmount | Store Literal value where creditChargeType= DISCOUNT | ||||||
| percentRateBasisTypeCode | - | - | - | ||||||
| qualifyingAmount | - | - | - | ||||||
| unitPriceBasisQuantity | - | - | - | ||||||
| baseValue | - | - | - | ||||||
| creditChargePercentRate | OrderProduct | DiscountPercent | Store Literal value where creditChargeType= DISCOUNT | ||||||
| extension | - | - | - | ||||||
| name | - | - | - | ||||||
| value | - | - | - | ||||||
| deliveryTerms | - | - | - | ||||||
| deliveryChargePaymentMethodType | - | - | - | ||||||
| fobTransferLocation | - | - | - | ||||||
| description | - | - | - | ||||||
| deliveryTermCode | - | - | - | ||||||
| deliverySchedule | - | - | - | ||||||
| scheduledQuantity | - | - | - | ||||||
| scheduledDateTime | - | - | - | ||||||
| previouslyScheduledQuantity | - | - | - | ||||||
| mpcDates | - | - | - | ||||||
| dateValue | - | - | - | ||||||
| dateType | - | - | - | ||||||
| timeZone | - | - | - | ||||||
| freeTextNote(1) | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| textReferenceCode | - | - | - | ||||||
| language | - | - | - | ||||||
| textFunctionCode | - | - | - | ||||||
| textFormatCode | - | - | - | ||||||
| freeTextNote(2) | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| freeFormText | - | - | - | ||||||
| CONSTANT[L1] | - | - | - | ||||||
| textReferenceCode | - | - | - | ||||||
| language | - | - | - | ||||||
| textFunctionCode | - | - | - | ||||||
| textFormatCode | - | - | - | ||||||
| transactionReferenceIdentifierList | - | - | - | ||||||
| b2bTransactionIdentifierValue | - | - | - | ||||||
| transactionDate | - | - | - | ||||||
| lineItemNumber | - | - | - | ||||||
| b2bTransactionIdentifierType | - | - | - | ||||||
| destinationLocationQuantity | - | - | - | ||||||
| unitOfMeasure | - | - | - | ||||||
| locationQuantityValue | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | - | - | ||||||
| termsOfPayment | - | - | - | ||||||
| paymentDueDate | - | - | - | ||||||
| termsOfPaymentTypeCode | - | - | - | ||||||
| termsOfPaymentPercent | - | - | - | ||||||
| paymentDeferredToDate | - | - | - | ||||||
| description | - | - | - | ||||||
| termsOfPaymentDateBasis | - | - | - | ||||||
| numberOfDays | - | - | - | ||||||
| paymentDeferredDueAmount | - | - | - | ||||||
| termsOfPaymentKey | - | - | - | ||||||
| invoicePayablePercent | - | - | - | ||||||
| itemWeight | - | - | - | ||||||
| weightType | - | - | - | ||||||
| unitOfMeasure | - | - | - | ||||||
| weightValue | - | - | - | ||||||
| shipToLocationInformation | - | - | - | ||||||
| businessName | - | - | - | ||||||
| companyLocationContactInformation | - | - | - | ||||||
| contactTitle | - | - | - | ||||||
| contactEmail | - | - | - | ||||||
| contactName | - | - | - | ||||||
| contactPhone | - | - | - | ||||||
| mpcCompanyLocationIdentifierList | - | - | - | ||||||
| companyIdentifierType | - | - | - | ||||||
| isIdentifierPresentInEvent | - | - | - | ||||||
| alternateCompanyLocationIdentifierValue | - | - | - | ||||||
| companyIdentifierValue | - | - | - | ||||||
| address | - | - | - | ||||||
| country | - | - | - | ||||||
| lscAddressIdentifier | - | - | - | ||||||
| address2 | - | - | - | ||||||
| city | - | - | - | ||||||
| address1 | - | - | - | ||||||
| postalCode | - | - | - | ||||||
| houseNumber | - | - | - | ||||||
| telephone | - | - | - | ||||||
| premisesCode | - | - | - | ||||||
| url | - | - | - | ||||||
| district | - | - | - | ||||||
| floorNumber | - | - | - | ||||||
| buildingNumber | - | - | - | ||||||
| state | - | - | - | ||||||
| fax | - | - | - | ||||||
| village | - | - | - | ||||||
| plantNumber | - | - | - | ||||||
| township | - | - | - | ||||||
| canonicalPurchaseOrderSummary(1) | - | - | - | ||||||
| summaryType | - | - | - | ||||||
| summaryValue | - | - | - | ||||||
| summaryValueUnit | - | - | - | ||||||
| canonicalPurchaseOrderSummary(2) | - | - | - | ||||||
| summaryType | - | - | - | ||||||
| summaryValue | - | - | - | ||||||
| summaryValueUnit | - | - | - | ||||||
| - | SourceOrderId | Hard Code to EDI | |||||||
| - | Usr850EDIControlDat | Hard Code to current date-time value. | |||||||
Tag end
