	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

157 columns | 920 | LT | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0025	Ledger Type Master File	1	LH	LT	Ledger Types	String	UDC	2	0
2	F0902	Account Balances	5	GB	LT	Ledger Types	String	UDC	2	0
3	F0911	Account Ledger	22	GL	LT	Ledger Types	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
4	F03B117	Revenue Recognition GL Info	34	RL	LT	Ledger Types	String	UDC	2	0
5	F03B119	Revenue Recognition GL Info Audit	7	RN	LT	Ledger Types	String	UDC	2	0
TOP05: Time Accounting and HRM Base
6	F069106	Union Benefits Master	14	Y1	LT	Ledger Types	String	UDC	2	0
TOP05T: Time Entry
7	F063951	Payroll Journal (Compressed) File	7	GL	LT	Ledger Types	String	UDC	2	0
TOP07: Payroll
8	F05290	WF - Payroll Journal (Detail)	7	JR	LT	Ledger Types	String	UDC	2	0
TOP09: General Accounting
9	F0902B	Account Balances - 52 Period Accounting	5	GB	LT	Ledger Types	String	UDC	2	0
10	F0902P	Purge - Account Balances	5	GB	LT	Ledger Types	String	UDC	2	0
11	F0902Z1	Account Balances - Batch File	5	GB	LT	Ledger Types	String	UDC	2	0
12	F0911P	Purge - Account Ledger	22	GL	LT	Ledger Types	String	UDC	2	0
13	F0911R	WF - Account Ledger Reconciliation	22	GL	LT	Ledger Types	String	UDC	2	0
14	F0911R1	Account Reconciliations Header - OneWorld ONLY	8	GL	LT	Ledger Types	String	UDC	2	0
15	F0911Z1	Journal Entry Transactions - Batch File	39	VN	LT	Ledger Types	String	UDC	2	0
16	F0911Z4	F0911 Interoperability Table	44	SZ	LT	Ledger Types	String	UDC	2	0
17	F0912	Cost Allocations/Flex Budgeting	17	RJ	LT	Ledger Types	String	UDC	2	0
18	F0912A	Index Computation Entry File	13	RI	LT	Ledger Types	String	UDC	2	0
19	F09360W	OVFS Column List Work Table	7	CL	LT	Ledger Types	String	UDC	2	0
20	F09370W	OVFS Balance Work Table	5	BW	LT	Ledger Types	String	UDC	2	0
21	F097021W	Account Ledger to Account Master Work Table	17	TA	LT	Ledger Types	String	UDC	2	0
22	F097031W	Account Balance to Account Master Work Table	7	AB	LT	Ledger Types	String	UDC	2	0
23	F09706W	Batch and Company Within Batch Out of Balance Work Table	5	NB	LT	Ledger Types	String	UDC	2	0
24	F09UI004	Variable Numerator Allocations work file	14	R#	LT	Ledger Types	String	UDC	2	0
25	F09UI007	Match Bank Tape to Recon File - ONE WORLD ONLY	15	GL	LT	Ledger Types	String	UDC	2	0
26	F09UI009	Trial Balance Generic Work File - OneWorld ONLY	3	GB	LT	Ledger Types	String	UDC	2	0
27	F09UI010	WorkFile for R097011	5	WF	LT	Ledger Types	String	UDC	2	0
28	F09UI013	Company by Batch Out of Balance	4	GL	LT	Ledger Types	String	UDC	2	0
29	F09UI014	Annual Close Work Table	8	GB	LT	Ledger Types	String	UDC	2	0
30	F09UI015	Indexed Computations Multi-Tiered Entries	22	GL	LT	Ledger Types	String	UDC	2	0
31	F09UI016	Account Balance Compare Exceptions	5	GW	LT	Ledger Types	String	UDC	2	0
32	F09UI123	Advanced Variable Numerator Worktable	19	VW	LT	Ledger Types	String	UDC	2	0
33	F52G02	Burdening Summarized Ledger	4	BS	LT	Ledger Types	String	UDC	2	0
34	F52G11	Burdening Detail Ledger	6	BD	LT	Ledger Types	String	UDC	2	0
35	F52G11WF	Temporary Burdened Detail Ledger Workfile	6	BW	LT	Ledger Types	String	UDC	2	0
36	F52G31WF	Reburdening Transactions Workfile	3	RB	LT	Ledger Types	String	UDC	2	0
37	F52G60	Burden Rate Calculations Workfile	2	BW	LT	Ledger Types	String	UDC	2	0
38	F70UI001	Work File for G/L by Cat. Code Localization	11	WA	LT	Ledger Types	String	UDC	2	0
39	F740911	Work File for G/L Report by Category Code Localization	14	WA	LT	Ledger Types	String	UDC	2	0
TOP10: Financial Reporting
40	F1001	Multi-Site Consolidation Transfer File Header	14	GP	LT	Ledger Types	String	UDC	2	0
41	F1001Z1	Unedited MSC Interoperability Header Table	24	IA	LT	Ledger Types	String	UDC	2	0
42	F10UI520	Cash Flow Statement Worktable	5	CW	LT	Ledger Types	String	UDC	2	0
TOP12: Fixed Assets
43	F12003	Default Depreciation Constants	4	FF	LT	Ledger Types	String	UDC	2	0
44	F1202	Asset Account Balances File	5	FL	LT	Ledger Types	String	UDC	2	0
45	F1202P	Asset Account Balances Purge Table	5	FL	LT	Ledger Types	String	UDC	2	0
46	F1208	Units of Production Schedule Master File	2	FP	LT	Ledger Types	String	UDC	2	0
47	F12141	Disposal Account Rule Table	3	DT	LT	Ledger Types	String	UDC	2	0
48	F12911ER	Post G/L to FA Exceptions Work File	7	GL	LT	Ledger Types	String	UDC	2	0
TOP13E: Equipment Cost Analysis
49	F1383	Equipment Analysis Costs	9	EC	LT	Ledger Types	String	UDC	2	0
50	F1385	Equipment Analysis Rules	3	ER	LT	Ledger Types	String	UDC	2	0
TOP15: Real Estate Management
51	F15302	Ledger Type Groups	3	LT	LT	Ledger Types	String	UDC	2	0
52	F1532B	Expense Participation Audit File	13	NT	LT	Ledger Types	String	UDC	2	0
TOP16: Profit Management (EPS)
53	F1602	Cost Analyzer Balances	5	CB	LT	Ledger Types	String	UDC	2	0
54	F1602Z1	External Cost Analyzer Balances - Interoperability Table	27	CZ	LT	Ledger Types	String	UDC	2	0
55	F1603	Cost Analyzer View Structure	14	CV	LT	Ledger Types	String	UDC	2	0
56	F1610	Cost Calculation Definitions	41	CD	LT	Ledger Types	String	UDC	2	0
57	F1611	Cost Calculation Transactions	14	CT	LT	Ledger Types	String	UDC	2	0
58	F1632	Driver Balances	4	CB	LT	Ledger Types	String	UDC	2	0
59	F1632Z1	External Driver Balances-Interoperability Table	26	CY	LT	Ledger Types	String	UDC	2	0
60	F1642	Rate Master Header File	1	RH	LT	Ledger Types	String	UDC	2	0
TOP39: Advanced Stock Valuation
61	F3910	G/L Adjustment Table	12	SC	LT	Ledger Types	String	UDC	2	0
TOP40: Inventory/OP Base
62	F4011Z	Batch Receiver File - Order Details	197	SZ	LT	Ledger Types	String	UDC	2	0
63	F49211	Sales Order Detail File - Tag File	116	UD	LT	Ledger Types	String	UDC	2	0
64	F49211Z1	Sales Order Detail Tag Unedited Transaction File	135	S1	LT	Ledger Types	String	UDC	2	0
65	F49219	Sales Order Detail - Tag History File	93	UD	LT	Ledger Types	String	UDC	2	0
TOP41: Inventory Management
66	F4115	Item History	6	IH	LT	Ledger Types	String	UDC	2	0
TOP42: Sales Management
67	F42800G	Sales Update G Batch Workfile	15	SG	LT	Ledger Types	String	UDC	2	0
68	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	36	UZ	LT	Ledger Types	String	UDC	2	0
TOP42B: Sales Order Entry
69	F49299	S.O. Detail Tag Ledger File	116	UD	LT	Ledger Types	String	UDC	2	0
TOP43: Procurement
70	F43080	Approvals Fields Constants	128	PD	LT	Ledger Types	String	UDC	2	0
71	F4311	Purchase Order Detail File	124	PD	LT	Ledger Types	String	UDC	2	0
72	F4311Z	Purchase Order Generator File	128	PW	LT	Ledger Types	String	UDC	2	0
73	F4311Z1	Purchase Order Detail Unedited Transaction Table	137	SZ	LT	Ledger Types	String	UDC	2	0
74	F43199	P.O. Detail Ledger File - Flexible Version	124	OL	LT	Ledger Types	String	UDC	2	0
TOP44H: Homebuilder Management
75	F44H590	Closing Worksheet Accounting Instructions	8	CI	LT	Ledger Types	String	UDC	2	0
76	F44H591	Closing Worksheet Entries	11	CW	LT	Ledger Types	String	UDC	2	0
77	F44H611	Bid Details	63	BD	LT	Ledger Types	String	UDC	2	0
78	F44H611W	Bid Details Work File	67	BW	LT	Ledger Types	String	UDC	2	0
79	F44H711	Lot Start Workfile	74	SW	LT	Ledger Types	String	UDC	2	0
80	F44H711Z	HB Lot Start Unedited Transaction File	87	SZ	LT	Ledger Types	String	UDC	2	0
81	F44H71W1	Lot Start Generation Workfile	74	GW	LT	Ledger Types	String	UDC	2	0
TOP47: Electronic Commerce
82	F47012	EDI Purchase Order Detail - Inbound	198	SZ	LT	Ledger Types	String	UDC	2	0
83	F47017	EDI Purchase Order Detail - Outbound	138	SZ	LT	Ledger Types	String	UDC	2	0
84	F47022	EDI P.O. Acknowledgment Detail - Inbound	138	SZ	LT	Ledger Types	String	UDC	2	0
85	F47027	EDI P.O. Acknowledgment Detail - Outbound	198	SZ	LT	Ledger Types	String	UDC	2	0
86	F47047	EDI Invoice Detail (Sales) - Outbound	198	SZ	LT	Ledger Types	String	UDC	2	0
87	F47072	EDI Receiving Advice Detail - Inbound	139	SZ	LT	Ledger Types	String	UDC	2	0
88	F47077	EDI Receiving Advice Detail - Outbound	139	SZ	LT	Ledger Types	String	UDC	2	0
89	F47092	EDI Request for Quote Detail - Inbound	198	SZ	LT	Ledger Types	String	UDC	2	0
90	F47097	EDI Request for Quote Detail - Outbound	138	SZ	LT	Ledger Types	String	UDC	2	0
91	F47102	EDI Response to RFQ Detail - Inbound	138	SZ	LT	Ledger Types	String	UDC	2	0
92	F47107	EDI Response to RFQ Detail - Outbound	197	SZ	LT	Ledger Types	String	UDC	2	0
93	F47132	EDI Purchase Order Change Detail - Inbound	199	SZ	LT	Ledger Types	String	UDC	2	0
94	F47137	EDI Purchase Order Change Detail - Outbound	139	SZ	LT	Ledger Types	String	UDC	2	0
95	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	140	SZ	LT	Ledger Types	String	UDC	2	0
96	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	200	SZ	LT	Ledger Types	String	UDC	2	0
97	F47157	EDI Shipping Schedule Detail - Outbound	147	SZ	LT	Ledger Types	String	UDC	2	0
TOP48S: Service Billing
98	F4812	Billing Detail Workfile	16	WD	LT	Ledger Types	String	UDC	2	0
99	F4812H	Billing Workfile History	16	WD	LT	Ledger Types	String	UDC	2	0
100	F4812HS	Billing Workfile History Purged Save	16	WD	LT	Ledger Types	String	UDC	2	0
101	F48S910	Billing Detail Journal Workfile	24	W2	LT	Ledger Types	String	UDC	2	0
102	F48S911	Summarized Journal Workfile	22	W3	LT	Ledger Types	String	UDC	2	0
103	F48S912	G/L Link	5	W6	LT	Ledger Types	String	UDC	2	0
104	F48S95	Billing AAI Information	21	WV	LT	Ledger Types	String	UDC	2	0
105	F48SUI01	Billing Detail Print Workfile	16	WD	LT	Ledger Types	String	UDC	2	0
TOP51X: In-Memory Project Management
106	F51X0902	Ledger Balances Worktable	7	LB	LT	Ledger Types	String	UDC	2	0
107	F51X0911	Account Ledger Worktable	7	AL	LT	Ledger Types	String	UDC	2	0
108	F51X90	Column Definition Table	5	X1	LT	Ledger Types	String	UDC	2	0
TOP70: Multi-National Products
109	F700911	GL Invoice Number	7	GA	LT	Ledger Types	String	UDC	2	0
TOP74: EMEA Localization
110	F749103	Section Column Definition - EMEA - 74	13	CD	LT	Ledger Types	String	UDC	2	0
111	F749105	Cells Definition - EMEA - 74	11	ED	LT	Ledger Types	String	UDC	2	0
TOP74H: Hungary
112	F741202	Work File Accumulated Asset Movement Dep - HUN - 74	5	WF	LT	Ledger Types	String	UDC	2	0
TOP74P: Poland
113	F74902T	Account Balance Tag File - COM - 09 - 74P	5	AT	LT	Ledger Types	String	UDC	2	0
114	F74P9100	Cash Desk Transaction - POL - 74P	9	CD	LT	Ledger Types	String	UDC	2	0
TOP74R: Russia
115	F74R0018	Russian Tax File - 74R	71	TD	LT	Ledger Types	String	UDC	2	0
116	F74R0100	Petty Cash Transactions - RUS - 00 - 74R	10	PC	LT	Ledger Types	String	UDC	2	0
117	F74R9002	Correspondence Balance - RUS- 09 - 74R	6	GB	LT	Ledger Types	String	UDC	2	0
118	F74R9029	Open Accounts - RUS - 09 - 74R	7	OA	LT	Ledger Types	String	UDC	2	0
TOP74U: United Kingdom Localizations
119	F74U0412	Application Commitment Workfile - UK - 43	7	AC	LT	Ledger Types	String	UDC	2	0
120	F74U0414	Certificate Commitment Workfile - UK - 43	7	CC	LT	Ledger Types	String	UDC	2	0
121	F74U0416	Purchase Order Commitment Workfile - UK - 43	7	PC	LT	Ledger Types	String	UDC	2	0
TOP75C: China
122	F75C015	Cash Flow Data - China	22	CF	LT	Ledger Types	String	UDC	2	0
123	F75C202	Asset Disposal Amounts - CHINA	2	DA	LT	Ledger Types	String	UDC	2	0
124	F75C902	Subsidiary Balances File - China	4	SB	LT	Ledger Types	String	UDC	2	0
125	F75C911	CNAO - E1 Document Number mapping - China	5	DN	LT	Ledger Types	String	UDC	2	0
126	F75C911A	Account Ledger Processing Info- China - 09	5	AL	LT	Ledger Types	String	UDC	2	0
127	F75C912	Transaction-wise Subsidiary Info - China - 09	5	TS	LT	Ledger Types	String	UDC	2	0
128	F75CUI1	China Financial Report Work File - 10	23	CF	LT	Ledger Types	String	UDC	2	0
129	F75CUI2	China Financial Report Staging Work File - 10	5	CF	LT	Ledger Types	String	UDC	2	0
TOP76A: Argentina
130	F76A41	CERG G/L - Lot Detail - ARG - 09 - 76A	8	LD	LT	Ledger Types	String	UDC	2	0
TOP76B: Brazil
131	F76B835	FCONT Account Ledger Operation - 76B	6	AO	LT	Ledger Types	String	UDC	2	0
132	F76B902	IN86-Work Table for Account Balance - 09	15	BC	LT	Ledger Types	String	UDC	2	0
133	F76B911	IN86-Work Table for Journal Entries - 09	20	BD	LT	Ledger Types	String	UDC	2	0
134	F76B937	SPED Book Ledger Types	2	LT	LT	Ledger Types	String	UDC	2	0
TOP76C: Colombia
135	F76C0902	Debits and Credits T/B by object account - COL - 76C	5	GB	LT	Ledger Types	String	UDC	2	0
136	F76C575	Work File Magnetic Media - COL - 04	6	Q1	LT	Ledger Types	String	UDC	2	0
137	F76C9415	Workfile for Dialy Book - COL - 09	12	LD	LT	Ledger Types	String	UDC	2	0
138	F76C9F02	DIAN Formats by AccountID - COL - 09	8	DF	LT	Ledger Types	String	UDC	2	0
139	F76C9F11	DIAN Formats File by Account Id - COL - 09	5	DF	LT	Ledger Types	String	UDC	2	0
140	F76CT1	Tributary Information - COL - 76C	6	TI	LT	Ledger Types	String	UDC	2	0
TOP76H: Chile
141	F76H6001	Actual Cost Process Header - CHI - 41 - 76H	11	PH	LT	Ledger Types	String	UDC	2	0
142	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	8	I1	LT	Ledger Types	String	UDC	2	0
143	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	5	I2	LT	Ledger Types	String	UDC	2	0
144	F76H6005	Account ID / Cost Type Relationship - CHI - 41 - 76H	1	AC	LT	Ledger Types	String	UDC	2	0
145	F76H6201	Replacement Cost Process Header - CHI - 41	10	RH	LT	Ledger Types	String	UDC	2	0
146	F76H902T	Account Balances Tag File - CHI - 09 - 76H	5	AT	LT	Ledger Types	String	UDC	2	0
TOP76M: Mexico
147	F76M990	GL VAT on Gain/loss MEX - 76M	6	GL	LT	Ledger Types	String	UDC	2	0
TOP76P: Peru
148	F76P502	Asset ledger set up - PER - 12 - 76P	4	AL	LT	Ledger Types	String	UDC	2	0
TOP83: Management Reporting - FASTR
149	F83UI001	Balance Audit Work File - (Financial Reporting)	10	R1	LT	Ledger Types	String	UDC	2	0
TOP89: Conversion Programs
150	F0902A	Account Debit Balances	5	GD	LT	Ledger Types	String	UDC	2	0
151	F0911T	Needed for upgrade for XE and below	5	GL	LT	Ledger Types	String	UDC	2	0
152	F42119B	Sales Order History File - temporary for upgrade (2)	11	SD	LT	Ledger Types	String	UDC	2	0
153	F4211B	Sales Order Detail File - temporary for upgrade (2)	11	SD	LT	Ledger Types	String	UDC	2	0
154	F43199A	Temp F43199 for ERP 9.0 Upgrade	124	OL	LT	Ledger Types	String	UDC	2	0
TOPH95: Object and Environment Tech
155	F8304	FASTR - Column Specifications Master File	10	R4	LT	Ledger Types	String	UDC	2	0
156	F8305	FASTR - Row Specifications Master File	7	R5	LT	Ledger Types	String	UDC	2	0
157	F8306	FASTR - Cell Specifications Master File	7	R6	LT	Ledger Types	String	UDC	2	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 09 / LT (Ledger Types) stock values

	Value	Description	Special Handling Code	Hard Coded
1	AA	General Ledger		N
2	AC	Consolidations Ledger		N
3	AD	As If Restatement Ledger		N
4	AU	General Ledger Units		N
5	AX	Cost Markup/Billing Ledger		N
6	AZ	Cash Basis		N
7	B1	Revised Budget 1		N
8	B2	Revised Budget 2		N
9	B3	Budget Ledger Amount - 3rd		N
10	BA	Budget Amount		N
11	BF	Budget Forecast		N
12	BU	Budget Ledger Units		N
13	BX	Budget Assumptions - Dollars		N
14	BZ	Budget Assumptions-Statistics		N
15	CA	Foreign Currency		N
16	CD	Foreign Currency-Direct Update		N
17	CU	Foreign Currency - Units		N
18	D1	Tax Ledger		N
19	D2	State - 150% Decline Bal		N
20	D3	Earn. & Profit-MACRS		N
21	D4	Alter. Minimum-200%		N
22	D5	MACRS Alternative		N
23	D7	Revaluation Ledger		N
24	E2	Committed Out of Scope		N
25	E3	Proceed in Scope		N
26	E4	Proceed Out of Scope		N
27	E5	Anticipated in Scope		N
28	E6	Anticipated Other Estimate		N
29	E7	Potential Out of Scope		N
30	EU	Change Management Units		N
31	F%	Percent of Job Complete		N
32	FA	Field Progress Amounts		N
33	FE	Field Estimate Ledger		N
34	FI	Financial Information		N
35	FM	Stored Materials		N
36	FU	Field Progress Units		N
37	GA	Actual Lease Revenues		N
38	GP	GAAP Adjustments		N
39	GU	Unit Square Footage Amounts		N
40	H%	Percent Complete		N
41	HA	Projected Final Amount		N
42	HU	Projected Final Units		N
43	IA	Job Cost Projection Budget Amt		N
44	IU	Job Cost Projection Budget Qty		N
45	JA	Job Cost Budget Amount		N
46	JU	Job Budgeted Units		N
47	KA	Notice to Proceed - Amounts		N
48	KU	Notice to Proceed - Units		N
49	LA	Request Budget Changes Amount		N
50	LU	Request Budget Changes Units		N
51	MA	Memo Budget Changes Amount		N
52	MU	Memo Budget Changes Units		N
53	NA	Notice to Proceed - Amounts		N
54	NI	Net Insider Ledger		N
55	NT	Notice to Proceed - Units		N
56	NU	Net Insider Units Ledger		N
57	PA	PO/Contract Amount		N
58	PR	Monthly Production		N
59	PU	PO/Contract Units		N
60	RA	Remaining Unit Rate		N
61	RO	Encumbrance Rollover		N
62	SA	Speculative Lease Amounts		N
63	TA	Book To Tax Ledger		N
64	TB	`754` Basis Adjustments		N
65	TF	Book To Tax Ledger - As If		N
66	TX	1099 Adjustment		N
67	U1	U1 through U9 client reserved		N
68	UA	UA through UZ client reserved		N
69	XA	Alternate Ledger	USD	N
70	XT	Transfer Cost Ledger		N
71	YA	Domestic Origin		N
72	ZA	Foreign Origin	USD	N
73	ZU	Cash Basis Units		N

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

157 columns | 920 | LT | STOCK UDC

TOPUDC 09 / LT (Ledger Types) stock values