	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

105 columns | 812 | JBST | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	91	GL	JBST	Job Step	String	UDC	4	0
TOP05: Time Accounting and HRM Base
2	F05102	Goal Master	14	SM	JBST	Job Step	String	UDC	4	0
3	F05105	Goal Suggestions	13	GS	JBST	Job Step	String	UDC	4	0
4	F0609	Deduction/Benefit/Accrual Ledger File	19	Y$	JBST	Job Step	String	UDC	4	0
5	F06106	Employee Pay Instructions	59	YM	JBST	Job Step	String	UDC	4	0
6	F0618	Employee Transaction History	44	YT	JBST	Job Step	String	UDC	4	0
7	F0619	Benefit/Accrual Detail File	19	Y$	JBST	Job Step	String	UDC	4	0
8	F0625	Change Code History File	3	JB	JBST	Job Step	String	UDC	4	0
9	F06251	Step Progression Rate History File	5	JB	JBST	Job Step	String	UDC	4	0
10	F069106	Union Benefits Master	3	Y1	JBST	Job Step	String	UDC	4	0
11	F069126	Union Rates File	6	YL	JBST	Job Step	String	UDC	4	0
12	F06915	Holiday Table	16	JH	JBST	Job Step	String	UDC	4	0
13	F069162	Job Type/ Item Cross Reference File	2	JH	JBST	Job Step	String	UDC	4	0
14	F06923	Valid Job Type/ Step Constant	3	YH	JBST	Job Step	String	UDC	4	0
15	F06925	Employee/Vendor Cross Reference	4	YG	JBST	Job Step	String	UDC	4	0
16	F06936	Retro Pay Types Rate	7	JA	JBST	Job Step	String	UDC	4	0
17	F0709	Deduction/Benefit/Accrual Ledger File	24	Y$	JBST	Job Step	String	UDC	4	0
TOP05A: OW HR & PR Foundation
18	F060116	Employee Master Information	33	YA	JBST	Job Step	String	UDC	4	0
19	F0601161	Point-In-Time Employee Master	35	PT	JBST	Job Step	String	UDC	4	0
20	F060116W	EE Master Request File	33	YA	JBST	Job Step	String	UDC	4	0
21	F060116Z	Unedited Quick Hire Transaction File	26	SZ	JBST	Job Step	String	UDC	4	0
22	F06345	Historical Payroll Register	12	JL	JBST	Job Step	String	UDC	4	0
TOP05T: Time Entry
23	F06022	Employee Piecerate File	20	JA	JBST	Job Step	String	UDC	4	0
24	F06116	Employee Transaction Detail File	44	YT	JBST	Job Step	String	UDC	4	0
25	F06116Z1	Employee Transactions - Batch File	56	VL	JBST	Job Step	String	UDC	4	0
26	F06278	Retro Timecard Detail File	42	YT	JBST	Job Step	String	UDC	4	0
27	F06290	Payroll Accounting Journal Work File	19	YR	JBST	Job Step	String	UDC	4	0
28	F063951	Payroll Journal (Compressed) File	28	GL	JBST	Job Step	String	UDC	4	0
29	F06904	Automatic Accounting Instructions	20	Y#	JBST	Job Step	String	UDC	4	0
30	F069136	Tip Disbursement	17	JE	JBST	Job Step	String	UDC	4	0
31	F06918	PF - Piece Rate File	4	JN	JBST	Job Step	String	UDC	4	0
32	F06932	Classification/Pay Cross Reference	2	J4	JBST	Job Step	String	UDC	4	0
TOP06: Payroll (old) - Obsolete-do not reuse
33	F060118	Employee Jobs	4	YE	JBST	Job Step	String	UDC	4	0
34	F060119	Employee Jobs History File	4	YE	JBST	Job Step	String	UDC	4	0
35	F060146	Employees Pay Rate File	5	JI	JBST	Job Step	String	UDC	4	0
TOP07: Payroll
36	F05290	WF - Payroll Journal (Detail)	28	JR	JBST	Job Step	String	UDC	4	0
37	F06270	Retro Processing Parameter	45	JP	JBST	Job Step	String	UDC	4	0
38	F063106	Deduction/Benefit Work File	10	Y7	JBST	Job Step	String	UDC	4	0
39	F07100	CCQ WORKFILE	5	F7	JBST	Job Step	String	UDC	4	0
40	F0716701	Employee Assignment T/E Template Information	5	EA	JBST	Job Step	String	UDC	4	0
41	F0716709	Employee Assignment T/E Template Info History	5	EA	JBST	Job Step	String	UDC	4	0
42	F0717	ROE Summary History	41	JF	JBST	Job Step	String	UDC	4	0
43	F071861	Stub Detail Piece Rate History File	7	Y8	JBST	Job Step	String	UDC	4	0
44	F0719	DBA Transaction Detail History	24	Y$	JBST	Job Step	String	UDC	4	0
45	F0729	Employee DBA Override Instructions	72	Y9	JBST	Job Step	String	UDC	4	0
46	F073521	Stub Detail Piece Rate File	7	Y2	JBST	Job Step	String	UDC	4	0
47	F07355	Pre-Payroll Error File	22	Y5	JBST	Job Step	String	UDC	4	0
48	F074001	New Hire Reporting Workfile - OneWorld Only	82	NH	JBST	Job Step	String	UDC	4	0
49	F07850	Group Fund Setup	7	FG	JBST	Job Step	String	UDC	4	0
50	F07UI200	Timecard History Work File	47	TH	JBST	Job Step	String	UDC	4	0
TOP08: Human Resources
51	F0800601	Organizational Business Unit/Job Cross-Reference	3	JC	JBST	Job Step	String	UDC	4	0
52	F0800605	Job Type/Step Competencies	2	JC	JBST	Job Step	String	UDC	4	0
53	F0800609	Gap Analysis Snapshot	9	YI	JBST	Job Step	String	UDC	4	0
54	F0800610	Competencies in Structure and Job	3	JC	JBST	Job Step	String	UDC	4	0
55	F0800612	User Defined Job Competency Description Reference	10	JC	JBST	Job Step	String	UDC	4	0
56	F08006WF	Job Competency Default Overrides Work File	8	JC	JBST	Job Step	String	UDC	4	0
57	F08092	Human Resources General Description-User Def Codes	5	JZ	JBST	Job Step	String	UDC	4	0
58	F08093	Human Resources General Description - Narration	5	JY	JBST	Job Step	String	UDC	4	0
59	F082003	Grade/Step Progression Detail File	6	YW	JBST	Job Step	String	UDC	4	0
60	F083305	Mail Merge Header/Detail	23	MM	JBST	Job Step	String	UDC	4	0
61	F087101	Default Setup Tasks	2	DT	JBST	Job Step	String	UDC	4	0
62	F087711	CBPA Appraisal Header	16	XJ	JBST	Job Step	String	UDC	4	0
63	F08JDWF1	Job Description Changes Integration Work File	8	JC	JBST	Job Step	String	UDC	4	0
64	F08JDWF2	Job Description History Integration Work File	4	JH	JBST	Job Step	String	UDC	4	0
TOP08A: eRecruit
65	F08470	Job Postings	19	JP	JBST	Job Step	String	UDC	4	0
TOP08AD: ADP Integration
66	F051371	ADP Employee DBA Instructions	64	AD	JBST	Job Step	String	UDC	4	0
67	F051372	ADP Employee Job Master Information	9	AD	JBST	Job Step	String	UDC	4	0
TOP08B: Benefits Administration
68	F0833WF	Benefit Statement Work file	20	WF	JBST	Job Step	String	UDC	4	0
TOP08H: Health and Safety
69	F08601	Injury/Illness Case Master	6	HL	JBST	Job Step	String	UDC	4	0
TOP08P: Position Control
70	F08001	Job information	3	JM	JBST	Job Step	String	UDC	4	0
71	F08005	Business Unit/ Job Id. X-Ref	3	JV	JBST	Job Step	String	UDC	4	0
72	F08101	Position Master	15	HP	JBST	Job Step	String	UDC	4	0
73	F08101P	Purge - Position Master	15	HP	JBST	Job Step	String	UDC	4	0
74	F08111	Position Budget Detail	9	HQ	JBST	Job Step	String	UDC	4	0
75	F08111P	Purge - Position Budget Detail	9	HQ	JBST	Job Step	String	UDC	4	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
76	F08102	Requisition Information	14	HN	JBST	Job Step	String	UDC	4	0
77	F08401	Applicant Master	8	HA	JBST	Job Step	String	UDC	4	0
78	F08401WF	Applicant Work File	9	XN	JBST	Job Step	String	UDC	4	0
TOP08U: OW HR US
79	F08910	CORBA Qualified Beneficiary File	30	J1	JBST	Job Step	String	UDC	4	0
80	F08920	COBRA Coverage	9	JS	JBST	Job Step	String	UDC	4	0
TOP08W: Wage and Salary
81	F08201	Salary Review Workfile	16	HR	JBST	Job Step	String	UDC	4	0
82	F08830WF	Compensation Root Work Table	32	YN	JBST	Job Step	String	UDC	4	0
TOP09: General Accounting
83	F0911P	Purge - Account Ledger	91	GL	JBST	Job Step	String	UDC	4	0
84	F0911Z1	Journal Entry Transactions - Batch File	108	VN	JBST	Job Step	String	UDC	4	0
85	F0911Z4	F0911 Interoperability Table	113	SZ	JBST	Job Step	String	UDC	4	0
86	F09UI015	Indexed Computations Multi-Tiered Entries	91	GL	JBST	Job Step	String	UDC	4	0
TOP12: Fixed Assets
87	F1201	Asset Master File	84	FA	JBST	Job Step	String	UDC	4	0
88	F1201P	Asset Master Purge Table	84	FA	JBST	Job Step	String	UDC	4	0
89	F1201Z1	Unedited Asset Master Transactions	95	FA	JBST	Job Step	String	UDC	4	0
TOP18: Resource Scheduling
90	F186301	Timecard Templates	26	TT	JBST	Job Step	String	UDC	4	0
91	F186602	Labor Rules Tag File	55	TF	JBST	Job Step	String	UDC	4	0
TOP42: Sales Management
92	F42800G1	Sales Update G Batch Detail Workfile	77	DG	JBST	Job Step	String	UDC	4	0
TOP48S: Service Billing
93	F48096	Billing Rate / Mark up Table	11	WQ	JBST	Job Step	String	UDC	4	0
94	F4812	Billing Detail Workfile	35	WD	JBST	Job Step	String	UDC	4	0
95	F4812H	Billing Workfile - History	35	WD	JBST	Job Step	String	UDC	4	0
96	F4812HS	Billing Workfile History Purged Save	35	WD	JBST	Job Step	String	UDC	4	0
97	F48S0618	Payroll Reclassification Workfile	44	YT	JBST	Job Step	String	UDC	4	0
98	F48S910	Billing Detail Journal File	49	W2	JBST	Job Step	String	UDC	4	0
99	F48S911	Compressed Journal File	40	W3	JBST	Job Step	String	UDC	4	0
100	F48SUI01	Billing Detail Print Workfile	35	WD	JBST	Job Step	String	UDC	4	0
TOP52: Contract Billing
101	F5212	T and M - Unit Price and Lumpsum Cross Reference Accounts	14	G5	JBST	Job Step	String	UDC	4	0
TOP75Z: New Zealand - Reporting System Only
102	F75Z0008	New Zealand Special Rates	6	Z8	JBST	Job Step	String	UDC	4	0
TOP77: Payroll (Canadian)
103	F07183	Commission History Detail File	12	ZB	JBST	Job Step	String	UDC	4	0
TOP89: Conversion Programs
104	F07186T	Piece Rate History File	7	Y8	JBST	Job Step	String	UDC	4	0
105	F07352T	Piece Rate Stub Detail Tag File	7	Y2	JBST	Job Step	String	UDC	4	0

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

TOPUDC 06 / GS (Job Step) stock values

	Value	Description	Hard Coded
1		.	N
2	1	Level I (Entry Level)	N
3	2	Level II	N
4	3	Level III	N
5	4	Level IV	N
6	5	Level V	N
7	9	Level IX	N
8	A	Apprentice	N
9	A.1	Apprentice 1	N
10	A.2	Apprentice 2	N
11	A.3	Apprentice 3	N
12	ARM	Armed	N
13	ARMN	Not armed	N
14	FORE	Foreman	N
15	J	Journeyman	N
16	JR	Junior	N
17	M	Master	N
18	PR	Principal in charge	N
19	SR	Senior	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

105 columns | 812 | JBST | STOCK UDC

TOPUDC 06 / GS (Job Step) stock values