	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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 | 920 | JBLC | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F0618	Employee Transaction History	130	YT	JBLC	Contract Labor Category	String	UDC	6	0
TOP05T: Time Entry
2	F06116	Employee Transaction Detail File	200	YT	JBLC	Contract Labor Category	String	UDC	6	0
3	F06116Z1	Employee Transactions - Batch File	210	VL	JBLC	Contract Labor Category	String	UDC	6	0
4	F06116Z2	ESS Timecard History	210	VM	JBLC	Contract Labor Category	String	UDC	6	0
TOP18: Timecard Automation
5	F186602	Labor Rules Tag File	204	TF	JBLC	Contract Labor Category	String	UDC	6	0
TOP48S: Service Billing
6	F48S0618	Payroll Reclassification Workfile	130	YT	JBLC	Contract Labor Category	String	UDC	6	0

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

TOPUDC 06 / G (Job Type) stock values

	Value	Description	Hard Coded
1		.	Y
2	#ALLOC	Allocated Tips record	N
3	#SUMM	Summarized Tips record	N
4	0A-0	Controller	N
5	0A-1	Accounting Manager	N
6	0A-10	Purchasing Agent	N
7	0A-2	Senior Accountant	N
8	0A-3	Financial Analyst	N
9	0A-4	Accountant	N
10	0P-0	Finance Director	N
11	0P-1	Asst Finance Director	N
12	0P-2	Accounts Payable Clerk III	N
13	0P-3	Lathe Operator - Apprentice 2	N
14	1M-1	MIS Manager	N
15	1M-2	IT Manager	N
16	1M-3	Senior MIS Manager	N
17	1M-4	Programmer Analyst	N
18	1M-5	IT Director	N
19	2H-1	Human Resources Manager	N
20	2H-2	Employment Representative	N
21	2H-3	Compensation Specialist	N
22	2H-4	Benefits Specialist	N
23	2H-5	EEO Specialist	N
24	2H-6	Instructor	N
25	3P-1	Payroll Manager	N
26	3P-2	Payroll Administrator	N
27	4-A1	Administrative Assistant	N
28	4A-1	Administrative Assistant	N
29	4A-2	Secretary	N
30	4A-3	Clerk	N
31	50PE	Project Engineer	N
32	50PM	Project Manager	N
33	50SU	Superintendent	N
34	5J-1	City Manager	N
35	5J-2	County Supervisor	N
36	5J-3	Purchasing Manager	N
37	5J-4	Fire Fighter	N
38	5J-5	Electrician	N
39	5J-6	Junior Engineer	N
40	5J-7	Nurse	N
41	5J-8	Teacher	N
42	5J-9	Journeyman	N
43	61	Foreman	N
44	62	Foreman	N
45	63	Equipment Operator	N
46	64	Engineer	N
47	64-1	Designer	N
48	64-5	Spec Typist	N
49	65	Draftsperson	N
50	67	Senior Electrician	N
51	68	Technician	N
52	69	Driver	N
53	6G-1	City Manager	N
54	6G-2	Purchasing Manager	N
55	6G-3	County Supervisor	N
56	6G-4	Fire Fighter	N
57	6G-5	Nurse	N
58	6S-1	Security Supervisor	N
59	6S-3	Security Screener	N
60	6S-5	Security Guard	N
61	7H-0	Hotel Manager	N
62	7H-1	Waiter/Waitress	N
63	7H-2	Hostess	N
64	7H-3	Housekeeper	N
65	7H-4	Service Worker (Bell Stand)	N
66	7H-5	Bartender	N
67	7H-6	Bus person	N
68	7H-7	Chef	N
69	8M-1	Maintenance Engineer	N
70	8M-2	Distribution Manager	N
71	8M-3	Clerk	N
72	8P-1	Plant Manager	N
73	8P-2	Foreman	N
74	8P-3	Lathe Operator - Apprentice 2	N
75	8P-4	Setup Person	N
76	8P-5	Production Worker	N
77	8P-6	QA Inspector	N
78	8P-7	Press Operator	N
79	8R-1	Maintenance Mechanic Junior	N
80	8R-2	Maintenance Electrician App 2	N
81	8R-3	Maintenance Instruc. Junior	N
82	999	Other	N
83	9S-1	Sales Management	N
84	9S-2	Sales Representative	N
85	A0	Chief Executive Officer	N
86	A1	President	N
87	A2	Vice President	N
88	ADMASS	Administrative Assistant	N
89	BOARD	Board of Directors	N
90	CC200	Corporate Controller	N
91	CLERK	Clerk	N
92	M1	Manager	N
93	M200	Manager	N
94	MX801	Administrador	N
95	MX802	Jefe de Operaciones	N
96	MX803	Asistente Administrativa	N
97	MX804	Supervisor	N
98	MX810	Tecnico Especialista	N
99	MX811	Electricista	N
100	MX812	Mecanico	N
101	MX813	Trabajos Generales	N
102	MX820	Operario - Eventuales	N
103	PB-1	Planner/Buyer	N
104	PRES	President	N
105	PROG	Associate Programmer	N
106	PROGRA	Programmer	N
107	SALREP	Sales Representative	N
108	SECRE	Secretary	N
109	TRN1	Trainer	N
110	TRNER	Trainer	N
111	TYPIST	Typist	N
112	VICPRE	Vice President	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

6 columns | 920 | JBLC | STOCK UDC

TOPUDC 06 / G (Job Type) stock values