	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

242 columns | 920 | SBL

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

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

242 columns | 920 | SBL