| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 109 | GL | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
2 | F0911T | Account Ledger Tag File | 18 | GL | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
3 | F4096 | Sales Flex Accounting | 15 | FA | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP05: Time Accounting and HRM Base |
4 | F0618 | Employee Transaction History | 102 | YT | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP05T: Time Entry |
5 | F06116 | Employee Transaction Detail File | 153 | YT | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
6 | F06116Z1 | Employee Transactions - Batch File | 165 | VL | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP07: Payroll |
7 | F0716701 | Employee Assignment T/E Template Information | 7 | EA | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
8 | F0716709 | Employee Assignment T/E Template Info History | 7 | EA | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP09: General Accounting |
9 | F0911P | Purge - Account Ledger | 109 | GL | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
10 | F0911R | WF - Acct Ledger File for Reconciliation | 61 | GL | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
11 | F0911Z1 | Journal Entry Transactions - Batch File | 160 | VN | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
12 | F0911Z1T | Journal Entry Transactions - Batch Tag File | 15 | VN | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
13 | F0911Z4 | F0911 Interoperability Table | 140 | SZ | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP16: Profit Management (EPS) |
14 | F1602 | Cost Analyzer Balances | 9 | CB | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
15 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 31 | CZ | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
16 | F1610 | Cost Calculation Definitions | 25 | CD | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
17 | F1611 | Cost Calculation Transactions | 18 | CT | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
18 | F1620 | Cost Object Types | 1 | CT | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
19 | F1630 | Driver Definitions | 11 | CD | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
20 | F1632 | Driver Balances | 9 | CB | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
21 | F1632Z1 | External Driver Balances-Interoperability Table | 31 | CY | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
22 | F16421 | Rate Master Detail File | 4 | RD | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP18: Resource Scheduling |
23 | F186602 | Labor Rules Tag File | 159 | TF | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP31: Shop Floor Control |
24 | F31UI802 | Accumulate Amounts by Account | 17 | WG | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
25 | F31UI803 | Work File for Summarizing Journal Entries | 17 | SG | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP42: Sales Management |
26 | F42800G1 | Sales Update G Batch Detail Workfile | 106 | DG | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP43: Procurement |
27 | F4311T | Purchase Order Detail Tag File | 12 | PD | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
28 | F4311Z | Purchase Order Generator File | 209 | PW | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
29 | F43121T | Purchase Order Receiver Tag File | 19 | PR | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
30 | F43121Z | Receiver workfile | 127 | PW | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
31 | F43121Z1 | Receipts Unedited Transaction Table | 138 | SZ | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
32 | F4314Z | Voucher Match Selection File | 91 | PN | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP45: Advanced Pricing |
33 | F4575 | Ship and Debit History | 47 | AH | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
34 | F4575TMP | Ship and Debit History - Temp Table | 47 | AH | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
35 | F4576 | Ship and Debit Claims | 75 | AC | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
36 | F4576TMP | Ship and Debit Claims- Temp Table | 75 | AC | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
37 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 72 | Z1 | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP48S: Service Billing |
38 | F48S0618 | Payroll Reclassification Workfile | 102 | YT | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP76H: Chile |
39 | F76H6001 | Actual Cost Process Header - CHI - 41 - 76H | 6 | PH | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
40 | F76H6002 | Indirect Costs Selection EPS F1602 - CHI - 41 - 76H | 12 | I1 | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
41 | F76H6003 | Indirect Costs Selection EPS F1642 - CHI - 41 - 76H | 13 | I2 | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |
TOP83: Management Reporting - FASTR |
42 | F83UI001 | Balance Audit Work File - (Financial Reporting) | 20 | R1 | ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 |