	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

127 columns | 812 | JBCD | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	90	GL	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP05: Time Accounting and HRM Base
2	F05102	Goal Master	13	SM	JBCD	Job Type (Craft) Code	String	UDC	6	0
3	F05105	Goal Suggestions	12	GS	JBCD	Job Type (Craft) Code	String	UDC	6	0
4	F0609	Deduction/Benefit/Accrual Ledger File	18	Y$	JBCD	Job Type (Craft) Code	String	UDC	6	0
5	F06106	Employee Pay Instructions	58	YM	JBCD	Job Type (Craft) Code	String	UDC	6	0
6	F0618	Employee Transaction History	43	YT	JBCD	Job Type (Craft) Code	String	UDC	6	0
7	F0619	Benefit/Accrual Detail File	18	Y$	JBCD	Job Type (Craft) Code	String	UDC	6	0
8	F0625	Change Code History File	2	JB	JBCD	Job Type (Craft) Code	String	UDC	6	0
9	F06251	Step Progression Rate History File	4	JB	JBCD	Job Type (Craft) Code	String	UDC	6	0
10	F069106	Union Benefits Master	2	Y1	JBCD	Job Type (Craft) Code	String	UDC	6	0
11	F069126	Union Rates File	5	YL	JBCD	Job Type (Craft) Code	String	UDC	6	0
12	F06915	Holiday Table	5	JH	JBCD	Job Type (Craft) Code	String	UDC	6	0
13	F069162	Job Type/ Item Cross Reference File	1	JH	JBCD	Job Type (Craft) Code	String	UDC	6	0
14	F06923	Valid Job Type/ Step Constant	2	YH	JBCD	Job Type (Craft) Code	String	UDC	6	0
15	F06925	Employee/Vendor Cross Reference	3	YG	JBCD	Job Type (Craft) Code	String	UDC	6	0
16	F06933	Step Progression Parameters	5	J@	JBCD	Job Type (Craft) Code	String	UDC	6	0
17	F06936	Retro Pay Types Rate	6	JA	JBCD	Job Type (Craft) Code	String	UDC	6	0
18	F0709	Deduction/Benefit/Accrual Ledger File	23	Y$	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP05A: OW HR & PR Foundation
19	F060116	Employee Master Information	32	YA	JBCD	Job Type (Craft) Code	String	UDC	6	0
20	F0601161	Point-In-Time Employee Master	34	PT	JBCD	Job Type (Craft) Code	String	UDC	6	0
21	F060116W	EE Master Request File	32	YA	JBCD	Job Type (Craft) Code	String	UDC	6	0
22	F060116Z	Unedited Quick Hire Transaction File	25	SZ	JBCD	Job Type (Craft) Code	String	UDC	6	0
23	F06345	Historical Payroll Register	11	JL	JBCD	Job Type (Craft) Code	String	UDC	6	0
24	F069056	Establishment Constant File	10	YO	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP05T: Time Entry
25	F06022	Employee Piecerate File	19	JA	JBCD	Job Type (Craft) Code	String	UDC	6	0
26	F06116	Employee Transaction Detail File	43	YT	JBCD	Job Type (Craft) Code	String	UDC	6	0
27	F06116Z1	Employee Transactions - Batch File	55	VL	JBCD	Job Type (Craft) Code	String	UDC	6	0
28	F06278	Retro Timecard Detail File	41	YT	JBCD	Job Type (Craft) Code	String	UDC	6	0
29	F06290	Payroll Accounting Journal Work File	18	YR	JBCD	Job Type (Craft) Code	String	UDC	6	0
30	F063951	Payroll Journal (Compressed) File	27	GL	JBCD	Job Type (Craft) Code	String	UDC	6	0
31	F06904	Automatic Accounting Instructions	19	Y#	JBCD	Job Type (Craft) Code	String	UDC	6	0
32	F069136	Tip Disbursement	6	JE	JBCD	Job Type (Craft) Code	String	UDC	6	0
33	F06918	PF - Piece Rate File	3	JN	JBCD	Job Type (Craft) Code	String	UDC	6	0
34	F069306	Union Local Cross Reference	3	Y@	JBCD	Job Type (Craft) Code	String	UDC	6	0
35	F06932	Classification/Pay Cross Reference	1	J4	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP06: Payroll (old) - Obsolete-do not reuse
36	F060118	Employee Jobs	3	YE	JBCD	Job Type (Craft) Code	String	UDC	6	0
37	F060119	Employee Jobs History File	3	YE	JBCD	Job Type (Craft) Code	String	UDC	6	0
38	F060146	Employees Pay Rate File	4	JI	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP07: Payroll
39	F05290	WF - Payroll Journal (Detail)	27	JR	JBCD	Job Type (Craft) Code	String	UDC	6	0
40	F06270	Retro Processing Parameter	44	JP	JBCD	Job Type (Craft) Code	String	UDC	6	0
41	F063106	Deduction/Benefit Work File	9	Y7	JBCD	Job Type (Craft) Code	String	UDC	6	0
42	F07100	CCQ WORKFILE	4	F7	JBCD	Job Type (Craft) Code	String	UDC	6	0
43	F0716701	Employee Assignment T/E Template Information	4	EA	JBCD	Job Type (Craft) Code	String	UDC	6	0
44	F0716709	Employee Assignment T/E Template Info History	4	EA	JBCD	Job Type (Craft) Code	String	UDC	6	0
45	F0717	ROE Summary History	40	JF	JBCD	Job Type (Craft) Code	String	UDC	6	0
46	F071861	Stub Detail Piece Rate History File	6	Y8	JBCD	Job Type (Craft) Code	String	UDC	6	0
47	F0719	DBA Transaction Detail History	23	Y$	JBCD	Job Type (Craft) Code	String	UDC	6	0
48	F0729	Employee DBA Override Instructions	71	Y9	JBCD	Job Type (Craft) Code	String	UDC	6	0
49	F073521	Stub Detail Piece Rate File	6	Y2	JBCD	Job Type (Craft) Code	String	UDC	6	0
50	F07355	Pre-Payroll Error File	21	Y5	JBCD	Job Type (Craft) Code	String	UDC	6	0
51	F074001	New Hire Reporting Workfile - OneWorld Only	81	NH	JBCD	Job Type (Craft) Code	String	UDC	6	0
52	F07880	SUI Magnetic Media Workfile	41	YW	JBCD	Job Type (Craft) Code	String	UDC	6	0
53	F07UI200	Timecard History Work File	46	TH	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08: Human Resources
54	F0800601	Organizational Business Unit/Job Cross-Reference	2	JC	JBCD	Job Type (Craft) Code	String	UDC	6	0
55	F0800605	Job Type/Step Competencies	1	JC	JBCD	Job Type (Craft) Code	String	UDC	6	0
56	F0800609	Gap Analysis Snapshot	8	YI	JBCD	Job Type (Craft) Code	String	UDC	6	0
57	F0800610	Competencies in Structure and Job	2	JC	JBCD	Job Type (Craft) Code	String	UDC	6	0
58	F0800612	User Defined Job Competency Description Reference	9	JC	JBCD	Job Type (Craft) Code	String	UDC	6	0
59	F08006WF	Job Competency Default Overrides Work File	7	JC	JBCD	Job Type (Craft) Code	String	UDC	6	0
60	F08092	Human Resources General Description-User Def Codes	4	JZ	JBCD	Job Type (Craft) Code	String	UDC	6	0
61	F08093	Human Resources General Description - Narration	4	JY	JBCD	Job Type (Craft) Code	String	UDC	6	0
62	F082003	Grade/Step Progression Detail File	5	YW	JBCD	Job Type (Craft) Code	String	UDC	6	0
63	F083305	Mail Merge Header/Detail	22	MM	JBCD	Job Type (Craft) Code	String	UDC	6	0
64	F087101	Default Setup Tasks	1	DT	JBCD	Job Type (Craft) Code	String	UDC	6	0
65	F087711	CBPA Appraisal Header	15	XJ	JBCD	Job Type (Craft) Code	String	UDC	6	0
66	F08JDWF1	Job Description Changes Integration Work File	7	JC	JBCD	Job Type (Craft) Code	String	UDC	6	0
67	F08JDWF2	Job Description History Integration Work File	3	JH	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08A: eRecruit
68	F08470	Job Postings	18	JP	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08AD: ADP Integration
69	F051371	ADP Employee DBA Instructions	63	AD	JBCD	Job Type (Craft) Code	String	UDC	6	0
70	F051372	ADP Employee Job Master Information	8	AD	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08B: Benefits Administration
71	F0833WF	Benefit Statement Work file	19	WF	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08H: Health and Safety
72	F08601	Injury/Illness Case Master	5	HL	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08P: Position Control
73	F08001	Job information	2	JM	JBCD	Job Type (Craft) Code	String	UDC	6	0
74	F08005	Business Unit/ Job Id. X-Ref	2	JV	JBCD	Job Type (Craft) Code	String	UDC	6	0
75	F08101	Position Master	14	HP	JBCD	Job Type (Craft) Code	String	UDC	6	0
76	F08101P	Purge - Position Master	14	HP	JBCD	Job Type (Craft) Code	String	UDC	6	0
77	F08111	Position Budget Detail	8	HQ	JBCD	Job Type (Craft) Code	String	UDC	6	0
78	F08111P	Purge - Position Budget Detail	8	HQ	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
79	F08102	Requisition Information	13	HN	JBCD	Job Type (Craft) Code	String	UDC	6	0
80	F08401	Applicant Master	7	HA	JBCD	Job Type (Craft) Code	String	UDC	6	0
81	F08401WF	Applicant Work File	8	XN	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08U: OW HR US
82	F08910	CORBA Qualified Beneficiary File	29	J1	JBCD	Job Type (Craft) Code	String	UDC	6	0
83	F08920	COBRA Coverage	8	JS	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP08W: Wage and Salary
84	F08201	Salary Review Workfile	15	HR	JBCD	Job Type (Craft) Code	String	UDC	6	0
85	F08830WF	Compensation Root Work Table	30	YN	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP09: General Accounting
86	F0911P	Purge - Account Ledger	90	GL	JBCD	Job Type (Craft) Code	String	UDC	6	0
87	F0911Z1	Journal Entry Transactions - Batch File	107	VN	JBCD	Job Type (Craft) Code	String	UDC	6	0
88	F0911Z4	F0911 Interoperability Table	112	SZ	JBCD	Job Type (Craft) Code	String	UDC	6	0
89	F09UI015	Indexed Computations Multi-Tiered Entries	90	GL	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP12: Fixed Assets
90	F1201	Asset Master File	83	FA	JBCD	Job Type (Craft) Code	String	UDC	6	0
91	F1201P	Asset Master Purge Table	83	FA	JBCD	Job Type (Craft) Code	String	UDC	6	0
92	F1201Z1	Unedited Asset Master Transactions	94	FA	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP13R: Resource Assignments
93	F48311	Resource Assignments	13	RA	JBCD	Job Type (Craft) Code	String	UDC	6	0
94	F48311S	Purge - Resource Assignments	13	RA	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP17: Customer Service Management
95	F3112Z2	Warranty Claim/Supplier Recovery processing	34	WL	JBCD	Job Type (Craft) Code	String	UDC	6	0
96	F4801TZ2	Warranty Claim/Supplier Recovery processing	60	WQ	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP18: Resource Scheduling
97	F186301	Timecard Templates	24	TT	JBCD	Job Type (Craft) Code	String	UDC	6	0
98	F186602	Labor Rules Tag File	54	TF	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP30: Product Data Management
99	F300311	Lean Multi Level Routing Detail File	31	EH	JBCD	Job Type (Craft) Code	String	UDC	6	0
100	F3003Z1	Routing Transactions File	48	SZ	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP31: Shop Floor Control
101	F3112	Work Order Routing	21	WL	JBCD	Job Type (Craft) Code	String	UDC	6	0
102	F3112S	Purge Shop Floor Control Routing Instructions	21	WL	JBCD	Job Type (Craft) Code	String	UDC	6	0
103	F3112Z1	Outbound Work Order Routings	34	SZ	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP40: Inventory/OP Base
104	F3003	Routing Master File	35	IR	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP42: Sales Management
105	F42800G1	Sales Update G Batch Detail Workfile	76	DG	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP48: Work Order Processing
106	F4801ST	Purge - Work Order Master Tag File	47	WA	JBCD	Job Type (Craft) Code	String	UDC	6	0
107	F4801T	Work Order Master Tag File	47	WA	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP48S: Service Billing
108	F48096	Billing Rate / Mark up Table	9	WQ	JBCD	Job Type (Craft) Code	String	UDC	6	0
109	F4812	Billing Detail Workfile	34	WD	JBCD	Job Type (Craft) Code	String	UDC	6	0
110	F4812H	Billing Workfile - History	34	WD	JBCD	Job Type (Craft) Code	String	UDC	6	0
111	F4812HS	Billing Workfile History Purged Save	34	WD	JBCD	Job Type (Craft) Code	String	UDC	6	0
112	F48S0618	Payroll Reclassification Workfile	43	YT	JBCD	Job Type (Craft) Code	String	UDC	6	0
113	F48S910	Billing Detail Journal File	48	W2	JBCD	Job Type (Craft) Code	String	UDC	6	0
114	F48S911	Compressed Journal File	39	W3	JBCD	Job Type (Craft) Code	String	UDC	6	0
115	F48SUI01	Billing Detail Print Workfile	34	WD	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP49: Transportation Management
116	F49004	Mode of Transport Constants	3	CT	JBCD	Job Type (Craft) Code	String	UDC	6	0
117	F49040	Vehicle Staff (Conversion from World File)	3	VS	JBCD	Job Type (Craft) Code	String	UDC	6	0
118	F49041	Depot/Vehicle Staff	6	VS	JBCD	Job Type (Craft) Code	String	UDC	6	0
119	F49614	Load Staff	3	TS	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP52: Contract Billing
120	F5212	T and M - Unit Price and Lumpsum Cross Reference Accounts	13	G5	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP75Z: New Zealand - Reporting System Only
121	F75Z0008	New Zealand Special Rates	5	Z8	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP77: Payroll (Canadian)
122	F07183	Commission History Detail File	11	ZB	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOP89: Conversion Programs
123	F07186T	Piece Rate History File	6	Y8	JBCD	Job Type (Craft) Code	String	UDC	6	0
124	F07352T	Piece Rate Stub Detail Tag File	6	Y2	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOPF30L: DFM Line Design
125	FF30L930	DFM Routings	36	LR	JBCD	Job Type (Craft) Code	String	UDC	6	0
TOPF31: Lean Transactions
126	FF31112	Routing Transaction Table	11	EH	JBCD	Job Type (Craft) Code	String	UDC	6	0
127	FF31112S	Purge - Routing Transaction Table	11	ET	JBCD	Job Type (Craft) Code	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		.	N
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	N
13	0P-3	Accounts Receivable Clerk	N
14	1M-1	MIS Manager	N
15	1M-2	IT Manager	N
16	1M-3	System Analyst	N
17	1M-4	Programmer Analyst	N
18	1M-5	Programmer	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	4A-1	Administrative Assistant	N
28	4A-2	Secretary	N
29	4A-3	Clerk	N
30	50PE	Project Engineer	N
31	50PM	Project Manager	N
32	50SU	Superintendent	N
33	5J-1	City Manager	N
34	5J-2	County Supervisor	N
35	5J-3	Purchasing Manager	N
36	5J-4	Fire Fighter	N
37	5J-5	Electrician	N
38	5J-6	Junior Engineer	N
39	5J-7	Nurse	N
40	5J-8	Teacher	N
41	5J-9	Journeyman	N
42	61	Foreman	N
43	62	Foreman	N
44	63	Equipment Operator	N
45	64	Engineer	N
46	64-1	Designer	N
47	64-5	Spec Typist	N
48	65	Draftsperson	N
49	66	Electrician	N
50	67	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	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

127 columns | 812 | JBCD | STOCK UDC

TOPUDC 06 / G (Job Type) stock values