| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40943 | Order Group Key ID Master File | 10 | OK | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
2 | F40UI74 | Price Adjustment History Work File | 51 | AW | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
TOP42: Sales Management |
3 | F4074 | Price Adjustment Ledger File | 34 | AL | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
TOP45: Advanced Pricing |
4 | F4072 | Price Adjustment Detail | 8 | AD | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
5 | F4072P | Price Adjustment Detail Purge | 9 | AD | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
6 | F4072W | Price Adjustment Detail Work File | 8 | AD | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
7 | F4078 | Rebate Transaction Summary | 5 | RH | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
8 | F4079 | Rebate Transaction Detail | 5 | SV | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
9 | F4511W | Pricing Structure View | 45 | AP | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
10 | F4574 | Key Reference Table | 63 | KR | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
11 | F4575 | Ship and Debit History | 20 | AH | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
12 | F4575TMP | Ship and Debit History - Temp Table | 20 | AH | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |
TOP89: Conversion Programs |
13 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 34 | AD | OGID | Order Group Key ID | Numeric | Generic Edit | 8 | 0 |