| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0018R | Tax Reconciliation Repository | 10 | ED | AID | Account ID | String | Generic Edit | 8 | 0 |
2 | F0030 | Bank Transit Master | 6 | AY | AID | Account ID | String | Generic Edit | 8 | 0 |
3 | F0030T | Bank Account X12 Information | 1 | AZ | AID | Account ID | String | Generic Edit | 8 | 0 |
4 | F0901WS | Account - Word Search | 2 | WS | AID | Account ID | String | Generic Edit | 8 | 0 |
5 | F0902 | Account Balances | 1 | GB | AID | Account ID | String | Generic Edit | 8 | 0 |
6 | F0911 | Account Ledger | 16 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP03B: Enhanced Accounts Receivable |
7 | F03B11 | Customer Ledger | 16 | RP | AID | Account ID | String | Generic Edit | 8 | 0 |
8 | F03B117 | Revenue Recognition GL Info | 53 | RL | AID | Account ID | String | Generic Edit | 8 | 0 |
9 | F03B119 | Revenue Recognition GL Info Audit | 51 | RN | AID | Account ID | String | Generic Edit | 8 | 0 |
10 | F03B11P | Customer Ledger Purge File | 16 | RP | AID | Account ID | String | Generic Edit | 8 | 0 |
11 | F03B11Z1 | Batch Invoices | 34 | VJ | AID | Account ID | String | Generic Edit | 8 | 0 |
12 | F03B11Z2 | F03B11 Interoperability Table | 29 | SY | AID | Account ID | String | Generic Edit | 8 | 0 |
13 | F03B13 | Receipts Header | 13 | RY | AID | Account ID | String | Generic Edit | 8 | 0 |
14 | F03B13P | Receipts Header Purge File | 13 | RY | AID | Account ID | String | Generic Edit | 8 | 0 |
15 | F03B13Z2 | F03B13 Interoperability Table | 26 | SY | AID | Account ID | String | Generic Edit | 8 | 0 |
16 | F03B14 | Receipts Detail | 14 | RZ | AID | Account ID | String | Generic Edit | 8 | 0 |
17 | F03B14P | Receipts Detail Purge File | 14 | RZ | AID | Account ID | String | Generic Edit | 8 | 0 |
18 | F03B14Z2 | F03B14 Interoperability Table | 27 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
19 | F03B575 | Auto Debit Invoice Select and Build | 19 | RD | AID | Account ID | String | Generic Edit | 8 | 0 |
20 | F03B672 | Draft Remittance | 16 | RD | AID | Account ID | String | Generic Edit | 8 | 0 |
21 | F09UI011 | Receipt Prepost Work File | 11 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP04: Accounts Payable |
22 | F09UI005 | Tax Offsets User Index | 6 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP05: Time Accounting and HRM Base |
23 | F0618 | Employee Transaction History | 96 | YT | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP05T: Time Entry |
24 | F0624 | Burden Distribution File | 17 | J# | AID | Account ID | String | Generic Edit | 8 | 0 |
25 | F06241 | Burden Distribution File | 17 | J# | AID | Account ID | String | Generic Edit | 8 | 0 |
26 | F069136 | Tip Disbursement | 13 | JE | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP07: Payroll |
27 | F07UI200 | Timecard History Work File | 98 | TH | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP08P: Position Control |
28 | F081012 | Position Accounts | 6 | HC | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP09: General Accounting |
29 | F0901 | Account Master | 2 | GM | AID | Account ID | String | Generic Edit | 8 | 0 |
30 | F0901C | Account Category Codes | 1 | GM | AID | Account ID | String | Generic Edit | 8 | 0 |
31 | F0901D | Account Master - Alternate Description | 3 | LK | AID | Account ID | String | Generic Edit | 8 | 0 |
32 | F0902B | Account Balances - 52 Period Accounting | 1 | GB | AID | Account ID | String | Generic Edit | 8 | 0 |
33 | F0902P | Purge - Account Balances | 1 | GB | AID | Account ID | String | Generic Edit | 8 | 0 |
34 | F0902Z1 | Account Balances - Batch File | 1 | GB | AID | Account ID | String | Generic Edit | 8 | 0 |
35 | F0911P | Purge - Account Ledger | 16 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
36 | F0911R | WF - Account Ledger Reconciliation | 16 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
37 | F0911R1 | Account Reconciliations Header - OneWorld ONLY | 1 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
38 | F0911Z1 | Journal Entry Transactions - Batch File | 33 | VN | AID | Account ID | String | Generic Edit | 8 | 0 |
39 | F0911Z4 | F0911 Interoperability Table | 38 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
40 | F0912 | Cost Allocations/Flex Budgeting | 14 | RJ | AID | Account ID | String | Generic Edit | 8 | 0 |
41 | F0912A | Index Computation Entry File | 10 | RI | AID | Account ID | String | Generic Edit | 8 | 0 |
42 | F0912B | Variable Allocation File | 13 | R# | AID | Account ID | String | Generic Edit | 8 | 0 |
43 | F092181 | Online Consolidation Detail File | 6 | LR | AID | Account ID | String | Generic Edit | 8 | 0 |
44 | F09300 | OVFS Report Table | 79 | FR | AID | Account ID | String | Generic Edit | 8 | 0 |
45 | F09350W | OVFS Row Definition Work Table | 19 | RW | AID | Account ID | String | Generic Edit | 8 | 0 |
46 | F09505 | WF - Bank File of Cleared Checks. | 1 | GN | AID | Account ID | String | Generic Edit | 8 | 0 |
47 | F09621 | Bank Account Cross Reference | 3 | GS | AID | Account ID | String | Generic Edit | 8 | 0 |
48 | F09628 | Auto Bank Statement Account Setup | 1 | GA | AID | Account ID | String | Generic Edit | 8 | 0 |
49 | F097021W | Account Ledger to Account Master Work Table | 20 | TA | AID | Account ID | String | Generic Edit | 8 | 0 |
50 | F097031W | Account Balance to Account Master Work Table | 3 | AB | AID | Account ID | String | Generic Edit | 8 | 0 |
51 | F097041W | Accounts to Business Units Work Table | 3 | AB | AID | Account ID | String | Generic Edit | 8 | 0 |
52 | F09UI004 | Variable Numerator Allocations work file | 8 | R# | AID | Account ID | String | Generic Edit | 8 | 0 |
53 | F09UI007 | Match Bank Tape to Recon File - ONE WORLD ONLY | 13 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
54 | F09UI014 | Annual Close Work Table | 1 | GB | AID | Account ID | String | Generic Edit | 8 | 0 |
55 | F09UI015 | Indexed Computations Multi-Tiered Entries | 16 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
56 | F09UI016 | Account Balance Compare Exceptions | 4 | GW | AID | Account ID | String | Generic Edit | 8 | 0 |
57 | F52G02 | Burdening Summarized Ledger | 1 | BS | AID | Account ID | String | Generic Edit | 8 | 0 |
58 | F52G11 | Burdening Detail Ledger | 16 | BD | AID | Account ID | String | Generic Edit | 8 | 0 |
59 | F52G11WF | Temporary Burdened Detail Ledger Workfile | 16 | BW | AID | Account ID | String | Generic Edit | 8 | 0 |
60 | F52G60 | Burden Rate Calculations Workfile | 3 | BW | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP10: Financial Reporting |
61 | F100901 | Level of Detail | 1 | FR | AID | Account ID | String | Generic Edit | 8 | 0 |
62 | F10430 | Multi-Site Consolidation - Account Structure | 9 | CF | AID | Account ID | String | Generic Edit | 8 | 0 |
63 | F10UI001 | Account Structure Build Workfile | 10 | CF | AID | Account ID | String | Generic Edit | 8 | 0 |
64 | F10UI003 | Dynamically Created Accounts | 9 | AC | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP11: Multi Currency |
65 | F1114 | Company Conversions Parameter File | 17 | C2 | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP12: Fixed Assets |
66 | F1202 | Asset Account Balances File | 1 | FL | AID | Account ID | String | Generic Edit | 8 | 0 |
67 | F1202P | Asset Account Balances Purge Table | 1 | FL | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP13E: Equipment Cost Analysis |
68 | F1383 | Equipment Analysis Costs | 6 | EC | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP14: Modeling - Planning & Budgeting |
69 | F1403 | Forecast Basis | 2 | BD | AID | Account ID | String | Generic Edit | 8 | 0 |
70 | F1404 | Forecast Results - Header | 2 | BY | AID | Account ID | String | Generic Edit | 8 | 0 |
71 | F14041 | Forecast Results - Detail | 2 | BZ | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP15: Real Estate Management |
72 | F1511 | Tenant/Lease Billings Detail | 16 | NJ | AID | Account ID | String | Generic Edit | 8 | 0 |
73 | F15110B | Expense Participation Class Account | 3 | OB | AID | Account ID | String | Generic Edit | 8 | 0 |
74 | F1511B | Lease Billings Master | 16 | NJ | AID | Account ID | String | Generic Edit | 8 | 0 |
75 | F1511H | Tenant/Lease Billings Detail History | 16 | N# | AID | Account ID | String | Generic Edit | 8 | 0 |
76 | F1511HB | Lease Billings History | 16 | NC | AID | Account ID | String | Generic Edit | 8 | 0 |
77 | F151521 | Lease E.P. Accounts Not Subject to Cap | 8 | LO | AID | Account ID | String | Generic Edit | 8 | 0 |
78 | F1530 | Expense Participation Class Master | 9 | NG | AID | Account ID | String | Generic Edit | 8 | 0 |
79 | F15301 | E.P. Class Account Overrides | 9 | AO | AID | Account ID | String | Generic Edit | 8 | 0 |
80 | F1532B | Expense Participation Audit File | 10 | NT | AID | Account ID | String | Generic Edit | 8 | 0 |
81 | F1533 | Tenant Class Account Exclusions | 4 | NM | AID | Account ID | String | Generic Edit | 8 | 0 |
82 | F1533B | Tenant Account Exclusions | 5 | NM | AID | Account ID | String | Generic Edit | 8 | 0 |
83 | F1538B1 | Occupancy Gross Up Audit | 6 | GU | AID | Account ID | String | Generic Edit | 8 | 0 |
84 | F1538B2 | Exclusion/Redistribution | 2 | RD | AID | Account ID | String | Generic Edit | 8 | 0 |
85 | F1539A | EP Billing Account Adjustments Audit | 18 | AU | AID | Account ID | String | Generic Edit | 8 | 0 |
86 | F1539E | EP Billing Account Exclusions Audit | 19 | AU | AID | Account ID | String | Generic Edit | 8 | 0 |
87 | F1539FL | EP Billing Adj Factor Lease Audit | 17 | AU | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP15L: Adv Real Estate Forecasting |
88 | F15L108 | AREF Base Account Definition | 2 | AD | AID | Account ID | String | Generic Edit | 8 | 0 |
89 | F15L109 | AREF Budget Results | 2 | BR | AID | Account ID | String | Generic Edit | 8 | 0 |
90 | F15L110 | AREF Account Status | 3 | AS | AID | Account ID | String | Generic Edit | 8 | 0 |
91 | F15L111 | AREF Account Status Detail | 3 | AD | AID | Account ID | String | Generic Edit | 8 | 0 |
92 | F15L118 | AREF Base Account Definition Detail | 2 | DD | AID | Account ID | String | Generic Edit | 8 | 0 |
93 | F15L120 | AREF Account Association | 3 | AA | AID | Account ID | String | Generic Edit | 8 | 0 |
94 | F15L38 | AREF EP Billing Register | 93 | NZ | AID | Account ID | String | Generic Edit | 8 | 0 |
95 | F15L403 | AREF Gross Up Processing Audit | 5 | SH | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP16: Profit Management (EPS) |
96 | F1602 | Cost Analyzer Balances | 3 | CB | AID | Account ID | String | Generic Edit | 8 | 0 |
97 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 25 | CZ | AID | Account ID | String | Generic Edit | 8 | 0 |
98 | F1611 | Cost Calculation Transactions | 10 | CT | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP17: Customer Service Management |
99 | F1721 | Contract Detail | 17 | CD | AID | Account ID | String | Generic Edit | 8 | 0 |
100 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 24 | WQ | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP31: Shop Floor Control |
101 | F31UI802 | Accumulate Amounts by Account | 9 | WG | AID | Account ID | String | Generic Edit | 8 | 0 |
102 | F31UI803 | Work File for Summarizing Journal Entries | 9 | SG | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP31P: Engineer To Order |
103 | F31P21 | Cost Classification Table | 4 | CC | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP39: Advanced Stock Valuation |
104 | F3910 | G/L Adjustment Table | 11 | SC | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP40: Inventory/OP Base |
105 | F4011Z | Batch Receiver File - Order Details | 193 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
106 | F49211 | Sales Order Detail File - Tag File | 128 | UD | AID | Account ID | String | Generic Edit | 8 | 0 |
107 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 147 | S1 | AID | Account ID | String | Generic Edit | 8 | 0 |
108 | F49219 | Sales Order Detail - Tag History File | 105 | UD | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP41: Inventory Management |
109 | F4111 | Item Ledger File | 49 | IL | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP42: Sales Management |
110 | F42800G1 | Sales Update G Batch Detail Workfile | 12 | DG | AID | Account ID | String | Generic Edit | 8 | 0 |
111 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 3 | UZ | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP42B: Sales Order Entry |
112 | F49299 | S.O. Detail Tag Ledger File | 128 | UD | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP43: Procurement |
113 | F40910 | Commitment Integrity Report Work File | 3 | P# | AID | Account ID | String | Generic Edit | 8 | 0 |
114 | F43080 | Approvals Fields Constants | 3 | PD | AID | Account ID | String | Generic Edit | 8 | 0 |
115 | F4311 | Purchase Order Detail File | 126 | PD | AID | Account ID | String | Generic Edit | 8 | 0 |
116 | F4311Z | Purchase Order Generator File | 130 | PW | AID | Account ID | String | Generic Edit | 8 | 0 |
117 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 139 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
118 | F43121 | Purchase Order Receiver File | 47 | PR | AID | Account ID | String | Generic Edit | 8 | 0 |
119 | F43121Z1 | Receipts Unedited Transaction Table | 64 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
120 | F43147 | Freight Distribution Workfile | 20 | FD | AID | Account ID | String | Generic Edit | 8 | 0 |
121 | F4314Z | Voucher Match Selection File | 146 | PN | AID | Account ID | String | Generic Edit | 8 | 0 |
122 | F4316 | Purchase Order Multiple Account File | 22 | P3 | AID | Account ID | String | Generic Edit | 8 | 0 |
123 | F4317 | Purchase Order Detail Non-Billable | 8 | PD | AID | Account ID | String | Generic Edit | 8 | 0 |
124 | F43199 | P.O. Detail Ledger File - Flexible Version | 126 | OL | AID | Account ID | String | Generic Edit | 8 | 0 |
125 | F43632Z | Open Purchase Order by Item Work File | 15 | OI | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP43A: Purchase Order Receipt/Routing |
126 | F43126 | Purchase Order Receiver Multiple Account | 9 | P4 | AID | Account ID | String | Generic Edit | 8 | 0 |
127 | F43127 | Purchase Order Receiver Non-Billable | 10 | PR | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP43E: Requisition Self Service |
128 | F43E16 | Requisition Multiple Account File | 8 | P3 | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP43Q: Strategic Sourcing |
129 | F43Q11 | Event Detail | 13 | ED | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP44H: Homebuilder Management |
130 | F44H611 | Bid Details | 9 | BD | AID | Account ID | String | Generic Edit | 8 | 0 |
131 | F44H611W | Bid Details Work File | 13 | BW | AID | Account ID | String | Generic Edit | 8 | 0 |
132 | F44H711 | Lot Start Workfile | 73 | SW | AID | Account ID | String | Generic Edit | 8 | 0 |
133 | F44H711Z | HB Lot Start Unedited Transaction File | 86 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
134 | F44H71W1 | Lot Start Generation Workfile | 73 | GW | AID | Account ID | String | Generic Edit | 8 | 0 |
135 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 43 | CG | AID | Account ID | String | Generic Edit | 8 | 0 |
136 | F44H73W2 | Lot Start - Budget Generation Workfile | 14 | BG | AID | Account ID | String | Generic Edit | 8 | 0 |
137 | F44H902W | Budget Creation Workfile | 2 | WF | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP47: Electronic Commerce |
138 | F47012 | EDI Purchase Order Detail - Inbound | 194 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
139 | F47017 | EDI Purchase Order Detail - Outbound | 140 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
140 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 140 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
141 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 194 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
142 | F47042 | EDI Invoice Detail - Inbound | 48 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
143 | F47047 | EDI Invoice Detail (Sales) - Outbound | 194 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
144 | F47072 | EDI Receiving Advice Detail - Inbound | 141 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
145 | F47077 | EDI Receiving Advice Detail - Outbound | 141 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
146 | F47092 | EDI Request for Quote Detail - Inbound | 194 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
147 | F47097 | EDI Request for Quote Detail - Outbound | 140 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
148 | F47102 | EDI Response to RFQ Detail - Inbound | 140 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
149 | F47107 | EDI Response to RFQ Detail - Outbound | 193 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
150 | F47132 | EDI Purchase Order Change Detail - Inbound | 195 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
151 | F47137 | EDI Purchase Order Change Detail - Outbound | 141 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
152 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 142 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
153 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 196 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
154 | F47157 | EDI Shipping Schedule Detail - Outbound | 149 | SZ | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP48: Work Order Processing |
155 | F4801ST | Purge - Work Order Master Tag File | 11 | WA | AID | Account ID | String | Generic Edit | 8 | 0 |
156 | F4801T | Work Order Master Tag File | 11 | WA | AID | Account ID | String | Generic Edit | 8 | 0 |
157 | F4801Z1 | Outbound Work Order Header | 158 | SY | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP48S: Service Billing |
158 | F4812 | Billing Detail Workfile | 6 | WD | AID | Account ID | String | Generic Edit | 8 | 0 |
159 | F4812H | Billing Workfile History | 6 | WD | AID | Account ID | String | Generic Edit | 8 | 0 |
160 | F4812HS | Billing Workfile History Purged Save | 6 | WD | AID | Account ID | String | Generic Edit | 8 | 0 |
161 | F48S0618 | Payroll Reclassification Workfile | 96 | YT | AID | Account ID | String | Generic Edit | 8 | 0 |
162 | F48S910 | Billing Detail Journal Workfile | 21 | W2 | AID | Account ID | String | Generic Edit | 8 | 0 |
163 | F48S911 | Summarized Journal Workfile | 19 | W3 | AID | Account ID | String | Generic Edit | 8 | 0 |
164 | F48S912 | G/L Link | 1 | W6 | AID | Account ID | String | Generic Edit | 8 | 0 |
165 | F48SUI01 | Billing Detail Print Workfile | 6 | WD | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP51: Job Costing |
166 | F5111 | Forecast Detail | 3 | FD | AID | Account ID | String | Generic Edit | 8 | 0 |
167 | F51901 | Cost Code Schedule | 1 | GP | AID | Account ID | String | Generic Edit | 8 | 0 |
168 | F51911 | Draw Reporting Master | 11 | GK | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP51F: Advanced Job Forecasting |
169 | F51F10W | Job Forecast Billing Worktable | 2 | PB | AID | Account ID | String | Generic Edit | 8 | 0 |
170 | F51F110 | Job Forecast Details | 2 | QG | AID | Account ID | String | Generic Edit | 8 | 0 |
171 | F51F115 | Remaining Work Detail | 2 | QJ | AID | Account ID | String | Generic Edit | 8 | 0 |
172 | F51F125 | Job Forecast Detail History | 3 | QI | AID | Account ID | String | Generic Edit | 8 | 0 |
173 | F51F20W | Job Forecast Account Info Worktable | 2 | PA | AID | Account ID | String | Generic Edit | 8 | 0 |
174 | F51F30W | View Forecast Work Table | 3 | VF | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP51X: In-Memory Project Management |
175 | F51X0902 | Ledger Balances Worktable | 4 | LB | AID | Account ID | String | Generic Edit | 8 | 0 |
176 | F51X0911 | Account Ledger Worktable | 4 | AL | AID | Account ID | String | Generic Edit | 8 | 0 |
177 | F51X10 | Project Advisor Console Worktable | 14 | EX | AID | Account ID | String | Generic Edit | 8 | 0 |
178 | F51X21 | Billing Amount Worktable | 3 | BA | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP53: Change Management |
179 | F5314 | Planned Change Order Master Table | 25 | D2 | AID | Account ID | String | Generic Edit | 8 | 0 |
180 | F5315 | Change Order Master Table | 24 | D3 | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP70: Multi-National Products |
181 | F7009001 | Chart of Accounts by Level | 2 | CA | AID | Account ID | String | Generic Edit | 8 | 0 |
182 | F704100 | Suspended VAT AP - COMM - 70 | 14 | VA | AID | Account ID | String | Generic Edit | 8 | 0 |
183 | F704200 | Final VAT AP - COMM - 70 | 21 | FV | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP74: EMEA Localization |
184 | F74412 | Customer / Supplier Balance Worktable (A/P and A/R) | 5 | RP | AID | Account ID | String | Generic Edit | 8 | 0 |
185 | F74900 | Foreign Receivables and Payables - EMEA | 22 | RP | AID | Account ID | String | Generic Edit | 8 | 0 |
186 | F749104 | Rows Definition - EMEA - 74 | 18 | RD | AID | Account ID | String | Generic Edit | 8 | 0 |
187 | F749111 | Account Group Detail- EMEA - 74 | 5 | AG | AID | Account ID | String | Generic Edit | 8 | 0 |
188 | F74UI91 | WF - Account Detail - EMEA - 74 | 7 | AD | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP74H: Hungary |
189 | F741202 | Work File Accumulated Asset Movement Dep - HUN - 74 | 1 | WF | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP74L: Portugal |
190 | F74L921 | Ref Accounts by Accounts - POR - 74L | 1 | RA | AID | Account ID | String | Generic Edit | 8 | 0 |
191 | F74LUI01 | Referential Account Details - Temp Table - 74L | 2 | TT | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP74P: Poland |
192 | F74902T | Account Balance Tag File - COM - 09 - 74P | 1 | AT | AID | Account ID | String | Generic Edit | 8 | 0 |
193 | F74P03BW | A/R Trial Balance - POL - 03B - 74P | 14 | P3 | AID | Account ID | String | Generic Edit | 8 | 0 |
194 | F74P04W | A/P Trial Balance Work Table - POL - 04 - 74P | 14 | P2 | AID | Account ID | String | Generic Edit | 8 | 0 |
195 | F74P9100 | Cash Desk Transaction - POL - 74P | 12 | CD | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP74R: Russia |
196 | F74R0018 | Russian Tax File - 74R | 39 | TD | AID | Account ID | String | Generic Edit | 8 | 0 |
197 | F74R0100 | Petty Cash Transactions - RUS - 00 - 74R | 13 | PC | AID | Account ID | String | Generic Edit | 8 | 0 |
198 | F74R012 | Cash Documents Next Number Setup - RUS - 00 | 6 | CD | AID | Account ID | String | Generic Edit | 8 | 0 |
199 | F74R013 | Cash Account Setup - RUS - 00 | 1 | CA | AID | Account ID | String | Generic Edit | 8 | 0 |
200 | F74R9029 | Open Accounts - RUS - 09 - 74R | 4 | OA | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP74S: Spain |
201 | F74S55 | Expenses and Exchange Rate for Payments - Spain - 04 | 8 | Q5 | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP74U: United Kingdom Localizations |
202 | F74U0412 | Application Commitment Workfile - UK - 43 | 4 | AC | AID | Account ID | String | Generic Edit | 8 | 0 |
203 | F74U0414 | Certificate Commitment Workfile - UK - 43 | 4 | CC | AID | Account ID | String | Generic Edit | 8 | 0 |
204 | F74U0416 | Purchase Order Commitment Workfile - UK - 43 | 4 | PC | AID | Account ID | String | Generic Edit | 8 | 0 |
205 | F74U0420 | SPC - Application Master - UK - 43 | 93 | SE | AID | Account ID | String | Generic Edit | 8 | 0 |
206 | F74U0425 | SPC - Certificate Master - UK - 43 | 97 | SF | AID | Account ID | String | Generic Edit | 8 | 0 |
207 | F74U4316 | SPC - Purchase Order Line Additional Information - UK - 43 | 41 | SC | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP75C: China |
208 | F75C010W | AP & AR XML Workfile - China -75C | 4 | AA | AID | Account ID | String | Generic Edit | 8 | 0 |
209 | F75C011 | Account - Subsidiary Cross Reference - China - 75C | 1 | UV | AID | Account ID | String | Generic Edit | 8 | 0 |
210 | F75C015 | Cash Flow Data - China | 12 | CF | AID | Account ID | String | Generic Edit | 8 | 0 |
211 | F75C091 | Account master - Tag file - China Localization | 1 | CL | AID | Account ID | String | Generic Edit | 8 | 0 |
212 | F75C201 | Modification Methods Information - CHINA | 4 | MM | AID | Account ID | String | Generic Edit | 8 | 0 |
213 | F75C902 | Subsidiary Balances File - China | 1 | SB | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP75I: India |
214 | F75I306 | Excise Account Master -IND-00 | 4 | EA | AID | Account ID | String | Generic Edit | 8 | 0 |
215 | F75I3061 | Excise Account Master - Credit Redistribution -IND | 3 | EC | AID | Account ID | String | Generic Edit | 8 | 0 |
216 | F75I612 | TCS Prepayment To Tax Authority | 14 | TP | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP75T: Taiwan |
217 | F75T012 | GUI/VAT GL Account Mapping - 75T | 4 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
218 | F75T013 | Declaration Site Tax Account Mapping-75T | 3 | EA | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP76A: Argentina |
219 | F760499A | Contract Withholding - Advances - ARG -04 - 76A | 8 | K8 | AID | Account ID | String | Generic Edit | 8 | 0 |
220 | F76A11 | Account ID Relationship - ARG - 00 - 76A | 1 | TF | AID | Account ID | String | Generic Edit | 8 | 0 |
221 | F76A19 | Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A | 20 | TI | AID | Account ID | String | Generic Edit | 8 | 0 |
222 | F76A19P | Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A | 20 | TI | AID | Account ID | String | Generic Edit | 8 | 0 |
223 | F76A19Z1 | Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A | 38 | VK | AID | Account ID | String | Generic Edit | 8 | 0 |
224 | F76A32 | A/P Account ID Relationship - ARG - 04 - 76A | 1 | X3 | AID | Account ID | String | Generic Edit | 8 | 0 |
225 | F76A42 | CERG G/L - Work File - ARG - 09 - 76A | 2 | TF | AID | Account ID | String | Generic Edit | 8 | 0 |
226 | F76AUI24 | Taxes Work File - ARG - 03B - 76A | 17 | TI | AID | Account ID | String | Generic Edit | 8 | 0 |
227 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 13 | WF | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP76B: Brazil |
228 | F7611B | Nota Fiscal Detail - BRA - 42 | 90 | FD | AID | Account ID | String | Generic Edit | 8 | 0 |
229 | F76B0526 | Chart of Account Brazilian Workfile. | 2 | AM | AID | Account ID | String | Generic Edit | 8 | 0 |
230 | F76B056 | Account - SPED Fiscal Brazilian WF - BRA - 76B | 6 | WT | AID | Account ID | String | Generic Edit | 8 | 0 |
231 | F76B0590 | Electronic Reporting - Chart of Accounts | 2 | CH | AID | Account ID | String | Generic Edit | 8 | 0 |
232 | F76B837 | FCONT Account Balances - 76B | 1 | FB | AID | Account ID | String | Generic Edit | 8 | 0 |
233 | F76B845 | FCONT Jobs Accounts Balances - 76B | 4 | JB | AID | Account ID | String | Generic Edit | 8 | 0 |
234 | F76B925 | Brazilian Account Information - BR - 09 | 1 | BA | AID | Account ID | String | Generic Edit | 8 | 0 |
235 | F76B926 | Ref Accounts by Accounts - BR - 09 | 1 | RA | AID | Account ID | String | Generic Edit | 8 | 0 |
236 | F76B935 | SPED Book Type Definition | 3 | BD | AID | Account ID | String | Generic Edit | 8 | 0 |
237 | F76B955 | SPED Job Accounts - BR - 09 | 2 | GL | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP76C: Colombia |
238 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 16 | RP | AID | Account ID | String | Generic Edit | 8 | 0 |
239 | F76C034A | A/R Check Detail file As Of - COL - 03B | 14 | RZ | AID | Account ID | String | Generic Edit | 8 | 0 |
240 | F76C0902 | Debits and Credits T/B by object account - COL - 76C | 1 | GB | AID | Account ID | String | Generic Edit | 8 | 0 |
241 | F76C9415 | Workfile for Dialy Book - COL - 09 | 8 | LD | AID | Account ID | String | Generic Edit | 8 | 0 |
242 | F76C9F01 | DIAN Setup Concept Code by Format and Account - 09 - COL | 2 | SC | AID | Account ID | String | Generic Edit | 8 | 0 |
243 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 21 | DF | AID | Account ID | String | Generic Edit | 8 | 0 |
244 | F76C9F11 | DIAN Formats File by Account Id - COL - 09 | 2 | DF | AID | Account ID | String | Generic Edit | 8 | 0 |
245 | F76CT2 | Sales/Use/V.A.T. Tax File - COL - 76C | 23 | CT | AID | Account ID | String | Generic Edit | 8 | 0 |
246 | F76CUI01 | Account Master - Work File - COL - 76C | 2 | GM | AID | Account ID | String | Generic Edit | 8 | 0 |
247 | F76CUI03 | Account Cat. Code - Work File - COL - 76C | 2 | GM | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP76H: Chile |
248 | F76H6002 | Indirect Costs Selection EPS F1602 - CHI - 41 - 76H | 7 | I1 | AID | Account ID | String | Generic Edit | 8 | 0 |
249 | F76H6005 | Account ID / Cost Type Relationship - CHI - 41 - 76H | 2 | AC | AID | Account ID | String | Generic Edit | 8 | 0 |
250 | F76H902T | Account Balances Tag File - CHI - 09 - 76H | 1 | AT | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP83: Management Reporting - FASTR |
251 | F83UI001 | Balance Audit Work File - (Financial Reporting) | 8 | R1 | AID | Account ID | String | Generic Edit | 8 | 0 |
TOP89: Conversion Programs |
252 | F0901T | Needed for upgrade for XE and below | 1 | GM | AID | Account ID | String | Generic Edit | 8 | 0 |
253 | F0902A | Account Debit Balances | 1 | GD | AID | Account ID | String | Generic Edit | 8 | 0 |
254 | F42119B | Sales Order History File - temporary for upgrade (2) | 22 | SD | AID | Account ID | String | Generic Edit | 8 | 0 |
255 | F4211B | Sales Order Detail File - temporary for upgrade (2) | 22 | SD | AID | Account ID | String | Generic Edit | 8 | 0 |
256 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 126 | OL | AID | Account ID | String | Generic Edit | 8 | 0 |
257 | F7460 | Next Auto Debit Number | 3 | QL | AID | Account ID | String | Generic Edit | 8 | 0 |
TOPH95: Object and Environment Tech |
258 | F00166 | Media Object Categories | 30 | GT | AID | Account ID | String | Generic Edit | 8 | 0 |