| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40721 | Preference Values Detail | 1 | PV | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
2 | F40UI74 | Price Adjustment History Work File | 37 | AW | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
TOP42: Sales Management |
3 | F4074 | Price Adjustment Ledger File | 31 | AL | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
TOP45: Advanced Pricing |
4 | F4072 | Price Adjustment Detail | 19 | AD | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
5 | F4072W | Price Adjustment Detail Work File | 19 | AD | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
6 | F4073 | Free Goods Master File | 2 | FG | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
7 | F40UI84 | Orders Affected by Price Change (Work-file) | 7 | XR | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
8 | F4511W | Pricing Structure View | 56 | AP | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
9 | F4572 | Live Promotions X-Reference by Cost Type | 12 | XR | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
10 | F4574 | Key Reference Table | 21 | KR | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
11 | F4575 | Ship and Debit History | 68 | AH | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
12 | F4575TMP | Ship and Debit History - Temp Table | 68 | AH | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |
TOP89: Conversion Programs |
13 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 21 | AD | ATID | Price Adjustment Key ID | Numeric | Generic Edit | 8 | 0 |