| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40P011 | Promotion Deal Detail File | 8 | PD | BSCD | Basis Code | Character | UDC | 1 | 0 |
| 2 | F40UI74 | Price Adjustment History Work File | 26 | AW | BSCD | Basis Code | Character | UDC | 1 | 0 |
| 3 | F4106 | Item Base Price File | 18 | BP | BSCD | Basis Code | Character | UDC | 1 | 0 |
| TOP41F: Apparel Management |
| 4 | FCW11 | Item Base Price File Work File | 17 | WP | BSCD | Basis Code | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 5 | F4074 | Price Adjustment Ledger File | 20 | AL | BSCD | Basis Code | Character | UDC | 1 | 0 |
| TOP42X: In-Memory Sales Advisor |
| 6 | F42X041W | Order Upsell Item Group Opportunities WF | 12 | BR | BSCD | Basis Code | Character | UDC | 1 | 0 |
| TOP45: Advanced Pricing |
| 7 | F4072 | Price Adjustment Detail | 14 | AD | BSCD | Basis Code | Character | UDC | 1 | 0 |
| 8 | F4072P | Price Adjustment Detail Purge | 15 | AD | BSCD | Basis Code | Character | UDC | 1 | 0 |
| 9 | F4072W | Price Adjustment Detail Work File | 14 | AD | BSCD | Basis Code | Character | UDC | 1 | 0 |
| 10 | F4511W | Pricing Structure View | 51 | AP | BSCD | Basis Code | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 11 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 16 | AD | BSCD | Basis Code | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
