Materials Consumed Guidelines (.csv)
See How To Use this Guide before interpreting the guidelines below.
The following outlines the TL_CSV_PTWO_MaterialsConsumed_IB message guidelines.
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 | Enum | Req | Description |
|---|---|---|---|---|---|---|
| TL_CSV_MatConsumed | 1...1 | - | - | - | - | - |
| ControlFileHeader | 1...1 | - | - | - | - | CSV file control header record. |
| Flag | 1...1 | String | 6/6 | - | M | Control file code identifying record = HEADER.1 |
| Version | 1...1 | String | 1/20 | - | M | Version of CSV message.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 - customer.4 |
| UsageIndicator | 1...1 | String | 1/10 | UsageIndicator | M | Identifies test or production data.5 |
| FileTransactionType | 1...1 | String | 1/30 | TransactionType | M | File message type must equal MATCONSUMED.6 |
| FileControlNumber | 1...1 | String | 1/20 | - | M | Unique file control ID number.7 |
| FileDate | 0...1 | Date | 8/8 | - | O | Date file generated in format YYYYMMDD.8 |
| FileTime | 0...1 | Time | 6/6 | - | O | Time file generated in format HHMMSS.9 |
| MaterialsConsumed_HeaderRecord | 1...1 | - | - | - | M | - |
| Flag | 1...1 | String | 6/6 | - | M | Transaction header record code = DOCHDR.10 |
| CustomerNumber | 0...1 | String | 0/80 | - | O | Customer ID number.11 |
| SupplierNumber | 0...1 | String | 0/80 | - | O | Supplier ID number.12 |
| ShipToNumber | 0...1 | String | 0/80 | - | O | Ship-to party ID number. |
| ConsumptionDate | 1...1 | Date | 8/8 | - | M | Date goods consumed in format YYYYMMDD.13 |
| ConsumptionTime | 0...1 | String | 6/6 | - | O | Time goods consumed in format HHMMSS.14 |
| ReferenceDocumentNumber | 0...1 | String | 0/35 | - | O | Reference document number. |
| DocumentText | 0...1 | String | 0/25 | - | O | Reference document text. |
| MaterialConsumptionType | 0...1 | String | 0/* | MaterialConsumptionType | O | Material consumption type.15 |
| BillOfLadingNumber | 0...1 | String | 0/35 | - | O | Bill of Lading number. |
| MaterialsConsumed_DetailsRecord | 1...1 | String | - | - | M | Materials consumed item details records. |
| Flag | 1...1 | String | 7/7 | - | M | Transaction item details record code = ITEMDET.16 |
| PurchaseOrderNumber | 1...1 | String | 0/35 | - | M | Purchase Order (PO) number.17 |
| PurchaseOrderLineItem | 1...1 | String | 0/6 | - | M | PO item number.18 |
| PurchaseOrderDate | 0...1 | Date | 8/8 | - | O | PO date.19 |
| WorkOrderNumber | 1...1 | String | 1/* | - | M | Work Order number.20 |
| CustomerMaterialNumber | 1...1 | String | 0/* | - | M | Customer material number.21 |
| ExpirationDate | 0...1 | Date | 8/8 | - | O | Expiration date for customer material.22 |
| SupplierMaterialNumber | 0...1 | String | 0/35 | - | O | Supplier material number.23 |
| MaterialDescription | 0...1 | String | 0/50 | - | O | Material description. |
| QuantityPosted | 1...1 | String | 1/15 | - | M | Quantity consumed.24 |
| QuantityUOM | 1...1 | String | 1/* | UnitOfMeasure | M | Unit of measure for quantity consumed.25 |
| TypeOfMaterialConsumed | 0...1 | String | 0/* | MaterialType | O | Type of material consumed.26 |
| Plant | 0...1 | String | 0/4 | - | O | Plant ID.27 |
| StorageLocation | 0...1 | String | 0/4 | - | O | Storage location.28 |
| CustomerBatchNumber | 1...1 | String | 0/35 | - | M | Customer batch number.29 |
| SupplierBatchNumber | 0...1 | String | 0/35 | - | O | Supplier batch number. |
