| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PTUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | PTJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | PTPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 4 | PTUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 5 | PTUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 6 | PTLINENBR | Line Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 7 | PTMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 8 | PTLVLA | Level Cost | String | UDC (40 CA) | 3 | 0 | Allow NULL? |
| 9 | PTPCST | Percent - Cost Add-On | Numeric | Generic Edit | 15 | 7 | Allow NULL? |
| 10 | PTPRP5 | Purchasing Category Code 5 | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 11 | PTDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | PTDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 13 | PTDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 14 | PTDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | PTDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 16 | PTLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 17 | PTAYPD | Amount - Vouchered YTD | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | PTAREC | Amount - Received | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | PTAFA1 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 20 | PTAFA2 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 21 | PTAFA3 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 22 | PTAFA4 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 23 | PTAFA5 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 24 | PTAFA6 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 25 | PTAFA7 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 26 | PTAFA8 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 27 | PTAFA9 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 28 | PTEF01 | Evaluation Factor1 | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | PTKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
