	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 | 13 INDEXES | 812 | 07 | F06136 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	812	F06136	YZ	74	13	Tax History	History Files	07: Payroll	AS400 Coexistence Tables

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, YZSSN, YZTARA, YZPTAX, YZSCOD, YZHMCO, YZCTRY, YZPBFP, YZDTEY, YZTAXX, 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, YZUTAX, YZUSER, YZPID, YZUPMJ, YZUUSR, YZUUPM, YZWST, YZWCNT, YZWCTY, YZSCDC, YZMEM$, YZCCPR, YZDTSP, YZTHTY, YZYTDG, YZYTDT FROM F06136

TOP 812 | 07 | F06136 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
2	YZSSN	Employee Tax ID	String	Generic Edit	20	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	YZSCOD	Statutory Code	String	UDC (06 SC)	3	0	Allow NULL?
6	YZHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
7	YZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
8	YZPBFP	Fiscal Period - Beginning Month	Numeric	UDC (07 MN)	2	0	Allow NULL?
9	YZDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
10	YZTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
11	YZBW01	Pay - Gross 01	Numeric	Generic Edit	15	2	Allow NULL?
12	YZBW02	Pay - Gross 02	Numeric	Generic Edit	15	2	Allow NULL?
13	YZBW03	Pay - Gross 03	Numeric	Generic Edit	15	2	Allow NULL?
14	YZBW04	Pay - Gross 04	Numeric	Generic Edit	15	2	Allow NULL?
15	YZBW05	Pay - Gross 05	Numeric	Generic Edit	15	2	Allow NULL?
16	YZBW06	Pay - Gross 06	Numeric	Generic Edit	15	2	Allow NULL?
17	YZBW07	Pay - Gross 07	Numeric	Generic Edit	15	2	Allow NULL?
18	YZBW08	Pay - Gross 08	Numeric	Generic Edit	15	2	Allow NULL?
19	YZBW09	Pay - Gross 09	Numeric	Generic Edit	15	2	Allow NULL?
20	YZBW10	Pay - Gross 10	Numeric	Generic Edit	15	2	Allow NULL?
21	YZBW11	Pay - Gross 11	Numeric	Generic Edit	15	2	Allow NULL?
22	YZBW12	Pay - Gross 12	Numeric	Generic Edit	15	2	Allow NULL?
23	YZBX01	Pay - Exclud1	Numeric	Generic Edit	15	2	Allow NULL?
24	YZBX02	Pay - Exclud2	Numeric	Generic Edit	15	2	Allow NULL?
25	YZBX03	Pay - Exclud3	Numeric	Generic Edit	15	2	Allow NULL?
26	YZBX04	Pay - Exclud4	Numeric	Generic Edit	15	2	Allow NULL?
27	YZBX05	Pay - Exclud5	Numeric	Generic Edit	15	2	Allow NULL?
28	YZBX06	Pay - Exclud6	Numeric	Generic Edit	15	2	Allow NULL?
29	YZBX07	Pay - Exclud7	Numeric	Generic Edit	15	2	Allow NULL?
30	YZBX08	Pay - Exclud8	Numeric	Generic Edit	15	2	Allow NULL?
31	YZBX09	Pay - Exclud9	Numeric	Generic Edit	15	2	Allow NULL?
32	YZBX10	Pay - Exclud10	Numeric	Generic Edit	15	2	Allow NULL?
33	YZBX11	Pay - Exclud11	Numeric	Generic Edit	15	2	Allow NULL?
34	YZBX12	Pay - Exclud12	Numeric	Generic Edit	15	2	Allow NULL?
35	YZBE01	Pay - Excess 01	Numeric	Generic Edit	15	2	Allow NULL?
36	YZBE02	Pay - Excess 02	Numeric	Generic Edit	15	2	Allow NULL?
37	YZBE03	Pay - Excess 03	Numeric	Generic Edit	15	2	Allow NULL?
38	YZBE04	Pay - Excess 04	Numeric	Generic Edit	15	2	Allow NULL?
39	YZBE05	Pay - Excess 05	Numeric	Generic Edit	15	2	Allow NULL?
40	YZBE06	Pay - Excess 06	Numeric	Generic Edit	15	2	Allow NULL?
41	YZBE07	Pay - Excess 07	Numeric	Generic Edit	15	2	Allow NULL?
42	YZBE08	Pay - Excess 08	Numeric	Generic Edit	15	2	Allow NULL?
43	YZBE09	Pay - Excess 09	Numeric	Generic Edit	15	2	Allow NULL?
44	YZBE10	Pay - Excess 10	Numeric	Generic Edit	15	2	Allow NULL?
45	YZBE11	Pay - Excess 11	Numeric	Generic Edit	15	2	Allow NULL?
46	YZBE12	Pay - Excess 12	Numeric	Generic Edit	15	2	Allow NULL?
47	YZBY01	Amount - Tax1	Numeric	Generic Edit	15	2	Allow NULL?
48	YZBY02	Amount - Tax2	Numeric	Generic Edit	15	2	Allow NULL?
49	YZBY03	Amount - Tax3	Numeric	Generic Edit	15	2	Allow NULL?
50	YZBY04	Amount - Tax4	Numeric	Generic Edit	15	2	Allow NULL?
51	YZBY05	Amount - Tax5	Numeric	Generic Edit	15	2	Allow NULL?
52	YZBY06	Amount - Tax6	Numeric	Generic Edit	15	2	Allow NULL?
53	YZBY07	Amount - Tax7	Numeric	Generic Edit	15	2	Allow NULL?
54	YZBY08	Amount - Tax8	Numeric	Generic Edit	15	2	Allow NULL?
55	YZBY09	Amount - Tax9	Numeric	Generic Edit	15	2	Allow NULL?
56	YZBY10	Amount - Tax10	Numeric	Generic Edit	15	2	Allow NULL?
57	YZBY11	Amount - Tax11	Numeric	Generic Edit	15	2	Allow NULL?
58	YZBY12	Amount - Tax12	Numeric	Generic Edit	15	2	Allow NULL?
59	YZUTAX	Amount - Uncollected Taxes	Numeric	Generic Edit	15	2	Allow NULL?
60	YZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
61	YZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
62	YZUPMJ	Date - Updated	Date	Generic Edit	6	0
63	YZUUSR	User ID - Update Control	String	Generic Edit	10	0	Allow NULL?
64	YZUUPM	Date - Controlled Update	Date	Generic Edit	6	0
65	YZWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
66	YZWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
67	YZWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
68	YZSCDC	School District Code	Numeric	UDC (07 SS)	5	0	Allow NULL?
69	YZMEM$	Amount - Memo Gross	Numeric	Generic Edit	15	2	Allow NULL?
70	YZCCPR	Country Code	String	UDC (00 CN)	3	0	Allow NULL?
71	YZDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
72	YZTHTY	Code - Tax History Type	Character	UDC (06 TH)	1	0	Allow NULL?
73	YZYTDG	Amount - YTD Gross Pay	Numeric	Generic Edit	15	2	Allow NULL?
74	YZYTDT	Amount - YTD Taxes Withheld	Numeric	Generic Edit	15	2	Allow NULL?

TOP 812 | 07 | F06136 INDEXES

Number

Description

Address Num Tax Hist type +A (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

Address Num Date +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DTEY	Date - YR	Ascending
3	THTY	Code - Tax History Type	Ascending
4	TAXX	Tax Identification Number	Ascending
5	PTAX	Tax Type	Ascending

Date Company +A

Element	Alias	Description	Sequence
1	DTEY	Date - YR	Ascending
2	HMCO	Company - Home	Ascending
3	THTY	Code - Tax History Type	Ascending
4	TARA	Tax Area (Work)	Ascending
5	TAXX	Tax Identification Number	Ascending
6	AN8	Address Number	Ascending

Address Num Date +B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DTEY	Date - YR	Ascending
3	PTAX	Tax Type	Ascending

Address Num Date +C

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DTEY	Date - YR	Ascending
3	THTY	Code - Tax History Type	Ascending
4	TARA	Tax Area (Work)	Ascending
5	PTAX	Tax Type	Ascending
6	HMCO	Company - Home	Ascending

Date Tax History +A

Element	Alias	Description	Sequence
1	DTEY	Date - YR	Ascending
2	THTY	Code - Tax History Type	Ascending
3	TARA	Tax Area (Work)	Ascending
4	PTAX	Tax Type	Ascending
5	AN8	Address Number	Ascending

Date Company +B

Element	Alias	Description	Sequence
1	DTEY	Date - YR	Ascending
2	HMCO	Company - Home	Ascending
3	TAXX	Tax Identification Number	Ascending
4	THTY	Code - Tax History Type	Ascending
5	PTAX	Tax Type	Ascending

Date Tax ID +A

Element	Alias	Description	Sequence
1	DTEY	Date - YR	Ascending
2	TAXX	Tax Identification Number	Ascending
3	THTY	Code - Tax History Type	Ascending
4	PTAX	Tax Type	Ascending
5	AN8	Address Number	Ascending

Date Century +A

Element	Alias	Description	Sequence
1	DTEY	Date - YR	Ascending
2	CTRY	Century	Ascending
3	TARA	Tax Area (Work)	Ascending
4	PTAX	Tax Type	Ascending
5	TAXX	Tax Identification Number	Ascending

Address Num Tax Area +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TARA	Tax Area (Work)	Ascending
3	PTAX	Tax Type	Ascending
4	DTEY	Date - YR	Ascending
5	TAXX	Tax Identification Number	Ascending
6	HMCO	Company - Home	Ascending

Date Company +C

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

Addres Num Tax Hist Type +B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	THTY	Code - Tax History Type	Ascending
3	DTEY	Date - YR	Ascending
4	HMCO	Company - Home	Ascending
5	TAXX	Tax Identification Number	Ascending
6	TARA	Tax Area (Work)	Ascending
7	PTAX	Tax Type	Ascending

Date Tax History Type +B

Element	Alias	Description	Sequence
1	DTEY	Date - YR	Ascending
2	THTY	Code - Tax History Type	Ascending
3	HMCO	Company - Home	Ascending
4	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

74 COLUMNS | 13 INDEXES | 812 | 07 | F06136 TABLE

TOP 812 | 07 | F06136 COLUMNS

TOP 812 | 07 | F06136 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 | 13 INDEXES | 812 | 07 | F06136 TABLE

TOP812 | 07 | F06136 COLUMNS

TOP812 | 07 | F06136 INDEXES

TOP 812 | 07 | F06136 COLUMNS

TOP 812 | 07 | F06136 INDEXES