| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40UI74 | Price Adjustment History Work File | 25 | AW | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 2 | F4106 | Item Base Price File | 21 | BP | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| TOP41F: Apparel Management |
| 3 | FCW11 | Item Base Price File Work File | 20 | WP | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| TOP42: Sales Management |
| 4 | F4074 | Price Adjustment Ledger File | 19 | AL | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| TOP45: Advanced Pricing |
| 5 | F4072 | Price Adjustment Detail | 16 | AD | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 6 | F4072P | Price Adjustment Detail Purge | 17 | AD | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 7 | F4072W | Price Adjustment Detail Work File | 16 | AD | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 8 | F4076 | Price Formula Master | 1 | FM | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 9 | F4511W | Pricing Structure View | 53 | AP | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 10 | F45715 | Adjustment Balances | 21 | AB | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 11 | F4574 | Key Reference Table | 23 | KR | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 12 | F4575 | Ship and Debit History | 35 | AH | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 13 | F4575TMP | Ship and Debit History - Temp Table | 35 | AH | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| 14 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 121 | Z1 | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| TOP49: Transportation Management |
| 15 | F4972 | Rate Detail | 17 | RX | FRMN | Price Formula Name | String | UDC | 10 | 0 |
| TOP89: Conversion Programs |
| 16 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 18 | AD | FRMN | Price Formula Name | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
