| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0902 | Account Balances | 38 | GB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
2 | F0911 | Account Ledger | 21 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
3 | F4096 | Sales Flex Accounting | 11 | FA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP03: Accounts Receivable |
4 | F0311 | Accounts Receivable Ledger | 52 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP03B: Enhanced Accounts Receivable |
5 | F03B11 | Customer Ledger | 53 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
6 | F03B11P | Customer Ledger Purge File | 53 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
7 | F03B11Z1 | Batch Invoices | 70 | VJ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
8 | F03B11Z2 | F03B11 Interoperability Table | 66 | SY | SBLT | Subledger Type | Character | UDC | 1 | 0 |
9 | F03B14 | Receipts Detail | 70 | RZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
10 | F03B14P | Receipts Detail Purge File | 70 | RZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
11 | F03B14Z2 | F03B14 Interoperability Table | 83 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
12 | F03B575 | Auto Debit Invoice Select and Build | 62 | RD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
13 | F09UI011 | Receipt Prepost Work File | 16 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP04: Accounts Payable |
14 | F0411 | Accounts Payable Ledger | 51 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
15 | F0411A | WF - As Of Accounts Payable Ledger | 51 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
16 | F0411P | Purge - Accounts Payable Ledger | 51 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
17 | F0411Z1 | Voucher Transactions - Batch Upload | 69 | VL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
18 | F0411Z3 | F0411 Interoperability Table | 74 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
19 | F09UI005 | Tax Offsets User Index | 35 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP05: Time Accounting and HRM Base |
20 | F06106 | Employee Pay Instructions | 75 | YM | SBLT | Subledger Type | Character | UDC | 1 | 0 |
21 | F0618 | Employee Transaction History | 18 | YT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP05T: Time Entry |
22 | F06116 | Employee Transaction Detail File | 18 | YT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
23 | F06116Z1 | Employee Transactions - Batch File | 35 | VL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
24 | F06116Z2 | ESS Timecard History | 35 | VM | SBLT | Subledger Type | Character | UDC | 1 | 0 |
25 | F0623 | Piecework History File | 4 | JL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
26 | F0624 | Burden Distribution File | 12 | J# | SBLT | Subledger Type | Character | UDC | 1 | 0 |
27 | F06241 | Burden Distribution File | 12 | J# | SBLT | Subledger Type | Character | UDC | 1 | 0 |
28 | F06278 | Retro Timecard Detail File | 21 | YT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
29 | F06290 | Payroll Accounting Journal Work File | 8 | YR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
30 | F063951 | Payroll Journal (Compressed) File | 25 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
31 | F06904 | Automatic Accounting Instructions | 15 | Y# | SBLT | Subledger Type | Character | UDC | 1 | 0 |
32 | F069161 | Item Master Cross Reference File | 3 | JE | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP07: Payroll |
33 | F05290 | WF - Payroll Journal (Detail) | 25 | JR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
34 | F06490 | Payroll/Accounts Payable Ledger Detail | 23 | JR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
35 | F06491 | Payroll/Accounts Payable Ledger Detail | 16 | J6 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
36 | F0716701 | Employee Assignment T/E Template Information | 17 | EA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
37 | F0716709 | Employee Assignment T/E Template Info History | 17 | EA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
38 | F0724 | Burden Distribution File | 15 | YS | SBLT | Subledger Type | Character | UDC | 1 | 0 |
39 | F07241 | Burden Distribution File | 15 | YS | SBLT | Subledger Type | Character | UDC | 1 | 0 |
40 | F07490 | Payroll - Accounts Payable Detail (One World) | 23 | JR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
41 | F07491 | Payroll - Accounts Payable Summary File | 16 | J6 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
42 | F07UI200 | Timecard History Work File | 21 | TH | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
43 | F051371 | ADP Employee DBA Instructions | 80 | AD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP08P: Position Control |
44 | F081012 | Position Accounts | 5 | HC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP09: General Accounting |
45 | F0902B | Account Balances - 52 Period Accounting | 78 | GB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
46 | F0902P | Purge - Account Balances | 38 | GB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
47 | F0902Z1 | Account Balances - Batch File | 41 | GB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
48 | F0911P | Purge - Account Ledger | 21 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
49 | F0911R | WF - Account Ledger Reconciliation | 21 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
50 | F0911Z1 | Journal Entry Transactions - Batch File | 38 | VN | SBLT | Subledger Type | Character | UDC | 1 | 0 |
51 | F0911Z4 | F0911 Interoperability Table | 43 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
52 | F0912 | Cost Allocations/Flex Budgeting | 48 | RJ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
53 | F0912A | Index Computation Entry File | 53 | RI | SBLT | Subledger Type | Character | UDC | 1 | 0 |
54 | F0912B | Variable Allocation File | 16 | R# | SBLT | Subledger Type | Character | UDC | 1 | 0 |
55 | F0917 | Bank Statement Detail | 36 | GD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
56 | F09617 | Auto Bank Statement Detail | 39 | GM | SBLT | Subledger Type | Character | UDC | 1 | 0 |
57 | F09UI004 | Variable Numerator Allocations work file | 13 | R# | SBLT | Subledger Type | Character | UDC | 1 | 0 |
58 | F09UI015 | Indexed Computations Multi-Tiered Entries | 21 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
59 | F09UI016 | Account Balance Compare Exceptions | 6 | GW | SBLT | Subledger Type | Character | UDC | 1 | 0 |
60 | F09UI123 | Advanced Variable Numerator Worktable | 8 | VW | SBLT | Subledger Type | Character | UDC | 1 | 0 |
61 | F52G02 | Burdening Summarized Ledger | 11 | BS | SBLT | Subledger Type | Character | UDC | 1 | 0 |
62 | F52G11 | Burdening Detail Ledger | 14 | BD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
63 | F52G11WF | Temporary Burdened Detail Ledger Workfile | 14 | BW | SBLT | Subledger Type | Character | UDC | 1 | 0 |
64 | F70UI001 | Work File for G/L by Cat. Code Localization | 10 | WA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
65 | F740911 | Work File for G/L Report by Category Code Localization | 13 | WA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP09E: Expense Reimbursment |
66 | F09E150 | Credit Card Transaction Interface Table | 10 | CI | SBLT | Subledger Type | Character | UDC | 1 | 0 |
67 | F20112 | Expense Report Detail | 60 | ED | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP10: Financial Reporting |
68 | F1002 | Multi-Site Consolidation Transfer File | 12 | GQ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
69 | F1002Z1 | Unedited MSC Interoperability Table | 21 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
70 | F10471 | Elimination Rules (OW) | 9 | ER | SBLT | Subledger Type | Character | UDC | 1 | 0 |
71 | F10UI006 | MSC - F1002 Elimination Work File | 11 | GE | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP12: Fixed Assets |
72 | F12002 | Default Accounting Constants | 22 | FD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
73 | F12003 | Default Depreciation Constants | 19 | FF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
74 | F1202 | Asset Account Balances File | 45 | FL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
75 | F1202P | Asset Account Balances Purge Table | 45 | FL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
76 | F1204 | Location Tracking Table | 29 | FM | SBLT | Subledger Type | Character | UDC | 1 | 0 |
77 | F1204P | Location Tracking Purge Table | 29 | FM | SBLT | Subledger Type | Character | UDC | 1 | 0 |
78 | F12911ER | Post G/L to FA Exceptions Work File | 20 | GL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP13: Plant/Equipment Management |
79 | F12120Z1 | Unedited Meter Reading Transactions | 23 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
80 | F1304 | Equipment Location Billing | 10 | FN | SBLT | Subledger Type | Character | UDC | 1 | 0 |
81 | F1305 | Equipment Distribution Rules | 10 | FV | SBLT | Subledger Type | Character | UDC | 1 | 0 |
82 | F1306 | Meter Reading Estimates | 8 | F5 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
83 | F1306P | Meter Reading Estimates Purge Table | 8 | F5 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP13E: Equipment Cost Analysis |
84 | F1383 | Equipment Analysis Costs | 8 | EC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP15: Property Management |
85 | F1502 | Recurring Billings Master | 54 | NF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
86 | F1502B | Recurring Billings Master | 50 | NF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
87 | F1502WB | Estimated EP Recurring Billings | 53 | N4 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
88 | F1511 | Tenant/Lease Billings Detail | 55 | NJ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
89 | F1511B | Lease Billings Master | 51 | NJ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
90 | F1511H | Tenant/Lease Billings Detail History | 55 | N# | SBLT | Subledger Type | Character | UDC | 1 | 0 |
91 | F1511HB | Lease Billings History | 51 | NC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
92 | F15153 | Lease Cap History | 11 | LC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
93 | F15303 | E.P. Class Expenses History | 8 | CH | SBLT | Subledger Type | Character | UDC | 1 | 0 |
94 | F1532B | Expense Participation Audit File | 15 | NT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
95 | F1533B | Tenant Account Exclusions | 34 | NM | SBLT | Subledger Type | Character | UDC | 1 | 0 |
96 | F1538B1 | Occupancy Gross Up Audit | 11 | GU | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP15L: Adv Real Estate Forecasting |
97 | F15L109 | AREF Budget Results | 6 | BR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
98 | F15L110 | AREF Account Status | 7 | AS | SBLT | Subledger Type | Character | UDC | 1 | 0 |
99 | F15L111 | AREF Account Status Detail | 7 | AD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP16: Profit Management (EPS) |
100 | F1602 | Cost Analyzer Balances | 7 | CB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
101 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 29 | CZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
102 | F1610 | Cost Calculation Definitions | 21 | CD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
103 | F1611 | Cost Calculation Transactions | 16 | CT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
104 | F1630 | Driver Definitions | 26 | CD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
105 | F1632 | Driver Balances | 7 | CB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
106 | F1632Z1 | External Driver Balances-Interoperability Table | 29 | CY | SBLT | Subledger Type | Character | UDC | 1 | 0 |
107 | F16421 | Rate Master Detail File | 12 | RD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP17: Customer Service Management |
108 | F1721 | Contract Detail | 22 | CD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP17C: Call Management |
109 | F1760 | Time Entry | 2 | ZB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP18: Resource Scheduling |
110 | F186301 | Timecard Templates | 19 | TT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
111 | F186602 | Labor Rules Tag File | 32 | TF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP40: Inventory/OP Base |
112 | F4011Z | Batch Receiver File - Order Details | 199 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
113 | F4211Z1 | Sales Order Detail Unedited Transaction File | 178 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
114 | F43800 | Summary Voucher Match | 11 | PR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP41: Inventory Management |
115 | F4111 | Item Ledger File | 58 | IL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
116 | F41UI001 | Inventory Transactions Detail File | 167 | IT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP42: Sales Management |
117 | F4211 | Sales Order Detail File | 165 | SD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
118 | F42119 | Sales Order History File | 165 | SD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
119 | F42199 | S.O. Detail Ledger File | 165 | SL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
120 | F42800G1 | Sales Update G Batch Detail Workfile | 21 | DG | SBLT | Subledger Type | Character | UDC | 1 | 0 |
121 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 59 | ZD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
122 | F42UI521 | Pick Slips Detail File | 116 | S9 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
123 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 57 | UZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP42B: Sales Order Entry |
124 | F42420 | Audit Log Transaction | 67 | AL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP43: Procurement |
125 | F40910 | Commitment Integrity Report Work File | 5 | P# | SBLT | Subledger Type | Character | UDC | 1 | 0 |
126 | F43080 | Approvals Fields Constants | 5 | PD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
127 | F4311 | Purchase Order Detail File | 130 | PD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
128 | F4311Z | Purchase Order Generator File | 134 | PW | SBLT | Subledger Type | Character | UDC | 1 | 0 |
129 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 143 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
130 | F43121 | Purchase Order Receiver File | 54 | PR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
131 | F43121Z | Receiver workfile | 45 | PW | SBLT | Subledger Type | Character | UDC | 1 | 0 |
132 | F43121Z1 | Receipts Unedited Transaction Table | 71 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
133 | F43147 | Freight Distribution Workfile | 26 | FD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
134 | F4314Z | Voucher Match Selection File | 154 | PN | SBLT | Subledger Type | Character | UDC | 1 | 0 |
135 | F4316 | Purchase Order Multiple Account File | 13 | P3 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
136 | F4316M | Model Purchase Order Multiple Account File | 6 | P4 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
137 | F43199 | P.O. Detail Ledger File - Flexible Version | 130 | OL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
138 | F43UI50D | PO Print Detail Work File | 41 | PW | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP43A: Purchase Order Receipt/Routing |
139 | F43126 | Purchase Order Receiver Multiple Account | 15 | P4 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
140 | F43127 | Purchase Order Receiver Non-Billable | 13 | PR | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP43E: Requisition Self Service |
141 | F43E16 | Requisition Multiple Account File | 14 | P3 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP43Q: Strategic Sourcing |
142 | F43Q11 | Event Detail | 17 | ED | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP44H: Homebuilder Management |
143 | F4453 | Lot Master (World) | 19 | JB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
144 | F44H590 | Closing Worksheet Accounting Instructions | 11 | CI | SBLT | Subledger Type | Character | UDC | 1 | 0 |
145 | F44H591 | Closing Worksheet Entries | 14 | CW | SBLT | Subledger Type | Character | UDC | 1 | 0 |
146 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 46 | CG | SBLT | Subledger Type | Character | UDC | 1 | 0 |
147 | F44H73W2 | Lot Start - Budget Generation Workfile | 6 | BG | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP45: Advanced Pricing |
148 | F4575 | Ship and Debit History | 53 | AH | SBLT | Subledger Type | Character | UDC | 1 | 0 |
149 | F4575TMP | Ship and Debit History - Temp Table | 53 | AH | SBLT | Subledger Type | Character | UDC | 1 | 0 |
150 | F4576 | Ship and Debit Claims | 81 | AC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
151 | F4576TMP | Ship and Debit Claims- Temp Table | 81 | AC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
152 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 78 | Z1 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP47: Electronic Commerce |
153 | F47012 | EDI Purchase Order Detail - Inbound | 200 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
154 | F47017 | EDI Purchase Order Detail - Outbound | 144 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
155 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 144 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
156 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 200 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
157 | F47042 | EDI Invoice Detail - Inbound | 56 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
158 | F47047 | EDI Invoice Detail (Sales) - Outbound | 200 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
159 | F47057 | EDI Payment Order Remittance Advice - Outbound | 102 | D3 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
160 | F47057W | EDI Payment Order Remittance Advice - Work | 102 | D3 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
161 | F47072 | EDI Receiving Advice Detail - Inbound | 145 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
162 | F47077 | EDI Receiving Advice Detail - Outbound | 145 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
163 | F47092 | EDI Request for Quote Detail - Inbound | 200 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
164 | F47097 | EDI Request for Quote Detail - Outbound | 144 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
165 | F47102 | EDI Response to RFQ Detail - Inbound | 144 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
166 | F47107 | EDI Response to RFQ Detail - Outbound | 199 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
167 | F47122 | EDI Product Activity Data Detail - Inbound | 71 | MJ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
168 | F47127 | EDI Product Activity Data Detail - Outbound | 71 | MJ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
169 | F47132 | EDI Purchase Order Change Detail - Inbound | 201 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
170 | F47137 | EDI Purchase Order Change Detail - Outbound | 145 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
171 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 146 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
172 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 202 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
173 | F47157 | EDI Shipping Schedule Detail - Outbound | 153 | SZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP48S: Service Billing |
174 | F4812 | Billing Detail Workfile | 12 | WD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
175 | F4812H | Billing Workfile History | 12 | WD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
176 | F4812HS | Billing Workfile History Purged Save | 12 | WD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
177 | F4822 | Invoice Summary Work File | 20 | W4 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
178 | F4823 | Voucher Summary | 18 | W0 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
179 | F48S0618 | Payroll Reclassification Workfile | 18 | YT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
180 | F48S910 | Billing Detail Journal Workfile | 20 | W2 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
181 | F48S911 | Summarized Journal Workfile | 18 | W3 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
182 | F48S912 | G/L Link | 4 | W6 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
183 | F48S95 | Billing AAI Information | 19 | WV | SBLT | Subledger Type | Character | UDC | 1 | 0 |
184 | F48SUI01 | Billing Detail Print Workfile | 12 | WD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP51: Job Costing |
185 | F5111 | Forecast Detail | 127 | FD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
186 | F5144 | Profit Recognition | 4 | G7 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
187 | F51911 | Draw Reporting Master | 10 | GK | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP52: Contract Billing |
188 | F5202 | Contract Billing Line Detail | 21 | G6 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
189 | F5212 | T and M - Unit Price and Lumpsum Cross Reference Accounts | 12 | G5 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
190 | F5280W | Contract Revenue Summary Work File | 21 | GY | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP52G: Government Contracting |
191 | F4822H | Invoice Summary History | 20 | IH | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP53: Change Management |
192 | F5302 | F5302 World Specs | 15 | DK | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP55: Reserved for Clients |
193 | F74TL004 | Trial Balance Temp File | 11 | TB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
194 | F74T531 | Customer Ledger Tranaction File | 13 | CT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
195 | F74T532 | Supplier Ledger Transaction File | 13 | SL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
196 | F74T550 | General Ledger Work File - Turkish | 24 | DK | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP74: EMEA Localization |
197 | F74900 | Foreign Receivables and Payables - EMEA | 60 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP74H: Hungary |
198 | F741202 | Work File Accumulated Asset Movement Dep - HUN - 74 | 7 | WF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP74P: Poland |
199 | F74902T | Account Balance Tag File - COM - 09 - 74P | 7 | AT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP74R: CIS |
200 | F74R9002 | Correspondence Balance - RUS- 09 - 74R | 42 | GB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
201 | F74R9029 | Open Accounts - RUS - 09 - 74R | 9 | OA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP74S: Spain |
202 | F74S55 | Expenses and Exchange Rate for Payments - Spain - 04 | 10 | Q5 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP74U: United Kingdom Localizations |
203 | F74U0420 | SPC - Application Master - UK - 43 | 19 | SE | SBLT | Subledger Type | Character | UDC | 1 | 0 |
204 | F74U0424 | SPC Subcontractor Payment Liability - UK - 43 | 27 | PL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
205 | F74U0425 | SPC - Certificate Master - UK - 43 | 20 | SF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
206 | F74U420A | SPC Application Amount Drill Down - UK - 43 | 15 | PA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
207 | F74U424A | SPC Subcontractor Accrual Data - UK - 43 | 12 | PL | SBLT | Subledger Type | Character | UDC | 1 | 0 |
208 | F74U424W | SPC Subcontractor Accrual Workfile - UK - 43 | 12 | WF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
209 | F74U4316 | SPC - Purchase Order Line Additional Information - UK - 43 | 45 | SC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP75C: China - Reporting System Only |
210 | F75C015 | Cash Flow Data - China | 21 | CF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
211 | F75C902 | Subsidiary Balances File - China | 4 | SB | LT | Ledger Types | String | UDC | 2 | 0 |
212 | F75C902 | Subsidiary Balances File - China | 5 | SB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP76B: Brazil - Reporting System Only |
213 | F7611B | Nota Fiscal Detail - BRA - 42 | 94 | FD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
214 | F76B901 | IN86- Work Table for Account Master - 09 | 6 | BA | SBLT | Subledger Type | Character | UDC | 1 | 0 |
215 | F76B902 | IN86-Work Table for Account Balance - 09 | 7 | BC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
216 | F76B911 | IN86-Work Table for Journal Entries - 09 | 7 | BD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP76C: Colombia |
217 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 52 | RP | SBLT | Subledger Type | Character | UDC | 1 | 0 |
218 | F76C034A | A/R Check Detail file As Of - COL - 03B | 115 | RZ | SBLT | Subledger Type | Character | UDC | 1 | 0 |
219 | F76C0902 | Debits and Credits T/B by object account - COL - 76C | 19 | GB | SBLT | Subledger Type | Character | UDC | 1 | 0 |
220 | F76C575 | Work File Magnetic Media - COL - 04 | 20 | Q1 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
221 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 13 | DF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
222 | F76C9F11 | DIAN Formats File by Account Id - COL - 09 | 7 | DF | SBLT | Subledger Type | Character | UDC | 1 | 0 |
223 | F76CT1 | Tributary Information - COL - 76C | 19 | TI | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP76H: Chile |
224 | F76H6002 | Indirect Costs Selection EPS F1602 - CHI - 41 - 76H | 10 | I1 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
225 | F76H6003 | Indirect Costs Selection EPS F1642 - CHI - 41 - 76H | 21 | I2 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
226 | F76H6005 | Account ID / Cost Type Relationship - CHI - 41 - 76H | 4 | AC | SBLT | Subledger Type | Character | UDC | 1 | 0 |
227 | F76H902T | Account Balances Tag File - CHI - 09 - 76H | 7 | AT | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP83: Management Reporting - FASTR |
228 | F83UI001 | Balance Audit Work File - (Financial Reporting) | 13 | R1 | SBLT | Subledger Type | Character | UDC | 1 | 0 |
TOP89: Conversion Programs |
229 | F0902A | Account Debit Balances | 7 | GD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
230 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 130 | OL | SBLT | Subledger Type | Character | UDC | 1 | 0 |