	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

92 COLUMNS | 4 INDEXES | 920 | 08W | F08830WF TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08W: Wage and Salary
1	920	F08830WF	YN	92	4	Compensation Root Work Table	Work Files	08W: Wage and Salary	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 YNMNAME, YNMTYPC, YNMDL01, YNMOWNR, YNRWTYP, YNAN8, YNALPH, YNANPA, YNSPRVN, YNDST, YNCO, YNHMCU, YNEST, YNPAST, YNUN, YNSALY, YNCOIHR, YNFTE, YNIH, YNPHRT, YNCASAL, YNCMPA, YNJBCX, YNCPDT, YNSAL, YNSLOC, YNPOS, YNDL01, YNCDIJ, YNJBCD, YNDL02, YNJBST, YNPGRD, YNPGRS, YNTIJM, YNTIPM, YNLISM, YNDR, YNLSRD, YNNSRD, YNCOCHG, YNBUCHG, YNPSCHG, YNUNCHG, YNLOCHG, YNPCCHG, YNCSCHG, YNCCCHG, YNCPCHG, YNPDCHG, YNJDCHG, YNSPCHG, YNCJTCHG, YNCJSCHG, YNCPGCHG, YNCPSCHG, YNLRDCHG, YNNSEFTO, YNNAS, YNNSOR, YNNCR, YNNPOS, YNNEJT, YNNHRR, YNNSALY, YNNPDL01, YNNJT, YNNJTDL, YNNJS, YNNPGR, YNNPST, YNPFRQ, YNFLSA, YNNUN, YNDIVC, YNJTTRS, YNPAPL, YNDATRVW, YNTIRNK, YNTRNKD, YNJBPCTRQD, YNLTJCRW, YNTBAM, YNTIAM, YNAPPST, YNANAB, YNLARD, YNUSER, YNPID, YNUPMJ, YNUPMT, YNJOBN FROM F08830WF

TOP 920 | 08W | F08830WF COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YNMNAME	Model Name	String	Generic Edit	10	0	Allow NULL?
2	YNMTYPC	Compensation Model Type Code	Character	Generic Edit	1	0	Allow NULL?
3	YNMDL01	Model Description	String	Generic Edit	30	0	Allow NULL?
4	YNMOWNR	Model Owner	Numeric	Generic Edit	8	0	Allow NULL?
5	YNRWTYP	Review Type	Character	UDC (05 RY)	1	0	Allow NULL?
6	YNAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
7	YNALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
8	YNANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
9	YNSPRVN	Supervisor Name	String	Generic Edit	30	0	Allow NULL?
10	YNDST	Date Started	Date	Generic Edit	6	0
11	YNCO	Company	String	Generic Edit	5	0	Allow NULL?
12	YNHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
13	YNEST	Employment Status	Character	UDC (06 ES)	1	0	Allow NULL?
14	YNPAST	Employee Pay Status	Character	UDC (06 PS)	1	0	Allow NULL?
15	YNUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
16	YNSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
17	YNCOIHR	Company Std Hours/Year	Numeric	Generic Edit	9	2	Allow NULL?
18	YNFTE	Full Time Equivalents	Numeric	Generic Edit	9	2	Allow NULL?
19	YNIH	Hours per Standard Year	Numeric	Generic Edit	7	2	Allow NULL?
20	YNPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
21	YNCASAL	Current Annualized Salary	Numeric	Generic Edit	11	2	Allow NULL?
22	YNCMPA	Compa-Ratio	Numeric	Generic Edit	5	2	Allow NULL?
23	YNJBCX	Job Title	String	Generic Edit	30	0	Allow NULL?
24	YNCPDT	Date - Current Position	Date	Generic Edit	6	0
25	YNSAL	Rate - Salary Annual	Numeric	Generic Edit	11	2	Allow NULL?
26	YNSLOC	Salary Data Locality	String	UDC (06 SL)	8	0	Allow NULL?
27	YNPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
28	YNDL01	Description	String	Generic Edit	30	0	Allow NULL?
29	YNCDIJ	Date in Current Job	Date	Generic Edit	6	0
30	YNJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
31	YNDL02	Description 02	String	Generic Edit	30	0	Allow NULL?
32	YNJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
33	YNPGRD	Pay Grade	String	Generic Edit	6	0	Allow NULL?
34	YNPGRS	Pay Grade Step	String	Generic Edit	4	0	Allow NULL?
35	YNTIJM	Time in Job (month)	Numeric	Generic Edit	3	0	Allow NULL?
36	YNTIPM	Time in Position(month)	Numeric	Generic Edit	3	0	Allow NULL?
37	YNLISM	Length in service(month)	Numeric	Generic Edit	3	0	Allow NULL?
38	YNDR	Date - Last Raise	Date	Generic Edit	6	0
39	YNLSRD	Last Compensation Review Date	Date	Generic Edit	6	0
40	YNNSRD	Next Compensation Review Date	Date	Generic Edit	6	0
41	YNCOCHG	Company change	Character	Generic Edit	1	0	Allow NULL?
42	YNBUCHG	BU change	Character	Generic Edit	1	0	Allow NULL?
43	YNPSCHG	Pay Status change	Character	Generic Edit	1	0	Allow NULL?
44	YNUNCHG	Union change	Character	Generic Edit	1	0	Allow NULL?
45	YNLOCHG	Locality Change	Character	Generic Edit	1	0	Allow NULL?
46	YNPCCHG	Pay Class Change	Character	Generic Edit	1	0	Allow NULL?
47	YNCSCHG	Current Salary Change	Character	Generic Edit	1	0	Allow NULL?
48	YNCCCHG	Current Compa Change	Character	Generic Edit	1	0	Allow NULL?
49	YNCPCHG	Current Position Change	Character	Generic Edit	1	0	Allow NULL?
50	YNPDCHG	Position Date change	Character	Generic Edit	1	0	Allow NULL?
51	YNJDCHG	Job Date change	Character	Generic Edit	1	0	Allow NULL?
52	YNSPCHG	SupervisorChange	Character	Generic Edit	1	0	Allow NULL?
53	YNCJTCHG	Current Job Type Change	Character	Generic Edit	1	0	Allow NULL?
54	YNCJSCHG	Current Job Step Change	Character	Generic Edit	1	0	Allow NULL?
55	YNCPGCHG	Current Pay Grade Change	Character	Generic Edit	1	0	Allow NULL?
56	YNCPSCHG	Current Pay Step Change	Character	Generic Edit	1	0	Allow NULL?
57	YNLRDCHG	Last Raise Date Change	Character	Generic Edit	1	0	Allow NULL?
58	YNNSEFTO	New Salary Effective Date	Date	Generic Edit	6	0
59	YNNAS	New Annualized Salary	Numeric	Generic Edit	11	2	Allow NULL?
60	YNNSOR	New Salary Outside range	Character	Generic Edit	1	0	Allow NULL?
61	YNNCR	New Compa Ratio	Numeric	Generic Edit	5	2	Allow NULL?
62	YNNPOS	New Position	String	Generic Edit	8	0	Allow NULL?
63	YNNEJT	New External Job Title	String	Generic Edit	30	0	Allow NULL?
64	YNNHRR	New Hourly Rate	Numeric	Generic Edit	9	3	Allow NULL?
65	YNNSALY	New Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
66	YNNPDL01	New Position Description	String	Generic Edit	30	0	Allow NULL?
67	YNNJT	New Job Type	String	Generic Edit	6	0	Allow NULL?
68	YNNJTDL	New Job Type Description	String	Generic Edit	30	0	Allow NULL?
69	YNNJS	New Job Step	String	Generic Edit	4	0	Allow NULL?
70	YNNPGR	New Pay Grade	String	Generic Edit	6	0	Allow NULL?
71	YNNPST	New Pay Step	String	Generic Edit	4	0	Allow NULL?
72	YNPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
73	YNFLSA	FLSA Exempt Y/N	Character	UDC (05 FL)	1	0	Allow NULL?
74	YNNUN	New Union Code	String	Generic Edit	6	0	Allow NULL?
75	YNDIVC	Benefit Group	String	Generic Edit	6	0	Allow NULL?
76	YNJTTRS	Submit Reports Status Flag	String	Generic Edit	3	0	Allow NULL?
77	YNPAPL	Performance Appraisal Level	Numeric	Generic Edit	6	3	Allow NULL?
78	YNDATRVW	Date Last Reviewed	Date	Generic Edit	6	0
79	YNTIRNK	Tier/Ranking	Numeric	Generic Edit	5	0	Allow NULL?
80	YNTRNKD	Last Tier/Rank date	Date	Generic Edit	6	0
81	YNJBPCTRQD	Total Job Competency Percent Achieved	Numeric	Generic Edit	15	2	Allow NULL?
82	YNLTJCRW	Last Total Job Competency review date	Date	Generic Edit	6	0
83	YNTBAM	Total Budget Amount	Numeric	Generic Edit	11	2	Allow NULL?
84	YNTIAM	Total Increase Amount	Numeric	Generic Edit	11	2	Allow NULL?
85	YNAPPST	Approval Status	Character	Generic Edit	1	0	Allow NULL?
86	YNANAB	Responding Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
87	YNLARD	Last Approved/Rejected Date	Date	Generic Edit	6	0
88	YNUSER	User ID	String	Generic Edit	10	0	Allow NULL?
89	YNPID	Program ID	String	Generic Edit	10	0	Allow NULL?
90	YNUPMJ	Date - Updated	Date	Generic Edit	6	0
91	YNUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
92	YNJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 08W | F08830WF INDEXES

Number

Description

Model RevType EE# Ownr +A (Primary/Unique)

Element	Alias	Description	Sequence
1	MNAME	Model Name	Ascending
2	RWTYP	Review Type	Ascending
3	AN8	Address Number	Ascending
4	MOWNR	Model Owner	Ascending

ModelName RevType AlphaName

Element	Alias	Description	Sequence
1	MNAME	Model Name	Ascending
2	RWTYP	Review Type	Ascending
3	ALPH	Name - Alpha	Ascending

Model RevType EE#

Element	Alias	Description	Sequence
1	MNAME	Model Name	Ascending
2	RWTYP	Review Type	Ascending
3	AN8	Address Number	Ascending

Model RevType Alpha Ownr

Element	Alias	Description	Sequence
1	MNAME	Model Name	Ascending
2	RWTYP	Review Type	Ascending
3	ALPH	Name - Alpha	Ascending
4	MOWNR	Model Owner	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

92 COLUMNS | 4 INDEXES | 920 | 08W | F08830WF TABLE

TOP 920 | 08W | F08830WF COLUMNS

TOP 920 | 08W | F08830WF 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

92 COLUMNS | 4 INDEXES | 920 | 08W | F08830WF TABLE

TOP920 | 08W | F08830WF COLUMNS

TOP920 | 08W | F08830WF INDEXES

TOP 920 | 08W | F08830WF COLUMNS

TOP 920 | 08W | F08830WF INDEXES