	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

95 columns | 910 | ODCT | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	43	GL	ODCT	Document Type - Original	String	UDC	2	0
TOP03: Accounts Receivable
2	F0311	Accounts Receivable Ledger	76	RP	ODCT	Document Type - Original	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
3	F03B11	Customer Ledger	71	RP	ODCT	Document Type - Original	String	UDC	2	0
4	F03B112	Invoice Revisions	7	RW	ODCT	Document Type - Original	String	UDC	2	0
5	F03B112P	Invoice Revisions Purge File	7	RW	ODCT	Document Type - Original	String	UDC	2	0
6	F03B11P	Customer Ledger Purge File	71	RP	ODCT	Document Type - Original	String	UDC	2	0
7	F03B11Z1	Batch Invoices	87	VJ	ODCT	Document Type - Original	String	UDC	2	0
8	F03B11Z2	F03B11 Interoperability Table	84	SY	ODCT	Document Type - Original	String	UDC	2	0
9	F03B14	Receipts Detail	81	RZ	ODCT	Document Type - Original	String	UDC	2	0
10	F03B14P	Receipts Detail Purge File	81	RZ	ODCT	Document Type - Original	String	UDC	2	0
11	F03B14Z2	F03B14 Interoperability Table	94	SZ	ODCT	Document Type - Original	String	UDC	2	0
12	F03B40	A/R Deduction Management	15	RB	ODCT	Document Type - Original	String	UDC	2	0
13	F03B575	Auto Debit Invoice Select and Build	80	RD	ODCT	Document Type - Original	String	UDC	2	0
14	F09UI011	Receipt Prepost Work File	47	GL	ODCT	Document Type - Original	String	UDC	2	0
TOP04: Accounts Payable
15	F0411	Accounts Payable Ledger	57	RP	ODCT	Document Type - Original	String	UDC	2	0
16	F0411A	WF - As Of Accounts Payable Ledger	57	RP	ODCT	Document Type - Original	String	UDC	2	0
17	F0411P	Purge - Accounts Payable Ledger	57	RP	ODCT	Document Type - Original	String	UDC	2	0
18	F0411Z1	Voucher Transactions - Batch Upload	75	VL	ODCT	Document Type - Original	String	UDC	2	0
19	F0411Z3	F0411 Interoperability Table	80	SZ	ODCT	Document Type - Original	String	UDC	2	0
20	F09UI005	Tax Offsets User Index	52	GL	ODCT	Document Type - Original	String	UDC	2	0
TOP09: General Accounting
21	F0911P	Purge - Account Ledger	43	GL	ODCT	Document Type - Original	String	UDC	2	0
22	F0911Z1	Journal Entry Transactions - Batch File	60	VN	ODCT	Document Type - Original	String	UDC	2	0
23	F0911Z4	F0911 Interoperability Table	65	SZ	ODCT	Document Type - Original	String	UDC	2	0
24	F09UI015	Indexed Computations Multi-Tiered Entries	43	GL	ODCT	Document Type - Original	String	UDC	2	0
TOP15: Property Management
25	F1511	Tenant/Lease Billings Detail	83	NJ	ODCT	Document Type - Original	String	UDC	2	0
26	F1511B	Lease Billings Master	79	NJ	ODCT	Document Type - Original	String	UDC	2	0
27	F1511H	Tenant/Lease Billings Detail History	82	N#	ODCT	Document Type - Original	String	UDC	2	0
28	F1511HB	Lease Billings History	78	NC	ODCT	Document Type - Original	String	UDC	2	0
TOP40: Inventory/OP Base
29	F4011Z	Batch Receiver File - Order Details	119	SZ	ODCT	Document Type - Original	String	UDC	2	0
30	F4211Z1	Sales Order Detail Unedited Transaction File	113	SZ	ODCT	Document Type - Original	String	UDC	2	0
TOP42: Sales Management
31	F4211	Sales Order Detail File	100	SD	ODCT	Document Type - Original	String	UDC	2	0
32	F42119	Sales Order History File	100	SD	ODCT	Document Type - Original	String	UDC	2	0
33	F42199	S.O. Detail Ledger File	100	SL	ODCT	Document Type - Original	String	UDC	2	0
34	F42565	Invoice Print File	167	IW	ODCT	Document Type - Original	String	UDC	2	0
35	F42UI11	SO Detail Cache File (MBF)	78	ZD	ODCT	Document Type - Original	String	UDC	2	0
TOP43: Procurement
36	F4311Z	Purchase Order Generator File	220	PW	ODCT	Document Type - Original	String	UDC	2	0
TOP45: Advanced Pricing
37	F4576Z1	Ship and Debit Claims Unedited Transaction Table	147	Z1	ODCT	Document Type - Original	String	UDC	2	0
TOP47: Electronic Commerce
38	F47012	EDI Purchase Order Detail - Inbound	120	SZ	ODCT	Document Type - Original	String	UDC	2	0
39	F47027	EDI P.O. Acknowledgment Detail - Outbound	120	SZ	ODCT	Document Type - Original	String	UDC	2	0
40	F47037	EDI Shipping Notice Detail - Outbound	110	SZ	ODCT	Document Type - Original	String	UDC	2	0
41	F470371	EDI Shipping Notice Detail - Outbound	126	SZ	ODCT	Document Type - Original	String	UDC	2	0
42	F47047	EDI Invoice Detail (Sales) - Outbound	120	SZ	ODCT	Document Type - Original	String	UDC	2	0
43	F47057	EDI Payment Order Remittance Advice - Outbound	44	D3	ODCT	Document Type - Original	String	UDC	2	0
44	F47057W	EDI Payment Order Remittance Advice - Work	44	D3	ODCT	Document Type - Original	String	UDC	2	0
45	F47092	EDI Request for Quote Detail - Inbound	120	SZ	ODCT	Document Type - Original	String	UDC	2	0
46	F47107	EDI Response to RFQ Detail - Outbound	120	SZ	ODCT	Document Type - Original	String	UDC	2	0
47	F47132	EDI Purchase Order Change Detail - Inbound	121	SZ	ODCT	Document Type - Original	String	UDC	2	0
48	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	122	SZ	ODCT	Document Type - Original	String	UDC	2	0
TOP48S: Service Billing
49	F4812	Billing Detail Workfile	21	WD	ODCT	Document Type - Original	String	UDC	2	0
50	F4812H	Billing Workfile History	21	WD	ODCT	Document Type - Original	String	UDC	2	0
51	F4812HS	Billing Workfile History Purged Save	21	WD	ODCT	Document Type - Original	String	UDC	2	0
52	F48SUI01	Billing Detail Print Workfile	21	WD	ODCT	Document Type - Original	String	UDC	2	0
TOP49: Transportation Management
53	F4981	Freight Audit History	43	FH	ODCT	Document Type - Original	String	UDC	2	0
TOP55: Reserved for Clients
54	F74H1051	Invoicing Workfile - New	31	IW	ODCT	Document Type - Original	String	UDC	2	0
55	F74P0710	Credit Order History	14	PL	ODCT	Document Type - Original	String	UDC	2	0
TOP70: Multi-National Products - obsolete-do not reuse
56	F704001	Payment WH Info TEMP - COMM - 04	7	PT	ODCT	Document Type - Original	String	UDC	2	0
57	F704002	Payment WH Info - COMM - 04	6	PF	ODCT	Document Type - Original	String	UDC	2	0
58	F704002P	Payment WH Info Purge - COMM - 04	6	PF	ODCT	Document Type - Original	String	UDC	2	0
TOP74: EMEA Localization
59	F7430015	Invoices Related to AR DN/CN - COMM - 03B	5	DR	ODCT	Document Type - Original	String	UDC	2	0
TOP74H: Hungary
60	F74H309	Gains & Losses Unrealized Account ing - HUN - 03B	5	GL	ODCT	Document Type - Original	String	UDC	2	0
61	F74H409	A/P Gains & Losses Unrealized Accounting - HUN - 04	5	GL	ODCT	Document Type - Original	String	UDC	2	0
TOP74P: Poland
62	F74P411H	F0411 Header File - POL - 04 - 74P	6	P4	ODCT	Document Type - Original	String	UDC	2	0
TOP74R: CIS
63	F74R3037	Adjustment Invoice Relationship in AR/SOP - RUS - 74R	5	AR	ODCT	Document Type - Original	String	UDC	2	0
TOP74Y: Italy - Reporting System Only
64	F74Y015	Yearly List Declaration - WF - IT - 00	29	YL	ODCT	Document Type - Original	String	UDC	2	0
65	F74Y018	Intrastat Additional Info for Services - ITA - 00	14	IA	ODCT	Document Type - Original	String	UDC	2	0
66	F74Y171	Contract Relations - IT - 00	15	CR	ODCT	Document Type - Original	String	UDC	2	0
67	F74Y315	Invoices Related to AR DN/CN - ITA - 03B	6	RI	ODCT	Document Type - Original	String	UDC	2	0
68	F74Y415	Vouchers Related to AP DN/CN - ITA - 04	7	RV	ODCT	Document Type - Original	String	UDC	2	0
TOP74Z: Czech Republic
69	F74Z0010	Cash Desk Document Printed - CZE - 74Z	6	ZO	ODCT	Document Type - Original	String	UDC	2	0
TOP75I: India
70	F75I3574	Consignment - Issues/Receipts Transactions	26	CT	ODCT	Document Type - Original	String	UDC	2	0
71	F75I3576	Stock Transfer - Work Orders	11	SW	ODCT	Document Type - Original	String	UDC	2	0
72	F75I380	Excise - RG-1 - Transaction File - IND	20	RG	ODCT	Document Type - Original	String	UDC	2	0
73	F75I411	F0411 Tag File - IN - 04	13	TF	ODCT	Document Type - Original	String	UDC	2	0
TOP75T: Taiwan
74	F75T004Z	GUI/VAT Transaction Header - Work - 75T	4	ZH	ODCT	Document Type - Original	String	UDC	2	0
75	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	4	ZD	ODCT	Document Type - Original	String	UDC	2	0
TOP76A: Argentina
76	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	42	HF	ODCT	Document Type - Original	String	UDC	2	0
77	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	42	HF	ODCT	Document Type - Original	String	UDC	2	0
78	F76A81	A/P Payment Control Group File - ARG - 04 - 76A	23	C5	ODCT	Document Type - Original	String	UDC	2	0
79	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	34	C6	ODCT	Document Type - Original	String	UDC	2	0
80	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	42	HF	ODCT	Document Type - Original	String	UDC	2	0
TOP76B: Brazil - Reporting System Only
81	F76B0411	Voucher Additional Information Brazil - 04	24	VB	ODCT	Document Type - Original	String	UDC	2	0
82	F76B473T	F04573 Brazilian Temp WH File - BR - 04	28	W3	ODCT	Document Type - Original	String	UDC	2	0
TOP76C: Colombia
83	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	70	RP	ODCT	Document Type - Original	String	UDC	2	0
84	F76C034A	A/R Check Detail file As Of - COL - 03B	81	RZ	ODCT	Document Type - Original	String	UDC	2	0
85	F76C575	Work File Magnetic Media - COL - 04	47	Q1	ODCT	Document Type - Original	String	UDC	2	0
TOP76H: Chile
86	F76H3B15	NC/ND - Invoice Related - CHI - 03B - 76H	5	IR	ODCT	Document Type - Original	String	UDC	2	0
87	F76H3B20	Invoices not Printed - CHI - 03B - 76H	13	AD	ODCT	Document Type - Original	String	UDC	2	0
88	F76HUI31	Document Related Work File - CHI - 42 - 76H	7	DR	ODCT	Document Type - Original	String	UDC	2	0
TOP76M: Mexico
89	F76M0314	Receipt Detail Tag File - Mexico	12	MA	ODCT	Document Type - Original	String	UDC	2	0
90	F76M0414	F0414 - Payment Detail Tag File - Mexico	13	RT	ODCT	Document Type - Original	String	UDC	2	0
91	F76M990	GL VAT on Gain/loss MEX - 76M	22	GL	ODCT	Document Type - Original	String	UDC	2	0
TOP76P: Peru
92	F76P411T	Peru AP Tag File - PER - 04 - 76P	22	T4	ODCT	Document Type - Original	String	UDC	2	0
93	F76P480	SPOT Voucher Information - PER - 04 - 76P	5	SV	ODCT	Document Type - Original	String	UDC	2	0
TOP76V: Venezuela
94	F76V4015	Vouchers Related to Credit/Debit Notes - VEN - 04	5	CD	ODCT	Document Type - Original	String	UDC	2	0
95	F76V4581	Withholding Historical File - VEN - 04	12	HR	ODCT	Document Type - Original	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 00 / DT (Document Type - All Documents) stock values

	Value	Description	Hard Coded
1	$P	Security Withholdings	Y
2	$Q	General SUSS	Y
3	%	Percentage Journal Entry	N
4	AJ	Service Billing Adjustments	Y
5	AR	Asset Revaluation	Y
6	AS	Asset Split	N
7	AT	Asset Transfer	N
8	BA	Billing Adjustments	Y
9	BF	Balance Forward/Summarize	N
10	CA	Credit Note for Aftercare	N
11	CC	Credit-Contract & Loyalty Supp	N
12	CG	Lot Grade Change	N
13	CP	Lot Potency Change	N
14	CQ	Credit Note - Quarterly Bonus	N
15	CT	Credit Note - Targeted Bonus	N
16	CW	Credit Note for Warranty	N
17	DP	Depreciation Journal	N
18	DR	Job Cost Draw Splits	Y
19	EU	Service Billing Revenue	Y
20	EX	Currency Conversion Offsets	N
21	IQ	Inventory Quantity Only	Y
22	IX	Recalculate Average Cost	N
23	IZ	Lot Hold/Release	N
24	JA	Budget or Cost Allocation	N
25	JB	Joint Interest Billing	N
26	JC	Job Cost % Complete	N
27	JD	JIB Detail Owner Entries	N
28	JE	Journal Entry	N
29	JF	Journals Brought Forward	N
30	JK	A/P Redistribute Payments	Y
31	JM	AR VAT Redistribution	Y
32	JP	Subscription Sales	N
33	JQ	Sub. Sales Net Ledger	N
34	JR	Subscription Sales Commissions	N
35	JT	Accrued Property Taxes	N
36	JV	A/P Redistribute Prepayments	Y
37	JX	Foreign Currency Revaluation	N
38	JZ	Cash Basis Journal Entry	N
39	NP	Partial NSF	Y
40	O	Ordering Document Types	N
41	O4	Purchase Order -Transportation	N
42	OA	Do Not Use	Y
43	OB	Blanket Order	N
44	OC	Construction Work Order	N
45	OD	Direct Ship Order	N
46	OE	Do Not Use--Exchange Rate Var.	N
47	OI	Interoperability Direct P.O.	N
48	OK	Purchase Intercompany Order	N
49	OM	Purchase Order RMA	N
50	OO	Outside Operations
51	OP	Purchase Order	N
52	OQ	Purchase Quote or Bid	N
53	OS	Subcontract	N
54	OU	Requisition Self Service	Y
55	OY	EDI Purchase Order Quote
56	P1	A/P Drafts	N
57	P7	Alternate Currency Payment	N
58	PA	Credit Note Reimbursements	N
59	PB	BACS Electronic Funds Transfer	N
60	PE	Change to Voucher Amount	N
61	PG	Gain/Loss on Exchange Rate	N
62	PI	Physical Inventory	N
63	PK	Automated Check	N
64	PL	Voucher Logging	N
65	PM	Manual Voucher	N
66	PN	Manual Check	N
67	PO	Void Check	N
68	PR	Recurring Voucher	N
69	PT	Electronic Funds Transfer	N
70	PW	Withholding
71	PY	Payment Order - EDI Only
72	R	Receivables	N
73	R1	A/R Drafts	N
74	R2	Contract Billing	N
75	R5	Deduction	Y
76	R6	RMA - Sales Order	Y
77	R7	Alternate Currency Receipt	N
78	RA	Adjustment	N
79	RB	Chargeback	N
80	RC	Cash Receipts	N
81	RE	Change to Invoice Amount	N
82	RF	Finance Charge	N
83	RG	Gain/Loss on Exchange Rate	N
84	RK	Cash Receipts Check	N
85	RO	Reversing or Void Entry	N
86	RQ	Chargeback Amount Created	N
87	RR	Recurring Invoice	N
88	RS	Spread Adjustments	N
89	RU	Unapplied Cash	N
90	RV	Non-sufficient Funds	N
91	RW	Balance Forward	N
92	RY	Cash Receipts - EDI Only
93	SB	Blanket Sales Order	N
94	SC	Actual Rate Schedule	N
95	SD	Direct Ship	N
96	SF	Free Goods	N
97	SI	Interbranch Sales	N
98	SQ	Sales Quote	N
99	SS	Do Not Use--Summary Records	N
100	SY	EDI Sales Order Quote	N
101	SZ	EDI Sales Order	N
102	TM	Enterprise Treasury Management	Y

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

95 columns | 910 | ODCT | STOCK UDC

TOPUDC 00 / DT (Document Type - All Documents) stock values