| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP34A: Advanced Planning & Scheduling |
| 1 | F34A40 | APS Integration Group Setup Table | 8 | N0 | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| TOP41: Inventory Management |
| 2 | F4101 | Item Master | 13 | IM | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| 3 | F4101C | Item Category Codes | 15 | IM | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| 4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 28 | SZ | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| 5 | F4102 | Item Branch File | 10 | IB | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| 6 | F41UI001 | Inventory Transactions Detail File | 54 | IT | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| TOP41F: Apparel Management |
| 7 | FCW08 | Category Codes Work File | 8 | WK | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| 8 | FCW10 | Item Branch Work File | 33 | WB | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| 9 | FCW96 | Material Analysis | 20 | WO | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| 10 | FCW97 | Grouping Messages | 20 | GM | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| TOP47: Electronic Commerce |
| 11 | F47082 | EDI Price Sales Catalog Detail - Inbound | 27 | FY | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
| TOPF30L: DFM Line Design |
| 12 | FF30L501 | DFM Item Definition Master | 13 | IB | SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC | 6 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
