| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 89 | GL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP03: Accounts Receivable |
2 | F0311 | Accounts Receivable Ledger | 87 | RP | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP04: Accounts Payable |
3 | F0411 | Accounts Payable Ledger | 67 | RP | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
4 | F0411A | WF - As Of - Accounts Payable Ledger | 67 | RP | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
5 | F0411P | Purge - Accounts Payable Ledger | 67 | RP | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
6 | F0411Z1 | Voucher Transactions - Batch File | 85 | VL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
7 | F0411Z3 | F0411 Interoperability Table | 90 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP05: Time Accounting and HRM Base |
8 | F0618 | Employee Transaction History | 23 | YT | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP05T: Time Entry |
9 | F06116 | Employee Transaction Detail File | 23 | YT | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
10 | F06116Z1 | Employee Transactions - Batch File | 40 | VL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
11 | F06278 | Retro Timecard Detail File | 26 | YT | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP07: Payroll |
12 | F0716701 | Employee Assignment T/E Template Information | 18 | EA | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
13 | F0716709 | Employee Assignment T/E Template Info History | 18 | EA | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
14 | F07UI200 | Timecard History Work File | 26 | TH | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP09: General Accounting |
15 | F0911P | Purge - Account Ledger | 89 | GL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
16 | F0911Z1 | Journal Entry Transactions - Batch File | 106 | VN | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
17 | F0911Z4 | F0911 Interoperability Table | 111 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
18 | F09UI015 | Indexed Computations Multi-Tiered Entries | 89 | GL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP13: Plant/Equipment Management |
19 | F13017 | Equipment Parts List | 22 | PL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP13R: Resource Assignments |
20 | F48311 | Resource Assignments | 5 | RA | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
21 | F48311S | Purge - Resource Assignments | 5 | RA | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
22 | F48316 | Maintenance Rescheduling Metrics | 2 | RS | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP17: Customer Service Management |
23 | F1775 | Claim Temporary Table | 29 | TC | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
24 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 31 | WP | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
25 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 26 | WL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
26 | F31172 | Routing Instructions - Extension | 2 | WS | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
27 | F31172S | Purge Routing Instructions - Extension | 2 | WS | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP17C: Call Management |
28 | F1760 | Time Entry | 4 | ZB | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP18: Resource Scheduling |
29 | F186602 | Labor Rules Tag File | 36 | TF | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP30: Product Data Management |
30 | F300211 | Lean Multi Level Bill of Material Detail | 17 | ED | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
31 | F3002Z1 | Bill of Material Transaction File | 49 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
32 | F300311 | Lean Multi Level Routing Detail File | 8 | EH | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
33 | F3003Z1 | Routing Transactions File | 23 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP31: Shop Floor Control |
34 | F3102 | Production Cost | 3 | IG | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
35 | F3102S | Purge - Production Cost | 3 | IG | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
36 | F31091 | Schedule Quantity Detail | 12 | IQ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
37 | F31091S | Schedule Quantity Detail Purge | 12 | IQ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
38 | F3111 | Work Order Parts List | 18 | WM | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
39 | F3111S | Purge - Shop Floor Parts List | 18 | WM | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
40 | F3111Z1 | Outbound Work Order Parts List | 31 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
41 | F3112 | Work Order Routing | 13 | WL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
42 | F31122 | Work Order Time Transactions | 11 | WT | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
43 | F31122S | Purge Work Order Time Transactions | 11 | WT | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
44 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 24 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
45 | F3112S | Purge Shop Floor Control Routing Instructions | 13 | WL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
46 | F3112ST | Purge Shop Floor Control Routing Instructions Tag Table | 2 | WL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
47 | F3112T | Shop Floor Control Routing Instructions Tag Table | 2 | WL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
48 | F3112Z1 | Outbound Work Order Routings | 26 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
49 | F3112Z1T | Outbound Work Order Routings Tag Table | 5 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP32: Configuration Management |
50 | F3212 | Configurator Routings File | 8 | RC | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
51 | F3215 | Configurator Component Table | 28 | CC | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
52 | F32159 | Configurator Component History Table | 27 | CH | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
53 | F3293 | Assembly Inclusions Rules | 20 | KY | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
54 | F3296T | Configurator Level Sequence File Table | 6 | KA | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP33: Capacity Planning |
55 | F33UI001 | Shop Floor Control Routing Instructions | 8 | WL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP34A: Advanced Planning & Scheduling |
56 | F34A120 | Routing Master Resource Table | 5 | N0 | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
57 | F34A150 | Work Order Routing Resource Table | 3 | RR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
58 | F34A90 | Last Outbound Phantom Information | 5 | PI | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP37: Quality Management |
59 | F3711 | Test Results | 61 | TR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
60 | F3711Z1 | Test Results Unedited Transaction Table | 74 | SZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
61 | F37900 | Certificate of Analysis (COA) Extract | 61 | TR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
62 | F40318 | Preference Profile - Quality Management | 45 | QC | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP40: Inventory/OP Base |
63 | F3002 | Bill of Material Master File | 36 | IX | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
64 | F30026 | Item Cost Component Add-Ons | 28 | IE | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
65 | F3003 | Routing Master File | 10 | IR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
66 | F3003T | Routing Tag File | 5 | IR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
67 | F3011 | Bill of Materials Change File | 36 | IZ | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
68 | F3013 | ECO Parts List Detail | 15 | CY | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
69 | F30UI004 | Bill of Material Update Work File | 34 | WF | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
70 | F40318R | Preference Resolution Ledger - Quality Management | 47 | QC | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP41: Inventory Management |
71 | F4111 | Item Ledger File | 63 | IL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP42: Sales Management |
72 | F42800G1 | Sales Update G Batch Detail Workfile | 82 | DG | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP47: Electronic Commerce |
73 | F47057 | EDI Payment Order Remittance Advice - Outbound | 53 | D3 | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
74 | F47057W | EDI Payment Order Remittance Advice - Work | 53 | D3 | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP48S: Service Billing |
75 | F4812 | Billing Detail Workfile | 13 | WD | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
76 | F4812H | Billing Workfile - History | 13 | WD | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
77 | F4812HS | Billing Workfile History Purged Save | 13 | WD | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
78 | F48S0618 | Payroll Reclassification Workfile | 23 | YT | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
79 | F48SUI01 | Billing Detail Print Workfile | 13 | WD | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP76B: Brazil - Reporting System Only |
80 | F76B3010 | Work Table for Item/Part List - 30 | 16 | IP | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOP89: Conversion Programs |
81 | F31172TE | F31172 temp table for TC merge | 2 | WS | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOPF30L: DFM Line Design |
82 | FF30L002 | DFM Bill of Material Master | 30 | DH | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
83 | FF30L930 | DFM Routings | 9 | LR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
TOPF31: Lean Transactions |
84 | FF31111 | Lean Transaction Parts List | 22 | PL | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
85 | FF31111S | Purge - Lean Transaction Parts List | 22 | PR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
86 | FF31112 | Routing Transaction Table | 53 | EH | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
87 | FF31112S | Purge - Routing Transaction Table | 53 | ET | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
88 | FF31113 | Lean Transaction Labor Detail | 14 | LD | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |
89 | FF31113S | Purge - Lean Transaction Labor Detail | 14 | LR | OPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 |