| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40942 | Customer Key ID Master File | 12 | CK | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 2 | F40UI74 | Price Adjustment History Work File | 50 | AW | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 3 | F4106 | Item Base Price File | 9 | BP | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 4 | F4074 | Price Adjustment Ledger File | 33 | AL | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| TOP45: Advanced Pricing |
| 5 | F4072 | Price Adjustment Detail | 7 | AD | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 6 | F4072W | Price Adjustment Detail Work File | 7 | AD | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 7 | F4077 | Rebate Thresholds | 5 | RT | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 8 | F4078 | Rebate Transaction Summary | 4 | RH | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 9 | F4079 | Rebate Transaction Detail | 4 | SV | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 10 | F4094TEM | ICID Conversion X-Ref | 13 | TC | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 11 | F4511W | Pricing Structure View | 44 | AP | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 12 | F45715 | Adjustment Balances | 8 | AB | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 13 | F4574 | Key Reference Table | 15 | KR | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 14 | F4575 | Ship and Debit History | 18 | AH | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 15 | F4575TMP | Ship and Debit History - Temp Table | 18 | AH | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 16 | F4576 | Ship and Debit Claims | 13 | AC | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 17 | F4576TMP | Ship and Debit Claims- Temp Table | 13 | AC | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| 18 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 26 | Z1 | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
| TOP89: Conversion Programs |
| 19 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 33 | AD | CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 |
