	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

91 columns | 920 | TYTN | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006DZ1	Business Unit Alternate Description Z file	12	SZ	TYTN	Type - Transaction	String	UDC	8	0
2	F0006Z1	Cost Center Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
3	F0006Z2	Business Unit Master Z File	9	SZ	TYTN	Type - Transaction	String	UDC	8	0
4	F0010Z	Company Constants Z File	11	SZ	TYTN	Type - Transaction	String	UDC	8	0
5	F0046	Processing Log	5	PL	TYTN	Type - Transaction	String	UDC	8	0
6	F0047	Data Export Control	1	DE	TYTN	Type - Transaction	String	UDC	8	0
7	F0401Z1	Supplier Master - Batch Upload	6	VO	TYTN	Type - Transaction	String	UDC	8	0
TOP01: Address Book
8	F0101Z2	Address Book - Interoperability	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
9	F01112Z1	Batch - Related Person	6	PB	TYTN	Type - Transaction	String	UDC	8	0
10	F0111Z1	Batch Who's Who Information	6	BW	TYTN	Type - Transaction	String	UDC	8	0
11	F01151Z1	Batch - Electronic Address	6	EB	TYTN	Type - Transaction	String	UDC	8	0
12	F0115Z1	Phones - Interoperability	7	PI	TYTN	Type - Transaction	String	UDC	8	0
13	F01161Z1	Batch - Alternative Address	6	LB	TYTN	Type - Transaction	String	UDC	8	0
TOP03: Accounts Receivable
14	F03012Z1	Customer Master LOB-Batch Table	6	VO	TYTN	Type - Transaction	String	UDC	8	0
TOP03B: Enhanced Accounts Receivable
15	F03B11Z2	F03B11 Interoperability Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
16	F03B13Z2	F03B13 Interoperability Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
17	F03B14Z2	F03B14 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
18	F03B41Z1	Inteoperability - Deductions Management	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP04: Accounts Payable
19	F0411Z3	F0411 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
20	F0413Z1	F0413 Interoperability Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
21	F0414Z1	F0414 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP05A: PeopleSoft HR & PR Foundation
22	F060116Z	Unedited Quick Hire Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP09: General Accounting
23	F0911Z4	F0911 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP10: Financial Reporting
24	F1001Z1	Unedited MSC Interoperability Header Table	6	IA	TYTN	Type - Transaction	String	UDC	8	0
25	F1002Z1	Unedited MSC Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP11: Multi Currency
26	F0015Z1	External Currency Exchange Rates	6	ZE	TYTN	Type - Transaction	String	UDC	8	0
TOP12: Fixed Assets
27	F1201Z1	Unedited Asset Master Transactions	6	FA	TYTN	Type - Transaction	String	UDC	8	0
28	F1217Z1	Unedited Equipment Tag Transactions	6	WR	TYTN	Type - Transaction	String	UDC	8	0
29	F1217Z2	Unedited Equipment Tag Transactions	6	WR	TYTN	Type - Transaction	String	UDC	8	0
TOP13: Plant/Equipment Management
30	F12120Z1	Unedited Meter Reading Transactions	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP13C: Condition-Base Maintenance
31	F1310Z1	Unedited Condition-Based Alerts	6	CB	TYTN	Type - Transaction	String	UDC	8	0
TOP16: Profit Management (EPS)
32	F1602Z1	External Cost Analyzer Balances - Interoperability Table	6	CZ	TYTN	Type - Transaction	String	UDC	8	0
33	F1632Z1	External Driver Balances-Interoperability Table	6	CY	TYTN	Type - Transaction	String	UDC	8	0
TOP17: Customer Service Management
34	F3111Z2	Warranty Claim/Supplier Recovery processing	6	WP	TYTN	Type - Transaction	String	UDC	8	0
35	F3112Z2	Warranty Claim/Supplier Recovery processing	6	WL	TYTN	Type - Transaction	String	UDC	8	0
36	F4801TZ2	Warranty Claim/Supplier Recovery processing	6	WQ	TYTN	Type - Transaction	String	UDC	8	0
37	F4801Z2	Warranty Claim/Supplier Recovery processing	6	WS	TYTN	Type - Transaction	String	UDC	8	0
TOP30: Product Data Management
38	F0007Z1	Work Day Calendar Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
39	F30006Z1	Work Center Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
40	F3002Z1	Bill of Material Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
41	F3003Z1	Routing Transactions File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP31: Shop Floor Control
42	F30161Z1	Inbound Kanban Card Detail	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
43	F3111Z1	Outbound Work Order Parts List	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
44	F31122Z1	Work Order Time Transactions Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
45	F3112Z1	Outbound Work Order Routings	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP31B: Blend Management
46	F31B17Z1	Operation EUR Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
47	F31B18Z1	VBT Barrel Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
48	F31B19Z1	Instructed Attributes Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
49	F31B31Z1	Operations Composition Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
50	F31B34Z1	Operations Style Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
51	F31B3CZ1	Operations Cost Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
52	F31B52Z1	Operations Equipment Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
53	F31B53Z1	Operations Consumables Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
54	F31B65Z1	Operations Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
55	F31B93Z1	WIM Work Order Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
56	F31B97Z1	Operations Resource Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
57	F31BQAZ1	Operations Quality Test Transaction File	9	SZ	TYTN	Type - Transaction	String	UDC	8	0
58	F31BSPZ1	Sample Transactions	42	ST	TYTN	Type - Transaction	String	UDC	8	0
TOP36: Forecasting
59	F3460Z1	Forecast Unedited Transactions	6	FT	TYTN	Type - Transaction	String	UDC	8	0
TOP37: Quality Management
60	F3711Z1	Test Results Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP40: Inventory/OP Base
61	F4106NC	Base Price Extraction	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
62	F4201Z1	Sales Order Header Unedited Transaction File	6	SY	TYTN	Type - Transaction	String	UDC	8	0
63	F4211Z1	Sales Order Detail Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
64	F49211Z1	Sales Order Detail Tag Unedited Transaction File	6	S1	TYTN	Type - Transaction	String	UDC	8	0
TOP41: Inventory Management
65	F4101Z1	F4101 Item Master Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
66	F4101Z1A	F4101 Detail Item Master Unedited Transaction	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
67	F41021Z1	Item Location Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
68	F4105Z1	Unedited Transaction Table - Item Cost	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
69	F4141Z1	F4141 Cycle Count Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP43: Procurement
70	F4301Z1	Purchase Order Header Unedited Transaction Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
71	F43092Z1	Receipt Routing Unedited Transaction Table	10	SZ	TYTN	Type - Transaction	String	UDC	8	0
72	F4311Z1	Purchase Order Detail Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
73	F43121Z1	Receipts Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP44H: Homebuilder Management
74	F44H101Z	HB Community Master Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
75	F44H201Z	HB Lot Master Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
76	F44H501Z	HB Sales Master Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
77	F44H604Z	HB Vendor Assignment Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
78	F44H711Z	HB Lot Start Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP45: Advanced Pricing
79	F4576Z1	Ship and Debit Claims Unedited Transaction Table	6	Z1	TYTN	Type - Transaction	String	UDC	8	0
TOP46: Warehouse Management
80	F4611Z1	Unedited Suggestion Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
81	F4942Z1	Work File for F4942	6	SY	TYTN	Type - Transaction	String	UDC	8	0
TOP47: Electronic Commerce
82	F47002	Flat File Cross-Reference Table	1	SV	TYTN	Type - Transaction	String	UDC	8	0
TOP48: Work Order Processing
83	F4801Z1	Outbound Work Order Header	6	SY	TYTN	Type - Transaction	String	UDC	8	0
TOP70: Multi-National Products
84	F70XMLZ1	XML Transaction Interfase	6	SY	TYTN	Type - Transaction	String	UDC	8	0
TOP74: EMEA Localization
85	F74XMLZ1	XML Transaction Interface	7	SY	TYTN	Type - Transaction	String	UDC	8	0
TOP76B: Brazil
86	F76B474	Dynamic Formater Bank Attributes - 03B	2	BA	TYTN	Type - Transaction	String	UDC	8	0
87	F76B474I	File Upload For Bank Transaction Inbound Process - 03B	4	BI	TYTN	Type - Transaction	String	UDC	8	0
88	F76B475	Dynamic Formater Bank Layout by Payment Instument - 03B	2	BL	TYTN	Type - Transaction	String	UDC	8	0
89	F76B476	Dynamic Formater Bank Attributes Cross Reference - 03B	2	BX	TYTN	Type - Transaction	String	UDC	8	0
90	F76B477	Dynamic Formater GL Bank Account File Numbers - 03B	2	BG	TYTN	Type - Transaction	String	UDC	8	0
TOP89: Conversion Programs
91	F01111Z1	Batch - Contact Information	6	CB	TYTN	Type - Transaction	String	UDC	8	0

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

TOPUDC 00 / TT (Transaction Type) stock values

	Value	Description	Special Handling Code	Hard Coded
1		.		N
2	809	Fixed Assets	1	Y
3	810	810/Invoice		N
4	820	Payment Order		Y
5	823	Lockbox		Y
6	824	Application Advice		Y
7	830	Planning Schedule		Y
8	832	Price Sales Catalog		Y
9	840	Request for Quote		Y
10	843	Response to RFQ		Y
11	844	Claim Notification		Y
12	845	Claim Acknowledgement		Y
13	849	Claim Status Notification		Y
14	850	Purchase Order		Y
15	852	Product Activity Data		Y
16	855	Purchase Order Acknowledgement		Y
17	856	Shipment Notice		Y
18	860	Purchase Order Change		Y
19	861	Receiving Advice		Y
20	862	Shipping Schedule		Y
21	865	Purchase Order Change Ack.		Y
22	867	Product Transfer and Release		Y
23	997	Functional Acknowledgment		Y
24	APERAK	Application Advice		Y
25	BRCOBES	Electronic Receipts Brazil		Y
26	BRPAGEL	Electronic Payment Brazil		Y
27	CBMALERT	Condition-Based Alerts		Y
28	CONTRL	Functional Acknowledgment		Y
29	CRTN0116	F060116 - Export to Criterion	1	Y
30	CRTN8001	F08001 - Export to Criterion	1	Y
31	CRTN8101	F08101 - Export to Criterion	1	Y
32	DEBADV	Lockbox		N
33	DELFOR	Planning Schedule		N
34	DEMAND	Inbound Demand		Y
35	DESADV	Shipment Notice		Y
36	IFTMAN	Receiving Advice		N
37	IFTMIN	Shipment Notice		N
38	INVOIC	Invoice		N
39	INVRPT	Product Data Activity		N
40	JDEAB	Address Book		Y
41	JDEBOM	Bill of Material Transaction		Y
42	JDECI	Contact Information		Y
43	JDECM	Customer Master		Y
44	JDECMP	Completions		Y
45	JDECSMS	Customer Service Management		Y
46	JDECYCLE	F4141 Process Cycle Count		Y
47	JDEEM	Equipment Management		Y
48	JDEEMPL	Employee Master		Y
49	JDEFA	Fixed Assets		Y
50	JDEFC	Forecast Transaction		Y
51	JDEHQ	Hours and Quantities		Y
52	JDEIC	Inventory Cost		Y
53	JDEII	Inventory Issues		Y
54	JDEIL	Item Location		N
55	JDEINV	Invoices	N	Y
56	JDEITEM	F4101 Process Item Master		Y
57	JDEJE	Journal Entry		Y
58	JDEKNB	Inbound Kanban Processing		Y
59	JDEMCU	Cost Centers		Y
60	JDEMSG	Transaction for Messages		Y
61	JDEPICK	ITLS Pick Slips		Y
62	JDEPL	WO Parts List Transaction		Y
63	JDEPOIN	Inbound Purchase Order		N
64	JDEPOOUT	Purchase Order Outbound		Y
65	JDEPRICE	Base Price Extraction		Y
66	JDEPYMNT	Outbound Payments		N
67	JDEQMTR	Quality Mgmt Test Result		Y
68	JDER	Receipts		Y
69	JDERC	A/R Cash Receipts		Y
70	JDEREC	Receipts	N	Y
71	JDEROU	Routing Transaction		N
72	JDERR	Receipts Routing		Y
73	JDERTG	WO Routings Transaction		Y
74	JDESBF	Super Backflush		Y
75	JDESC	Shipment Confirmation	1	Y
76	JDESFJE	Store Forward Journal Entry		Y
77	JDESHIP	ITLS Shipment Confirm		Y
78	JDESHIPI	Inbound Shipment		N
79	JDESM	Supplier Master		Y
80	JDESOE	ITLS Sales Order Entry		Y
81	JDESOOUT	Sales Order Outbound		N
82	JDESUGST	WMS Inbound Suggestion		Y
83	JDETEIN	Time Entry PC Upload		Y
84	JDETRV	EDI Transmission Values		Y
85	JDEVOUCH	Inbound/Outbound Vouchers		Y
86	JDEWC	Work Center Transaction		Y
87	JDEWCN	WIM Consumable		Y
88	JDEWCO	WIM Composition		Y
89	JDEWCST	WIM Cost		Y
90	JDEWDC	Work Day Calendar Transaction		Y
91	JDEWEQ	WIM Equipment		Y
92	JDEWEUR	WIM Multiple EUR		Y
93	JDEWINS	WIM Instructed Attributes		Y
94	JDEWO	Work Order Header Transaction		Y
95	JDEWOP	WIM Operation		Y
96	JDEWQA	WIM Quality		Y
97	JDEWRS	WIM Resource		Y
98	JDEWSPL	WIM Samples		Y
99	JDEWST	WIM Style		Y
100	JDEWVBT	WIM VBT Transactions		Y
101	JDEWWO	WIM Work Order		Y
102	METERS	Inbound Meter Readings		N
103	ORDCHG	Purchase Order Change		N
104	ORDERS	Purchase Order		N
105	ORDRSP	Purchase Order Acknowledgment		N
106	PAYEXT	Payment Order		N
107	PCRC8102	Export to Personic	1	N
108	PRICAT	Price Sales Catalog		N
109	PRSC0006	F0006 - Export to Personic	1	Y
110	PRSC0116	F060116 - Export to Personic	1	Y
111	PRSC116Z	F060116z -Import from Personic		Y
112	PRSC2001	F082001 - Export to Personic	1	Y
113	PRSC8001	F08001 - Export to Persionic	1	Y
114	PRSC8101	F08101 - Export to Personic	1	Y
115	PRSC8102	F08102 - Export to Personic	1	Y
116	QUOTES	Response to RFQ		N
117	REQUOT	Request for Quote		N
118	SLSRPT	Product Transfer and Resale		N
119	UDCADDS	State	1	Y
120	UDCAT1	Search Type	1	Y
121	UDCCTR	Country Code	1	Y
122	UDCEEOJ	EEO Job Category	1	Y
123	UDCEEOM	Ethnic Code	1	Y
124	UDCEST	Employment Status	1	Y
125	UDCFLSA	Overtime Extempt	1	Y
126	UDCJBCD	Job Type	1	Y
127	UDCJBST	Job Step	1	Y
128	UDCJGRP	Job Group	1	Y
129	UDCJSTA	Job Status	1	Y
130	UDCLNGP	Language Preference	1	Y
131	UDCMAIL	Check Route Code	1	Y
132	UDCMSTX	Marital Status	1	Y
133	UDCP001	Category Code 1	1	Y
134	UDCP0010	Category Code 10	1	Y
135	UDCP0011	Category Code 11	1	Y
136	UDCP0012	Category Code 12	1	Y
137	UDCP0013	Category Code 13	1	Y
138	UDCP0014	Category Code 14	1	Y
139	UDCP0015	Category Code 15	1	Y
140	UDCP0016	Category Code 16	1	Y
141	UDCP0017	Category Code 17	1	Y
142	UDCP0018	Category Code 18	1	Y
143	UDCP0019	Category Code 19	1	Y
144	UDCP002	Category Code 2	1	Y
145	UDCP0020	Category Code 20	1	Y
146	UDCP003	Category Code 3	1	Y
147	UDCP004	Category Code 4	1	Y
148	UDCP005	Category Code 5	1	Y
149	UDCP006	Category Code 6	1	Y
150	UDCP007	Category Code 7	1	Y
151	UDCP008	Category Code 8	1	Y
152	UDCP009	Category Code 9	1	Y
153	UDCPAST	Pay Status	1	Y
154	UDCPFRQ	Pay Frequency	1	Y
155	UDCRCCD	Record Type	1	Y
156	UDCREQS	Requisition Status	1	Y
157	UDCSALU	Prefix	1	Y
158	UDCSALY	Pay Class	1	Y
159	UDCSEX	Gender	1	Y
160	UDCSHFT	Shift Code	1	Y
161	UDCSLOC	Locality	1	Y
162	UDCSUFF	Suffix	1	Y
163	UDCTYC	Emer Contact Type	1	Y
164	UDCUN	Union	1	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

91 columns | 920 | TYTN | STOCK UDC

TOPUDC 00 / TT (Transaction Type) stock values