	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

6 columns | 812 | OMWAC | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOPH92: Interactive Engine/OL
1	F98210	OMW Log Header	5	LH	OMWAC	Object Management Action Code	String	UDC	5	0
2	F98222	OMW Project Objects	15	PO	OMWAC	Object Management Action Code	String	UDC	5	0
3	F98223	OMW Allowed Actions	4	AA	OMWAC	Object Management Action Code	String	UDC	5	0
4	F98225	OMW Transfer Activity Rules	9	TR	OMWAC	Object Management Action Code	String	UDC	5	0
5	F98231D	OMW Transfer Activity Rule Director - Detail	2	TD	OMWAC	Object Management Action Code	String	UDC	5	0
6	F9829	OMW Notification Subscriptions	7	OS	OMWAC	Object Management Action Code	String	UDC	5	0

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

TOPUDC H92 / AC (OMW Actions) stock values

	Value	Description	Hard Coded
1	01	Transfer	Y
2	02	Check-In	Y
3	03	Check-Out	Y
4	04	Delete	Y
5	05	Add	Y
6	06	Copy	Y
7	07	Install	Y
8	08	Save	Y
9	09	Restore	Y
10	10	Design	Y
11	106	Get ObjectID	Y
12	109	Generate Web Specs	Y
13	11	Get	Y
14	12	Remove Object From Project	N
15	13	Update Project	Y
16	14	Update Project User	Y
17	15	Remove User From Project	Y
18	16	Add Object to Project	Y
19	20	Request Token	Y
20	21	Switch Token	Y
21	22	Add to Token Queue	Y
22	23	Force Release From Token Queue	Y
23	30	Erase Check-Out	Y
24	31	Rollback	Y
25	32	Backup	Y
26	35	Validate Check-Out Date	Y
27	36	Is Local	Y
28	37	Is Different	Y
29	38	Status Change	Y
30	Z100	Get Object From Project	Y
31	Z101	Get User From Project	Y
32	Z102	Update Project Object	Y
33	Z103	Copy Object from Project	Y
34	Z104	Move Object to Project	Y
35	Z105	Assign Token	Y
36	Z108	Get OMW Feature	Y
37	Z700	PARAMETER_OBJECTTYPE	Y
38	Z7000	eP_PARAMETER_PO_PROMPT_FLAG	Y
39	Z7001	eP_PARAMETER_VER_SECURITY	Y
40	Z7002	eP_PARAMETER_PO_DATA	Y
41	Z7003	eP_PARAMETER_BHVRCOM	Y
42	Z7004	eP_PARAMETER_VOID	Y
43	Z7005	eP_PARAMETER_SETSEL_FLAG	Y
44	Z7006	eP_PARAMETER_FORM_TO_CALL	Y
45	Z7007	eP_PARAMETER_REPLACE_SAVELOC	Y
46	Z7008	eP_PARAMETER_DEL_FROMSRVR	Y
47	Z7009	eP_PARAMETER_DEL_COMPLETELY	Y
48	Z701	PARAMETER_OBJECTID	Y
49	Z7010	eP_PARAMETER_GLOSSARY_ITEM	Y
50	Z7011	eP_PARAMETER_INHERIT_TOKEN	Y
51	Z7012	eP_PARAMETER_UPDATEDPROJECTSLI	Y
52	Z7013	eP_PARAMETER_NEWPROJECTID	Y
53	Z7014	eP_PARAMETER_NOSTATUSUPDATE	Y
54	Z7015	eP_PARAMETER_FROMSARSTATUS	Y
55	Z7016	eP_PARAMETER_TOSARSTATUS	Y
56	Z7017	eP_PARAMETER_XFERREDINHERITOBJ	Y
57	Z7018	eP_PARAMETER_OL_PACKAGECOL	Y
58	Z7019	eP_PARAMETER_OL_BASEMEMBER	Y
59	Z702	PARAMETER_PROJECTID	Y
60	Z7020	eP_PARAMETER_OL_PROCESSOP	Y
61	Z7021	eP_PARAMETER_OL_GTFUTURE	Y
62	Z7022	eP_PARAMETER_OL_TYPETEXT	Y
63	Z7023	eP_PARAMETER_OL_TEXTFILE	Y
64	Z7024	eP_PARAMETER_OL_CURRENCY	Y
65	Z7025	eP_PARAMETER_OL_APPLID	Y
66	Z7026	eP_PARAMETER_OL_ANSI	Y
67	Z7027	eP_PARAMETER_DEL_SAVE	Y
68	Z7028	eP_PARAMETER_OBJSNOTMODIFIEDOB	Y
69	Z7029	eP_PARAMETER_PROJECTPOINTERLIS	Y
70	Z703	PARAMETER_OBJECTDESCRIPTION	Y
71	Z7030	ePARAMETER_FROMPATH	Y
72	Z7031	ePARAMETER_TOPATH	Y
73	Z7032	ePARAMETER_PACKAGE_NAME	Y
74	Z7039	eP_PARAMETER_OMWFEATURETYPE	Y
75	Z704	PARAMETER_RELEASE	Y
76	Z7043	eP_PARAMETER_TEXT_SEARCH_BSVW	Y
77	Z7044	eP_PARAMETER_NO_PROGRESS_DLG	Y
78	Z7045	eP_PARAMETER_PRINT_IMMEDIATE	Y
79	Z705	PARAMETER_PROGRAMID	Y
80	Z7050	eP_PARAMETER_NONOL_WF_PROCESS	Y
81	Z7051	eP_PARAMETER_NONOL_WF_VERSION	Y
82	Z7052	eP_PARAMETER_NONOL_WF_DESC	Y
83	Z7053	eP_PARAMETER_NONOL_WF_PROD_CD	Y
84	Z7054	eP_PARAMETER_NONOL_WF_KEY_DS	Y
85	Z7055	eP_PARAMETER_NONOL_WF_ADD_DS	Y
86	Z7056	eP_PARAMETER_NONOL_WF_HISTORY	Y
87	Z7057	eP_PARAMETER_NONOL_WF_CPY_PROC	Y
88	Z7058	eP_PARAMETER_NONOL_WF_CPY_VER	Y
89	Z7059	eP_PARAMETER_NONOL_WF_CAT_1	Y
90	Z706	PARAMETER_METHOD	Y
91	Z7060	eP_PARAMETER_NONOL_WF_CAT_2	Y
92	Z7061	eP_PARAMETER_NONOL_WF_CAT_3	Y
93	Z7062	eP_PARAMETER_NONOL_WF_ESCALATE	Y
94	Z707	PARAMETER_TOSTATUS	Y
95	Z708	PARAMETER_FROMTSTATUS	Y
96	Z709	PARAMETER_TOPATHCODE	Y
97	Z710	PARAMETER_FROMPATHCODE	Y
98	Z711	PARAMETER_TOENV	Y
99	Z712	PARAMETER_FROMENV	Y
100	Z713	PARAMETER_TODS	Y
101	Z714	PARAMETER_FROMDS	Y
102	Z715	PARAMETER_CURRENTPROJECT	Y
103	Z716	PARAMETER_CURRENTSTATUS	Y
104	Z717	PARAMETER_SEVERITY	Y
105	Z718	PARAMETER_SARNUMBER	Y
106	Z719	PARAMETER_SIGNONUSER	Y
107	Z720	PARAMETER_SIGNONUSERROLE	Y
108	Z721	PARAMETER_VERSIONID	Y
109	Z722	PARAMETER_DELETELOCALONLY	Y
110	Z723	PARAMETER_OBJECTINTERFACEPO	Y
111	Z724	PARAMETER_LOGINTERFACEPOINT	Y
112	Z725	eP_PARAMETER_SYSTEMCODE	Y
113	Z726	eP_PARAMETER_PLANCOMPLETEDATE	Y
114	Z727	eP_PARAMETER_CATEGORYCODE1	Y
115	Z728	eP_PARAMETER_CATEGORYCODE2	Y
116	Z729	eP_PARAMETER_CATEGORYCODE3	Y
117	Z730	eP_PARAMETER_CATEGORYCODE4	Y
118	Z731	eP_PARAMETER_CATEGORYCODE5	Y
119	Z732	eP_PARAMETER_CATEGORYCODE6	Y
120	Z733	eP_PARAMETER_CATEGORYCODE7	Y
121	Z734	eP_PARAMETER_CATEGORYCODE8	Y
122	Z735	eP_PARAMETER_CATEGORYCODE9	Y
123	Z736	eP_PARAMETER_CATEGORYCODE10	Y
124	Z737	eP_PARAMETER_PROJECTTYPE	Y
125	Z738	eP_PARAMETER_PROJECTDESC	Y
126	Z739	PARAMETER_AUTOHUSER	Y
127	Z740	PARAMETER_HWND	Y
128	Z741	P_PARAMETER_OKCANCEL	Y
129	Z742	P_OL_ADD_MODE_FLAG	Y
130	Z743	P_PARAMETER_REPSYSTEMCODE	Y
131	Z744	P_PARAMETER_OL_FUNC_USE	Y
132	Z745	eP_PARAMETER_OL_TC_FLAG	Y
133	Z746	eP_PARAMETER_OL_COL_PREFIX	Y
134	Z747	eP_PARAMETER_OL_DSTR_TYPE	Y
135	Z748	eP_PARAMETER_OL_SRC_LANG	Y
136	Z749	P_PARAMETER_CLIENT_SERVER	Y
137	Z750	P_PARAMETER_CREATIONDATE	Y
138	Z751	P_PARAMETER_STARTDATE	Y
139	Z752	eP_PARAMETER_OL_COMMON_FILE	Y
140	Z753	eP_PARAMETER_OL_COPY_DATA	Y
141	Z754	eP_PARAMETER_OL_OPT_DATA	Y
142	Z755	eP_PARAMETER_OL_PO_TEMPLATE	Y
143	Z756	eP_PARAMETER_OL_PAR_DLL	Y
144	Z757	eP_PARAMETER_OL_CC1	Y
145	Z758	eP_PARAMETER_OL_CC2	Y
146	Z759	eP_PARAMETER_OL_CC3	Y
147	Z760	eP_PARAMETER_OL_CC4	Y
148	Z761	eP_PARAMETER_OL_CC5	Y
149	Z762	eP_PARAMETER_PROMPT_USER	Y
150	Z763	P_PARAMETER_PRJHANDLE	Y
151	Z764	P_PRJPOINTER	Y
152	Z765	P_DESIGN MODE	Y
153	Z766	eP_PARAMETER_PROJECTLEAD	Y
154	Z767	eP_PARAMETER_ESTHOURS	Y
155	Z768	eP_PARAMETER_DATEASSIGNED	Y
156	Z769	eP_PARAMETER_TIMEASSIGNED	Y
157	Z770	eP_PARAMETER_ER_PRODTYPE	Y
158	Z771	eP_PARAMETER_REFERENCESAR	Y
159	Z772	eP_PARAMETER_COMPLETEDATE	Y
160	Z773	eP_PARAMETER_TRUE_FALSE	Y
161	Z774	eP_PARAMETER_OL_OMIT_OPT	Y
162	Z775	eP_PARAMETER_OL_GLBL_BUILD	Y
163	Z776	eP_PARAMETER_OL_JDETEXT	Y
164	Z777	eP_PARAMETER_OL_OBJ_CAT	Y
165	Z778	eP_PARAMETER_OL_PAR_OBN	Y
166	Z780	eP_PARAMETER_LOCATION	Y
167	Z781	eP_PARAMETER_NEWRELEASE	Y
168	Z782	eP_PARAMETER_DEAD_LOCK_PROJECT	Y
169	Z783	eP_PARAMETER_DEAD_LOCK_OBJECT	Y
170	Z784	eP_PARAMETER_ASSIGNED_TOKEN_PR	Y
171	Z785	eP_PARAMETER_ASSIGNED_TOKEN_OB	Y
172	Z786	eP_PARAMETER_PROOF_FINAL	Y
173	Z787	eP_PARAMETER_TDA_DATA	Y
174	Z788	eP_PARAMETER_TSE_OTHERUSER	Y
175	Z789	eP_PARAMETER_NEW_PO_TEMPLATE	Y
176	Z790	eP_PARAMETER_CUSTOMER_NUMBER	Y
177	Z791	eP_PARAMETER_ORIGINATOR	Y
178	Z792	eP_PARAMETER_PRODUCT_SUPPORT	Y
179	Z793	eP_PARAMETER_MANAGER	Y
180	Z794	eP_PARAMETER_SUPERVISOR	Y
181	Z795	eP_PARAMETER_ASSIGNED_TO	Y
182	Z796	eP_PARAMETER_TESTER	Y
183	Z797	eP_PARAMETER_LONGDESC	Y
184	Z798	eP_PARAMETER_COVERPAGE	Y
185	Z799	eP_PARAMETER_JOBQUEUE	Y
186	Z801	L_SETATTRIBUTE_TOSTATUS	Y
187	Z802	L_SETATTRIBUTE_FROMSTATUS	Y
188	Z803	L_SETATTRIBUTE_TOPATHCODE	Y
189	Z804	L_SETATTRIBUTE_FROMPATHCODE	Y
190	Z805	L_SETATTRIBUTE_TOENV	Y
191	Z806	L_SETATTRIBUTE_FROMENV	Y
192	Z807	L_SETATTRIBUTE_TODS	Y
193	Z808	L_SETATTRIBUTE_FROMDS	Y
194	Z90	Create Object	Y
195	Z901	O_SETATTRIBUTE_TOSTATUS	Y
196	Z902	O_SETATTRIBUTE_CURRENTPROJECT	Y
197	Z903	O_SETATTRIBUTE_SARNUMBER	Y
198	Z904	O_SETATTRIBUTE_SIGNONUSER	Y
199	Z905	O_SETATTRIBUTE_SIGNONUSERROLE	Y
200	Z906	O_SETATTRIBUTE_VERSIONID	Y
201	Z907	O_SETATTRIBUTE_DELETELOCALONL	Y
202	Z91	Create Project	Y
203	Z92	Get Project	Y
204	Z93	Log Action	Y
205	Z94	Log Initilize	Y
206	Z95	Get Object	Y
207	Z950	O_GETATTRIBUTE_TOSTATUS	Y
208	Z951	O_GETATTRIBUTE_OMWRELEASE	Y
209	Z952	O_GETATTRIBUTE_SARNUMBER	Y
210	Z953	O_GETATTRIBUTE_SIGNONUSER	Y
211	Z954	O_GETATTRIBUTE_SIGNONUSERROLE	Y
212	Z955	O_GETATTRIBUTE_VERSIONID	Y
213	Z956	O_GETATTRIBUTE_OBJECTID	Y
214	Z957	O_GETATTRIBUTE_OBJECTTYPE	Y
215	Z958	O_GETATTRIBUTE_DESCRIPTION	Y
216	Z96	Delete Pointer reference	Y
217	Z97	Create Parameter Object	Y
218	Z99	Add User To Project	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

6 columns | 812 | OMWAC | STOCK UDC

TOPUDC H92 / AC (OMW Actions) stock values