	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

74 COLUMNS | 1 INDEXES | 920 | 07 | F06136B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F06136B	YZ	74	1	Tax Summary (PA ACT 32)	Files	07: Payroll

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 YZAN8, YZTHTY, YZTARA, YZPTAX, YZDTEY, YZTAXX, YZHMCO, YZSCDC, YZINTEGER, YZTXOF, YZRTAM, YZSSN, YZBW01, YZBW02, YZBW03, YZBW04, YZBW05, YZBW06, YZBW07, YZBW08, YZBW09, YZBW10, YZBW11, YZBW12, YZBX01, YZBX02, YZBX03, YZBX04, YZBX05, YZBX06, YZBX07, YZBX08, YZBX09, YZBX10, YZBX11, YZBX12, YZBE01, YZBE02, YZBE03, YZBE04, YZBE05, YZBE06, YZBE07, YZBE08, YZBE09, YZBE10, YZBE11, YZBE12, YZBY01, YZBY02, YZBY03, YZBY04, YZBY05, YZBY06, YZBY07, YZBY08, YZBY09, YZBY10, YZBY11, YZBY12, YZMATH01, YZMATH02, YZMATH03, YZINT01, YZINT02, YZINT03, YZDESC, YZDESC02, YZDESC3, YZJOBN, YZUPMJ, YZUPMT, YZUSER, YZPID FROM F06136B

TOP 920 | 07 | F06136B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YZAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	YZTHTY	Code - Tax History Type	Character	UDC (06 TH)	1	0	Allow NULL?
3	YZTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
4	YZPTAX	Tax Type	String	UDC (06 TX)	2	0	Allow NULL?
5	YZDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
6	YZTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
7	YZHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
8	YZSCDC	School District Code	Numeric	UDC (07 SS)	5	0	Allow NULL?
9	YZINTEGER	INT	Integer	Generic Edit	11	0	Allow NULL?
10	YZTXOF	Tax Override Flag	Character	Generic Edit	1	0	Allow NULL?
11	YZRTAM	Amount or Rate	Numeric	Generic Edit	9	4	Allow NULL?
12	YZSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
13	YZBW01	Pay - Gross 01	Numeric	Generic Edit	15	2	Allow NULL?
14	YZBW02	Pay - Gross 02	Numeric	Generic Edit	15	2	Allow NULL?
15	YZBW03	Pay - Gross 03	Numeric	Generic Edit	15	2	Allow NULL?
16	YZBW04	Pay - Gross 04	Numeric	Generic Edit	15	2	Allow NULL?
17	YZBW05	Pay - Gross 05	Numeric	Generic Edit	15	2	Allow NULL?
18	YZBW06	Pay - Gross 06	Numeric	Generic Edit	15	2	Allow NULL?
19	YZBW07	Pay - Gross 07	Numeric	Generic Edit	15	2	Allow NULL?
20	YZBW08	Pay - Gross 08	Numeric	Generic Edit	15	2	Allow NULL?
21	YZBW09	Pay - Gross 09	Numeric	Generic Edit	15	2	Allow NULL?
22	YZBW10	Pay - Gross 10	Numeric	Generic Edit	15	2	Allow NULL?
23	YZBW11	Pay - Gross 11	Numeric	Generic Edit	15	2	Allow NULL?
24	YZBW12	Pay - Gross 12	Numeric	Generic Edit	15	2	Allow NULL?
25	YZBX01	Pay - Exclud1	Numeric	Generic Edit	15	2	Allow NULL?
26	YZBX02	Pay - Exclud2	Numeric	Generic Edit	15	2	Allow NULL?
27	YZBX03	Pay - Exclud3	Numeric	Generic Edit	15	2	Allow NULL?
28	YZBX04	Pay - Exclud4	Numeric	Generic Edit	15	2	Allow NULL?
29	YZBX05	Pay - Exclud5	Numeric	Generic Edit	15	2	Allow NULL?
30	YZBX06	Pay - Exclud6	Numeric	Generic Edit	15	2	Allow NULL?
31	YZBX07	Pay - Exclud7	Numeric	Generic Edit	15	2	Allow NULL?
32	YZBX08	Pay - Exclud8	Numeric	Generic Edit	15	2	Allow NULL?
33	YZBX09	Pay - Exclud9	Numeric	Generic Edit	15	2	Allow NULL?
34	YZBX10	Pay - Exclud10	Numeric	Generic Edit	15	2	Allow NULL?
35	YZBX11	Pay - Exclud11	Numeric	Generic Edit	15	2	Allow NULL?
36	YZBX12	Pay - Exclud12	Numeric	Generic Edit	15	2	Allow NULL?
37	YZBE01	Pay - Excess 01	Numeric	Generic Edit	15	2	Allow NULL?
38	YZBE02	Pay - Excess 02	Numeric	Generic Edit	15	2	Allow NULL?
39	YZBE03	Pay - Excess 03	Numeric	Generic Edit	15	2	Allow NULL?
40	YZBE04	Pay - Excess 04	Numeric	Generic Edit	15	2	Allow NULL?
41	YZBE05	Pay - Excess 05	Numeric	Generic Edit	15	2	Allow NULL?
42	YZBE06	Pay - Excess 06	Numeric	Generic Edit	15	2	Allow NULL?
43	YZBE07	Pay - Excess 07	Numeric	Generic Edit	15	2	Allow NULL?
44	YZBE08	Pay - Excess 08	Numeric	Generic Edit	15	2	Allow NULL?
45	YZBE09	Pay - Excess 09	Numeric	Generic Edit	15	2	Allow NULL?
46	YZBE10	Pay - Excess 10	Numeric	Generic Edit	15	2	Allow NULL?
47	YZBE11	Pay - Excess 11	Numeric	Generic Edit	15	2	Allow NULL?
48	YZBE12	Pay - Excess 12	Numeric	Generic Edit	15	2	Allow NULL?
49	YZBY01	Amount - Tax1	Numeric	Generic Edit	15	2	Allow NULL?
50	YZBY02	Amount - Tax2	Numeric	Generic Edit	15	2	Allow NULL?
51	YZBY03	Amount - Tax3	Numeric	Generic Edit	15	2	Allow NULL?
52	YZBY04	Amount - Tax4	Numeric	Generic Edit	15	2	Allow NULL?
53	YZBY05	Amount - Tax5	Numeric	Generic Edit	15	2	Allow NULL?
54	YZBY06	Amount - Tax6	Numeric	Generic Edit	15	2	Allow NULL?
55	YZBY07	Amount - Tax7	Numeric	Generic Edit	15	2	Allow NULL?
56	YZBY08	Amount - Tax8	Numeric	Generic Edit	15	2	Allow NULL?
57	YZBY09	Amount - Tax9	Numeric	Generic Edit	15	2	Allow NULL?
58	YZBY10	Amount - Tax10	Numeric	Generic Edit	15	2	Allow NULL?
59	YZBY11	Amount - Tax11	Numeric	Generic Edit	15	2	Allow NULL?
60	YZBY12	Amount - Tax12	Numeric	Generic Edit	15	2	Allow NULL?
61	YZMATH01	Math Numeric 01	Numeric	Generic Edit	15	2	Allow NULL?
62	YZMATH02	Math Numeric 02	Numeric	Generic Edit	15	2	Allow NULL?
63	YZMATH03	Math Numeric 03	Numeric	Generic Edit	15	2	Allow NULL?
64	YZINT01	Integer01 - EnterpriseOne	Integer	Generic Edit	4	0	Allow NULL?
65	YZINT02	Integer 02	Integer	Generic Edit	4	0	Allow NULL?
66	YZINT03	Integer 03	Integer	Generic Edit	4	0	Allow NULL?
67	YZDESC	Description	String	Generic Edit	30	0	Allow NULL?
68	YZDESC02	Description 2	String	Generic Edit	45	0	Allow NULL?
69	YZDESC3	Description Level Three	String	Generic Edit	30	0	Allow NULL?
70	YZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
71	YZUPMJ	Date - Updated	Date	Generic Edit	6	0
72	YZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
73	YZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
74	YZPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 07 | F06136B INDEXES

Number

Description

AddressNum_TaxHistoryType (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	THTY	Code - Tax History Type	Ascending
3	TARA	Tax Area (Work)	Ascending
4	PTAX	Tax Type	Ascending
5	DTEY	Date - YR	Ascending
6	TAXX	Tax Identification Number	Ascending
7	HMCO	Company - Home	Ascending
8	SCDC	School District Code	Ascending
9	INTEGER	INT	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

74 COLUMNS | 1 INDEXES | 920 | 07 | F06136B TABLE

TOP 920 | 07 | F06136B COLUMNS

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

74 COLUMNS | 1 INDEXES | 920 | 07 | F06136B TABLE

TOP920 | 07 | F06136B COLUMNS

TOP920 | 07 | F06136B INDEXES

TOP 920 | 07 | F06136B COLUMNS

TOP 920 | 07 | F06136B INDEXES