	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

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

	Value	Description	Hard Coded
1	00	Original	Y
2	01	Cancellation	Y
3	02	Add	N
4	03	Delete	N
5	04	Change	Y
6	05	Replace	Y
7	06	Confirmation	Y
8	07	Duplicate	N
9	08	Status	N
10	10	Not Found	N
11	11	Response	N
12	12	Not Processed	N
13	13	Request	N
14	14	Advance Notification	N
15	15	Re-Submission	N
16	16	Proposed	N
17	17	Cancel to be Reissued	N
18	18	Reissue	N
19	19	Seller Initiated Change	N
20	20	Final Transmission	N
21	21	Transaction on Hold	N
22	22	Information Copy	N
23	24	Draft	N
24	25	Incremental	N
25	26	Replace-Specified Buyer Part	N
26	27	Verify	N
27	28	Query	N
28	30	Renewal	N
29	31	Allowance/Addition	N
30	32	Recovery/Deduction	N
31	33	Request for Payment	N
32	34	Payment Declined	N
33	35	Request Authority	N
34	36	Authority to Deduct (Reply)	N
35	37	Authority Declined (Reply)	N
36	38	No Financial Value	N
37	41	Corrected and Verified	N
38	42	Temporary Record	N
39	43	Request Permission to Service	N
40	44	Rejection	N
41	45	Followup	N
42	46	Cancellation with Refund	N
43	47	Transfer	N
44	48	Suspended	N
45	49	Original - No Response Necess.	N
46	50	Registar	N
47	51	Historical Inquiry	N
48	52	Response to Historical Inquiry	N
49	53	Completion	N
50	54	Approval	N
51	5C	Chargeable Resubmission	N
52	77	Simulation Exercise	N
53	A	Add	Y
54	AI	Add Additional Item(s)	Y
55	C	Change	Y
56	CA	Changes to Line Items	N
57	CB	Change of Date Terms	N
58	CC	Changes To Terms	N
59	CE	Chg-Item Level Allowance/Chg	N
60	CF	Cancel Prev Transmitted P.O.	N
61	CG	Chg-Total Lev Allowance/Charge	N
62	CH	Chg Orig Confirm Corig Announc	N
63	CI	Chg Confirm Revised Announce	N
64	CN	Complete Notification	N
65	CO	Corrected	N
66	CT	Change of Dates	N
67	D	Delete	Y
68	DI	Delete Item(s)	N
69	I	Inquiry	Y
70	MU	(Mult) Un Price Qty Reshed Chg	N
71	NC	Concurrent Item (No Change)	N
72	OA	Orig Confirm Revised Announce	N
73	OC	Orig Confirm of Orig Announce	N
74	PC	Price Change	N
75	PQ	Unit Price/Quantity Change	N
76	PR	Unit Price/Reschedule Change	N
77	QD	Quantity Decrease	N
78	QI	Quantity Increase	N
79	R	Replace	Y
80	RA	Replace Mode of Shipment	N
81	RB	Replace All Dates	N
82	RC	Reject Item Change	N
83	RE	Replacement Item	N
84	RH	Release Hold	N
85	RM	Replacement Item-Modifications	N
86	RQ	Reschedule/Quantity Change	N
87	RS	Reschedule	N
88	RZ	Replace All Values	N
89	S	Same as Except	Y
90	SU	Status Update	N
91	TI	Transfer Item	N
92	UA	Update - After Image	Y
93	UB	Update - Before Image	Y
94	ZZ	Mutual Defined	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

83 columns | 920 | TNAC | STOCK UDC

TOPUDC 00 / TA (Transaction Action) stock values