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 | Creatio Output Element | Mapping Rules | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
| JSON | - | - | - | |||||||
| 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 |
If source = STANDALONEORDER the map SA If source= NEWORDER then map as NE else do not map. |
|||||||
| 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\nwhere 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:ss Where dateType=CANCELBY |
|||||||
| dateType | - | - | - | |||||||
| timeZone | - | - | - | |||||||
| mpcDates | - | - | - | |||||||
| dateValue | Order | DueDate |
Store literal Value Where dateType=DELIVERYREQUESTED |
|||||||
| dateType | - | - | - | |||||||
| timeZone | - | - | - | |||||||
| shipToLocationInformation | - | - | - | |||||||
| [CONSTANT VALUE] | - | - | - | |||||||
| businessName | - | - | - | |||||||
| mpcCompanyLocationIdentifierList(1) | - | - | - | |||||||
| companyIdentifierType | - | - | - | |||||||
| isIdentifierPresentInEvent | - | - | - | |||||||
| alternateCompanyLocationIdentifierValue | - | - | - | |||||||
| companyIdentifierValue | Order | AccountId |
Store literal Value where companyIdentifierType= DEA |
|||||||
| 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 Where companyIdentifierType= DEA |
|||||||
| 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 | - | - | - | |||||||
| isIdentifierPresentInEvent | - | - | - | |||||||
| alternateCompanyLocationIdentifierValue | - | - | - | |||||||
| companyIdentifierValue | - | - | - | |||||||
| 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\nwhere Company identifier Type=DEA | |||||||
| address | - | - | - | |||||||
| country | - | - | - | |||||||
| lscAddressIdentifier | - | - | - | |||||||
| address1 | - | - | - | |||||||
| address2 | - | - | - | |||||||
| city | - | - | - | |||||||
| postalCode | - | - | - | |||||||
| houseNumber | - | - | - | |||||||
| telephone | Order | ContactNumber | store literal value. Check for this first and if this value is address.telephone 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 where Company identifier Type=DEA |
|||||||
| 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 | ||||||||
Tag end
