	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

53 COLUMNS | 14 INDEXES | 920 | 07 | F07831 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F07831	YB	53	14	Employee State/Local Control Table	Extra Features Files	07Y: US Payroll Year End	Business Data

TOP 920 | 07 | F07831 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YBIDYE	Year-End ID	String	Generic Edit	10	0	Allow NULL?
2	YBDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
3	YBTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
4	YBCO	Company	String	Generic Edit	5	0	Allow NULL?
5	YBAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
6	YBTFYE	Type of Form	Character	UDC (07Y TF)	1	0	Allow NULL?
7	YBTWYE	Type of W-2	Character	UDC (07Y TH)	1	0	Allow NULL?
8	YBCORF	Correction Form	Character	Generic Edit	1	0	Allow NULL?
9	YBDTCF	Date - Correction Form	Date	Generic Edit	6	0
10	YBPTAX	Tax Type	String	UDC (06 TX)	2	0	Allow NULL?
11	YBWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
12	YBPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
13	YBWCN	W2 Control Number	Numeric	Generic Edit	8	0	Allow NULL?
14	YBWSCN	W2 Control Number(Subsequent)	Numeric	Generic Edit	2	0	Allow NULL?
15	YBW2RT	Record Type	Character	UDC (07Y W4)	1	0	Allow NULL?
16	YBTIS	Tax Identification Summation	Character	UDC (05 YN)	1	0	Allow NULL?
17	YBSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
18	YBTAXS	State Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
19	YBSCOD	Statutory Code	String	UDC (06 SC)	3	0	Allow NULL?
20	YBW2DS	W-2 Description	String	Generic Edit	10	0	Allow NULL?
21	YBWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
22	YBWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
23	YBSTWG	Amount - Wages State Taxable	Numeric	Generic Edit	15	2	Allow NULL?
24	YBSTAJ	Amount - Wages State Taxable Adjusted	Numeric	Generic Edit	15	2	Allow NULL?
25	YBSTTX	Amount - State Income Tax	Numeric	Generic Edit	15	2	Allow NULL?
26	YBFDWG	Amount - Wages Federal Taxable	Numeric	Generic Edit	15	2	Allow NULL?
27	YBFDTX	Amount - Federal Income Tax	Numeric	Generic Edit	15	2	Allow NULL?
28	YBALPC	Percentage - Allocation	Numeric	Generic Edit	15	4	Allow NULL?
29	YBW2SU	Amount - W-2 State Unemployment	Numeric	Generic Edit	15	2	Allow NULL?
30	YBW2SD	Amount - W-2 State Disability	Numeric	Generic Edit	15	2	Allow NULL?
31	YBW2PC	W-2 Print Code	Character	Generic Edit	1	0	Allow NULL?
32	YBW2BF	W-2 Base State Flag	Character	Generic Edit	1	0	Allow NULL?
33	YBW2P1	Date - Last Printed 1	Date	Generic Edit	6	0
34	YBDTMT	Date - Magnetic Media	Date	Generic Edit	6	0
35	YBPALF	Name - Alpha Sort	String	Generic Edit	12	0	Allow NULL?
36	YBHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
37	YBHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
38	YBADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
39	YBMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
40	YBSG	Last Job Worked	String	Generic Edit	12	0	Allow NULL?
41	YBPWCN	Previous W2 Control Number	Numeric	Generic Edit	8	0	Allow NULL?
42	YBPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
43	YBPAST	Employee Pay Status	Character	UDC (06 PS)	1	0	Allow NULL?
44	YBDT	Date - Terminated	Date	Generic Edit	6	0
45	YBTXSU	SUI Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
46	YBSUWG	Amount - Wages State Taxable - SUI	Numeric	Generic Edit	15	2	Allow NULL?
47	YBUPMJ	Date - Updated	Date	Generic Edit	6	0
48	YBUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
49	YBPID	Program ID	String	Generic Edit	10	0	Allow NULL?
50	YBJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
51	YBUSER	User ID	String	Generic Edit	10	0	Allow NULL?
52	YBSEIC	State Amount - EIC	Numeric	Generic Edit	15	2	Allow NULL?
53	YBSCDC	School District Code	Numeric	UDC (07 SS)	5	0	Allow NULL?

TOP 920 | 07 | F07831 INDEXES

Number

Description

Year End ID Year +A (Primary/Unique)

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	TAXX	Tax Identification Number	Ascending
4	CO	Company	Ascending
5	AN8	Address Number	Ascending
6	TFYE	Type of Form	Ascending
7	TWYE	Type of W-2	Ascending
8	CORF	Correction Form	Ascending
9	DTCF	Date - Correction Form	Ascending
10	PTAX	Tax Type	Ascending
11	WST	Work State	Ascending
12	WCNT	Work County	Ascending
13	WCTY	Work City	Ascending
14	PRTR	Transaction No. - Payroll	Ascending
15	SCDC	School District Code	Ascending

Year End ID Year +B

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	TFYE	Type of Form	Ascending
4	TAXX	Tax Identification Number	Ascending
5	CO	Company	Ascending
6	AN8	Address Number	Ascending

Year Form Type An8 +A

Element	Alias	Description	Sequence
1	DTEY	Date - YR	Ascending
2	TFYE	Type of Form	Ascending
3	AN8	Address Number	Ascending
4	WCN	W2 Control Number	Ascending

Year End ID Year +C

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	PTAX	Tax Type	Ascending
4	W2RT	Record Type	Ascending
5	TAXX	Tax Identification Number	Ascending
6	CO	Company	Ascending
7	AN8	Address Number	Ascending
8	TFYE	Type of Form	Ascending
9	TWYE	Type of W-2	Ascending
10	CORF	Correction Form	Ascending
11	DTCF	Date - Correction Form	Ascending
12	WST	Work State	Ascending
13	WCNT	Work County	Ascending
14	WCTY	Work City	Ascending

Year End ID Year +D

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	WCN	W2 Control Number	Ascending
4	TAXX	Tax Identification Number	Ascending
5	SSN	Employee Tax ID	Ascending
6	TWYE	Type of W-2	Ascending
7	W2BF	W-2 Base State Flag	Descending

Year End ID Year +E

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	TFYE	Type of Form	Ascending
4	WCN	W2 Control Number	Ascending
5	PTAX	Tax Type	Ascending
6	W2BF	W-2 Base State Flag	Ascending

Year End ID Year +F

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	AN8	Address Number	Ascending
4	TAXX	Tax Identification Number	Ascending
5	TFYE	Type of Form	Ascending
6	TWYE	Type of W-2	Ascending
7	CORF	Correction Form	Ascending
8	DTCF	Date - Correction Form	Ascending
9	PTAX	Tax Type	Ascending
10	WST	Work State	Ascending
11	WCNT	Work County	Ascending
12	WCTY	Work City	Ascending
13	W2RT	Record Type	Ascending

Year End ID Year +G

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	TAXX	Tax Identification Number	Ascending
4	CO	Company	Ascending
5	AN8	Address Number	Ascending
6	TFYE	Type of Form	Ascending
7	TWYE	Type of W-2	Ascending
8	CORF	Correction Form	Ascending
9	DTCF	Date - Correction Form	Ascending
10	WST	Work State	Ascending
11	WCNT	Work County	Ascending
12	WCTY	Work City	Ascending

Year End ID Year +H

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	WCN	W2 Control Number	Ascending
4	AN8	Address Number	Ascending
5	CO	Company	Ascending
6	WST	Work State	Ascending
7	WCNT	Work County	Ascending
8	WCTY	Work City	Ascending
9	PTAX	Tax Type	Ascending

Year End ID Year +I

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	TAXX	Tax Identification Number	Ascending
4	TFYE	Type of Form	Ascending
5	TWYE	Type of W-2	Ascending

Year End ID Year +J

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	TAXX	Tax Identification Number	Ascending
4	AN8	Address Number	Ascending
5	TFYE	Type of Form	Ascending
6	TWYE	Type of W-2	Ascending
7	CORF	Correction Form	Ascending
8	DTCF	Date - Correction Form	Ascending
9	W2RT	Record Type	Ascending
10	TIS	Tax Identification Summation	Ascending

Year End ID Year +K

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	AN8	Address Number	Ascending
4	TFYE	Type of Form	Ascending
5	PRTR	Transaction No. - Payroll	Ascending

Year End ID Year +L

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	TAXX	Tax Identification Number	Ascending
4	CO	Company	Ascending
5	AN8	Address Number	Ascending
6	TFYE	Type of Form	Ascending
7	TWYE	Type of W-2	Ascending
8	PTAX	Tax Type	Ascending
9	W2RT	Record Type	Ascending
10	WCN	W2 Control Number	Ascending

Year End ID Year +M

Element	Alias	Description	Sequence
1	IDYE	Year-End ID	Ascending
2	DTEY	Date - YR	Ascending
3	PTAX	Tax Type	Ascending
4	W2RT	Record Type	Ascending
5	TAXX	Tax Identification Number	Ascending
6	CO	Company	Ascending
7	AN8	Address Number	Ascending
8	TFYE	Type of Form	Ascending
9	TWYE	Type of W-2	Ascending
10	CORF	Correction Form	Ascending
11	DTCF	Date - Correction Form	Ascending
12	WST	Work State	Ascending
13	WCNT	Work County	Ascending
14	WCTY	Work City	Ascending
15	SCDC	School District Code	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

53 COLUMNS | 14 INDEXES | 920 | 07 | F07831 TABLE

TOP 920 | 07 | F07831 COLUMNS

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

53 COLUMNS | 14 INDEXES | 920 | 07 | F07831 TABLE

TOP920 | 07 | F07831 COLUMNS

TOP920 | 07 | F07831 INDEXES

TOP 920 | 07 | F07831 COLUMNS

TOP 920 | 07 | F07831 INDEXES