	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

29 columns | 920 | TPUR | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP40R: Demand Scheduling
1	F40R11	Demand Detail	50	DD	TPUR	Transaction Set Purpose	String	UDC	2	0
2	F40R41	Demand History	55	DI	TPUR	Transaction Set Purpose	String	UDC	2	0
3	F47171	EDI Demand Header	17	EH	TPUR	Transaction Set Purpose	String	UDC	2	0
TOP43: Procurement
4	F43121Z1	Receipts Unedited Transaction Table	14	SZ	TPUR	Transaction Set Purpose	String	UDC	2	0
TOP43S: JSSS/Supplier Self Service
5	F43001	Procurement Self-Service Transaction Log	15	SA	TPUR	Transaction Set Purpose	String	UDC	2	0
TOP45: Advanced Pricing
6	F4576Z1	Ship and Debit Claims Unedited Transaction Table	103	Z1	TPUR	Transaction Set Purpose	String	UDC	2	0
TOP47: Electronic Commerce
7	F47011	EDI Purchase Order Header - Inbound	18	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
8	F47016	EDI Purchase Order Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
9	F47021	EDI P.O. Acknowledgment Header - Inbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
10	F47026	EDI P.O. Acknowledgment Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
11	F47031	EDI Shipping Notice Header - Inbound	16	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
12	F47036	EDI Shipping Notice Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
13	F47046	EDI Invoice Header (Sales) - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
14	F47061	EDI Planning Schedule Header - Inbound	15	MJ	TPUR	Transaction Set Purpose	String	UDC	2	0
15	F47066	EDI Planning Schedule Header - Outbound	15	MJ	TPUR	Transaction Set Purpose	String	UDC	2	0
16	F47071	EDI Receiving Advice Header - Inbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
17	F47076	EDI Receiving Advice Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
18	F47081	EDI Price Sales Catalog Header - Inbound	15	FV	TPUR	Transaction Set Purpose	String	UDC	2	0
19	F47091	EDI Request for Quote Header - Inbound	16	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
20	F47096	EDI Request for Quote Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
21	F47101	EDI Response to RFQ Header - Inbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
22	F47106	EDI Response to RFQ Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
23	F47131	EDI Purchase Order Change Header - Inbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
24	F47136	EDI Purchase Order Change Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
25	F47141	EDI P.O. Change Acknowledgment Header - Inbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
26	F47146	EDI P.O. Change Acknowledgment Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
27	F47156	EDI Shipping Schedule Header - Outbound	15	SY	TPUR	Transaction Set Purpose	String	UDC	2	0
28	F47181	EDI Consumption Header (FUTURE)	7	EH	TPUR	Transaction Set Purpose	String	UDC	2	0
29	F47191	EDI Acknowledgement Header	15	AH	TPUR	Transaction Set Purpose	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 47 / PU (Transaction Set Purpose Code) stock values

	Value	Description	Hard Coded
1	00	Original	N
2	01	Cancellation	N
3	02	Add	N
4	03	Delete	N
5	04	Change	N
6	05	Replace	N
7	06	Confirmation	N
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
15	15	Re-Submission
16	16	Proposed
17	17	Cancel, to be Reissued
18	18	Reissue
19	19	Seller Initiated Change
20	20	Final Transmission
21	21	Transaction on Hold
22	22	Information Copy
23	25	Incremental
24	26	Replace - Specified Buyer Part
25	27	Verify
26	28	Query
27	30	Renewal
28	31	Allowance/Addition
29	32	Recovery/Deduction
30	33	Request for Payment
31	34	Payment Declined
32	35	Request Authority
33	36	Authority to Deduct (Reply)
34	37	Authority Declined (Reply)
35	38	No Financial Value
36	41	Corrected and Verified
37	42	Temporary Record
38	43	Request Permission to Service
39	44	Rejection
40	45	Followup
41	46	Cancellation with Refund
42	47	Transfer
43	48	Suspended
44	49	Original - No Response Necess.
45	50	Registar
46	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

29 columns | 920 | TPUR | STOCK UDC

TOPUDC 47 / PU (Transaction Set Purpose Code) stock values