	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

91 COLUMNS | 2 INDEXES | 920 | 07 | F07880 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F07880	YW	91	2	SUI Magnetic Media Workfile	Work Files	07S: Payroll SUI	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 YWAN8, YWHMCO, YWTARA, YWDTEY, YWPQTR, YWTAXX, YWALPH3, YWADD1, YWADD2, YWADD3, YWCTY1, YWADDS, YWADDZ, YWCNT2, YWCTR2, YWFPC2, YWSEAN, YWWKSE, YWSCOD, YWTYPEEMPLOY, YWTAXTYPECD, YWSSN, YWNAMECODE, YWALPH, YWEMPLNAME, YWEMPFNAME, YWEMPMI, YWADD4, YWADD5, YWADD6, YWMSCY, YWADDO, YWCRTE, YWSTCD, YWCTR, YWCOUN, YWFPC1, YWSEX, YWDSI, YWDT, YWJBCD, YWWCMP, YWGPAY, YWG301, YWWE01, YWWX01, YWG101, YWG201, YWBW01, YWBY01, YWHOURS, YWMTH1, YWMTH2, YWMTH3, YWAG, YWSTAM, YWAN8T, YWTAXX2, YWALPH5, YWADD13, YWADD14, YWADD15, YWCTYNH3, YWADDSNH3, YWADDZNH3, YWCRTENH3, YWCTR6, YWCOUNNH3, YWFPC5, YWAN8D, YWALPH4, YWADD10, YWADD11, YWADD12, YWCTYNH2, YWADDSNH2, YWTAXENTCODE, YWADDZNH2, YWCRTENH2, YWCTR5, YWCOUNNH2, YWFPC4, YWAR3, YWPH3, YWUNITCODE, YWCTRY, YWUPMJ, YWUPMT, YWPID, YWJOBN, YWUSER FROM F07880

TOP 920 | 07 | F07880 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YWAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	YWHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
3	YWTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
4	YWDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
5	YWPQTR	Quarter	Character	UDC (07 QU)	1	0	Allow NULL?
6	YWTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
7	YWALPH3	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
8	YWADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
9	YWADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
10	YWADD3	Address Line 3	String	Generic Edit	40	0	Allow NULL?
11	YWCTY1	City	String	Generic Edit	25	0	Allow NULL?
12	YWADDS	State	String	UDC (00 S)	3	0	Allow NULL?
13	YWADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
14	YWCNT2	County	String	Generic Edit	25	0	Allow NULL?
15	YWCTR2	Country	String	UDC (00 CN)	3	0	Allow NULL?
16	YWFPC2	ForeignPostalCode	String	Generic Edit	15	0	Allow NULL?
17	YWSEAN	State Employer Account Number	String	Generic Edit	12	0	Allow NULL?
18	YWWKSE	State - Working	String	UDC (06 SC)	3	0	Allow NULL?
19	YWSCOD	Statutory Code	String	UDC (06 SC)	3	0	Allow NULL?
20	YWTYPEEMPLOY	Type of Employment - EnterpriseOne	Character	Generic Edit	1	0	Allow NULL?
21	YWTAXTYPECD	Tax Type Code - EnterpriseOne	Character	Generic Edit	1	0	Allow NULL?
22	YWSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
23	YWNAMECODE	Name Code - EnterpriseOne	Character	Generic Edit	1	0	Allow NULL?
24	YWALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
25	YWEMPLNAME	Employee Last Name - PeopleSoft	String	Generic Edit	30	0	Allow NULL?
26	YWEMPFNAME	Employee First Name - PeopleSoft	String	Generic Edit	12	0	Allow NULL?
27	YWEMPMI	Employee Middle Initial - PeopleSoft	Character	Generic Edit	1	0	Allow NULL?
28	YWADD4	Address Line 4	String	Generic Edit	40	0	Allow NULL?
29	YWADD5	Address Line 5	String	Generic Edit	40	0	Allow NULL?
30	YWADD6	Address Line 6	String	Generic Edit	40	0	Allow NULL?
31	YWMSCY	City	String	Generic Edit	25	0	Allow NULL?
32	YWADDO	Postal Code - Origin	String	Generic Edit	12	0	Allow NULL?
33	YWCRTE	Carrier Route (Future)	String	Generic Edit	4	0	Allow NULL?
34	YWSTCD	State Code	String	Generic Edit	3	0	Allow NULL?
35	YWCTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
36	YWCOUN	County	String	UDC (00 CT)	25	0	Allow NULL?
37	YWFPC1	ForeignPostalCode	String	Generic Edit	15	0	Allow NULL?
38	YWSEX	Gender (Male/Female)	Character	UDC (07 SG)	1	0	Allow NULL?
39	YWDSI	Date - Original Employment	Date	Generic Edit	6	0
40	YWDT	Date - Terminated	Date	Generic Edit	6	0
41	YWJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
42	YWWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
43	YWGPAY	Amount - Gross Pay	Numeric	Generic Edit	15	2	Allow NULL?
44	YWG301	Tax 01	Numeric	Generic Edit	15	2	Allow NULL?
45	YWWE01	Excludable - Week 01	Numeric	Generic Edit	15	2	Allow NULL?
46	YWWX01	Excess Wages - Week 01	Numeric	Generic Edit	15	2	Allow NULL?
47	YWG101	Gross Pay 01	Numeric	Generic Edit	15	2	Allow NULL?
48	YWG201	Excludable Gross 01	Numeric	Generic Edit	15	2	Allow NULL?
49	YWBW01	Pay - Gross 01	Numeric	Generic Edit	15	2	Allow NULL?
50	YWBY01	Amount - Tax1	Numeric	Generic Edit	15	2	Allow NULL?
51	YWHOURS	Hours Worked	Numeric	Generic Edit	15	2	Allow NULL?
52	YWMTH1	Month 1 Employment	Numeric	Generic Edit	15	2	Allow NULL?
53	YWMTH2	Month 2 Employment	Numeric	Generic Edit	15	2	Allow NULL?
54	YWMTH3	Month 3 Employment	Numeric	Generic Edit	15	2	Allow NULL?
55	YWAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
56	YWSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
57	YWAN8T	Address Number - Transmitter	Numeric	Generic Edit	8	0	Allow NULL?
58	YWTAXX2	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
59	YWALPH5	Name - Alpha Contact	String	Generic Edit	40	0	Allow NULL?
60	YWADD13	Address Line 13	String	Generic Edit	40	0	Allow NULL?
61	YWADD14	Address Line 14	String	Generic Edit	40	0	Allow NULL?
62	YWADD15	Address Line 15	String	Generic Edit	40	0	Allow NULL?
63	YWCTYNH3	City	String	Generic Edit	25	0	Allow NULL?
64	YWADDSNH3	State	String	UDC (00 S)	3	0	Allow NULL?
65	YWADDZNH3	Postal Code	String	Generic Edit	12	0	Allow NULL?
66	YWCRTENH3	Carrier Route (Future)	String	Generic Edit	4	0	Allow NULL?
67	YWCTR6	Country	String	UDC (00 CN)	3	0	Allow NULL?
68	YWCOUNNH3	County	String	UDC (00 CT)	25	0	Allow NULL?
69	YWFPC5	ForeignPostalCode	String	Generic Edit	15	0	Allow NULL?
70	YWAN8D	Address Number - Contact Person	Numeric	Generic Edit	8	0	Allow NULL?
71	YWALPH4	Name - Alpha Employer	String	Generic Edit	40	0	Allow NULL?
72	YWADD10	Address Line 10	String	Generic Edit	40	0	Allow NULL?
73	YWADD11	Address Line 11	String	Generic Edit	40	0	Allow NULL?
74	YWADD12	Address Line 12	String	Generic Edit	40	0	Allow NULL?
75	YWCTYNH2	City	String	Generic Edit	25	0	Allow NULL?
76	YWADDSNH2	State	String	UDC (00 S)	3	0	Allow NULL?
77	YWTAXENTCODE	Tax Entity Code - EnterpriseOne	String	Generic Edit	6	0	Allow NULL?
78	YWADDZNH2	Postal Code	String	Generic Edit	12	0	Allow NULL?
79	YWCRTENH2	Carrier Route (Future)	String	Generic Edit	4	0	Allow NULL?
80	YWCTR5	Country	String	UDC (00 CN)	3	0	Allow NULL?
81	YWCOUNNH2	County	String	UDC (00 CT)	25	0	Allow NULL?
82	YWFPC4	ForeignPostalCode	String	Generic Edit	15	0	Allow NULL?
83	YWAR3	Phone Area Code 3	String	Generic Edit	6	0	Allow NULL?
84	YWPH3	Phone Number	String	Generic Edit	20	0	Allow NULL?
85	YWUNITCODE	Unit / Plant Code - EnterpriseOne	String	Generic Edit	3	0	Allow NULL?
86	YWCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
87	YWUPMJ	Date - Updated	Date	Generic Edit	6	0
88	YWUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
89	YWPID	Program ID	String	Generic Edit	10	0	Allow NULL?
90	YWJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
91	YWUSER	User ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 07 | F07880 INDEXES

Number

Description

HMCO AN8 +A (Primary/Unique)

Element	Alias	Description	Sequence
1	HMCO	Company - Home	Ascending
2	TARA	Tax Area (Work)	Ascending
3	AN8	Address Number	Ascending
4	DTEY	Date - YR	Ascending
5	PQTR	Quarter	Ascending

Tax Area State Acct Num +

Element	Alias	Description	Sequence
1	TARA	Tax Area (Work)	Ascending
2	SEAN	State Employer Account Number	Ascending
3	AN8	Address Number	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

91 COLUMNS | 2 INDEXES | 920 | 07 | F07880 TABLE

TOP 920 | 07 | F07880 COLUMNS

TOP 920 | 07 | F07880 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

91 COLUMNS | 2 INDEXES | 920 | 07 | F07880 TABLE

TOP920 | 07 | F07880 COLUMNS

TOP920 | 07 | F07880 INDEXES

TOP 920 | 07 | F07880 COLUMNS

TOP 920 | 07 | F07880 INDEXES