	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

76 COLUMNS | 12 INDEXES | 920 | 08P | F08001 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08P: Position Control
1	920	F08001	JM	76	12	Job information	Master Files	08P: Position Control	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT JMJGRP, JMJBCD, JMJBST, JMDL01, JMSALY, JMPGRD, JMPFRQ, JMEEOJ, JMWCMP, JMWET, JMFLSA, JMDIVC, JMUN, JMEMET, JMEVD, JMEPNT, JMD001, JMD002, JMD003, JMD004, JMD005, JMD006, JMD007, JMD008, JMD009, JMD010, JMPT01, JMPT02, JMPT03, JMPT04, JMPT05, JMPT06, JMPT07, JMPT08, JMPT09, JMPT10, JMP001, JMP002, JMP003, JMP004, JMP005, JMP006, JMP007, JMP008, JMP009, JMP010, JMFE01, JMFE02, JMFE03, JMFE04, JMFE05, JMFE06, JMFE07, JMFE08, JMFE09, JMFE10, JMFW01, JMFW02, JMFW03, JMFW04, JMFW05, JMFW06, JMFW07, JMFW08, JMFW09, JMFW10, JMJSTA, JMEFTB, JMEFTE, JMUSER, JMPID, JMJOBN, JMUPMJ, JMPGRS, JMCENC, JMSTCR FROM F08001

TOP 920 | 08P | F08001 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	JMJGRP	Job Group	String	UDC (08 JG)	6	0	Allow NULL?
2	JMJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
3	JMJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
4	JMDL01	Description	String	Generic Edit	30	0	Allow NULL?
5	JMSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
6	JMPGRD	Pay Grade	String	Generic Edit	6	0	Allow NULL?
7	JMPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
8	JMEEOJ	Job Category (EEO)	String	UDC (06 J)	3	0	Allow NULL?
9	JMWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
10	JMWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
11	JMFLSA	FLSA Exempt Y/N	Character	UDC (05 FL)	1	0	Allow NULL?
12	JMDIVC	Benefit Group	String	Generic Edit	6	0	Allow NULL?
13	JMUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
14	JMEMET	Job Evaluation Method	String	UDC (08 EM)	4	0	Allow NULL?
15	JMEVD	Date - Job Evaluation (Julian)	Date	Generic Edit	6	0
16	JMEPNT	Job Evaluation Points	Numeric	Generic Edit	5	0	Allow NULL?
17	JMD001	Job Evaluation Factor-Points in Degr 001	Numeric	Generic Edit	5	0	Allow NULL?
18	JMD002	Job Evaluation Factor-Points in Degr 002	Numeric	Generic Edit	5	0	Allow NULL?
19	JMD003	Job Evaluation Factor-Points in Degr 003	Numeric	Generic Edit	5	0	Allow NULL?
20	JMD004	Job Evaluation Factor-Points in Degr 004	Numeric	Generic Edit	5	0	Allow NULL?
21	JMD005	Job Evaluation Factor-Points in Degr 005	Numeric	Generic Edit	5	0	Allow NULL?
22	JMD006	Job Evaluation Factor-Points in Degr 006	Numeric	Generic Edit	5	0	Allow NULL?
23	JMD007	Job Evaluation Factor-Points in Degr 007	Numeric	Generic Edit	5	0	Allow NULL?
24	JMD008	Job Evaluation Factor-Points in Degr 008	Numeric	Generic Edit	5	0	Allow NULL?
25	JMD009	Job Evaluation Factor-Points in Degr 009	Numeric	Generic Edit	5	0	Allow NULL?
26	JMD010	Job Evaluation Factor-Points in Degr 010	Numeric	Generic Edit	5	0	Allow NULL?
27	JMPT01	Job Evaluation Points per Factor 01	Numeric	Generic Edit	5	0	Allow NULL?
28	JMPT02	Job Evaluation Points per Factor 02	Numeric	Generic Edit	5	0	Allow NULL?
29	JMPT03	Job Evaluation Points per Factor 03	Numeric	Generic Edit	5	0	Allow NULL?
30	JMPT04	Job Evaluation Points per Factor 04	Numeric	Generic Edit	5	0	Allow NULL?
31	JMPT05	Job Evaluation Points per Factor 05	Numeric	Generic Edit	5	0	Allow NULL?
32	JMPT06	Job Evaluation Points per Factor 06	Numeric	Generic Edit	5	0	Allow NULL?
33	JMPT07	Job Evaluation Points per Factor 07	Numeric	Generic Edit	5	0	Allow NULL?
34	JMPT08	Job Evaluation Points per Factor 08	Numeric	Generic Edit	5	0	Allow NULL?
35	JMPT09	Job Evaluation Points per Factor 09	Numeric	Generic Edit	5	0	Allow NULL?
36	JMPT10	Job Evaluation Points per Factor 10	Numeric	Generic Edit	5	0	Allow NULL?
37	JMP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
38	JMP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
39	JMP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
40	JMP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
41	JMP005	Category Codes - Payroll5	String	UDC (06 05)	3	0	Allow NULL?
42	JMP006	Category Codes - Payroll6	String	UDC (06 06)	3	0	Allow NULL?
43	JMP007	Category Codes - Payroll7	String	UDC (06 07)	3	0	Allow NULL?
44	JMP008	Category Codes - Payroll8	String	UDC (06 08)	3	0	Allow NULL?
45	JMP009	Category Codes - Payroll9	String	UDC (06 09)	3	0	Allow NULL?
46	JMP010	Category Codes - Payroll10	String	UDC (06 10)	3	0	Allow NULL?
47	JMFE01	Factor Evaluation Code 1	String	Generic Edit	10	0	Allow NULL?
48	JMFE02	Factor Evaluation Code 2	String	Generic Edit	10	0	Allow NULL?
49	JMFE03	Factor Evaluation Code 3	String	Generic Edit	10	0	Allow NULL?
50	JMFE04	Factor Evaluation Code 4	String	Generic Edit	10	0	Allow NULL?
51	JMFE05	Factor Evaluation Code 5	String	Generic Edit	10	0	Allow NULL?
52	JMFE06	Factor Evaluation Code 6	String	Generic Edit	10	0	Allow NULL?
53	JMFE07	Factor Evaluation Code 7	String	Generic Edit	10	0	Allow NULL?
54	JMFE08	Factor Evaluation Code 8	String	Generic Edit	10	0	Allow NULL?
55	JMFE09	Factor Evaluation Code 9	String	Generic Edit	10	0	Allow NULL?
56	JMFE10	Factor Evaluation Code 10	String	Generic Edit	10	0	Allow NULL?
57	JMFW01	Factor Weight % 1	Numeric	Generic Edit	5	2	Allow NULL?
58	JMFW02	Factor Weight % 2	Numeric	Generic Edit	5	2	Allow NULL?
59	JMFW03	Factor Weight % 3	Numeric	Generic Edit	5	2	Allow NULL?
60	JMFW04	Factor Weight % 4	Numeric	Generic Edit	5	2	Allow NULL?
61	JMFW05	Factor Weight % 5	Numeric	Generic Edit	5	2	Allow NULL?
62	JMFW06	Factor Weight % 6	Numeric	Generic Edit	5	2	Allow NULL?
63	JMFW07	Factor Weight % 7	Numeric	Generic Edit	5	2	Allow NULL?
64	JMFW08	Factor Weight % 8	Numeric	Generic Edit	5	2	Allow NULL?
65	JMFW09	Factor Weight % 9	Numeric	Generic Edit	5	2	Allow NULL?
66	JMFW10	Factor Weight % 10	Numeric	Generic Edit	5	2	Allow NULL?
67	JMJSTA	Job Status Code	String	UDC (08 JS)	3	0	Allow NULL?
68	JMEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
69	JMEFTE	Date - Ending Effective	Date	Generic Edit	6	0
70	JMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
71	JMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
72	JMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
73	JMUPMJ	Date - Updated	Date	Generic Edit	6	0
74	JMPGRS	Pay Grade Step	String	Generic Edit	4	0	Allow NULL?
75	JMCENC	NOC - Can Emp Equity	String	UDC (05 NC)	4	0	Allow NULL?
76	JMSTCR	Status Change Reason	String	UDC (08 JC)	3	0	Allow NULL?

TOP 920 | 08P | F08001 INDEXES

Number

Description

Job Type Job Step (Primary/Unique)

Element	Alias	Description	Sequence
1	JBCD	Job Type (Craft) Code	Ascending
2	JBST	Job Step	Descending

Job Eval Mthd Job Cat A+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	JBCD	Job Type (Craft) Code	Ascending
3	JBST	Job Step	Descending

Job Eval Mthd Job Eval001 A+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT01	Job Evaluation Points per Factor 01	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval002 B+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT02	Job Evaluation Points per Factor 02	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval003 C+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT03	Job Evaluation Points per Factor 03	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval004 D+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT04	Job Evaluation Points per Factor 04	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval005 E+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT05	Job Evaluation Points per Factor 05	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval006 F+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT06	Job Evaluation Points per Factor 06	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval007 G+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT07	Job Evaluation Points per Factor 07	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval008 H+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT08	Job Evaluation Points per Factor 08	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval009 I+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT09	Job Evaluation Points per Factor 09	Descending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Descending

Job Eval Mthd Job Eval010 J+

Element	Alias	Description	Sequence
1	EMET	Job Evaluation Method	Ascending
2	PT10	Job Evaluation Points per Factor 10	Descending
3	JBCD	Job Type (Craft) Code	Descending
4	JBST	Job Step	Ascending

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

76 COLUMNS | 12 INDEXES | 920 | 08P | F08001 TABLE

TOP 920 | 08P | F08001 COLUMNS

TOP 920 | 08P | F08001 INDEXES

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

76 COLUMNS | 12 INDEXES | 920 | 08P | F08001 TABLE

TOP920 | 08P | F08001 COLUMNS

TOP920 | 08P | F08001 INDEXES

TOP 920 | 08P | F08001 COLUMNS

TOP 920 | 08P | F08001 INDEXES