| 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 |
TOP41F: Apparel Management |
4 | FCW11 | Item Base Price File Work File | 19 | WP | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
TOP42: Sales Management |
5 | F4074 | Price Adjustment Ledger File | 21 | AL | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
6 | F42565 | Invoice Print File | 159 | IW | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
TOP45: Advanced Pricing |
7 | F4072 | Price Adjustment Detail | 17 | AD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
8 | F4072P | Price Adjustment Detail Purge | 18 | AD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
9 | F4072W | Price Adjustment Detail Work File | 17 | AD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
10 | F4511W | Pricing Structure View | 54 | AP | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
11 | F4574 | Key Reference Table | 62 | KR | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
12 | F4575 | Ship and Debit History | 34 | AH | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
13 | F4575TMP | Ship and Debit History - Temp Table | 34 | AH | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
14 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 114 | Z1 | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
TOP75I: India |
15 | F75I017 | Sales Order Tag File IND 42 | 17 | SO | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
16 | F75I2213 | Setoff Temp Table | 6 | TT | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
17 | F75I324 | Work File for ARE1 ARE3 IND 42 | 14 | Q3 | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
18 | F75I354 | Excise ARE3 Tag file for Form Header IND 42 | 19 | QW | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
19 | F75I385 | RG23D Register - Issues - IND - 42 | 24 | ED | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
20 | F75I4213 | Setoff Report Data -IND -00 | 27 | SO | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
21 | F75I4223 | Sales Tax Summary/Detail | 26 | SD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |
TOP89: Conversion Programs |
22 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 19 | AD | FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 |