	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

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

117 columns | 920 | JBST | STOCK UDC

TOPUDC 06 / GS (Job Step) stock values