| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP13: Plant/Equipment Management |
| 1 | F13017 | Equipment Parts List | 18 | PL | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP16: Profit Management (EPS) |
| 2 | F1610 | Cost Calculation Definitions | 64 | CD | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP17C: Call Management |
| 3 | F1755 | Case Master | 168 | ZA | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP30: Product Data Management |
| 4 | F3002Z1 | Bill of Material Transaction File | 32 | SZ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 5 | F3003Z1 | Routing Transactions File | 25 | SZ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 6 | F30UI008 | Bill of Material Comparison Work File | 16 | IJ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 7 | F30UI014 | BOM Header Work File for BI | 9 | BH | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 8 | F30UI015 | BOM Item Fact Work File for BI | 13 | BD | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 9 | F30UI016 | BOM Explosion Work File for BI | 20 | BE | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP31: Shop Floor Control |
| 10 | F3109 | Line/Item Relationship Master | 11 | IP | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP32: Configuration Management |
| 11 | F3281 | Rules Table Definition | 8 | RT | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 12 | F3282 | Configured Item/Rules Table Cross Reference | 6 | RK | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 13 | F32821 | Rules Table Value Definition | 7 | RL | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 14 | F3283 | Rules Table Detail | 27 | RD | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 15 | F3291 | Configured Item Segments | 7 | KW | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 16 | F3292 | Cross Segment Editing Rules | 8 | KU | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 17 | F32921 | Cross Segment Editing Rules - Values | 8 | KX | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 18 | F32922 | Cross Segment Editing Rules - Range | 9 | KV | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 19 | F3293 | Assembly Inclusions Rules | 35 | KY | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP33: Capacity Planning |
| 20 | F3303 | Capacity Resource Profile | 12 | CT | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP34: Requirements Planning |
| 21 | F3403 | Branch Relationships Master File | 10 | MP | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 22 | F3404 | Co-Products Planning/Costing Table | 6 | PM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 23 | F43211 | Supplier Schedule Master File | 8 | SS | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP34X: In-Memory Planning Advisor |
| 24 | F34X310W | Planning Advisor BOM Component Detail Table | 32 | PD | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP36: Forecasting |
| 25 | F34007 | Forecast Prices | 6 | FH | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP37: Quality Management |
| 26 | F3701 | Test Definitions Master File | 4 | QA | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 27 | F3702 | Specifications Definitions Master File | 6 | QS | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 28 | F37021 | Specifications Detail File | 5 | QD | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 29 | F3711 | Test Results | 42 | TR | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 30 | F3711Z1 | Test Results Unedited Transaction Table | 55 | SZ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 31 | F37900 | Certificate of Analysis (COA) Extract | 42 | TR | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 32 | F40318 | Preference Profile - Quality Management | 15 | QC | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP40: Inventory/OP Base |
| 33 | F3002 | Bill of Material Master File | 19 | IX | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 34 | F3003 | Routing Master File | 12 | IR | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 35 | F3011 | Bill of Materials Change File | 19 | IZ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 36 | F3013 | ECO Parts List Detail | 24 | CY | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 37 | F3015 | Component Locator File | 5 | CQ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 38 | F40318R | Preference Resolution Ledger - Quality Management | 17 | QC | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP41: Inventory Management |
| 39 | F4101A | Item File | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 40 | F4101B | Item Master Bulk Data | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 41 | F4101C | Item Category Codes | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 42 | F4101F | Item Customer Service Data | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 43 | F4101G | Item Branch Quantities | 4 | IB | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 44 | F4101M | Item Manufacturing Data | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 45 | F4101P | Item Master Packaging | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 46 | F4101S | Item Master Shipping Data | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 47 | F4101W | Item Profile Data | 4 | IM | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 48 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 193 | SZ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 49 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 113 | SZ | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP43: Procurement |
| 50 | F41291 | Item Cost Components | 18 | IG | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP74U: United Kingdom Localizations |
| 51 | F74U420A | SPC Application Amount Drill Down - UK - 43 | 17 | PA | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 52 | F74U421B | Application Approval Delegates - UK - 43 | 4 | AD | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 53 | F74U4321 | Requisition Template Answers - UK - 43 | 9 | RA | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP75I: India |
| 54 | F75I791 | Item/Supplier Cost Components - IND - 43B | 19 | IS | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP75T: Taiwan |
| 55 | F75T002 | GUI/VAT Number Register - 75T | 8 | NR | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 56 | F75T0029 | GUI/VAT Number Register History - 75T | 8 | NR | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 57 | F75T003 | GUI/VAT Number Segment - 75T | 11 | NS | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 58 | F75T0039 | GUI/VAT Number Segment History - 75T | 11 | NS | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP76B: Brazil |
| 59 | F76B3010 | Work Table for Item/Part List - 30 | 13 | IP | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOP76V: Venezuela |
| 60 | F76V4010 | Tributary Unit Setup - 04 - VE | 3 | IS | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 61 | F76V410 | Tributary Unit Setup - VEN - 04 | 3 | TU | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| TOPF30L: DFM Line Design |
| 62 | FF30L002 | DFM Bill of Material Master | 15 | DH | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
| 63 | FF30L930 | DFM Routings | 11 | LR | EFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 |
