| 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 |
5 | F42565 | Invoice Print File | 189 | IW | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP45: Advanced Pricing |
6 | F4070 | Price Adjustment Schedule | 4 | SN | AST | Price Adjustment Name | String | UDC | 8 | 0 |
7 | F4070P | Price Adjustment Schedule Purge | 5 | SN | AST | Price Adjustment Name | String | UDC | 8 | 0 |
8 | F4071 | Price Adjustment Type | 1 | AT | AST | Price Adjustment Name | String | UDC | 8 | 0 |
9 | F4071P | Price Adjustment Type Purge | 2 | AT | AST | Price Adjustment Name | String | UDC | 8 | 0 |
10 | F4072 | Price Adjustment Detail | 1 | AD | AST | Price Adjustment Name | String | UDC | 8 | 0 |
11 | F4072P | Price Adjustment Detail Purge | 2 | AD | AST | Price Adjustment Name | String | UDC | 8 | 0 |
12 | F4072W | Price Adjustment Detail Work File | 1 | AD | AST | Price Adjustment Name | String | UDC | 8 | 0 |
13 | F4073 | Free Goods Master File | 1 | FG | AST | Price Adjustment Name | String | UDC | 8 | 0 |
14 | F4073P | Free Goods Master File Purge | 2 | FG | AST | Price Adjustment Name | String | UDC | 8 | 0 |
15 | F4077 | Rebate Thresholds | 1 | RT | AST | Price Adjustment Name | String | UDC | 8 | 0 |
16 | F4077P | Rebate Thresholds Purge | 2 | RT | AST | Price Adjustment Name | String | UDC | 8 | 0 |
17 | F4078 | Rebate Transaction Summary | 6 | RH | AST | Price Adjustment Name | String | UDC | 8 | 0 |
18 | F4079 | Rebate Transaction Detail | 6 | SV | AST | Price Adjustment Name | String | UDC | 8 | 0 |
19 | F4510 | Price Workbench Query Header | 7 | PW | AST | Price Adjustment Name | String | UDC | 8 | 0 |
20 | F4511W | Pricing Structure View | 6 | AP | AST | Price Adjustment Name | String | UDC | 8 | 0 |
21 | F45715 | Adjustment Balances | 1 | AB | AST | Price Adjustment Name | String | UDC | 8 | 0 |
22 | F4572 | Live Promotions X-Reference by Cost Type | 13 | XR | AST | Price Adjustment Name | String | UDC | 8 | 0 |
23 | F4573 | Free Goods Reference File | 11 | RF | AST | Price Adjustment Name | String | UDC | 8 | 0 |
24 | F4574 | Key Reference Table | 20 | KR | AST | Price Adjustment Name | String | UDC | 8 | 0 |
25 | F4575 | Ship and Debit History | 9 | AH | AST | Price Adjustment Name | String | UDC | 8 | 0 |
26 | F4575TMP | Ship and Debit History - Temp Table | 9 | AH | AST | Price Adjustment Name | String | UDC | 8 | 0 |
27 | F4576 | Ship and Debit Claims | 8 | AC | AST | Price Adjustment Name | String | UDC | 8 | 0 |
28 | F4576TMP | Ship and Debit Claims- Temp Table | 8 | AC | AST | Price Adjustment Name | String | UDC | 8 | 0 |
29 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 21 | Z1 | AST | Price Adjustment Name | String | UDC | 8 | 0 |
30 | F4580 | Price Matrix Definition | 2 | MX | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP47: Electronic Commerce |
31 | F470473 | EDI Invoice Detail Charges | 13 | S7 | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP70: Multi-National Products - obsolete-do not reuse |
32 | F702018 | Taxes by Sales Order Line - COMM - 42 | 19 | TA | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP74: EMEA Localization |
33 | F7420034 | Price Adjustment (Print Info) - COMM - 42 | 7 | PI | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP75I: India |
34 | F75I006 | O2C Tax Set up-IND-00 | 1 | TS | AST | Price Adjustment Name | String | UDC | 8 | 0 |
35 | F75I017 | Sales Order Tag File IND 42 | 5 | SO | AST | Price Adjustment Name | String | UDC | 8 | 0 |
36 | F75I309 | Personal Consumption - CENVAT setoff - IND - 41 | 33 | CS | AST | Price Adjustment Name | String | UDC | 8 | 0 |
37 | F75I324 | Work File for ARE1 ARE3 IND 42 | 5 | Q3 | AST | Price Adjustment Name | String | UDC | 8 | 0 |
38 | F75I354 | Excise ARE3 Tag file for Form Header IND 42 | 5 | QW | AST | Price Adjustment Name | String | UDC | 8 | 0 |
39 | F75I385 | RG23D Register - Issues - IND - 42 | 21 | ED | AST | Price Adjustment Name | String | UDC | 8 | 0 |
40 | F75I4223 | Sales Tax Summary/Detail | 25 | SD | AST | Price Adjustment Name | String | UDC | 8 | 0 |
41 | F75I731 | Service Tax A/R File - IND - 03B | 5 | ST | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP76H: Chile |
42 | F76H3B35 | Price Adjustment (Print Info) - CHI - 03B - 76H | 7 | PI | AST | Price Adjustment Name | String | UDC | 8 | 0 |
TOP89: Conversion Programs |
43 | F4072TEM | Price Adjustment Detail - Temp for Upgrade | 1 | AD | AST | Price Adjustment Name | String | UDC | 8 | 0 |