DAC Implementation of MTC Electronic Invoice
Version 1.0 10/7/2004
Note: This file is produced in plain ASCII text with fixed-length fields and no delimiters. Numeric fields are filled with leading zeros. For negative numeric fields, the first position of the field will be "-".
| Record Type | Field Name | From | To | Length | Decimal Precision | Type | Description |
| Header | Record Type | 1 | 1 | 1 | A | Code to identify record type. Literal "A". | |
| Cust Vendor | 2 | 7 | 6 | A | Customer's identification of vendor. | ||
| Invoice Number | 8 | 17 | 10 | 0 | N | MTC Invoice Number to Customer. | |
| Invoice Date | 18 | 23 | 6 | 0 | N | Date of Invoice YYMMDD | |
| Invoice Total | 24 | 33 | 10 | 2 | N | Total Dollar amount of Invoice | |
| Detail | Record Type | 1 | 1 | 1 | A | Code to identify record type. Literal "B". | |
| UPC Number | 2 | 12 | 11 | 0 | N | UPC Code | |
| Description | 13 | 37 | 25 | A | MTC Description of Item | ||
| Vendor Item | 38 | 43 | 6 | 0 | N | MTC Item Number | |
| Unit Cost | 44 | 49 | 6 | 2 | N | Customer's price for sell unit. | |
| Combo Code | 50 | 51 | 2 | A | For combo to identify record which is parent. The records immediately following will be components and will have item number for components in positions 71-76. | ||
| Unit Multiplier | 52 | 57 | 6 | 0 | N | # of retail units in one MTC unit. | |
| Qty of Units | 58 | 62 | 5 | 0 | N | Number of MTC Units Shipped. | |
| Suggested Retail Price | 63 | 67 | 5 | 2 | N | MTC Suggested Retail Price | |
| Price Multi-Pack | 68 | 70 | 3 | 0 | N | Multi-Pack Size for suggested retail (Always 1) | |
| Parent Item# | 71 | 76 | 6 | 0 | N | For components of combo - combo item# | |
| Sales Tax | Record Type | 1 | 1 | 1 | A | Code to identify record type. Literal "C". | |
| Charge Type | 2 | 4 | 3 | A | Type of charge. Literal "TAB". | ||
| Description | 5 | 29 | 25 | A | Description of charge. Literal "Sales Tax". | ||
| Amount | 30 | 38 | 0 | 2 | N | Dollar Amount of Charge. |