| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PTKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | PTDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | PTDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | PTLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 5 | PTNLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | PTDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | PTDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 8 | PTTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 9 | PTDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 10 | PTMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 11 | PTLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 12 | PTPRRC | Amount - Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 13 | PTQTYS | Units - Stocked | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | PTAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | PTLAND | Code - Landed Cost | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | PTPRP5 | Purchasing Category Code 5 | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 17 | PTLVLA | Level Cost | String | UDC (40 CA) | 3 | 0 | Allow NULL? |
| 18 | PTDESC | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | PTPCST | Percent - Cost Add-On | Numeric | Generic Edit | 15 | 7 | Allow NULL? |
| 20 | PTAREC | Amount - Received | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | PTALIN | Line - Associated | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 22 | PTPARCNGRP | Parent Child Relationship | Numeric | Generic Edit | 11 | 0 | Allow NULL? |
| 23 | PTYFRMTY | Form Type | String | UDC (75I FS) | 10 | 0 | Allow NULL? |
| 24 | PTFDNM | Name - Field | String | Generic Edit | 30 | 0 | Allow NULL? |
| 25 | PTADSO | Origin State | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 26 | PTDATESUB | Date Submitted | Date | Generic Edit | 6 | 0 | |
| 27 | PTASHD | Amount - Shift Differential | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 28 | PTREM1 | Remark 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 29 | PTPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | PTKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 31 | PTCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 32 | PTASID | Serial Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 33 | PTAFA1 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 34 | PTAFA2 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 35 | PTAFA3 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 36 | PTAFA4 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 37 | PTAFA5 | Amount After Conversion | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 38 | PTSRDS | Description - Work Order | String | Generic Edit | 60 | 0 | Allow NULL? |
| 39 | PTSRDS1 | Description - Work Order 1 | String | Generic Edit | 60 | 0 | Allow NULL? |
| 40 | PTSRDS2 | Description - Work Order 2 | String | Generic Edit | 60 | 0 | Allow NULL? |
| 41 | PTSRDS3 | Description - Work Order 3 | String | Generic Edit | 60 | 0 | Allow NULL? |
| 42 | PTSRDS4 | Description - Work Order 4 | String | Generic Edit | 60 | 0 | Allow NULL? |
| 43 | PTOPT | Option | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 44 | PTOPTF | Valid Option | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | PTOPTI | Option Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | PTOPTOW | Mode - Options | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | PTOPTD | Default Option | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 48 | PTDT1 | Date - Last Statement Date | Date | Generic Edit | 6 | 0 | |
| 49 | PTADTJ | Date - Applied | Date | Generic Edit | 6 | 0 | |
| 50 | PTAPVDTE | Approved Date | Date | Generic Edit | 6 | 0 | |
| 51 | PTAPDT | Application Date | Date | Generic Edit | 6 | 0 | |
| 52 | PTDT | Date - Terminated | Date | Generic Edit | 6 | 0 | |
| 53 | PTUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 54 | PTJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 55 | PTPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 56 | PTTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 57 | PTUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 58 | PTEF01 | Evaluation Factor1 | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
