| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F4096 | Sales Flex Accounting | 2 | FA | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP40: Inventory/OP Base |
2 | F40721 | Preference Values Detail | 2 | PV | AST | Price Adjustment Name | String | UDC | 8 | 0 |
3 | F40UI74 | Price Adjustment History Work File | 18 | AW | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP42: Sales Management |
4 | F4074 | Price Adjustment Ledger File | 12 | AL | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP45: Advanced Pricing |
5 | F4070 | Price Adjustment Schedule | 4 | SN | AST | Price Adjustment Name | String | UDC | 8 | 0 |
6 | F4071 | Price Adjustment Type | 1 | AT | AST | Price Adjustment Name | String | UDC | 8 | 0 |
7 | F4072 | Price Adjustment Detail | 1 | AD | AST | Price Adjustment Name | String | UDC | 8 | 0 |
8 | F4072W | Price Adjustment Detail Work File | 1 | AD | AST | Price Adjustment Name | String | UDC | 8 | 0 |
9 | F4073 | Free Goods Master File | 1 | FG | AST | Price Adjustment Name | String | UDC | 8 | 0 |
10 | F4077 | Rebate Thresholds | 1 | RT | AST | Price Adjustment Name | String | UDC | 8 | 0 |
11 | F4078 | Rebate Transaction Summary | 6 | RH | AST | Price Adjustment Name | String | UDC | 8 | 0 |
12 | F4079 | Rebate Transaction Detail | 6 | SV | AST | Price Adjustment Name | String | UDC | 8 | 0 |
13 | F4510 | Price Workbench Query Header | 7 | PW | AST | Price Adjustment Name | String | UDC | 8 | 0 |
14 | F4511W | Pricing Structure View | 6 | AP | AST | Price Adjustment Name | String | UDC | 8 | 0 |
15 | F45715 | Adjustment Balances | 1 | AB | AST | Price Adjustment Name | String | UDC | 8 | 0 |
16 | F4572 | Live Promotions X-Reference by Cost Type | 13 | XR | AST | Price Adjustment Name | String | UDC | 8 | 0 |
17 | F4573 | Free Goods Reference File | 11 | RF | AST | Price Adjustment Name | String | UDC | 8 | 0 |
18 | F4574 | Key Reference Table | 20 | KR | AST | Price Adjustment Name | String | UDC | 8 | 0 |
19 | F4575 | Ship and Debit History | 9 | AH | AST | Price Adjustment Name | String | UDC | 8 | 0 |
20 | F4575TMP | Ship and Debit History - Temp Table | 9 | AH | AST | Price Adjustment Name | String | UDC | 8 | 0 |
21 | F4576 | Ship and Debit Claims | 8 | AC | AST | Price Adjustment Name | String | UDC | 8 | 0 |
22 | F4576TMP | Ship and Debit Claims- Temp Table | 8 | AC | AST | Price Adjustment Name | String | UDC | 8 | 0 |
23 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 21 | Z1 | AST | Price Adjustment Name | String | UDC | 8 | 0 |
24 | F4580 | Price Matrix Definition | 2 | MX | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP47: Electronic Commerce |
25 | F470473 | EDI Invoice Detail Charges | 13 | S7 | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP74: EMEA Localization |
26 | F7420034 | Price Adjustment (Print Info) - COMM - 42 | 7 | PI | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP76H: Chile |
27 | F76H3B35 | Price Adjustment (Print Info) - CHI - 03B - 76H | 7 | PI | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP89: Conversion Programs |
28 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 1 | AD | AST | Price Adjustment Name | String | UDC | 8 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.