| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40941 | Item Key ID Master File | 12 | IK | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 2 | F40UI74 | Price Adjustment History Work File | 49 | AW | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 3 | F4106 | Item Base Price File | 8 | BP | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| TOP41F: Apparel Management |
| 4 | FCW11 | Item Base Price File Work File | 7 | WP | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 5 | F4074 | Price Adjustment Ledger File | 32 | AL | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| TOP45: Advanced Pricing |
| 6 | F4072 | Price Adjustment Detail | 6 | AD | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 7 | F4072P | Price Adjustment Detail Purge | 7 | AD | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 8 | F4072W | Price Adjustment Detail Work File | 6 | AD | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 9 | F4077 | Rebate Thresholds | 4 | RT | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 10 | F4077P | Rebate Thresholds Purge | 5 | RT | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 11 | F4078 | Rebate Transaction Summary | 3 | RH | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 12 | F4079 | Rebate Transaction Detail | 3 | SV | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 13 | F4094TEM | ICID Conversion X-Ref | 12 | TC | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 14 | F4511W | Pricing Structure View | 43 | AP | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 15 | F4551 | Basket Master Detail | 3 | BD | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 16 | F45715 | Adjustment Balances | 7 | AB | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 17 | F4574 | Key Reference Table | 14 | KR | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 18 | F4575 | Ship and Debit History | 17 | AH | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 19 | F4575TMP | Ship and Debit History - Temp Table | 17 | AH | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 20 | F4576 | Ship and Debit Claims | 12 | AC | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 21 | F4576TMP | Ship and Debit Claims- Temp Table | 12 | AC | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 22 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 25 | Z1 | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
| TOP89: Conversion Programs |
| 23 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 32 | AD | IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 |
