	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

61 columns | 812 | DCTM | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP03: Accounts Receivable
1	F0311	Accounts Receivable Ledger	7	RP	DCTM	Document Type - Matching	String	UDC	2	0
2	F0312	A/R Batch Cash Application	17	RU	DCTM	Document Type - Matching	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
3	F03B14	A/R Check Detail File	9	RZ	DCTM	Document Type - Matching	String	UDC	2	0
4	F03B14P	Receipts Detail Purge File	9	RZ	DCTM	Document Type - Matching	String	UDC	2	0
5	F03B14Z2	F03B14 Interoperability Table	22	SZ	DCTM	Document Type - Matching	String	UDC	2	0
TOP04: Accounts Payable
6	F0413	Accounts Payable - Matching Document	2	RM	DCTM	Document Type - Matching	String	UDC	2	0
7	F0413A	WF - As Of - Accounts Payable Payment Register	2	RM	DCTM	Document Type - Matching	String	UDC	2	0
8	F0413P	Purge - Accounts Payable Matching Documents	2	RM	DCTM	Document Type - Matching	String	UDC	2	0
9	F0413Z1	F0413 Interoperability Table	15	SY	DCTM	Document Type - Matching	String	UDC	2	0
10	F0414	Accounts Payable Matching Document Detail	3	RN	DCTM	Document Type - Matching	String	UDC	2	0
11	F0414A	WF - As Of - Accounts Payable Payment Detail	3	RN	DCTM	Document Type - Matching	String	UDC	2	0
12	F0414P	Purge - Accounts Payable Matching Document Detail	3	RN	DCTM	Document Type - Matching	String	UDC	2	0
13	F0414Z1	F0414 Interoperability Table	16	SZ	DCTM	Document Type - Matching	String	UDC	2	0
14	F04572	A/P Payment Processing - Summary File	10	KK	DCTM	Document Type - Matching	String	UDC	2	0
TOP09: General Accounting
15	F0917	Bank Statement Detail	29	GD	DCTM	Document Type - Matching	String	UDC	2	0
16	F09617	Auto Bank Statement Detail	33	GM	DCTM	Document Type - Matching	String	UDC	2	0
17	F09626	Auto Reconciliation Rules Setup	4	GR	DCTM	Document Type - Matching	String	UDC	2	0
TOP17C: Call Management
18	F1755	Customer Call Master	88	ZA	DCTM	Document Type - Matching	String	UDC	2	0
TOP45: Advanced Pricing
19	F4576	Ship and Debit Claims	41	AC	DCTM	Document Type - Matching	String	UDC	2	0
20	F4576TMP	Ship and Debit Claims- Temp Table	41	AC	DCTM	Document Type - Matching	String	UDC	2	0
21	F4576Z1	Ship and Debit Claims Unedited Transaction Table	54	Z1	DCTM	Document Type - Matching	String	UDC	2	0
TOP47: Electronic Commerce
22	F47056	EDI Payment Order Header - Outbound	21	D1	DCTM	Document Type - Matching	String	UDC	2	0
23	F470561	EDI Payment Order Bank N and A - Outbound	16	D2	DCTM	Document Type - Matching	String	UDC	2	0
24	F470561W	EDI Payment Order Bank N and A - Work	18	D2	DCTM	Document Type - Matching	String	UDC	2	0
25	F470562	EDI Payment Order Vendor N and A - Outbound	15	D4	DCTM	Document Type - Matching	String	UDC	2	0
26	F470562W	EDI Payment Order Vendor N and A - Work	15	D4	DCTM	Document Type - Matching	String	UDC	2	0
27	F470563	EDI Payment Order Payee N and A - Outbound	15	D5	DCTM	Document Type - Matching	String	UDC	2	0
28	F470563W	EDI Payment Order Payee N and A - Work	15	D5	DCTM	Document Type - Matching	String	UDC	2	0
29	F47056W	EDI Payment Order Header - Work	21	D1	DCTM	Document Type - Matching	String	UDC	2	0
30	F47057	EDI Payment Order Remittance Advice - Outbound	21	D3	DCTM	Document Type - Matching	String	UDC	2	0
31	F47057W	EDI Payment Order Remittance Advice - Work	21	D3	DCTM	Document Type - Matching	String	UDC	2	0
32	F47113	EDI Lockbox/Payment Detail - Batch	12	Z3	DCTM	Document Type - Matching	String	UDC	2	0
33	F47114	EDI Lockbox/Payment Detail - Payment	13	Z4	DCTM	Document Type - Matching	String	UDC	2	0
TOP49: Transportation Management
34	F49595	Document Print - Document Summary	21	DK	DCTM	Document Type - Matching	String	UDC	2	0
35	F49695	Document Register	19	DR	DCTM	Document Type - Matching	String	UDC	2	0
TOP53: Change Management
36	F5302	F5302 World Specs	45	DK	DCTM	Document Type - Matching	String	UDC	2	0
37	F5311	Change Request Details Table	122	DK	DCTM	Document Type - Matching	String	UDC	2	0
38	F5311Z1	Change Request Details Table Workfile	127	DK	DCTM	Document Type - Matching	String	UDC	2	0
TOP74: EMEA Localization
39	F74412	Customer / Supplier Balance Workfile (A/R and A/P)	14	RP	DCTM	Document Type - Matching	String	UDC	2	0
40	F74S55	Expenses and Exchange Rate for Payments - Spain	5	Q5	DCTM	Document Type - Matching	String	UDC	2	0
TOP74P: Poland
41	F74P03BW	A/R Trial Balance - POL - 03B - 74P	16	P3	DCTM	Document Type - Matching	String	UDC	2	0
42	F74P04W	A/P Trial Balance Work Table - POL - 04 - 74P	16	P2	DCTM	Document Type - Matching	String	UDC	2	0
TOP74R: CIS
43	F74R3B14	F03B14 Tag File - RUS - 03B - 74R	4	TF	DCTM	Document Type - Matching	String	UDC	2	0
44	F74R4014	F0414 Tag File - RUS - 04 - 74R	3	TF	DCTM	Document Type - Matching	String	UDC	2	0
TOP74U: United Kingdom Localizations
45	F74U4053	Subcontractor Documents Detail - CIS Monthly Return - UK- 04	8	DM	DCTM	Document Type - Matching	String	UDC	2	0
TOP74Y: Italy - Reporting System Only
46	F743B14I	Suspended IVA Generation - Receipt/Rebate Control-Italy	19	TI	DCTM	Document Type - Matching	String	UDC	2	0
TOP75A: Australia - Reporting System Only
47	F75A0201	Recipient Created Tax Invoice Tag File	6	TF	DCTM	Document Type - Matching	String	UDC	2	0
48	F75A0220	Payment Summary Workfile	1	PS	DCTM	Document Type - Matching	String	UDC	2	0
TOP75J: Japan - Reporting System Only
49	F750411	Withholding Tax Detail Table - Japan	12	JX	DCTM	Document Type - Matching	String	UDC	2	0
TOP76A: Argentina
50	F760414A	A/P Payment Detail Tag File - ARG - 04	3	V1	DCTM	Document Type - Matching	String	UDC	2	0
51	F760499A	Contract Withholding - Advances - ARG -04 - 04	6	K8	DCTM	Document Type - Matching	String	UDC	2	0
52	F76A09	Invoice Total - ARG - 00 - 00	4	TT	DCTM	Document Type - Matching	String	UDC	2	0
53	F76A09P	Invoice Total Purge - ARG - 03B - 76A	4	TT	DCTM	Document Type - Matching	String	UDC	2	0
54	F76A19	Taxes - Tax Amounts by Invoice Suffix AGR	5	TI	DCTM	Document Type - Matching	String	UDC	2	0
55	F76A19P	Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A	5	TI	DCTM	Document Type - Matching	String	UDC	2	0
56	F76A19Z1	Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B	23	VK	DCTM	Document Type - Matching	String	UDC	2	0
57	F76A414P	Purge - A/P Payment Detail - ARG - 04 - 76A	3	V1	DCTM	Document Type - Matching	String	UDC	2	0
58	F76AUI24	Taxes Work File - ARG - 00	5	TI	DCTM	Document Type - Matching	String	UDC	2	0
TOP76C: Colombia
59	F76C034A	A/R Check Detail file As Of - COL - 76C	9	RZ	DCTM	Document Type - Matching	String	UDC	2	0
TOP76M: Mexico
60	F76M0414	F0414 - Payment Detail Tag File - Mexico	5	RT	DCTM	Document Type - Matching	String	UDC	2	0
TOP76P: Peru
61	F76P414T	F0414 Tag File - PER - 04 - 76P	3	P4	DCTM	Document Type - Matching	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

61 columns | 812 | DCTM | STOCK UDC

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