	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

32 columns | 812 | OSTP | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F17001	Customer Service Constants Table - F17001	28	CS	OSTP	Organization Structure Type	String	UDC	3	0
TOP01: Address Book
2	F0150	Address Organization Structure Master File - OSTP - PA8 - AN8	1	MA	OSTP	Organization Structure Type	String	UDC	3	0
3	F01501	Enhanced Parent Child	1	PR	OSTP	Organization Structure Type	String	UDC	3	0
4	F01505	Tier Descriptions	2	TD	OSTP	Organization Structure Type	String	UDC	3	0
TOP31P: Engineer To Order
5	F31P01	Project Attributes	24	PA	OSTP	Organization Structure Type	String	UDC	3	0
6	F31P10	Project Quote Header	24	PQ	OSTP	Organization Structure Type	String	UDC	3	0
TOP40: Inventory/OP Base
7	F4009	Distribution/Manufacturing Constants	33	CP	OSTP	Organization Structure Type	String	UDC	3	0
TOP41: Inventory Management
8	F4101H	Item Hierarchy (Web)	1	IH	OSTP	Organization Structure Type	String	UDC	3	0
9	F4101HD	Item Hierarchy - Alternate Description	1	IH	OSTP	Organization Structure Type	String	UDC	3	0
TOP42: Sales Management
10	F4211	Sales Order Detail File	252	SD	OSTP	Organization Structure Type	String	UDC	3	0
11	F42119	Sales Order History File	252	SD	OSTP	Organization Structure Type	String	UDC	3	0
12	F42199	S.O. Detail Ledger File	252	SL	OSTP	Organization Structure Type	String	UDC	3	0
13	F42CSS	Customer Self Service Workfile	16	CS	OSTP	Organization Structure Type	String	UDC	3	0
14	F42UI11	SO Detail Cache File (MBF)	183	ZD	OSTP	Organization Structure Type	String	UDC	3	0
TOP42B: Sales Order Entry
15	F4211CZ1	Sales Order Detail Unedited Transaction File - CRM	20	CZ	OSTP	Organization Structure Type	String	UDC	3	0
16	F42420	Audit Log Transaction	112	AL	OSTP	Organization Structure Type	String	UDC	3	0
17	F47012T	EDI Purchase Order Detail Tag - Inbound	67	UZ	OSTP	Organization Structure Type	String	UDC	3	0
18	F47132T	EDI Purchase Order Change Detail Tag - Inbound	67	UZ	OSTP	Organization Structure Type	String	UDC	3	0
TOP43: Procurement
19	F43E09	F43E09 - Approvals Activity Table	14	AA	OSTP	Organization Structure Type	String	UDC	3	0
TOP43E: Requisition Self Service
20	F43E091	Approval Authority (Employee)	6	AE	OSTP	Organization Structure Type	String	UDC	3	0
21	F43E092	Approval Authority (Employee Group/BU)	7	AG	OSTP	Organization Structure Type	String	UDC	3	0
22	F43E093	Approval Authority (Business Unit)	6	AU	OSTP	Organization Structure Type	String	UDC	3	0
23	F43E095	Approval Authority (Commodity/BU)	7	AC	OSTP	Organization Structure Type	String	UDC	3	0
TOP76C: Colombia
24	F76C001	General Parameters - COL - 04	10	PG	OSTP	Organization Structure Type	String	UDC	3	0
TOP90CB: CRM Sales Force Automation
25	F90CB01D	Lead_Item_Hierarchy Table	2	LI	OSTP	Organization Structure Type	String	UDC	3	0
26	F90CB02I	Opportunity_Item Table	54	OI	OSTP	Organization Structure Type	String	UDC	3	0
27	F90CB06C	Opportunity_Item_For_Forecast Table	57	OH	OSTP	Organization Structure Type	String	UDC	3	0
TOP90CC: CRM Marketing Automation
28	F90CC040	Campaign table	4	CM	OSTP	Organization Structure Type	String	UDC	3	0
TOPH90: ONEWORLD TOOLS
29	F98840	Organizational Structure Master	2	OM	OSTP	Organization Structure Type	String	UDC	3	0
30	F98840N	Organizational Structure Master - Net Change	5	OM	OSTP	Organization Structure Type	String	UDC	3	0
31	F98845	Organizational Structure Rule	6	OR	OSTP	Organization Structure Type	String	UDC	3	0
32	F98845N	Organizational Structure Rule - Net Change	8	OR	OSTP	Organization Structure Type	String	UDC	3	0

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

TOPUDC 01 / TS (Parent/Child Structure Type) stock values

	Value	Description	Special Handling Code	Hard Coded
1		Accounts Receivable	1	N
2	99	1099 Structure		N
3	AA	Acknowledgement Approver		Y
4	CON	Customer Contacts		N
5	CSS	Customer Self-Service		N
6	EML	E-Mail Distribution		N
7	ERS	Expense Report Security		N
8	ES	Employee/Supervisor		N
9	ET	Employee Termination		N
10	ORG	Organization Structure	1	N
11	RSS	Requisition Self Service		Y
12	WFS	Workflow Security		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

32 columns | 812 | OSTP | STOCK UDC

TOPUDC 01 / TS (Parent/Child Structure Type) stock values