	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

39 columns | 920 | PYIN | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0401Z1	Supplier Master - Batch Upload	32	VO	PYIN	Payment Instrument	Character	UDC	1	0
TOP01: Address Book
2	F0401	Supplier Master	19	A6	PYIN	Payment Instrument	Character	UDC	1	0
TOP03: Accounts Receivable
3	F0311	Accounts Receivable Ledger	101	RP	PYIN	Payment Instrument	Character	UDC	1	0
4	F0312	A/R Batch Cash Application	42	RU	PYIN	Payment Instrument	Character	UDC	1	0
TOP03B: Enhanced Accounts Receivable
5	F03B13Z1	Electronic Receipts Input	42	RU	PYIN	Payment Instrument	Character	UDC	1	0
TOP04: Accounts Payable
6	F0411	Accounts Payable Ledger	78	RP	PYIN	Payment Instrument	Character	UDC	1	0
7	F0411A	WF - 'As Of' Accounts Payable Ledger	78	RP	PYIN	Payment Instrument	Character	UDC	1	0
8	F0411P	Purge - Accounts Payable Ledger	78	RP	PYIN	Payment Instrument	Character	UDC	1	0
9	F0411Z1	Voucher Transactions - Batch Upload	96	VL	PYIN	Payment Instrument	Character	UDC	1	0
10	F0411Z3	F0411 Interoperability Table	101	SZ	PYIN	Payment Instrument	Character	UDC	1	0
11	F0413	Accounts Payable - Matching Document	16	RM	PYIN	Payment Instrument	Character	UDC	1	0
12	F0413A	WF - 'As Of' Accounts Payable Payment Register	16	RM	PYIN	Payment Instrument	Character	UDC	1	0
13	F0413P	Purge - Accounts Payable Matching Documents	16	RM	PYIN	Payment Instrument	Character	UDC	1	0
14	F0413Z1	F0413 Interoperability Table	31	SY	PYIN	Payment Instrument	Character	UDC	1	0
15	F0417	A/P Payments - Default Print and Update	1	KB	PYIN	Payment Instrument	Character	UDC	1	0
16	F0417M	Multiple Vendor Bank Account Types	1	KB	PYIN	Payment Instrument	Character	UDC	1	0
17	F04571	A/P Payment Processing - Header	4	KH	PYIN	Payment Instrument	Character	UDC	1	0
18	F04572	A/P Payment Processing - Summary	52	KK	PYIN	Payment Instrument	Character	UDC	1	0
19	F0474N1	A/P Enterprise Info. - Sweden BGI/BGU	10	QB	PYIN	Payment Instrument	Character	UDC	1	0
TOP06: Payroll (old) - Obsolete-do not reuse
20	F0690961	Payroll Additional Constants	2	YK	PYIN	Payment Instrument	Character	UDC	1	0
TOP09: General Accounting
21	F0911Z4	F0911 Interoperability Table	124	SZ	PYIN	Payment Instrument	Character	UDC	1	0
22	F0917	Bank Statement Detail	39	GD	PYIN	Payment Instrument	Character	UDC	1	0
23	F09521	Cash Type Rules	14	FR	PYIN	Payment Instrument	Character	UDC	1	0
TOP42: Sales Management
24	F42800G	Sales Update G Batch Workfile	38	SG	PYIN	Payment Instrument	Character	UDC	1	0
TOP43Q: Strategic Sourcing
25	F43Q91	Bidder Registration	8	BR	PYIN	Payment Instrument	Character	UDC	1	0
TOP47: Electronic Commerce
26	F47041	EDI Invoice Header - Inbound	38	SY	PYIN	Payment Instrument	Character	UDC	1	0
27	F47056	EDI Payment Order Header - Outbound	24	D1	PYIN	Payment Instrument	Character	UDC	1	0
28	F47056W	EDI Payment Order Header - Work	24	D1	PYIN	Payment Instrument	Character	UDC	1	0
29	F47057	EDI Payment Order Remittance Advice - Outbound	24	D3	PYIN	Payment Instrument	Character	UDC	1	0
30	F47057W	EDI Payment Order Remittance Advice - Work	24	D3	PYIN	Payment Instrument	Character	UDC	1	0
31	F47113	EDI Lockbox/Payment Detail - Batch	21	Z3	PYIN	Payment Instrument	Character	UDC	1	0
TOP74W: Sweden
32	F74W201	Debit Advice Header - 74W	2	K1	PYIN	Payment Instrument	Character	UDC	1	0
TOP75C: China
33	F75C010W	AP & AR XML Workfile - China -75C	31	AA	PYIN	Payment Instrument	Character	UDC	1	0
TOP76A: Argentina
34	F76A20	Credit Invoice Constants - ARG - 03B - 76A	4	IC	PYIN	Payment Instrument	Character	UDC	1	0
35	F76A81	A/P Payment Control Group File - ARG - 04 - 76A	22	C5	PYIN	Payment Instrument	Character	UDC	1	0
36	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	32	C6	PYIN	Payment Instrument	Character	UDC	1	0
37	F76AUI51	Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A	9	IK	PYIN	Payment Instrument	Character	UDC	1	0
TOP76B: Brazil
38	F76B474I	File Upload For Bank Transaction Inbound Process - 03B	9	BI	PYIN	Payment Instrument	Character	UDC	1	0
39	F76B475	Dynamic Formater Bank Layout by Payment Instument - 03B	3	BL	PYIN	Payment Instrument	Character	UDC	1	0

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

TOPUDC 00 / PY (Payment Instrument) stock values

	Value	Description	Special Handling Code	Hard Coded
1		Default (A/R & A/P)		N
2	!	Check Payment	12	N
3	#	A/P Payments - BR Bradesco		N
4	$	DENSAI Payment - Japan		N
5	%	Bordero - Brazil Bradesco		N
6	&	Bordero Print - BR Bradesco		N
7	.	Cash Payment	11	N
8	/	Check + Bordero - BR Bradesco		N
9	0	LCRM - Magnetic Draft		N
10	1	LCR - Supplier Draft W/Acct #		N
11	2	BOR - Cust Draft W/Acct #		N
12	3	LCC - Supplier Draft WO/Acct #		N
13	4	BOC - Cust Draft WO/Acct #		N
14	5	Italian Bank Tape		N
15	6	Create Bank Tapes - France		N
16	7	Sweden Bank File BGI		N
17	8	Print Z1 Form		N
18	9	Print Foreign Payments - Z1		N
19	<	Only payment order		N
20	>	Check		N
21	?	Credit Card Payment	13	N
22	A	Auto Debits (A/R only)		N
23	B	BACS (UK EFT) (A/R & A/P)		N
24	C	Check - 8 3/4 (A/R & A/P)		N
25	D	Draft by Invoice (A/R & A/P)		N
26	E	Print Checks - Italian Format		N
27	F	Draft by Statement (A/R only)		N
28	G	Germany (A/P only)		N
29	H	German Bank Diskette		N
30	I	Elec Funds-Italy (A/P only)		N
31	J	France (A/P only)		N
32	K	Switzerland (A/P only)		N
33	L	Belgium (A/P only)		N
34	M	Contract Checks (A/R & A/P)		N
35	N	Print Checks - Brazil		N
36	O	Balance Transfer		N
37	P	Create Paper Transfer France		N
38	Q	Bank Transfer - Japan		N
39	R	French Payment Print		N
40	S	Summarized Check run		N
41	T	Elec Funds Transfer(A/R & A/P)		N
42	U	UK Check (A/P only)		N
43	V	EFT PPD Format (A/P Only)		N
44	W	Check - 8 1/2 (A/P only)		N
45	X	EDI Remote Draft (A/R & A/P)		N
46	Y	EDI Remote Wire (A/R & A/P)		N
47	Z	EDI Remote Check (A/R & A/P)		N
48	[	48 hs.Clearing Draft		N
49	]	.		N
50	{	Deferred check		N
51	}	24 hs.Clearing Draft		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

39 columns | 920 | PYIN | STOCK UDC

TOPUDC 00 / PY (Payment Instrument) stock values