| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP30: Product Data Management |
1 | F300211 | Lean Multi Level Bill of Material Detail | 13 | ED | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP30A: Product Costing |
2 | F30UI011 | Work File for Cost Component | 9 | CC | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
3 | F30UI012 | Work File for Parent Child | 13 | PC | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP31B: Blend Management |
4 | F31B051 | Equipment Consumables | 7 | EC | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
5 | F31B053 | Consumable Assignments | 8 | CA | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
6 | F31B46 | Consumable Templates | 16 | CT | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP37: Quality Management |
7 | F37012 | Test Consumables | 6 | TC | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP40: Inventory/OP Base |
8 | F4011Z | Batch Receiver File - Order Details | 154 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
9 | F4211AU | Sales Order Detail Audit File | 19 | AU | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
10 | F4211DT | Sales Order Detail Date Tracking File | 16 | DT | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
11 | F4211Z1 | Sales Order Detail Unedited Transaction File | 141 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP41: Inventory Management |
12 | F4101 | Item Master | 43 | IM | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
13 | F4101A | Item File | 24 | IM | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
14 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 58 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
15 | F41UI001 | Inventory Transactions Detail File | 163 | IT | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
16 | F41UI002 | Inventory Transactions Batch File | 18 | TI | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP41F: Apparel Management |
17 | FCW09 | Item Revisions Work File | 35 | WR | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
18 | FCW34 | Price List Detail | 12 | PD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
19 | FCW962 | Simulation Consolidated Parts List | 8 | CL | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP42: Sales Management |
20 | F4211 | Sales Order Detail File | 128 | SD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
21 | F42119 | Sales Order History File | 128 | SD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
22 | F42199 | S.O. Detail Ledger File | 128 | SL | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
23 | F42UI11 | SO Detail Cache File (MBF) | 88 | ZD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
24 | F42UI521 | Pick Slips Detail File | 99 | S9 | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP42W: Fulfillment Management |
25 | F4277703 | Unfulfilled Items Workfile | 9 | UI | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
26 | F427UI01 | Release Fulfillment Work File | 46 | RF | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP43: Procurement |
27 | F43080 | Approvals Fields Constants | 110 | PD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
28 | F4311 | Purchase Order Detail File | 106 | PD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
29 | F4311Z | Purchase Order Generator File | 110 | PW | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
30 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 119 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
31 | F43121Z | Receiver workfile | 52 | PW | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
32 | F43199 | P.O. Detail Ledger File - Flexible Version | 106 | OL | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
33 | F4371 | Suggested Reorder Stock Items | 16 | PD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP43E: Requisition Self Service |
34 | F43E11 | Requisition Detail | 25 | RD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP43Q: Strategic Sourcing |
35 | F43Q92 | Adhoc Item Definition | 2 | AI | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP45: Advanced Pricing |
36 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 153 | Z1 | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP46: Warehouse Management |
37 | F4142 | Warehouse Count Transactions | 13 | CT | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
38 | F4602 | Location Detail Information | 65 | IF | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
39 | F4611 | Warehouse Suggestions | 41 | R2 | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
40 | F4611PU | Warehouse Suggestions - Purged | 40 | R2 | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
41 | F4611Z1 | Unedited Suggestion Table | 53 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
42 | F46130 | Putaway Reservations | 17 | R3 | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
43 | F46130PU | Putaway Reservations - Purged | 17 | R3 | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP46L: License Plating |
44 | F46L11 | License Plate Item Detail | 7 | ID | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
45 | F46L42 | License Plate Cycle and Tag Count | 10 | CC | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
46 | F46L99 | License Plate History | 40 | LM | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
47 | F46LUI01 | Assign/Remove Items To LP Work File | 13 | WF | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP47: Electronic Commerce |
48 | F47012 | EDI Purchase Order Detail - Inbound | 155 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
49 | F47017 | EDI Purchase Order Detail - Outbound | 120 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
50 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 120 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
51 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 155 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
52 | F47032 | EDI Shipping Notice Detail - Inbound | 90 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
53 | F47037 | EDI Shipping Notice Detail - Outbound | 137 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
54 | F470371 | EDI Shipping Notice Detail - Outbound | 158 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
55 | F47047 | EDI Invoice Detail (Sales) - Outbound | 155 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
56 | F47072 | EDI Receiving Advice Detail - Inbound | 121 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
57 | F47077 | EDI Receiving Advice Detail - Outbound | 121 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
58 | F47082 | EDI Price Sales Catalog Detail - Inbound | 61 | FY | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
59 | F47092 | EDI Request for Quote Detail - Inbound | 155 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
60 | F47097 | EDI Request for Quote Detail - Outbound | 120 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
61 | F47102 | EDI Response to RFQ Detail - Inbound | 120 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
62 | F47107 | EDI Response to RFQ Detail - Outbound | 155 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
63 | F47132 | EDI Purchase Order Change Detail - Inbound | 156 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
64 | F47137 | EDI Purchase Order Change Detail - Outbound | 121 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
65 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 122 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
66 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 157 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
67 | F47157 | EDI Shipping Schedule Detail - Outbound | 129 | SZ | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP48: Work Order Processing |
68 | F48UI001 | X4801 Master Business Function Workfile | 134 | WA | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP49: Transportation Management |
69 | F4963 | Load In-transit | 13 | TI | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
70 | F49632 | Load In-transit Left on Board | 13 | LB | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
71 | F4971 | Freight Rate Definition | 12 | RD | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP75I: India |
72 | F75I3901 | Work With Consignment - IND -43 | 16 | CO | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP76B: Brazil - Reporting System Only |
73 | F761BA | AS Fiscal file book - 09 | 97 | FB | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
74 | F76B052 | Unit of measure - SPED Fiscal Brazilian WF - BRA - 76B | 6 | WU | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
75 | F76B0524 | Unit of Measure Brazilian Work File | 7 | AB | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
76 | F76B0802 | Unit of measure - SPED Fiscal Brazilian Workfile | 4 | UM | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
77 | F76B0803 | UM Conversions - SPED Fiscal Brazilian Workfile | 5 | FC | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
78 | F76B400B | IN86-Work Table for Inventory Records - 41 | 6 | IR | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP76H: Chile |
79 | F76H6008 | Manufactured Items - CHI - 41 - 76H | 9 | IP | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP79A: Greenhouse Gas Accounting |
80 | F79A11 | GHG Ledger | 14 | GR | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
81 | F79A11Z1 | GHG Ledger - Batch File | 32 | GL | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
82 | F79A12 | GHG Ledger Audit | 15 | GR | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
83 | F79AU11 | GHG Ledger Work Table | 17 | GR | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP80D: Plant Manager Dashboard |
84 | F80D010 | Sales Order Fact | 18 | SF | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOP89: Conversion Programs |
85 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 106 | OL | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |
TOPF30L: DFM Line Design |
86 | FF30L501 | DFM Item Definition Master | 93 | IB | UOM1 | Unit of Measure - Primary | String | UDC | 2 | 0 |