| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PMPCTY | Pricing Method | Character | UDC (42 CT) | 1 | 0 | Allow NULL? |
| 2 | PMPRTY | Contract Pricing Code | Character | UDC (42 PT) | 1 | 0 | Allow NULL? |
| 3 | PMMCAT | Pricing Rule | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 4 | PMDESC | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | PMCLV | Pricing Category Level | String | Generic Edit | 3 | 0 | Allow NULL? |
| 6 | PMCXPJ | Date - Expiration (Julian) | Date | Generic Edit | 6 | 0 | |
| 7 | PMCEFJ | Date - Effective (Julian) | Date | Generic Edit | 6 | 0 | |
| 8 | PMOVLP | Amount - Override List Price | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 9 | PMOVQT | Units - Over | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 10 | PMUMC | Quantity Type | Character | UDC (H42 UM) | 1 | 0 | Allow NULL? |
| 11 | PMCBAS | Basis - For Cost or Price | Character | UDC (H42 CB) | 1 | 0 | Allow NULL? |
| 12 | PMFVN | Factor Value - Numeric | Numeric | Generic Edit | 7 | 4 | Allow NULL? |
| 13 | PMFVA | Factor Value - Alpha | String | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | PMFVTY | Factor Value - Type | Character | UDC (H00 FV) | 1 | 0 | Allow NULL? |
| 15 | PMRPLO | Reprice Line or Order | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | PMLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 17 | PMITMR | Item Number - Short - Related | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 18 | PMRPRI | Related - Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | PMLIM | Limit - Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | PMQTYT | Units - Shipped to Date | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | PMLINV | Invoice - Last Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 22 | PMDLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 | |
| 23 | PMCTTL | Column Heading - Price Book | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | PMPNCD | Page Note Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | PMLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 26 | PMPCN | Contract - Pricing | String | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | PMTYDS | Type Discount | Character | UDC | 1 | 0 | Allow NULL? |
| 28 | PMCQTO | Contract Quantity Ordered | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | PMCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 30 | PMCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | PMCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 32 | PMUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 33 | PMTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
