	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

122 columns | 910 | EDER | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP03B: Enhanced Accounts Receivable
1	F03B11Z1	Batch Invoices	10	VJ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP04: Accounts Payable
2	F0411Z1	Voucher Transactions - Batch Upload	10	VL	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
3	F0411Z3	F0411 Interoperability Table	17	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP05: Time Accounting and HRM Base
4	F05100Z1	Resource Competencies Unedited Transactions File	22	CU	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP05T: Time Entry
5	F06116Z1	Employee Transactions - Batch File	10	VL	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
6	F06116Z2	ESS Timecard History	10	VM	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP09: General Accounting
7	F0911Z1	Journal Entry Transactions - Batch File	10	VN	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
8	F0911Z4	F0911 Interoperability Table	17	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP11: Multi Currency
9	F0015Z1	External Currency Exchange Rates	17	ZE	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP16: Profit Management (EPS)
10	F1602Z1	External Cost Analyzer Balances - Interoperability Table	17	CZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
11	F1632Z1	External Driver Balances-Interoperability Table	17	CY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP40: Inventory/OP Base
12	F4001Z	Batch Receiver File - Order Headings	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
13	F4011Z	Batch Receiver File - Order Details	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP40R: Demand Scheduling
14	F47171	EDI Demand Header	10	EH	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
15	F47172	EDI Demand Detail	10	ED	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
16	F471721	EDI Demand Supplemental Data	10	EU	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
17	F471722	EDI Demand Addresses	10	EA	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
18	F471723	EDI Demand Contact Names	10	EC	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
19	F471724	EDI Demand Contact Numbers	10	EN	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
20	F47173	EDI Demand Scheduling Detail	10	ES	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
21	F471731	EDI Demand Packaging	10	EP	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
22	F47800	EDI Transmission Values	8	FF	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP42: Sales Management
23	F47027T	Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound	11	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
24	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	22	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
25	F47047T	Tag for F47047- EDI Invoice Detail (Sales) - Outbound	11	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
26	F47107T	Tag for F47107- EDI Response to RFQ Detail - Outbound	11	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
27	F47147T	Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound	11	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP42B: Sales Order Entry
28	F4011ZT	Batch Receiver File - Order Details Tag	10	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
29	F47012T	EDI Purchase Order Detail Tag - Inbound	10	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
30	F47092T	EDI Request for Quote Detail Tag - Inbound	10	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
31	F47132T	EDI Purchase Order Change Detail Tag - Inbound	10	UZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP45: Advanced Pricing
32	F4572Z1	Live Promotions Interface - Inbound / Outbound	14	LP	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
33	F4572ZP	Purge Live Promotions Interface	14	PG	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP47: Electronic Commerce
34	F47006	EDI Order Header - Outbound Tax Table	10	ST	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
35	F47007	EDI Order Detail - Outbound Tax Table	10	DT	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
36	F47011	EDI Purchase Order Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
37	F47011TX	EDI Purchase Order Header Tax - Inbound	10	ST	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
38	F47012	EDI Purchase Order Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
39	F47012TX	EDI Purchase Order Detail Tax - Inbound	10	DT	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
40	F47016	EDI Purchase Order Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
41	F470161	EDI Purchase Order Additional Header - Outbound	74	S3	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
42	F47017	EDI Purchase Order Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
43	F470171	EDI Purchase Order Additional Detail - Outbound	55	S4	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
44	F47021	EDI P.O. Acknowledgment Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
45	F47022	EDI P.O. Acknowledgment Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
46	F47026	EDI P.O. Acknowledgment Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
47	F47027	EDI P.O. Acknowledgment Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
48	F47031	EDI Shipping Notice Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
49	F47032	EDI Shipping Notice Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
50	F47036	EDI Shipping Notice Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
51	F47036X	EDI Shipping Notice Header Tax - Outbound	10	ST	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
52	F47037	EDI Shipping Notice Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
53	F470371	EDI Shipping Notice Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
54	F470371X	EDI Shipping Notice Detail Tax - Outbound	13	DT	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
55	F470372	EDI ASN Demand Scheduling Detail	10	AI	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
56	F470373	EDI ASN Shipping	9	AG	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
57	F470374	EDI ASN Demand Addresses	11	AM	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
58	F470375	EDI ASN Packaging Detail	10	AK	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
59	F47041	EDI Invoice Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
60	F47042	EDI Invoice Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
61	F47044	EDI Invoice Summary - Inbound	10	SW	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
62	F47046	EDI Invoice Header (Sales) - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
63	F47047	EDI Invoice Detail (Sales) - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
64	F47056	EDI Payment Order Header - Outbound	10	D1	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
65	F47056W	EDI Payment Order Header - Work	10	D1	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
66	F47057	EDI Payment Order Remittance Advice - Outbound	10	D3	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
67	F47057W	EDI Payment Order Remittance Advice - Work	10	D3	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
68	F47061	EDI Planning Schedule Header - Inbound	10	MJ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
69	F47062	EDI Planning Schedule Detail - Inbound	10	MY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
70	F47066	EDI Planning Schedule Header - Outbound	10	MJ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
71	F47067	EDI Planning Schedule Detail - Outbound	10	MY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
72	F47071	EDI Receiving Advice Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
73	F47072	EDI Receiving Advice Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
74	F47076	EDI Receiving Advice Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
75	F47077	EDI Receiving Advice Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
76	F47081	EDI Price Sales Catalog Header - Inbound	10	FV	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
77	F47082	EDI Price Sales Catalog Detail - Inbound	10	FY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
78	F47091	EDI Request for Quote Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
79	F47091TX	EDI Request for Quote Header Tax - Inbound	10	ST	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
80	F47092	EDI Request for Quote Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
81	F47096	EDI Request for Quote Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
82	F47097	EDI Request for Quote Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
83	F47101	EDI Response to RFQ Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
84	F47102	EDI Response to RFQ Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
85	F47106	EDI Response to RFQ Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
86	F47107	EDI Response to RFQ Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
87	F47111	EDI Lockbox/Payment Header - Transaction	10	Z1	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
88	F47112	EDI Lockbox Header - Transaction	10	Z2	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
89	F47121	EDI Product Activity Data Header - Inbound	10	M1	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
90	F47122	EDI Product Activity Data Detail - Inbound	10	MJ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
91	F47126	EDI Product Activity Data Header - Outbound	10	M1	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
92	F47127	EDI Product Activity Data Detail - Outbound	10	MJ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
93	F47131	EDI Purchase Order Change Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
94	F47131TX	EDI Purchase Order Change Header Tax - Inbound	10	ST	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
95	F47132	EDI Purchase Order Change Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
96	F47132TX	EDI Purchase Order Change Detail Tax - Inbound	10	DT	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
97	F47136	EDI Purchase Order Change Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
98	F47137	EDI Purchase Order Change Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
99	F47141	EDI P.O. Change Acknowledgment Header - Inbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
100	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
101	F47146	EDI P.O. Change Acknowledgment Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
102	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
103	F47156	EDI Shipping Schedule Header - Outbound	10	SY	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
104	F47157	EDI Shipping Schedule Detail - Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
105	F4716	EDI Item Text - Inbound/Outbound	10	SZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
106	F47181	EDI Consumption Header (FUTURE)	16	EH	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
107	F47182	EDI Consumption Detail (FUTURE)	25	ED	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
108	F47191	EDI Acknowledgement Header	11	AH	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
109	F47192	EDI Acknowledgement Error Detail	10	AE	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
110	F47194	EDI Acknowledgement References	10	AR	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
111	F47196	EDI Acknowledgement Name And Address	10	AA	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
112	F47198	EDI Acknowledgement Notes	10	AN	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
113	F4722	EDI Tolerance Rules	3	PZ	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
114	F47CTL	EDI Lockbox/Payment Work File	14	Z5	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP49: Transportation Management
115	F47092TX	EDI Request for Quote Detail Tax - Inbound	10	DT	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP75I: India
116	F75I344	Excise - ARE1 Bond Register	17	QB	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
117	F75I344C	ARE-1 Bond Register for Cancelled Receipts-IND-00	3	CD	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
118	F75I344Y	Print ARE-1Bond Register-IND-00	20	CD	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
119	F75I345	Excise - ARE3 Form Header Details-IND-00	8	QR	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
120	F75I345X	Excise - ARE-3 Form Header for Yarn	6	QR	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP76A: Argentina
121	F76A19Z1	Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A	10	VK	EDER	EDI - Send/Receive Indicator	Character	UDC	1	0
TOP79A: Greenhouse Gas Accounting
122	F79A11Z1	GHG Ledger - Batch File	10	GL	EDER	EDI - Send/Receive Indicator	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 H00 / ED (EDER) stock values

	Value	Description	Hard Coded
1	B	Both	N
2	R	Receive	N
3	S	Send	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

122 columns | 910 | EDER | STOCK UDC

TOPUDC H00 / ED (EDER) stock values