| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PCITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | PCEV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | PCAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 4 | PCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | PCCERS | Status - Certification | String | UDC (43 CR) | 2 | 0 | Allow NULL? |
| 6 | PCCEFJ | Date - Effective (Julian) | Date | Generic Edit | 6 | 0 | |
| 7 | PCCXPJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 | |
| 8 | PCNROU | Route - Normal Route Code | String | UDC (43 RC) | 4 | 0 | Allow NULL? |
| 9 | PCTROU | Route - Alternate Route Code | String | UDC (43 RC) | 4 | 0 | Allow NULL? |
| 10 | PCACST | Amount - Average Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 11 | PCLTQP | Percentage - Leadtime Quantity | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 12 | PCTFRD | Days - Frequency | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 13 | PCTFRQ | Frequency - Number | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 14 | PCALTD | Leadtime - Average | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 15 | PCDAYE | Days - Allowed Early | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 16 | PCDAYL | Days - Allowed Late | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
