	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

127 columns | 812 | 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
4	F0911T	Account Ledger Tag File	5	GL	LT	Ledger Types	String	UDC	2	0
TOP05: Time Accounting and HRM Base
5	F069106	Union Benefits Master	14	Y1	LT	Ledger Types	String	UDC	2	0
TOP05T: Time Entry
6	F063951	Payroll Journal (Compressed) File	7	GL	LT	Ledger Types	String	UDC	2	0
TOP07: Payroll
7	F05290	WF - Payroll Journal (Detail)	7	JR	LT	Ledger Types	String	UDC	2	0
TOP09: General Accounting
8	F0902B	Account Balances - 52 Period Accounting	5	GB	LT	Ledger Types	String	UDC	2	0
9	F0902P	Purge - Account Balances	5	GB	LT	Ledger Types	String	UDC	2	0
10	F0902Z1	Account Balances - Batch File	5	GB	LT	Ledger Types	String	UDC	2	0
11	F0911P	Purge - Account Ledger	22	GL	LT	Ledger Types	String	UDC	2	0
12	F0911R	WF - Acct Ledger File for Reconciliation	22	GL	LT	Ledger Types	String	UDC	2	0
13	F0911R1	Account Reconciliations Header - OneWorld ONLY	8	GL	LT	Ledger Types	String	UDC	2	0
14	F0911Z1	Journal Entry Transactions - Batch File	39	VN	LT	Ledger Types	String	UDC	2	0
15	F0911Z4	F0911 Interoperability Table	44	SZ	LT	Ledger Types	String	UDC	2	0
16	F0912	Cost Allocations/Flex Budgeting	17	RJ	LT	Ledger Types	String	UDC	2	0
17	F0912A	Index Computation Entry File	13	RI	LT	Ledger Types	String	UDC	2	0
18	F09UI004	Variable Numerator Allocations work file	14	R#	LT	Ledger Types	String	UDC	2	0
19	F09UI007	Match Bank Tape to Recon File - ONE WORLD ONLY	15	GL	LT	Ledger Types	String	UDC	2	0
20	F09UI009	Trial Balance Generic Work File - OneWorld ONLY	3	GB	LT	Ledger Types	String	UDC	2	0
21	F09UI010	WorkFile for R097011	5	WF	LT	Ledger Types	String	UDC	2	0
22	F09UI013	Company by Batch Out of Balance	4	GL	LT	Ledger Types	String	UDC	2	0
23	F09UI014	Annual Close Work Table	8	GB	LT	Ledger Types	String	UDC	2	0
24	F09UI015	Indexed Computations Multi-Tiered Entries	22	GL	LT	Ledger Types	String	UDC	2	0
25	F09UI016	Account Balance Compare Exceptions	5	GW	LT	Ledger Types	String	UDC	2	0
26	F70UI001	Work File for G/L by Cat. Code Localization	11	WA	LT	Ledger Types	String	UDC	2	0
27	F740911	Work File for G/L Report by Category Code Localization	14	WA	LT	Ledger Types	String	UDC	2	0
TOP10: Financial Reporting
28	F1001	Multi-Site Consolidation Transfer File Header	14	GP	LT	Ledger Types	String	UDC	2	0
29	F1001Z1	Unedited MSC Interoperability Header Table	24	IA	LT	Ledger Types	String	UDC	2	0
30	F10UI520	Cash Flow Statement Worktable	5	CW	LT	Ledger Types	String	UDC	2	0
TOP12: Fixed Assets
31	F12003	Default Depreciation Constants	4	FF	LT	Ledger Types	String	UDC	2	0
32	F1202	Asset Account Balances File	5	FL	LT	Ledger Types	String	UDC	2	0
33	F1202P	Asset Account Balances Purge Table	5	FL	LT	Ledger Types	String	UDC	2	0
34	F1208	Units of Production Schedule Master File	2	FP	LT	Ledger Types	String	UDC	2	0
35	F12141	Disposal Account Rule Table	3	DT	LT	Ledger Types	String	UDC	2	0
36	F12911ER	Post G/L to FA Exceptions Work File	7	GL	LT	Ledger Types	String	UDC	2	0
TOP13E: Equipment Cost Analysis
37	F1383	Equipment Analysis Costs	9	EC	LT	Ledger Types	String	UDC	2	0
38	F1385	Equipment Analysis Rules	3	ER	LT	Ledger Types	String	UDC	2	0
TOP15: Property Management
39	F1532B	Expense Participation Audit File	13	NT	LT	Ledger Types	String	UDC	2	0
TOP16: Profit Management (EPS)
40	F1602	Cost Analyzer Balances	5	CB	LT	Ledger Types	String	UDC	2	0
41	F1602Z1	External Cost Analyzer Balances - Interoperability Table	27	CZ	LT	Ledger Types	String	UDC	2	0
42	F1603	Cost Analyzer View Structure	14	CV	LT	Ledger Types	String	UDC	2	0
43	F1610	Cost Calculation Definitions	41	CD	LT	Ledger Types	String	UDC	2	0
44	F1611	Cost Calculation Transactions	14	CT	LT	Ledger Types	String	UDC	2	0
45	F1632	Driver Balances	4	CB	LT	Ledger Types	String	UDC	2	0
46	F1632Z1	External Driver Balances-Interoperability Table	26	CY	LT	Ledger Types	String	UDC	2	0
47	F1642	Rate Master Header File	1	RH	LT	Ledger Types	String	UDC	2	0
TOP39: Advanced Stock Valuation
48	F3910	G/L Adjustment Table	12	SC	LT	Ledger Types	String	UDC	2	0
TOP40: Inventory/OP Base
49	F4011Z	Batch Receiver File - Order Details	197	SZ	LT	Ledger Types	String	UDC	2	0
50	F49211	Sales Order Detail File - Tag File	116	UD	LT	Ledger Types	String	UDC	2	0
51	F49211Z1	Sales Order Detail Tag Unedited Transaction File	135	S1	LT	Ledger Types	String	UDC	2	0
52	F49219	Sales Order Detail - Tag History File	93	UD	LT	Ledger Types	String	UDC	2	0
TOP41: Inventory Management
53	F4115	Item History	6	IH	LT	Ledger Types	String	UDC	2	0
TOP42: Sales Management
54	F42800G	Sales Update G Batch Workfile	15	SG	LT	Ledger Types	String	UDC	2	0
55	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	36	UZ	LT	Ledger Types	String	UDC	2	0
TOP42B: Sales Order Entry
56	F49299	S.O. Detail Tag Ledger File	116	UD	LT	Ledger Types	String	UDC	2	0
TOP43: Procurement
57	F43080	Approvals Fields Constants	128	PD	LT	Ledger Types	String	UDC	2	0
58	F4311	Purchase Order Detail File	124	PD	LT	Ledger Types	String	UDC	2	0
59	F4311Z	Purchase Order Generator File	128	PW	LT	Ledger Types	String	UDC	2	0
60	F4311Z1	Purchase Order Detail Unedited Transaction Table	137	SZ	LT	Ledger Types	String	UDC	2	0
61	F43199	P.O. Detail Ledger File - Flexible Version	124	OL	LT	Ledger Types	String	UDC	2	0
TOP44H: Homebuilder Management
62	F44H590	Closing Worksheet Accounting Instructions	8	CI	LT	Ledger Types	String	UDC	2	0
63	F44H591	Closing Worksheet Entries	11	CW	LT	Ledger Types	String	UDC	2	0
64	F44H611	Bid Details	63	BD	LT	Ledger Types	String	UDC	2	0
65	F44H611W	Bid Details Work File	67	BW	LT	Ledger Types	String	UDC	2	0
66	F44H711	Lot Start Workfile	74	SW	LT	Ledger Types	String	UDC	2	0
67	F44H711Z	HB Lot Start Unedited Transaction File	87	SZ	LT	Ledger Types	String	UDC	2	0
68	F44H71W1	Lot Start Generation Workfile	74	GW	LT	Ledger Types	String	UDC	2	0
TOP47: Electronic Commerce
69	F47012	EDI Purchase Order Detail - Inbound	198	SZ	LT	Ledger Types	String	UDC	2	0
70	F47017	EDI Purchase Order Detail - Outbound	138	SZ	LT	Ledger Types	String	UDC	2	0
71	F47022	EDI P.O. Acknowledgment Detail - Inbound	138	SZ	LT	Ledger Types	String	UDC	2	0
72	F47027	EDI P.O. Acknowledgment Detail - Outbound	198	SZ	LT	Ledger Types	String	UDC	2	0
73	F47047	EDI Invoice Detail (Sales) - Outbound	198	SZ	LT	Ledger Types	String	UDC	2	0
74	F47072	EDI Receiving Advice Detail - Inbound	139	SZ	LT	Ledger Types	String	UDC	2	0
75	F47077	EDI Receiving Advice Detail - Outbound	139	SZ	LT	Ledger Types	String	UDC	2	0
76	F47092	EDI Request for Quote Detail - Inbound	198	SZ	LT	Ledger Types	String	UDC	2	0
77	F47097	EDI Request for Quote Detail - Outbound	138	SZ	LT	Ledger Types	String	UDC	2	0
78	F47102	EDI Response to RFQ Detail - Inbound	138	SZ	LT	Ledger Types	String	UDC	2	0
79	F47107	EDI Response to RFQ Detail - Outbound	197	SZ	LT	Ledger Types	String	UDC	2	0
80	F47132	EDI Purchase Order Change Detail - Inbound	199	SZ	LT	Ledger Types	String	UDC	2	0
81	F47137	EDI Purchase Order Change Detail - Outbound	139	SZ	LT	Ledger Types	String	UDC	2	0
82	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	140	SZ	LT	Ledger Types	String	UDC	2	0
83	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	200	SZ	LT	Ledger Types	String	UDC	2	0
84	F47157	EDI Shipping Schedule Detail - Outbound	147	SZ	LT	Ledger Types	String	UDC	2	0
TOP48S: Service Billing
85	F4812	Billing Detail Workfile	16	WD	LT	Ledger Types	String	UDC	2	0
86	F4812H	Billing Workfile - History	16	WD	LT	Ledger Types	String	UDC	2	0
87	F4812HS	Billing Workfile History Purged Save	16	WD	LT	Ledger Types	String	UDC	2	0
88	F48S910	Billing Detail Journal File	24	W2	LT	Ledger Types	String	UDC	2	0
89	F48S911	Compressed Journal File	22	W3	LT	Ledger Types	String	UDC	2	0
90	F48S912	G/L Link File	5	W6	LT	Ledger Types	String	UDC	2	0
91	F48S95	Billing AAI Information	21	WV	LT	Ledger Types	String	UDC	2	0
92	F48SUI01	Billing Detail Print Workfile	16	WD	LT	Ledger Types	String	UDC	2	0
TOP57: Reserved for Clients
93	F74T550	General Ledger Work File - Turkish	25	DK	LT	Ledger Types	String	UDC	2	0
94	F74T550B	General Ledger PO Work File - Turkish	12	PO	LT	Ledger Types	String	UDC	2	0
TOP74: EMEA Localization
95	F749103	Section Column Definition - EMEA - 74	13	CD	LT	Ledger Types	String	UDC	2	0
96	F749105	Cells Definition - EMEA - 74	11	ED	LT	Ledger Types	String	UDC	2	0
TOP74H: Hungary
97	F741202	Work File Accumulated Asset Movement Dep - HUN - 74	5	WF	LT	Ledger Types	String	UDC	2	0
TOP74P: Poland
98	F74902T	Account Balance Tag File - COM - 09 - 74P	5	AT	LT	Ledger Types	String	UDC	2	0
99	F74P9100	Cash Desk Transaction - POL - 74P	9	CD	LT	Ledger Types	String	UDC	2	0
TOP74R: CIS
100	F74R0018	Russian Tax File - 74R	71	TD	LT	Ledger Types	String	UDC	2	0
101	F74R0100	Petty Cash Transactions - RUS - 00 - 74R	10	PC	LT	Ledger Types	String	UDC	2	0
102	F74R9002	Correspondence Balance - RUS- 09 - 74R	6	GB	LT	Ledger Types	String	UDC	2	0
103	F74R9029	Open Accounts - RUS - 09 - 74R	7	OA	LT	Ledger Types	String	UDC	2	0
TOP75C: China - Reporting System Only
104	F75CUI1	China Financial Report Work File - 10	23	CF	LT	Ledger Types	String	UDC	2	0
105	F75CUI2	China Financial Report Staging Work File - 10	5	CF	LT	Ledger Types	String	UDC	2	0
TOP76A: Argentina
106	F76A41	CERG G/L - Lot Detail - ARG - 09 - - 09	8	LD	LT	Ledger Types	String	UDC	2	0
TOP76B: Brazil - Reporting System Only
107	F76B902	IN86-Work Table for Account Balance - 09	15	BC	LT	Ledger Types	String	UDC	2	0
108	F76B911	IN86-Work Table for Journal Entries - 09	20	BD	LT	Ledger Types	String	UDC	2	0
TOP76C: Colombia
109	F76C0902	Debits and Credits T/B by object account - COL - 76C	5	GB	LT	Ledger Types	String	UDC	2	0
110	F76C575	Work File Magnetic Media - COL - 04	6	Q1	LT	Ledger Types	String	UDC	2	0
111	F76C9415	Workfile for Dialy Book - COL - 09	12	LD	LT	Ledger Types	String	UDC	2	0
112	F76CT1	Tributary Information - COL - 76C	6	TI	LT	Ledger Types	String	UDC	2	0
TOP76H: Chile
113	F76H6001	Actual Cost Process Header - CHI - 41 - 76H	11	PH	LT	Ledger Types	String	UDC	2	0
114	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	8	I1	LT	Ledger Types	String	UDC	2	0
115	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	5	I2	LT	Ledger Types	String	UDC	2	0
116	F76H6005	Account ID / Cost Type Relationship - CHI - 41 - 76H	1	AC	LT	Ledger Types	String	UDC	2	0
117	F76H6201	Replacement Cost Process Header - CHI - 41	10	RH	LT	Ledger Types	String	UDC	2	0
118	F76H902T	Account Balances Tag File - CHI - 09 - 76H	5	AT	LT	Ledger Types	String	UDC	2	0
TOP76P: Peru
119	F76P502	Asset ledger set up - PER - 12 - 76P	4	AL	LT	Ledger Types	String	UDC	2	0
TOP83: Management Reporting - FASTR
120	F83UI001	Balance Audit Work File - (Financial Reporting)	10	R1	LT	Ledger Types	String	UDC	2	0
TOP89: Conversion Programs
121	F0902A	Account Debit Balances	5	GD	LT	Ledger Types	String	UDC	2	0
122	F42119B	Sales Order History File - temporary for upgrade (2)	11	SD	LT	Ledger Types	String	UDC	2	0
123	F4211B	Sales Order Detail File - temporary for upgrade (2)	11	SD	LT	Ledger Types	String	UDC	2	0
124	F43199A	Temp F43199 for ERP 9.0 Upgrade	124	OL	LT	Ledger Types	String	UDC	2	0
TOPH95: Tech Resources/Applications
125	F8304	FASTR - Column Specifications Master File	10	R4	LT	Ledger Types	String	UDC	2	0
126	F8305	FASTR - Row Specifications Master File	7	R5	LT	Ledger Types	String	UDC	2	0
127	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	B2	Revised Budget		N
8	B3	Budget Ledger Amount - 3rd		N
9	BA	Budget Amount		N
10	BU	Budget Ledger Units		N
11	BX	Budget Assumptions - Dollars		N
12	BZ	Budget Assumptions-Statistics		N
13	CA	Foreign Currency		N
14	CD	Foreign Currency-Direct Update		N
15	CU	Foreign Currency - Units		N
16	D1	Federal Tax -Book1		N
17	D2	State - 150% Decline Bal		N
18	D3	Earn. & Profit-MACRS		N
19	D4	Alter. Minimum-200%		N
20	D5	MACRS Alternative		N
21	D7	Revaluation Ledger		N
22	E2	Committed Out of Scope		N
23	E3	Proceed in Scope		N
24	E4	Proceed Out of Scope		N
25	E5	Anticipated in Scope		N
26	E6	Anticipated Other Estimate		N
27	E7	Potential Out of Scope		N
28	EU	Change Management Units		N
29	F%	Percent of Job Complete		N
30	FA	Field Progress Amounts		N
31	FE	Field Estimate Ledger		N
32	FI	Financial Information		N
33	FM	Stored Materials		N
34	FU	Field Progress Units		N
35	GA	Actual Lease Revenues		N
36	GP	GAAP Adjustments		N
37	GU	Unit Square Footage Amounts		N
38	H%	Percent Complete		N
39	HA	Projected Final Amount		N
40	HU	Projected Final Units		N
41	IA	Job Cost Projection Budget Amt		N
42	JA	Job Cost Budget Amount		N
43	JU	Job Budgeted Units		N
44	KA	Notice to Proceed - Amounts		N
45	KU	Notice to Proceed - Units		N
46	LA	Request Budget Changes Amount		N
47	LU	Request Budget Changes Units		N
48	MA	Memo Budget Changes Amount		N
49	MU	Memo Budget Changes Units		N
50	NA	Notice to Proceed - Amounts		N
51	NI	Net Insider Ledger		N
52	NT	Notice to Proceed - Units		N
53	NU	Net Insider Units Ledger		N
54	PA	PO/Contract Amount		N
55	PR	Monthly Production		N
56	PU	PO/Contract Units		N
57	RA	Remaining Unit Rate		N
58	RO	Encumbrance Rollover		N
59	SA	Speculative Lease Amounts		N
60	TA	Book To Tax Ledger		N
61	TB	`754` Basis Adjustments		N
62	TF	Book To Tax Ledger - As If		N
63	TX	1099 Adjustment		N
64	U2	Opening Accounts		N
65	XA	Alternate Ledger	USD	N
66	XT	Transfer Cost Ledger		N
67	YA	Domestic Origin		N
68	ZA	Foreign Origin	USD	N
69	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

127 columns | 812 | LT | STOCK UDC

TOPUDC 09 / LT (Ledger Types) stock values