Purchase Order Confirmation Guidelines (.csv)
See How To Use this Guide before selecting the below fields.
The following outlines the TL_CSV_PTPO_PurchaseOrderConfirmation_IB message guidelines. These fields are sent by the sender to TraceLink.
When sending an element in Date or DateTime format, a valid date must be given. "00" is not a valid day or month value and "0000" is not a valid year value.| Data Element | Occurs | Format | Length | Enums | Req | Description |
|---|---|---|---|---|---|---|
| CSV_PurchaseOrderAcknowledgement | 1...1 | - | - | - | Purchase Order (PO) Acknowledgment root record. | |
| ControlFileHeader | 1...1 | - | - | - | M | CSV file control header record. |
| Flag | 1...1 | String | 6/6 | - | M | Control file code identifying record = HEADER.1 |
| Version | 1...1 | String | 1/3 | - | M | Version of CSV transaction.2 |
| FileSenderNumber | 1...1 | String | 1/20 | - | M | File sender company ID - Supplier Site ID.3 |
| FileReceiverNumber | 1...1 | String | 1/20 | - | M | File receiver company ID - CustomerSiteID.4 |
| UsageIndicator | 1...1 | String | 0/20 | UsageIndicator | O | Identifies test or production data.5 |
| FileTransactionType | 0...1 | String | 1/30 | TransactionType | M | File transaction type = POACKNOWLEDGE.6 |
| FileControlNumber | 0...1 | String | 1/20 | - | M | Unique file control ID number.7 |
| FileDate | 0...1 | Date | 0/8 | - | O | Date file generated in format YYYYMMDD.8 |
| FileTime | 0...1 | Time | 0/6 | - | O | Time file generated in format HHMMSS.9 |
| POAcknowledge_HeaderRecord | 1...1 | - | - | - | M | PO header record. |
| Flag | 1...1 | String | 6/6 | - | M | Transaction header record code = DOCHDR.10 |
| OrderLevelAction | 0...1 | String | 0/15 | HeaderActionCode | O | Action to be triggered in receiving system. |
| PurchaseOrderNumber | 0...1 | String | 1/35 | - | O | PO number.11 |
| PurchaseOrderDate | 0...1 | Date | 1/8 | - | O | PO date in format YYYYMMDD.12 |
| RequestedDeliveryDate | 0...1 | Date | 0/8 | - | O | Requested delivery date in format YYYYMMDD.13 |
| OrderAcknowledgementRequired | 0...1 | String | 0/1 | - | O | Order acknowledgment flag. |
| OrderAcknowledgementStatus | 0...1 | String | 0/5 | - | O | Order wide acknowledgment status. |
| OrderCurrency | 0...1 | String | 0/3 | CurrencyCodeType | O | Order currency.14 |
| ExchangeRate | 0...1 | String | 0/6 | - | O | Exchange rate if foreign currency. |
| TermsOfPaymentCode | 0...1 | String | 0/6 | - | O | Terms of payment.15 |
| OrderDocumentType | 0...1 | String | 0/10 | - | O | Identifies type of order in file. |
| ShippingConditions | 0...1 | String | 0/2 | - | O | Shipping conditions code for whole order.16 |
| ShippingConditionsDescription | 0...1 | String | 0/20 | - | O | Shipping conditions description.17 |
| RecipientNumber | 0...1 | String | 0/80 | - | O | Customer's partner number for order recipient.18 |
| SalesOrderNumber | 0...1 | String | 0/35 | - | O | Sales order number.19 |
| SalesOrderDate | 0...1 | Date | 0/8 | - | O | Sales order date in format YYYYMMDD.20 |
| SupplierInternalPurchaseOrderNumber | 0...1 | String | 0/35 | - | O | Supplier's internal or alternate PO number.21 |
| POAcknowledge_HeaderPartnerAddressGroup | 1...* | - | - | - | M | Partner ID and address data. |
| Flag | 1...1 | String | 7/7 | - | M | Header partner records code = PARTNER.22 |
| PartnerTypeHandlingCode | 0...1 | String | 0/15 | PartnerTypeHandlingCode | O | Partner type qualifier code.23 |
| PartnerNumber | 0...1 | String | 0/80 | - | O | Customer ID.24 |
| AlternatePartnerNumber | 0...1 | String | 0/80 | - | O | Alternate partner ID. |
| PartnerName1 | 0...1 | String | 0/35 | - | O | Name (line 1).25 |
| PartnerName2 | 0...1 | String | 0/35 | - | O | Name (line 2). |
| PartnerStreetAddress1 | 0...1 | String | 0/35 | - | O | Main street address.26 |
| PartnerStreetAddress2 | 0...1 | String | 0/35 | - | O | Street address (line 2). |
| PartnerCity | 0...1 | String | 0/35 | - | O | City.27 |
| PartnerRegionCode | 0...1 | String | 0/6 | - | O | State, province, or region.28 |
| PartnerPostalCode | 0...1 | String | 0/15 | - | O | Postal code.29 |
| PartnerCountry | 0...1 | String | 0/2 | CountryCode | O | 2-character ISO country key.30 |
| PartnerISOLanguageKey | 0...1 | String | 0/3 | - | O | ISO language key.31 |
| PartnerContactTelephone | 0...1 | String | 0/25 | - | O | Contact telephone number.32 |
| PartnerContactFax | 0...1 | String | 0/25 | - | O | Contact fax number.33 |
| POAcknowledge_HeaderAdditionalDocumentsGroup | 0...* | - | - | - | O | Group stores additional document type numbers and dates in PO. |
| Flag | 1...1 | String | 12/12 | - | M | Additional header document type record code = HDRDOCUMENTS.34 |
| DocumentTypeHandlingCode | 0...1 | String | 0/15 | DocumentType | O | Document type qualifier code.35 |
| DocumentNumber | 0...1 | String | 0/35 | - | O | Document ID number.36 |
| DocumentDate | 0...1 | String | 0/8 | - | O | Date document issued.37 |
| POAcknowledge_HeaderAdditionalDatesGroup | 0...* | - | - | - | O | Group records additional date types. |
| Flag | 1...1 | String | 1/8 | - | M | Additional header date type record code = HDRDATES.38 |
| DateTypeHandlingCode | 0...1 | String | 0/15 | DateType | O | Date type qualifier code.39 |
| Date | 0...1 | String | 0/8 | - | O | Recorded date.40 |
| Time | 0...1 | String | 0/6 | - | O | Recorded time.41 |
| POAcknowledge_HeaderDeliveryTerms | 0...* | - | - | - | O | Delivery terms for order. |
| Flag | 1...1 | String | 11/11 | - | M | Delivery terms type record code = HDRDELIVERY.42 |
| DeliveryTypeHandlingCode | 0...1 | String | 0/15 | DeliveryTypes | O | Delivery type qualifier code.43 |
| DeliveryTermsCode | 0...1 | String | 0/3 | - | O | Delivery terms code.44 |
| DeliveryTermsDescription | 0...1 | String | 0/70 | - | O | Delivery terms code description.45 |
| DeliveryPriority | 0...1 | String | 0/2 | - | O | Delivery priority. |
| POAcknowledge_HeaderPaymentTerms | 0...* | - | - | - | O | Payment terms for order. |
| Flag | 1...1 | String | 7/7 | - | M | Payment terms type record code = PAYMENT.46 |
| PaymentTermsHandlingCode | 0...1 | String | 0/15 | PaymentTerms | O | Payment terms qualifier code. Codes = Pay1, Pay2, Pay3.47 |
| PaymentTermsInDays | 0...1 | String | 0/8 | - | O | Payment terms in number of days.48 |
| PaymentTermsPercent | 0...1 | String | 0/8 | - | O | Payment terms in percent.49 |
| PaymentTermsDescription | 0...1 | String | 0/70 | - | O | Description of payment terms.50 |
| POAcknowledge_HeaderOrganizationGroup | 0...* | - | - | - | O | Organization groups. |
| Flag | 1...1 | String | 12/12 | - | M | Organization entity type record code = ORGANIZATION.51 |
| OrganizationTypeHandlingCode | 0...1 | String | 0/15 | OrgType | O | Organization type qualifier code.52 |
| OrganizationType | 0...1 | String | 0/35 | - | O | Organization type description.53 |
| POAcknowledge_HeaderAdditionalDataGroup | 0...* | - | - | - | O | Payment terms for order. |
| Flag | 1...1 | String | 13/13 | - | M | Additional data type record code = HDRADDITIONAL.54 |
| AdditionalDataHandlingCode | 0...1 | String | 0/15 | - | O | Additional data qualifier code. |
| AdditionalData | 0...1 | String | 0/35 | - | O | Additional data element. |
| AdditionalDataText | 0...1 | String | 0/40 | - | O | Additional data text. |
| POAcknowledge_HeaderFreeTextGroup | 0...* | - | - | - | O | - |
| Flag | 1...1 | String | 7/7 | - | M | Free text type header record code = HDRTEXT.55 |
| FreeTextHandlingCode | 0...1 | String | 0/* | - | O | Free text record qualifier code.56 |
| FreeTextObject | 0...1 | String | 0/10 | - | O | Free text business document object.57 |
| FreeTextLanguageKey | 0...1 | String | 0/3 | - | O | Language key for text.58 |
| FreeTextContents | 0...1 | String | 0/70 | - | O | Free text contents.59 |
| FreeTextFormat | 0...1 | String | 0/2 | - | O | Format for text block: continuous text flow (*) or line break (/).60 |
| POAcknowledge_ItemDetails | 1...* | - | - | - | M | Materials consumed item details records. |
| Flag | 1...1 | String | 11/11 | - | M | Transaction item details record code = ITEMDET.61 |
| LineItemNumber | 0...1 | String | 0/6 | - | O | Line item number.62 |
| ItemAction | 0...1 | String | 0/15 | ItemActionCode | O | Identifies action taken on item. Relevant for PO acknowledgment.63 |
| ItemAcknowledgementStatus | 0...1 | String | 0/15 | AcknowledgeStatus | O | Acknowledgment status for item. Relevant for PO acknowledgment.64 |
| AcknowledgementRequired | 0...1 | String | 1/1 | - | M | Acknowledgment of PO required flag. |
| CustomerMaterialNumber | 0...1 | String | 1/35 | - | M | Customer material number.65 |
| MaterialDescription | 0...1 | String | 0/8 | - | O | Customer material description.66 |
| SupplierMaterialNumber | 0...1 | String | 0/35 | - | O | Supplier material number.67 |
| CustomerLotNumber | 0...1 | String | 0/35 | - | O | Customer lot or batch number.68 |
| TotalItemQuantityOrdered | 0...1 | String | 1/15 | - | M | Total quantity ordered.69 |
| TotalQuantityUnitOfMeasure | 0...1 | String | 1/5 | UnitOfMeasure | M | Unit of measure for quantity ordered.70 |
| ItemUnitPrice | 0...1 | String | 0/15 | - | O | Unit price for item.71 |
| PricingUnitNumerator | 0...1 | String | 0/9 | - | O | Pricing unit per used to calculate item net price.72 |
| ItemNetValue | 0...1 | String | 0/18 | - | O | Net value of item.73 |
| ItemGrossPrice | 0...1 | String | 0/18 | - | O | Gross price for item including surcharges, discounts, and taxes.74 |
| ItemCurrency | 0...1 | String | 0/3 | CurrencyCodeType | O | Line item currency.75 |
| ItemNetWeight | 0...1 | String | 0/18 | - | O | Total net weight for item. |
| NetWeightUnitOfMeasure | 0...1 | String | 0/3 | UnitOfMeasure | C | Unit of measure for net weight.
Mandatory if ItemNetWeight is populated. |
| ItemMaterialClass | 0...1 | String | 0/9 | - | O | Material class or group code for item.76 |
| PurchaseOrderNumber | 0...1 | String | 0/35 | - | O | Referenced PO number.77 |
| PurchaseOrderLineItemNumber | 0...1 | String | 0/6 | - | O | Referenced PO line item number.78 |
| RejectionReasonCode | 0...1 | String | 0/2 | - | O | Code identifying reason item was rejected. Only relevant for PO Acknowledgment. |
| RejectionReasonCodeDescription | 0...1 | String | 0/40 | - | O | Description of rejection reason code. Only relevant for PO Acknowledgment. |
| ItemCategory | 0...1 | String | 0/15 | ItemCategoryType | O | Code identifying type of item ordered, such as consignment or subcontracting.79 |
| ItemPlant | 0...1 | String | 0/4 | - | O | Plant ID where item is located.80 |
| ItemStorageLocation | 0...1 | String | 0/4 | - | O | Storage location in plant for item.81 |
| ItemDeliveryPriority | 0...1 | String | 0/2 | - | O | Priority assigned to delivery of item.82 |
| ItemDeliveryPriorityDescription | 0...1 | String | 0/20 | - | O | Description of delivery priority.83 |
| ItemRoute | 0...1 | String | 0/6 | - | O | Code for route that will be used to deliver item to customer.84 |
| ItemRouteDescription | 0...1 | String | 0/40 | - | O | Description of item route code.85 |
| ShippingReceivingPoint | 0...1 | String | 0/4 | - | O | Shipping/receiving point.86 |
| SalesDocumentItemCategory | 0...1 | String | 0/4 | - | O | Sales document item category. |
| BillOfMaterialsFlag | 0...1 | String | 0/6 | - | O | Identifies top level item of Bill of Materials. |
| BillOfMaterialsLevel | 0...1 | String | 0/5 | - | O | For future use... BOM item level (1,2,3). |
| PriceUnitConversionDenominator | 0...1 | String | 0/6 | - | O | Denominator (divisor) for conversion of sales quantity into SKU quantity.87 |
| PriceUnitConversionNumerator | 0...1 | String | 0/6 | - | O | Numerator (factor) for conversion of sales quantity into SKU quantity.88 |
| NumberPartialDeliveries | 0...1 | String | 0/1 | - | O | Maximum number of partial deliveries for item.89 |
| POAcknowledge_ItemSplitDeliverySchedulesGroup | 1...* | - | - | - | M | Scheduled quantities and dates for split deliveries. |
| Flag | 1...1 | String | 13/13 | - | M | Split delivery schedule record code = SPLITDELIVERY.90 |
| ScheduledDeliveryQuantity | 0...1 | String | 0/15 | - | O | Scheduled delivery quantity.91 |
| ScheduledDeliveryUnitOfMeasure | 0...1 | String | 0/3 | - | O | Unit of measure for quantity to be delivered.92 |
| ScheduledDeliveryDate | 0...1 | String | 0/8 | - | O | Date quantity of item to be delivered.93 |
| POAcknowledge_ItemAdditionalMaterialsGroup | 0...* | - | - | - | O | Additional materials group. |
| Flag | 1...1 | String | 9/9 | - | M | Additional materials record code = MATERIALS.94 |
| MaterialsTypeHandlingCode | 0...1 | String | 0/15 | MaterialsType | O | Materials type qualifier code.95 |
| MaterialOrLotNumber | 0...1 | String | 0/35 | - | O | Material or batch number of item.96 |
| MaterialDescription | 0...1 | String | 0/70 | - | O | Description of item.97 |
| POAcknowledge_ItemPricingDiscountGroup | 0...* | - | - | - | O | Pricing, surcharges, discounts, taxes, and other customer item pricing data. |
| Flag | 1...1 | String | 11/11 | - | M | Item pricing discount group record code = ITEMPRICING.98 |
| AdditionSubtractionIndicator | 0...1 | String | 0/1 | - | O | Identifies pricing record as debit (-) or credit (+).99 |
| PricingDiscountType | 0...1 | String | 0/5 | - | O | Pricing record type code.100 |
| PricingDiscountDescription | 0...1 | String | 0/80 | - | O | Text description for pricing record type.101 |
| PricingDiscountAmount | 0...1 | String | 0/15 | - | O | Fixed total amount in pricing record. |
| PricingDiscountUnitPrice | 0...1 | String | 0/15 | - | O | Unit price for pricing record.102 |
| PricingDiscountPricingUnit | 0...1 | String | 0/9 | - | O | Pricing unit used to calculate pricing amount.103 |
| PricingDiscountUnitOfMeasure | 0...1 | String | 0/3 | - | O | Unit of measure used in pricing record.104 |
| PricingDiscountCurrency | 0...1 | String | 0/3 | CurrencyCodeType | O | Pricing record currency.105 |
| POAcknowledge_ItemAdditionalDocumentsGroup | 0...* | - | - | - | O | Group stores additional document type numbers and dates in PO at item level. |
| Flag | 1...1 | String | 13/13 | - | M | Additional item level document type record code = ITEMDOCUMENTS.106 |
| DocumentTypeHandlingCode | 0...1 | String | 0/15 | DocumentType | O | Document type qualifier code.107 |
| DocumentNumber | 0...1 | String | 0/35 | - | O | Document ID number.108 |
| DocumentLineItemNumber | 0...1 | String | 0/6 | - | O | Document line item number.109 |
| DocumentDate | 0...1 | String | 0/8 | - | O | Date document issued.110 |
| POAcknowledge_ItemAdditionalDatesGroup | 0...* | - | - | - | O | Additional date types at item level. |
| Flag | 1...1 | String | 9/9 | - | M | Additional item level date type record code = ITEMDATES.111 |
| DateTypeHandlingCode | 0...1 | String | 0/15 | DateType | O | Date type qualifier code.112 |
| Date | 0...1 | String | 0/8 | - | O | Recorded date. |
| Time | 0...1 | String | 0/6 | - | O | Recorded time. |
| POAcknowledge_ItemPartnerAddressGroup | 0...* | - | - | - | O | Ship-to partner ID and address data at item level, if present in transaction. |
| Flag | 1...1 | String | 11/11 | - | M | Item partner records code = ITEMPARTNER.113 |
| PartnerTypeHandlingCode | 0...1 | String | 0/15 | PartnerTypeHandlingCode | O | Partner type qualifier code.114 |
| PartnerNumber | 0...1 | String | 0/80 | - | O | Customer ID.115 |
| AlternatePartnerNumber | 0...1 | String | 0/80 | - | O | Alternate partner ID. |
| PartnerName1 | 0...1 | String | 0/35 | - | O | Name(line 1)116 |
| PartnerName2 | 0...1 | String | 0/35 | - | O | Name (line 2). |
| PartnerStreetAddress1 | 0...1 | Date | 0/35 | - | O | Main street address.117 |
| PartnerStreetAddress2 | 0...1 | Time | 0/35 | - | O | Street address (line 2). |
| PartnerCity | 0...1 | String | 0/35 | - | O | City.118 |
| PartnerRegionCode | 0...1 | String | 0/6 | - | O | State, province or region.119 |
| PartnerPostalCode | 0...1 | String | 0/15 | - | O | Postal code.120 |
| PartnerCountry | 0...1 | String | 0/2 | CountryCode | O | 2-char ISO country key.121 |
| PartnerISOLanguageKey | 0...1 | String | 0/3 | - | O | ISO language key.122 |
| PartnerContactTelephone | 0...1 | String | 0/25 | - | O | Contact telephone number. |
| PartnerContactFax | 0...1 | String | 0/25 | - | O | Contact fax number. |
| POAcknowledge_ItemDeliveryTerms | 0...* | - | - | - | O | Delivery terms for order at item level. |
| Flag | 1...1 | String | 12/12 | - | M | Delivery terms type record code = HDRDELIVERY.123 |
| DeliveryTypeHandlingCode | 0...1 | String | 0/15 | DeliveryTypes | O | Delivery type qualifier code.124 |
| DeliveryTermsCode | 0...1 | String | 0/3 | - | O | Delivery terms code.125 |
| DeliveryTermsDescription | 0...1 | String | 0/70 | - | O | Delivery terms code description.126 |
| DeliveryPriority | 0...1 | String | 0/2 | - | O | Customer ID number. |
| POAcknowledge_ItemAdditionalDataGroup | 0...* | - | - | - | O | Payment terms for order. |
| Flag | 1...1 | String | 14/14 | - | M | Additional item level data type record code = ITEMADDITIONAL.127 |
| AdditionalDataHandlingCode | 0...1 | String | 0/15 | - | O | Additional data qualifier code. |
| AdditionalData | 0...1 | String | 0/35 | - | O | Additional data element. |
| AdditionalDataText | 0...1 | String | 0/40 | - | O | Additional data text. |
| POAcknowledge_ItemFreeTextGroup | 0...* | - | - | - | O | - |
| Flag | 1...1 | String | 8/8 | - | M | Free text type header record code = ITEMTEXT.128 |
| FreeTextHandlingCode | 0...1 | String | 0/1 | - | O | Free text record qualifier code.129 |
| FreeTextObject | 0...1 | String | 0/1 | - | O | Free text business document object. |
| FreeTextLanguageKey | 0...1 | String | 0/1 | - | O | Language key for text.130 |
| FreeTextContents | 0...1 | String | 0/1 | - | O | Free text contents.131 |
| FreeTextFormat | 0...1 | String | 0/1 | - | O | Format for text block: continuous text flow (*) or line break (/).132 |
