| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP30A: Product Costing |
1 | F30UI011 | Work File for Cost Component | 2 | CC | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
2 | F30UI012 | Work File for Parent Child | 2 | PC | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP31: Shop Floor Control |
3 | F3102WF | Production Cost Work File | 62 | IG | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
4 | F31UI803 | Work File for Summarizing Journal Entries | 27 | SG | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP31A: Manufacturing Accounting |
5 | F30UI003 | WIP Revaluation Work File | 30 | WR | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP40: Inventory/OP Base |
6 | F40UI74 | Price Adjustment History Work File | 3 | AW | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP40G: Grower Management |
7 | F40G30S | Assessments / Donations Workfile | 2 | AD | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP42: Sales Management |
8 | F42UI01 | SO Header Cache File (MBF) | 3 | ZH | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
9 | F42UI130 | Commitment Work File | 2 | ZC | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP42B: Sales Order Entry |
10 | F42216WF | Pending Blanket Release Work File - F42216WF | 5 | PB | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP43: Procurement |
11 | F4301Z | PO Header Work File | 100 | PA | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
12 | F43092Z | Receipt Routing Work File | 50 | PV | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
13 | F4311Z | Purchase Order Generator File | 225 | PW | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
14 | F43121Z | Receiver workfile | 136 | PW | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
15 | F4314Z | Voucher Match Selection File | 201 | PN | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
16 | F43632Z | Open Purchase Order by Item Work File | 3 | OI | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
17 | F4371 | Suggested Reorder Stock Items | 29 | PD | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP45: Advanced Pricing |
18 | F4072W | Price Adjustment Detail Work File | 39 | AD | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
19 | F4511W | Pricing Structure View | 3 | AP | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
20 | F45511W | Search Agent Directives Work File | 3 | SW | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |
TOP49: Transportation Management |
21 | F49T05 | OTM Record Reservation | 4 | OR | PEID | Process ID | Numeric | Generic Edit | 15 | 0 |