	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

139 columns | 920 | ICUT | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0011	Batch Control Records	1	IC	ICUT	Batch Type	String	UDC	2	0
2	F0011W	F0011W - WF - Batch To Detail	1	IC	ICUT	Batch Type	String	UDC	2	0
3	F0018	Taxes	51	TD	ICUT	Batch Type	String	UDC	2	0
4	F007021W	Transactions to Batch Headers Work Table	4	TB	ICUT	Batch Type	String	UDC	2	0
5	F007032W	Batches Out Of Balance Work Table	4	OB	ICUT	Batch Type	String	UDC	2	0
6	F0911	Account Ledger	9	GL	ICUT	Batch Type	String	UDC	2	0
TOP03: Accounts Receivable
7	F0311	Accounts Receivable Ledger	16	RP	ICUT	Batch Type	String	UDC	2	0
8	F0312	A/R Batch Cash Application	3	RU	ICUT	Batch Type	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
9	F03B11	Customer Ledger	8	RP	ICUT	Batch Type	String	UDC	2	0
10	F03B112	Invoice Revisions	18	RW	ICUT	Batch Type	String	UDC	2	0
11	F03B112P	Invoice Revisions Purge File	18	RW	ICUT	Batch Type	String	UDC	2	0
12	F03B117	Revenue Recognition GL Info	12	RL	ICUT	Batch Type	String	UDC	2	0
13	F03B119	Revenue Recognition GL Info Audit	24	RN	ICUT	Batch Type	String	UDC	2	0
14	F03B11P	Customer Ledger Purge File	8	RP	ICUT	Batch Type	String	UDC	2	0
15	F03B11Z1	Batch Invoices	26	VJ	ICUT	Batch Type	String	UDC	2	0
16	F03B11Z2	F03B11 Interoperability Table	21	SY	ICUT	Batch Type	String	UDC	2	0
17	F03B13	Receipts Header	18	RY	ICUT	Batch Type	String	UDC	2	0
18	F03B13P	Receipts Header Purge File	18	RY	ICUT	Batch Type	String	UDC	2	0
19	F03B13Z1	Electronic Receipts Input	16	RU	ICUT	Batch Type	String	UDC	2	0
20	F03B13Z2	F03B13 Interoperability Table	31	SY	ICUT	Batch Type	String	UDC	2	0
21	F03B14	Receipts Detail	19	RZ	ICUT	Batch Type	String	UDC	2	0
22	F03B14P	Receipts Detail Purge File	19	RZ	ICUT	Batch Type	String	UDC	2	0
23	F03B14Z2	F03B14 Interoperability Table	32	SZ	ICUT	Batch Type	String	UDC	2	0
24	F03B571	Auto Debit Batch Control	6	RC	ICUT	Batch Type	String	UDC	2	0
25	F03B575	Auto Debit Invoice Select and Build	11	RD	ICUT	Batch Type	String	UDC	2	0
26	F03B672	Draft Remittance	21	RD	ICUT	Batch Type	String	UDC	2	0
27	F03BUI05	Auto Receipts Batch Workfile	3	R5	ICUT	Batch Type	String	UDC	2	0
28	F09UI011	Receipt Prepost Work File	6	GL	ICUT	Batch Type	String	UDC	2	0
TOP04: Accounts Payable
29	F0411	Accounts Payable Ledger	20	RP	ICUT	Batch Type	String	UDC	2	0
30	F0411A	WF - 'As Of' Accounts Payable Ledger	20	RP	ICUT	Batch Type	String	UDC	2	0
31	F0411P	Purge - Accounts Payable Ledger	20	RP	ICUT	Batch Type	String	UDC	2	0
32	F0411Z1	Voucher Transactions - Batch Upload	38	VL	ICUT	Batch Type	String	UDC	2	0
33	F0411Z3	F0411 Interoperability Table	42	SZ	ICUT	Batch Type	String	UDC	2	0
34	F0413	Accounts Payable - Matching Document	9	RM	ICUT	Batch Type	String	UDC	2	0
35	F0413A	WF - 'As Of' Accounts Payable Payment Register	9	RM	ICUT	Batch Type	String	UDC	2	0
36	F0413P	Purge - Accounts Payable Matching Documents	9	RM	ICUT	Batch Type	String	UDC	2	0
37	F0413Z1	F0413 Interoperability Table	23	SY	ICUT	Batch Type	String	UDC	2	0
38	F09UI005	Tax Offsets User Index	4	GL	ICUT	Batch Type	String	UDC	2	0
39	F09UI006	Tax (F0018) Replica	51	TD	ICUT	Batch Type	String	UDC	2	0
TOP09: General Accounting
40	F0911P	Purge - Account Ledger	9	GL	ICUT	Batch Type	String	UDC	2	0
41	F0911R	WF - Account Ledger Reconciliation	9	GL	ICUT	Batch Type	String	UDC	2	0
42	F0911Z1	Journal Entry Transactions - Batch File	26	VN	ICUT	Batch Type	String	UDC	2	0
43	F0911Z4	F0911 Interoperability Table	31	SZ	ICUT	Batch Type	String	UDC	2	0
44	F097021W	Account Ledger to Account Master Work Table	10	TA	ICUT	Batch Type	String	UDC	2	0
45	F09706W	Batch and Company Within Batch Out of Balance Work Table	4	NB	ICUT	Batch Type	String	UDC	2	0
46	F09UI004	Variable Numerator Allocations work file	2	R#	ICUT	Batch Type	String	UDC	2	0
47	F09UI013	Company by Batch Out of Balance	1	GL	ICUT	Batch Type	String	UDC	2	0
48	F09UI015	Indexed Computations Multi-Tiered Entries	9	GL	ICUT	Batch Type	String	UDC	2	0
49	F09UI618	Auto Bank Statement Process Work Table	20	NB	ICUT	Batch Type	String	UDC	2	0
50	F52G11	Burdening Detail Ledger	53	BD	ICUT	Batch Type	String	UDC	2	0
51	F70UI001	Work File for G/L by Cat. Code Localization	22	WA	ICUT	Batch Type	String	UDC	2	0
52	F740911	Work File for G/L Report by Category Code Localization	26	WA	ICUT	Batch Type	String	UDC	2	0
TOP11C: Cash Basis
53	F11CUI01	A/R Cash Basis Work File	3	CB	ICUT	Batch Type	String	UDC	2	0
54	F11CUI02	A/P Cash Basis Work File	3	CB	ICUT	Batch Type	String	UDC	2	0
TOP15: Real Estate Management
55	F1511B1	Billing Batches Summary	2	NW	ICUT	Batch Type	String	UDC	2	0
56	F1540	Sales Report Control File	12	NR	ICUT	Batch Type	String	UDC	2	0
57	F1540B	Sales Report Control	22	NR	ICUT	Batch Type	String	UDC	2	0
TOP31: Shop Floor Control
58	F3106	W.O. Cross Reference File	6	SD	ICUT	Batch Type	String	UDC	2	0
TOP38: Agreement Management
59	F38111	Agreements Transaction Ledger	57	DZ	ICUT	Batch Type	String	UDC	2	0
TOP39: Advanced Stock Valuation
60	F3910	G/L Adjustment Table	18	SC	ICUT	Batch Type	String	UDC	2	0
TOP41: Inventory Management
61	F41UI001	Inventory Transactions Detail File	11	IT	ICUT	Batch Type	String	UDC	2	0
TOP42: Sales Management
62	F42800G	Sales Update G Batch Workfile	4	SG	ICUT	Batch Type	String	UDC	2	0
TOP43: Procurement
63	F43092Z	Receipt Routing Work File	17	PV	ICUT	Batch Type	String	UDC	2	0
TOP43S: JSSS/Supplier Self Service
64	F4313	POFLIP	24	PF	ICUT	Batch Type	String	UDC	2	0
TOP45: Advanced Pricing
65	F4575	Ship and Debit History	62	AH	ICUT	Batch Type	String	UDC	2	0
66	F4575TMP	Ship and Debit History - Temp Table	62	AH	ICUT	Batch Type	String	UDC	2	0
67	F4576	Ship and Debit Claims	55	AC	ICUT	Batch Type	String	UDC	2	0
68	F4576TMP	Ship and Debit Claims- Temp Table	55	AC	ICUT	Batch Type	String	UDC	2	0
69	F4576Z1	Ship and Debit Claims Unedited Transaction Table	86	Z1	ICUT	Batch Type	String	UDC	2	0
TOP47: Electronic Commerce
70	F47056	EDI Payment Order Header - Outbound	16	D1	ICUT	Batch Type	String	UDC	2	0
71	F470561	EDI Payment Order Bank N & A - Outbound	10	D2	ICUT	Batch Type	String	UDC	2	0
72	F470561W	EDI Payment Order Bank N & A - Work	12	D2	ICUT	Batch Type	String	UDC	2	0
73	F470562	EDI Payment Order Vendor N & A - Outbound	10	D4	ICUT	Batch Type	String	UDC	2	0
74	F470562W	EDI Payment Order Vendor N & A - Work	10	D4	ICUT	Batch Type	String	UDC	2	0
75	F470563	EDI Payment Order Payee N & A - Outbound	10	D5	ICUT	Batch Type	String	UDC	2	0
76	F470563W	EDI Payment Order Payee N & A - Work	10	D5	ICUT	Batch Type	String	UDC	2	0
77	F47056W	EDI Payment Order Header - Work	16	D1	ICUT	Batch Type	String	UDC	2	0
78	F47057	EDI Payment Order Remittance Advice - Outbound	16	D3	ICUT	Batch Type	String	UDC	2	0
79	F47057W	EDI Payment Order Remittance Advice - Work	16	D3	ICUT	Batch Type	String	UDC	2	0
80	F47112	EDI Lockbox Header - Transaction	25	Z2	ICUT	Batch Type	String	UDC	2	0
81	F47113	EDI Lockbox/Payment Detail - Batch	28	Z3	ICUT	Batch Type	String	UDC	2	0
TOP52: Contract Billing
82	F5216	Milestone/Progress Billing Information	25	A6	ICUT	Batch Type	String	UDC	2	0
83	F52161	Mileston/Progress Billing Line Cross Reference Details	12	A7	ICUT	Batch Type	String	UDC	2	0
TOP70: Multi-National Products
84	F704100	Suspended VAT AP - COMM - 70	10	VA	ICUT	Batch Type	String	UDC	2	0
85	F704200	Final VAT AP - COMM - 70	11	FV	ICUT	Batch Type	String	UDC	2	0
TOP74: EMEA Localization
86	F740018D	Data extraction ESL - 74	26	DE	ICUT	Batch Type	String	UDC	2	0
87	F740018W	Data extraction ESL - Workfile - 74	26	DE	ICUT	Batch Type	String	UDC	2	0
88	F74093	Worktable for Printing IVA Summary - Italy	50	HC	ICUT	Batch Type	String	UDC	2	0
89	F74900	Foreign Receivables and Payables - EMEA	14	RP	ICUT	Batch Type	String	UDC	2	0
TOP74F: France
90	F74F210	FEC - Last Sequence Number by CO-Fiscal Period - FR	3	FP	ICUT	Batch Type	String	UDC	2	0
TOP74H: Hungary
91	F74H309	Gains & Losses Unrealized Account ing - HUN - 03B	13	GL	ICUT	Batch Type	String	UDC	2	0
92	F74H409	A/P Gains & Losses Unrealized Accounting - HUN - 04	13	GL	ICUT	Batch Type	String	UDC	2	0
93	F74H910	JE VAT Differences - HUN - 09	9	VD	ICUT	Batch Type	String	UDC	2	0
TOP74P: Poland
94	F74P9100	Cash Desk Transaction - POL - 74P	13	CD	ICUT	Batch Type	String	UDC	2	0
TOP74R: Russia
95	F74R0011	Batch Tag File - RUS - 09 - 74R	1	IC	ICUT	Batch Type	String	UDC	2	0
96	F74R0100	Petty Cash Transactions - RUS - 00 - 74R	14	PC	ICUT	Batch Type	String	UDC	2	0
97	F74R311	Prepayment Detail Tax File - RUS - 03B	26	DE	ICUT	Batch Type	String	UDC	2	0
98	F74R410	Tax on Hold - RUS - 04	16	TH	ICUT	Batch Type	String	UDC	2	0
99	F74R9003	Correspondence Method - RUS -09 - 74R	2	CM	ICUT	Batch Type	String	UDC	2	0
100	F74R9004	Correspondence Rules - RUS -09 - 74R	2	CR	ICUT	Batch Type	String	UDC	2	0
101	F74R9011	Correspondence Rules - RUS -09 - 74R	16	CR	ICUT	Batch Type	String	UDC	2	0
TOP74U: United Kingdom Localizations
102	F74U0420	SPC - Application Master - UK - 43	28	SE	ICUT	Batch Type	String	UDC	2	0
103	F74U0425	SPC - Certificate Master - UK - 43	30	SF	ICUT	Batch Type	String	UDC	2	0
TOP74Y: Italy
104	F743B14I	Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B	8	TI	ICUT	Batch Type	String	UDC	2	0
105	F74Y015	Yearly List Declaration - WF - IT - 00	18	YL	ICUT	Batch Type	String	UDC	2	0
TOP74Z: Czech Republic
106	F74Z0010	Cash Desk Document Printed - CZE - 74Z	8	ZO	ICUT	Batch Type	String	UDC	2	0
107	F74ZUI01	Corresponding Accounts	5	CZ	ICUT	Batch Type	String	UDC	2	0
TOP75C: China
108	F75C015	Cash Flow Data - China	11	CF	ICUT	Batch Type	String	UDC	2	0
109	F75C4203	Chinese VAT on Free Goods Cross Reference - China - 42	10	FC	ICUT	Batch Type	String	UDC	2	0
TOP75I: India
110	F75I611	TCS Prepayment Transaction File - IND-03B	16	TT	ICUT	Batch Type	String	UDC	2	0
111	F75I732	Service Tax A/R File Additional Info - IND - 03B	12	ST	ICUT	Batch Type	String	UDC	2	0
112	F75I742	Service Tax A/P File Additional Info - IND - 04	13	ST	ICUT	Batch Type	String	UDC	2	0
113	F75IUI7	Service Tax Credit Register - Work File - IND	11	WF	ICUT	Batch Type	String	UDC	2	0
TOP76A: Argentina
114	F76A4111	Item Ledger Tag File - ARG - 76A	2	IL	ICUT	Batch Type	String	UDC	2	0
115	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	25	WF	ICUT	Batch Type	String	UDC	2	0
116	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	28	WF	ICUT	Batch Type	String	UDC	2	0
117	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	37	WF	ICUT	Batch Type	String	UDC	2	0
TOP76B: Brazil
118	F76B011	Nota Fiscal Taxes Detail - Brazil - 42	32	TD	ICUT	Batch Type	String	UDC	2	0
119	F76B835	FCONT Account Ledger Operation - 76B	2	AO	ICUT	Batch Type	String	UDC	2	0
TOP76C: Colombia
120	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	8	RP	ICUT	Batch Type	String	UDC	2	0
121	F76C034A	A/R Check Detail file As Of - COL - 03B	19	RZ	ICUT	Batch Type	String	UDC	2	0
122	F76C575	Work File Magnetic Media - COL - 04	2	Q1	ICUT	Batch Type	String	UDC	2	0
123	F76C9415	Workfile for Dialy Book - COL - 09	3	LD	ICUT	Batch Type	String	UDC	2	0
124	F76C9F02	DIAN Formats by AccountID - COL - 09	10	DF	ICUT	Batch Type	String	UDC	2	0
125	F76CT1	Tributary Information - COL - 76C	2	TI	ICUT	Batch Type	String	UDC	2	0
126	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	7	CT	ICUT	Batch Type	String	UDC	2	0
127	F76CUI02	Tax Detail - Work File - COL - 76C	57	TD	ICUT	Batch Type	String	UDC	2	0
128	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	58	TD	ICUT	Batch Type	String	UDC	2	0
TOP76E: Ecuador
129	F76E0018	Print Withholding Workfile - EC - 04	8	TD	ICUT	Batch Type	String	UDC	2	0
130	F76E4010	Withholding Certificate Information - EC - 04	4	CE	ICUT	Batch Type	String	UDC	2	0
TOP76H: Chile
131	F76H6001	Actual Cost Process Header - CHI - 41 - 76H	22	PH	ICUT	Batch Type	String	UDC	2	0
132	F76H6201	Replacement Cost Process Header - CHI - 41	13	RH	ICUT	Batch Type	String	UDC	2	0
133	F76HUI32	Workfile for R76H3B40 - CHI - 42 - 76H	13	WF	ICUT	Batch Type	String	UDC	2	0
TOP76M: Mexico
134	F76M0314	Receipt Detail Tag File - Mexico	10	MA	ICUT	Batch Type	String	UDC	2	0
135	F76M0414	F0414 - Payment Detail Tag File - Mexico	6	RT	ICUT	Batch Type	String	UDC	2	0
136	F76M930	AR VAT on Gain/loss MEX - 76M	19	AP	ICUT	Batch Type	String	UDC	2	0
137	F76M940	AP VAT on Gain/loss - MEX - 76M	16	AP	ICUT	Batch Type	String	UDC	2	0
138	F76M990	GL VAT on Gain/loss MEX - 76M	17	GL	ICUT	Batch Type	String	UDC	2	0
TOPF31: Lean Transactions
139	FF31201	Cross Reference	5	CR	ICUT	Batch Type	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 98 / IT (Batch Type) stock values

	Value	Description	Special Handling Code	Hard Coded
1	#	Payroll Vouchers		N
2	#1	Payroll Vouchers		N
3	$	Reserved for Clients		N
4	%	Reserved for Clients		N
5	&	A/R Drafts		N
6	&B	Draft Register		N
7	+	Bank Statement
8	+B	Bank Statements		N
9	/	Tenant Vouchers		N
10	0	Manufacturing
11	1	Tenant Invoice Work Batch
12	2	Tenant A/R Invoices
13	2B	Tenant A/R Invoices		N
14	3	Sales Report Entry
15	4	Pro-Forma P/R Pay Period Jrnls
16	41	Pro-Forma P/R Pay Period Jrnls		N
17	5	Pro-Forma Daily Timecard Jrnls
18	51	Pro-Forma Daily Timecard Jrnls		N
19	6	Partnership Distribution
20	7	Actual Payroll Period Journals
21	8	Production FASTR
22	9	Lockbox/Batch Cash Receipts
23	9B	Automatic Receipts		N
24	@	Reserved for Clients		N
25	A	Revenue - Check Entry		N
26	AR	Asset Revaluation		N
27	B	Revenue - Journal Entries		N
28	C	JIB Cost Allocations		N
29	D	Cost Allocations/Flex Budget		N
30	DB	Draft Receipts		N
31	E	Asset Transfer		N
32	F	Balance Forward A/R Update		N
33	FB	Balance Forward A/R Updates		N
34	G	General Accounting
35	H	Change Orders
36	I	Invoice Entry
37	IB	Invoices		N
38	J	JIB Invoices and Statements
39	K	A/P Checks (Automatic)
40	L	ALRS Checks
41	M	Manual & Void Checks w/Match
42	N	Inventory
43	NC	Frozen Cost Update		N
44	O	PO/Contract Entries
45	P	Actual Timecard Journals
46	Q	Direct Payments
47	R	Cash Receipts and Adjustments
48	RB	Receipts & Adjustments	N	Y
49	S	Stock Transfers
50	ST	Inter Branch Sales Transfer
51	T	Equipment Time Entry
52	U	Oil & Gas Equipment Time Entry
53	UB	Utility Billing		N
54	V	Voucher Entry
55	W	Manual Checks without Match
56	X	Depreciation - Journal Entries
57	XX	Detailed Currency Restatement		N
58	Y	Subscription Sales
59	Z	Disposal - Journal Entries

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

139 columns | 920 | ICUT | STOCK UDC

TOPUDC 98 / IT (Batch Type) stock values