	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

85 columns | 812 | TYTN | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006Z1	Cost Center Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
2	F0046	Processing Log	5	PL	TYTN	Type - Transaction	String	UDC	8	0
3	F0047	Data Export Control	1	DE	TYTN	Type - Transaction	String	UDC	8	0
4	F0401Z1	Supplier Master - Batch File	6	VO	TYTN	Type - Transaction	String	UDC	8	0
TOP01: Address Book
5	F0101Z2	Address Book - Interoperability	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
6	F01111Z1	Batch - Contact Information	6	CB	TYTN	Type - Transaction	String	UDC	8	0
7	F01112Z1	Batch - Related Person	6	PB	TYTN	Type - Transaction	String	UDC	8	0
8	F0111Z1	Batch Who's Who Information	6	BW	TYTN	Type - Transaction	String	UDC	8	0
9	F01151Z1	Batch - Electronic Address	6	EB	TYTN	Type - Transaction	String	UDC	8	0
10	F0115Z1	Phones - Interoperability	7	PI	TYTN	Type - Transaction	String	UDC	8	0
11	F01161Z1	Batch - Alternative Address	6	LB	TYTN	Type - Transaction	String	UDC	8	0
TOP03: Accounts Receivable
12	F03012Z1	Customer Master LOB-Batch File	6	VO	TYTN	Type - Transaction	String	UDC	8	0
TOP03B: Enhanced Accounts Receivable
13	F03B11Z2	F03B11 Interoperability Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
14	F03B13Z2	F03B13 Interoperability Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
15	F03B14Z2	F03B14 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
16	F03B41Z1	Inteoperability - Deductions Management	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP04: Accounts Payable
17	F0411Z3	F0411 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
18	F0413Z1	F0413 Interoperability Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
19	F0414Z1	F0414 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP05A: OW HR & PR Foundation
20	F060116Z	Unedited Quick Hire Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP09: General Accounting
21	F0911Z4	F0911 Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP10: Financial Reporting
22	F1001Z1	Unedited MSC Interoperability Header Table	6	IA	TYTN	Type - Transaction	String	UDC	8	0
23	F1002Z1	Unedited MSC Interoperability Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP11: Multi Currency
24	F0015Z1	External Currency Exchange Rates	6	ZE	TYTN	Type - Transaction	String	UDC	8	0
TOP12: Fixed Assets
25	F1201Z1	Unedited Asset Master Transactions	6	FA	TYTN	Type - Transaction	String	UDC	8	0
26	F1217Z1	Unedited Equipment Tag Transactions	6	WR	TYTN	Type - Transaction	String	UDC	8	0
27	F1217Z2	Unedited Equipment Tag Transactions	6	WR	TYTN	Type - Transaction	String	UDC	8	0
TOP13: Plant/Equipment Management
28	F12120Z1	Unedited Meter Reading Transactions	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP13C: Condition-Base Maintenance
29	F1310Z1	Unedited Condition-Based Alerts	6	CB	TYTN	Type - Transaction	String	UDC	8	0
TOP16: Profit Management (EPS)
30	F1602Z1	External Cost Analyzer Balances - Interoperability Table	6	CZ	TYTN	Type - Transaction	String	UDC	8	0
31	F1632Z1	External Driver Balances-Interoperability Table	6	CY	TYTN	Type - Transaction	String	UDC	8	0
TOP17: Customer Service Management
32	F3111Z2	Warranty Claim/Supplier Recovery processing	6	WP	TYTN	Type - Transaction	String	UDC	8	0
33	F3112Z2	Warranty Claim/Supplier Recovery processing	6	WL	TYTN	Type - Transaction	String	UDC	8	0
34	F4801TZ2	Warranty Claim/Supplier Recovery processing	6	WQ	TYTN	Type - Transaction	String	UDC	8	0
35	F4801Z2	Warranty Claim/Supplier Recovery processing	6	WS	TYTN	Type - Transaction	String	UDC	8	0
TOP30: Product Data Management
36	F0007Z1	Work Day Calendar Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
37	F30006Z1	Work Center Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
38	F3002Z1	Bill of Material Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
39	F3003Z1	Routing Transactions File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP31: Shop Floor Control
40	F30161Z1	Inbound Kanban Card Detail	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
41	F3111Z1	Outbound Work Order Parts List	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
42	F31122Z1	Work Order Time Transactions Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
43	F3112Z1	Outbound Work Order Routings	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
44	F4801Z1	Outbound Work Order Header	6	SY	TYTN	Type - Transaction	String	UDC	8	0
TOP31B: Blend Management
45	F31B17Z1	Operation EUR Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
46	F31B18Z1	VBT Barrel Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
47	F31B19Z1	Instructed Attributes Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
48	F31B31Z1	Operations Composition Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
49	F31B34Z1	Operations Style Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
50	F31B3CZ1	Operations Cost Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
51	F31B52Z1	Operations Equipment Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
52	F31B53Z1	Operations Consumables Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
53	F31B65Z1	Operations Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
54	F31B93Z1	WIM Work Order Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
55	F31B97Z1	Operations Resource Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
56	F31BQAZ1	Operations Quality Test Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP36: Forecasting
57	F3460Z1	Forecast Unedited Transactions	6	FT	TYTN	Type - Transaction	String	UDC	8	0
TOP37: Quality Management
58	F3711Z1	Test Results Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP40: Inventory/OP Base
59	F4106NC	Base Price Extraction	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
60	F4201Z1	Sales Order Header Unedited Transaction File	6	SY	TYTN	Type - Transaction	String	UDC	8	0
61	F4211Z1	Sales Order Detail Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
62	F49211Z1	Sales Order Detail Tag Unedited Transaction File	6	S1	TYTN	Type - Transaction	String	UDC	8	0
TOP41: Inventory Management
63	F4101Z1	F4101 Item Master Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
64	F4101Z1A	F4101 Detail Item Master Unedited Transaction	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
65	F41021Z1	Item Location Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
66	F4105Z1	Unedited Transaction Table - Item Cost	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
67	F4141Z1	F4141 Cycle Count Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP43: Procurement
68	F4301Z1	Purchase Order Header Unedited Transaction Table	6	SY	TYTN	Type - Transaction	String	UDC	8	0
69	F43092Z1	Receipt Routing Unedited Transaction Table	10	SZ	TYTN	Type - Transaction	String	UDC	8	0
70	F4311Z1	Purchase Order Detail Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
71	F43121Z1	Receipts Unedited Transaction Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP44H: Homebuilder Management
72	F44H101Z	HB Community Master Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
73	F44H201Z	HB Lot Master Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
74	F44H501Z	HB Sales Master Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
75	F44H604Z	HB Vendor Assignment Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
76	F44H711Z	HB Lot Start Unedited Transaction File	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
TOP45: Advanced Pricing
77	F4576Z1	Ship and Debit Claims Unedited Transaction Table	6	Z1	TYTN	Type - Transaction	String	UDC	8	0
TOP46: Warehouse Management
78	F4611Z1	Unedited Suggestion Table	6	SZ	TYTN	Type - Transaction	String	UDC	8	0
79	F4942Z1	Work File for F4942	6	SY	TYTN	Type - Transaction	String	UDC	8	0
TOP47: Electronic Commerce
80	F47002	Flat File Cross-Reference Table	1	SV	TYTN	Type - Transaction	String	UDC	8	0
TOP76B: Brazil - Reporting System Only
81	F76B474	Dynamic Formater Bank Attributes - 03B	2	BA	TYTN	Type - Transaction	String	UDC	8	0
82	F76B474I	File Upload For Bank Transaction Inbound Process - 03B	4	BI	TYTN	Type - Transaction	String	UDC	8	0
83	F76B475	Dynamic Formater Bank Layout by Payment Instument - 03B	2	BL	TYTN	Type - Transaction	String	UDC	8	0
84	F76B476	Dynamic Formater Bank Attributes Cross Reference - 03B	2	BX	TYTN	Type - Transaction	String	UDC	8	0
85	F76B477	Dynamic Formater GL Bank Account File Numbers - 03B	2	BG	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	810	Invoice		N
2	820	Payment Order		N
3	823	Lockbox		N
4	824	Application Advice		Y
5	830	Planning Schedule		N
6	832	Price Sales Catalog		N
7	840	Request for Quote		N
8	843	Response to RFQ		N
9	844	Claim Notification		N
10	845	Claim Acknowledgement		N
11	849	Claim Status Notification		N
12	850	Purchase Order		N
13	852	Product Activity Data		N
14	855	Purchase Order Acknowledgment		N
15	856	Shipment Notice		N
16	860	Purchase Order Change		N
17	861	Receiving Advice		N
18	862	Shipping Schedule		N
19	865	Purchase Order Change Ack.		N
20	867	Product Transfer and Resale		N
21	997	Functional Acknowledgment		Y
22	APERAK	Application Advice		Y
23	CBMALERT	Condition-Based Alerts		Y
24	CONTRL	Functional Acknowledgment		Y
25	CRTN0116	F060116 - Export to Criterion	1	Y
26	CRTN8001	F08001 - Export to Criterion	1	Y
27	CRTN8101	F08101 - Export to Criterion	1	Y
28	DEBADV	Lockbox		N
29	DELFOR	Planning Schedule		N
30	DEMAND	Inbound Demand		Y
31	DESADV	Shipment Notice		Y
32	IFTMAN	Receiving Advice		N
33	IFTMIN	shipment Notice		N
34	INVOIC	Invoice		N
35	INVRPT	Product Data Activity		N
36	JDEAB	Address Book		Y
37	JDEBOM	Bill of Material Transaction		Y
38	JDECM	Customer Master		Y
39	JDECMP	Completions		Y
40	JDECSMS	Customer Service Management		Y
41	JDECYCLE	F4141 Process Cycle Count		Y
42	JDEEM	Equipment Management		Y
43	JDEEMPL	Employee Master		Y
44	JDEFA	Fixed Assets		Y
45	JDEFC	Forecast Transaction		Y
46	JDEHQ	Hours and Quantities		Y
47	JDEIC	Inventory Cost		Y
48	JDEII	Inventory Issues		Y
49	JDEIL	Item Location		N
50	JDEINV	Invoices	N	Y
51	JDEITEM	F4101 Process Item Master		Y
52	JDEJE	Journal Entry		Y
53	JDEKNB	Inbound Kanban Processing		Y
54	JDEMCU	Cost Centers		Y
55	JDEMSG	Transaction for Messages		Y
56	JDEPICK	ITLS Pick Slips OW only		Y
57	JDEPL	WO Parts List Transaction		Y
58	JDEPOIN	Inbound Purchase Order		N
59	JDEPOOUT	Purchase Order Outbound		Y
60	JDEPRICE	Base Price Extraction		Y
61	JDEPYMNT	Outbound Payments		N
62	JDEQMTR	Quality Mgmt Test Result		Y
63	JDER	Receipts		Y
64	JDERC	A/R Cash Receipts		Y
65	JDEREC	Receipts	N	Y
66	JDEROU	Routing Transaction		N
67	JDERR	Receipts Routing		Y
68	JDERTG	WO Routings Transaction		Y
69	JDESBF	Super Backflush		Y
70	JDESC	Shipment Confirmation	1	Y
71	JDESFJE	Store Forward Journal Entry		Y
72	JDESHIP	ITLS Shipment Confirm OW only		Y
73	JDESHIPI	Inbound Shipment		N
74	JDESM	Supplier Master		Y
75	JDESOE	ITLS Sales Order Entry OW only		Y
76	JDESOOUT	Sales Order Outbound		N
77	JDESUGST	WMS Inbound Suggestion		Y
78	JDETEIN	Time Entry PC Upload		Y
79	JDETRV	EDI Transmission Values		Y
80	JDEVOUCH	Inbound Vouchers		Y
81	JDEWC	Work Center Transaction		Y
82	JDEWCN	WIM Consumable		Y
83	JDEWCO	WIM Composition		Y
84	JDEWCST	WIM Cost		Y
85	JDEWDC	Work Day Calendar Transaction		Y
86	JDEWEQ	WIM Equipment		Y
87	JDEWEUR	WIM Multiple EUR		Y
88	JDEWINS	WIM Instructed Attributes		Y
89	JDEWO	Work Order Header Transaction		Y
90	JDEWOP	WIM Operation		Y
91	JDEWQA	WIM Quality		Y
92	JDEWRS	WIM Resource		Y
93	JDEWST	WIM Style		Y
94	JDEWVBT	WIM VBT Transactions		Y
95	JDEWWO	WIM Work Order		Y
96	JDINV	Invoice		N
97	JEDTEIN	Time Entry PC Upload		Y
98	ORDCHG	Purchase Order Change		N
99	ORDERS	Purchase Order		N
100	ORDRSP	Purchase Order Acknowledgment		N
101	PAYEXT	Payment Order		N
102	PCRC8102	Export to Personic	1	N
103	PRICAT	Price Sales Catalog		N
104	PRSC0006	F0006 - Export to Personic	1	Y
105	PRSC0116	F060116 - Export to Personic	1	Y
106	PRSC116Z	F060116z -Import from Personic		Y
107	PRSC2001	F082001 - Export to Personic	1	Y
108	PRSC8001	F08001 - Export to Persionic	1	Y
109	PRSC8101	F08101 - Export to Personic	1	Y
110	PRSC8102	F08102 - Export to Personic	1	Y
111	QUOTES	Response to RFQ		N
112	REQUOT	Request for Quote		N
113	SLSRPT	Product Transfer and Resale		N
114	UDCADDS	State	1	Y
115	UDCAT1	Search Type	1	Y
116	UDCCTR	Country Code	1	Y
117	UDCEEOJ	EEO Job Category	1	Y
118	UDCEEOM	Ethnic Code	1	Y
119	UDCEST	Employment Status	1	Y
120	UDCFLSA	Overtime Extempt	1	Y
121	UDCJBCD	Job Type	1	Y
122	UDCJBST	Job Step	1	Y
123	UDCJGRP	Job Group	1	Y
124	UDCJSTA	Job Status	1	Y
125	UDCLNGP	Language Preference	1	Y
126	UDCMAIL	Check Route Code	1	Y
127	UDCMSTX	Marital Status	1	Y
128	UDCP001	Category Code 1	1	Y
129	UDCP0010	Category Code 10	1	Y
130	UDCP0011	Category Code 11	1	Y
131	UDCP0012	Category Code 12	1	Y
132	UDCP0013	Category Code 13	1	Y
133	UDCP0014	Category Code 14	1	Y
134	UDCP0015	Category Code 15	1	Y
135	UDCP0016	Category Code 16	1	Y
136	UDCP0017	Category Code 17	1	Y
137	UDCP0018	Category Code 18	1	Y
138	UDCP0019	Category Code 19	1	Y
139	UDCP002	Category Code 2	1	Y
140	UDCP0020	Category Code 20	1	Y
141	UDCP003	Category Code 3	1	Y
142	UDCP004	Category Code 4	1	Y
143	UDCP005	Category Code 5	1	Y
144	UDCP006	Category Code 6	1	Y
145	UDCP007	Category Code 7	1	Y
146	UDCP008	Category Code 8	1	Y
147	UDCP009	Category Code 9	1	Y
148	UDCP010	Category Code 10	1	Y
149	UDCP011	Category Code 11	1	Y
150	UDCP012	Category Code 12	1	Y
151	UDCP013	Category Code 13	1	Y
152	UDCP014	Category Code 14	1	Y
153	UDCP015	Category Code 15	1	Y
154	UDCP016	Categpru Code 16	1	Y
155	UDCP017	Category Code 17	1	Y
156	UDCP018	Category Code 18	1	Y
157	UDCP019	Category Code 19	1	Y
158	UDCP020	Category Code 20	1	Y
159	UDCPAST	Pay Status	1	Y
160	UDCPFRQ	Pay Frequency	1	Y
161	UDCRCCD	Record Type	1	Y
162	UDCREQS	Requisition Status	1	Y
163	UDCSALU	Prefix	1	Y
164	UDCSALY	Pay Class	1	Y
165	UDCSEX	Gender	1	Y
166	UDCSHFT	Shift Code	1	Y
167	UDCSLOC	Locality	1	Y
168	UDCSUFF	Suffix	1	Y
169	UDCTYC	Emer Contact Type	1	Y
170	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

85 columns | 812 | TYTN | STOCK UDC

TOPUDC 00 / TT (Transaction Type) stock values