| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40P011 | Promotion Deal Detail File | 9 | PD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
2 | F40UI74 | Price Adjustment History Work File | 27 | AW | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
3 | F4106 | Item Base Price File | 20 | BP | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
TOP42: Sales Management |
4 | F4074 | Price Adjustment Ledger File | 21 | AL | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
5 | F42565 | Invoice Print File | 159 | IW | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
TOP45: Advanced Pricing |
6 | F4072 | Price Adjustment Detail | 17 | AD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
7 | F4072W | Price Adjustment Detail Work File | 17 | AD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
8 | F4511W | Pricing Structure View | 54 | AP | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
9 | F4574 | Key Reference Table | 62 | KR | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
10 | F4575 | Ship and Debit History | 34 | AH | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
11 | F4575TMP | Ship and Debit History - Temp Table | 34 | AH | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
12 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 114 | Z1 | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
TOP89: Conversion Programs |
13 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 19 | AD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |