| 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 | 4 | AW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP40G: Grower Management |
2 | F40G30S | Assessments / Donations Workfile | 4 | AD | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP42: Sales Management |
3 | F42UI01 | SO Header Cache File (MBF) | 4 | ZH | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
4 | F42UI130 | Commitment Work File | 1 | ZC | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP42B: Sales Order Entry |
5 | F42216WF | Pending Blanket Release Work File - F42216WF | 6 | PB | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP43: Procurement |
6 | F4301Z | PO Header Work File | 101 | PA | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
7 | F43092Z | Receipt Routing Work File | 51 | PV | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
8 | F4311Z | Purchase Order Generator File | 226 | PW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
9 | F43121Z | Receiver workfile | 137 | PW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
10 | F4314Z | Voucher Match Selection File | 202 | PN | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
11 | F43632Z | Open Purchase Order by Item Work File | 2 | OI | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
12 | F4371 | Suggested Reorder Stock Items | 30 | PD | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP44H: Homebuilder Management |
13 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 83 | CG | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP45: Advanced Pricing |
14 | F4072W | Price Adjustment Detail Work File | 40 | AD | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
15 | F4511W | Pricing Structure View | 4 | AP | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
16 | F45511W | Search Agent Directives Work File | 4 | SW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP49: Transportation Management |
17 | F49T05 | OTM Record Reservation | 5 | OR | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
TOP75I: India |
18 | F75I013 | Credit Distribution | 1 | PD | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |