| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | RIAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | RICS47 | Customer Group - Pricing U/M (ECS) | String | UDC (40 47) | 8 | 0 | Allow NULL? |
| 3 | RIITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | RIIT47 | Item Group - Pricing U/M (ECS) | String | UDC (40 97) | 8 | 0 | Allow NULL? |
| 5 | RIEFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 6 | RIEXDJ | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 7 | RIMNQ | Quantity - From | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 8 | RIMXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 9 | RIUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 10 | RITXID | Text ID Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | RISTPR | Status - Preference | Character | UDC (40 PT) | 1 | 0 | Allow NULL? |
| 12 | RIOSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 13 | RIMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 14 | RIUOM4 | Unit of Measure - Pricing | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 15 | RIPRAS | Price at Ambient/Standard/Weight (A S W) | Character | UDC (38 PR) | 1 | 0 | Allow NULL? |
| 16 | RICP01 | Sales Price Based On Date | Character | UDC (40 DB) | 1 | 0 | Allow NULL? |
| 17 | RIURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 18 | RIURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 19 | RIURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | RIURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 21 | RIURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 22 | RIUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | RIPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | RIJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | RIUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 26 | RITDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
