| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP30: Product Data Management |
| 1 | F300210 | Lean Multi Level Bill of Material Header | 7 | EH | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 2 | F300211 | Lean Multi Level Bill of Material Detail | 19 | ED | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 3 | F30UI008 | Bill of Material Comparison Work File | 8 | IJ | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP31: Shop Floor Control |
| 4 | F3118 | Shortage Maintenance Master File | 15 | WN | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP34: Requirements Planning |
| 5 | F34UI004 | MPS Net Change User Index | 12 | M8 | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP40: Inventory/OP Base |
| 6 | F4211AU | Sales Order Detail Audit File | 7 | AU | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 7 | F4101 | Item Master | 72 | IM | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 8 | F4101A | Item File | 43 | IM | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 9 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 87 | SZ | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 10 | F4102 | Item Branch File | 67 | IB | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 11 | F41UI001 | Inventory Transactions Detail File | 79 | IT | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 12 | F42UI11 | SO Detail Cache File (MBF) | 121 | ZD | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 13 | F42UI130 | Commitment Work File | 40 | ZC | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 14 | F4311Z | Purchase Order Generator File | 193 | PW | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 15 | F43121Z | Receiver workfile | 29 | PW | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 16 | F4314Z | Voucher Match Selection File | 15 | PN | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 17 | F4371 | Suggested Reorder Stock Items | 21 | PD | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP43Q: Strategic Sourcing |
| 18 | F43Q92 | Adhoc Item Definition | 3 | AI | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP46L: License Plating |
| 19 | F46LUI01 | Assign/Remove Items To LP Work File | 32 | WF | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOP48: Work Order Processing |
| 20 | F48UI001 | X4801 Master Business Function Workfile | 136 | WA | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOPF30L: DFM Line Design |
| 21 | FF30L501 | DFM Item Definition Master | 46 | IB | STKT | Stocking Type | Character | UDC | 1 | 0 |
| TOPH91: Design Tools |
| 22 | F98TC002 | Table Conversion Normalized 1 | 6 | TN | STKT | Stocking Type | Character | UDC | 1 | 0 |
| 23 | F98TC01 | Table Conversion UnNormalized | 10 | TC | STKT | Stocking Type | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
