45: Advanced Pricing |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 812 | F4070 | SN | 22 | 8 | Price Adjustment Schedule | Master Files | 45: Advanced Pricing | AS400 Coexistence Tables |
2 | 812 | F4070P | SN | | | Price Adjustment Schedule Purge | Master Files | 45: Advanced Pricing | Business Data |
3 | 812 | F4071 | AT | 62 | 2 | Price Adjustment Type | Master Files | 45: Advanced Pricing | AS400 Coexistence Tables |
4 | 812 | F4071P | AT | | | Price Adjustment Type Purge | Master Files | 45: Advanced Pricing | Business Data |
5 | 812 | F4072 | AD | 37 | 7 | Price Adjustment Detail | Master Files | 45: Advanced Pricing | AS400 Coexistence Tables |
6 | 812 | F4072P | AD | | | Price Adjustment Detail Purge | Master Files | 45: Advanced Pricing | Business Data |
7 | 812 | F4072W | AD | 40 | 2 | Price Adjustment Detail Work File | Master Files | 45: Advanced Pricing | Business Data |
8 | 812 | F4073 | FG | 23 | 3 | Free Goods Master File | Master Files | 45: Advanced Pricing | AS400 Coexistence Tables |
9 | 812 | F4073P | FG | | | Free Goods Master File Purge | Master Files | 45: Advanced Pricing | Business Data |
10 | 812 | F4075 | VB | 12 | 3 | Price Variable Table | Master Files | 45: Advanced Pricing | AS400 Coexistence Tables |
11 | 812 | F4076 | FM | 8 | 3 | Price Formula Master | Master Files | 45: Advanced Pricing | AS400 Coexistence Tables |
12 | 812 | F4077 | RT | 31 | 5 | Rebate Thresholds | Master Files | 45: Advanced Pricing | AS400 Coexistence Tables |
13 | 812 | F4077P | RT | | | Rebate Thresholds Purge | Master Files | 45: Advanced Pricing | Business Data |
14 | 812 | F4078 | RH | 33 | 2 | Rebate Transaction Summary | Transaction Files | 45: Advanced Pricing | AS400 Coexistence Tables |
15 | 812 | F4079 | SV | 36 | 5 | Rebate Transaction Detail | Transaction Files | 45: Advanced Pricing | AS400 Coexistence Tables |
16 | 812 | F4094TEM | TC | 13 | 3 | ICID Conversion X-Ref | Files | 45: Advanced Pricing | Business Data |
17 | 812 | F40UI84 | XR | 7 | 1 | Orders Affected by Price Change (Work-file) | Work Files | 45: Advanced Pricing | No |
18 | 812 | F4501 | MS | 14 | 2 | Master Schedule Adjustment | Master Files | 45: Advanced Pricing | No |
19 | 812 | F4502 | FG | 13 | 1 | Free Goods Catalog | Files | 45: Advanced Pricing | Business Data |
20 | 812 | F4510 | PW | 16 | 6 | Price Workbench Query Header | Files | 45: Advanced Pricing | |
21 | 812 | F4511W | AP | 99 | 6 | Pricing Structure View | Files | 45: Advanced Pricing | Business Data |
22 | 812 | F4550 | BH | 13 | 1 | Basket Master Header | Files | 45: Advanced Pricing | Business Data |
23 | 812 | F4551 | BD | 18 | 2 | Basket Master Detail | Files | 45: Advanced Pricing | Business Data |
24 | 812 | F45510 | SH | 12 | 1 | Search Agent Directives Header | Files | 45: Advanced Pricing | Business Data |
25 | 812 | F45511 | SD | 12 | 1 | Search Agent Directives Detail | Files | 45: Advanced Pricing | Business Data |
26 | 812 | F45511W | SW | 11 | 1 | Search Agent Directives Work File | Files | 45: Advanced Pricing | Business Data |
27 | 812 | F45520 | PH | 29 | 1 | Price List Header | Files | 45: Advanced Pricing | Business Data |
28 | 812 | F45521 | PD | 29 | 2 | Price List Detail | Files | 45: Advanced Pricing | Business Data |
29 | 812 | F45522 | PL | 10 | 2 | Price List Level-Break Pattern | Files | 45: Advanced Pricing | Business Data |
30 | 812 | F45523 | PC | 9 | 3 | Price List Columns Group Pattern | Files | 45: Advanced Pricing | Business Data |
31 | 812 | F45524 | PI | 10 | 2 | Price List Item Selection | Files | 45: Advanced Pricing | Business Data |
32 | 812 | F45715 | AB | 45 | 2 | Adjustment Balances | Balance Files | 45: Advanced Pricing | No |
33 | 812 | F4572 | XR | 30 | 4 | Live Promotions X-Reference by Cost Type | Files | 45: Advanced Pricing | No |
34 | 812 | F4572Z1 | LP | 50 | 1 | Live Promotions Interface - Inbound / Outbound | Files | 45: Advanced Pricing | No |
35 | 812 | F4572ZP | PG | 50 | 1 | Purge Live Promotions Interface | Files | 45: Advanced Pricing | No |
36 | 812 | F4573 | RF | 11 | 1 | Free Goods Reference File | Transaction Files | 45: Advanced Pricing | AS400 Coexistence Tables |
37 | 812 | F4574 | KR | 97 | 8 | Key Reference Table | Transaction Files | 45: Advanced Pricing | No |
38 | 812 | F4575 | AH | 83 | 1 | Ship and Debit History | Transaction Files | 45: Advanced Pricing | No |
39 | 812 | F4575TMP | AH | 85 | 1 | Ship and Debit History - Temp Table | Transaction Files | 42: Sales Management | Business Data |
40 | 812 | F4576 | AC | 88 | 1 | Ship and Debit Claims | Master Files | 45: Advanced Pricing | No |
41 | 812 | F4576TMP | AC | 88 | 1 | Ship and Debit Claims- Temp Table | Master Files | 42: Sales Management | Business Data |
42 | 812 | F4576Z1 | Z1 | 158 | 1 | Ship and Debit Claims Unedited Transaction Table | Transaction Files | 45: Advanced Pricing | No |
43 | 812 | F4580 | MX | 11 | 2 | Price Matrix Definition | Files | 45: Advanced Pricing | |