| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PUAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | PUCS02 | Customer Group - Unit of Measure | String | UDC (40 02) | 8 | 0 | Allow NULL? |
| 3 | PUITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | PUIT02 | Item Group - Unit of Measure | String | UDC (40 52) | 8 | 0 | Allow NULL? |
| 5 | PUEFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 6 | PUEXDJ | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 7 | PUMNQ | Quantity - From | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | PUMXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | PUUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 10 | PUTXID | Text ID Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | PUSTPR | Status - Preference | Character | UDC (40 PT) | 1 | 0 | Allow NULL? |
| 12 | PUUOM4 | Unit of Measure - Pricing | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 13 | PUURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 14 | PUURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 15 | PUURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | PUURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | PUURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 18 | PUUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | PUPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | PUJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | PUUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 22 | PUTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 23 | PUPRAS | Price at Ambient/Standard/Weight (A S W) | Character | UDC (38 PR) | 1 | 0 | Allow NULL? |
| 24 | PUOSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 25 | PUMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 26 | PUCP01 | Sales Price Based On Date | Character | UDC (40 DB) | 1 | 0 | Allow NULL? |
