	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

105 COLUMNS | 6 INDEXES | 812 | 05 | F06106 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	812	F06106	YM	105	6	Employee Pay Instructions	Secondary Master Files	05: Time Accounting and HRM Base	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 YMAN8, YMEXR, YMPDBA, YMDISO, YMPGRP, YMPSDT, YMPTDT, YMSFLG, YMDTAB, YMPB, YMDESQ, YMSHFT, YMAM, YMMCU, YMOBJ, YMSUB, YMSBL, YMTARA, YMWCMP, YMLMTH, YMLF, YMPHRW, YMPCUN, YMUM, YMPHRT, YMPPRT, YMBHRT, YMPBRT, YMBDRT, YMB2RT, YMRBOB, YMRBO2, YMRTAM, YMPAYM, YMSHD, YMCMTH, YMGPA, YMPPDL, YMMDL, YMADL, YMPPPL, YMNP, YMAD, YMAI, YMLD, YMSEC$, YMANN8, YMDEP1, YMDEP2, YMDEP3, YMDEP4, YMDEP5, YMDEP6, YMP001, YMP002, YMP003, YMP004, YMJBCD, YMJBST, YMHMIN, YMHMAX, YMWET, YMEQCG, YMEQHR, YMERC, YMQOBJ, YMEQRT, YMPDED, YMDGRP, YMDPRI, YMARRR, YMQDL, YMDW, YMPRTR, YMSBLT, YMAAF, YMDAAF, YMACEQ, YMALHR, YMUN, YMAMTS, YMSADL, YMWR01, YMCOVA, YMZOVR, YMCMAX, YMUAMT, YMAR1Y, YMARSY, YMRTAB, YMCTAB, YMRCCD, YMPCNO, YMODBA, YMUDBA, YMGVCH, YMPLAN, YMAOPT, YMUSER, YMPID, YMUPMJ, YMPOS, YMHMCU, YMTSKID, YMDEFR FROM F06106

TOP 812 | 05 | F06106 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YMAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
2	YMEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
3	YMPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
4	YMDISO	DBA Type	Character	UDC (05 DI)	1	0	Allow NULL?
5	YMPGRP	Deduct/Benefit Override Code	String	Generic Edit	2	0	Allow NULL?
6	YMPSDT	Date - Pay Starts	Date	Generic Edit	6	0
7	YMPTDT	Date - Pay Stops	Date	Generic Edit	6	0
8	YMSFLG	Void Flag (Y/N)	Character	Generic Edit	1	0	Allow NULL?
9	YMDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
10	YMPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
11	YMDESQ	Source of Calculation	Character	UDC (06 DB)	1	0	Allow NULL?
12	YMSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
13	YMAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
14	YMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
15	YMOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
16	YMSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
17	YMSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
18	YMTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
19	YMWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
20	YMLMTH	Labor Distribution Method	Character	UDC (07 LT)	1	0	Allow NULL?
21	YMLF	Labor Distribution Multiplier	Numeric	Generic Edit	5	4	Allow NULL?
22	YMPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
23	YMPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
24	YMUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
25	YMPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
26	YMPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
27	YMBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
28	YMPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
29	YMBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
30	YMB2RT	Rate - Burden	Numeric	Generic Edit	9	3	Allow NULL?
31	YMRBOB	Burden Obj. Account - Recharge	String	Generic Edit	6	0	Allow NULL?
32	YMRBO2	Burden Obj. Account - Recharge 2	String	Generic Edit	6	0	Allow NULL?
33	YMRTAM	Amount or Rate	Numeric	Generic Edit	9	4	Allow NULL?
34	YMPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
35	YMSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
36	YMCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
37	YMGPA	Amount - Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
38	YMPPDL	Pay Period Limit	Numeric	Generic Edit	15	2	Allow NULL?
39	YMMDL	Monthly Limit	Numeric	Generic Edit	15	2	Allow NULL?
40	YMADL	Annual Limit	Numeric	Generic Edit	15	2	Allow NULL?
41	YMPPPL	Limit on Pay Period Percent	Numeric	Generic Edit	15	4	Allow NULL?
42	YMNP	Number of Deduction Periods	Numeric	Generic Edit	4	0	Allow NULL?
43	YMAD	Amount - Due	Numeric	Generic Edit	15	2	Allow NULL?
44	YMAI	Type - Sales	Character	UDC	1	0	Allow NULL?
45	YMLD	Percent or Amount	Character	UDC (07 LD)	1	0	Allow NULL?
46	YMSEC$	Security Indicator	Character	Generic Edit	1	0	Allow NULL?
47	YMANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
48	YMDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
49	YMDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
50	YMDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
51	YMDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
52	YMDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
53	YMDEP6	Deduction Period 6	Character	UDC (05A DD)	1	0	Allow NULL?
54	YMP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
55	YMP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
56	YMP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
57	YMP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
58	YMJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
59	YMJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
60	YMHMIN	Hours - Minimum	Numeric	Generic Edit	15	2	Allow NULL?
61	YMHMAX	Hours - Maximum	Numeric	Generic Edit	15	2	Allow NULL?
62	YMWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
63	YMEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
64	YMEQHR	Hours - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
65	YMERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
66	YMQOBJ	Equipment Object Account	String	Generic Edit	6	0	Allow NULL?
67	YMEQRT	Billing Rate - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
68	YMPDED	DBA For Prior Limit	Numeric	Generic Edit	5	0	Allow NULL?
69	YMDGRP	Group Limit Code	String	UDC (06 GR)	2	0	Allow NULL?
70	YMDPRI	Order To Adjust Ded	Numeric	Generic Edit	5	0	Allow NULL?
71	YMARRR	Arrearage Method	Character	UDC (05A AR)	1	0	Allow NULL?
72	YMQDL	Quarterly Limit	Numeric	Generic Edit	15	2	Allow NULL?
73	YMDW	Day of the Week	Character	UDC (06 DW)	1	0	Allow NULL?
74	YMPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
75	YMSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
76	YMAAF	Vacation Factor	Character	UDC (07 AA)	1	0	Allow NULL?
77	YMDAAF	Deduction Factor	Character	UDC	1	0	Allow NULL?
78	YMACEQ	Accrual Equivalent	Numeric	Generic Edit	5	0	Allow NULL?
79	YMALHR	Hours Worked - Annual Leave	Numeric	Generic Edit	7	2	Allow NULL?
80	YMUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
81	YMAMTS	Amount or Rate - Secondary	Numeric	Generic Edit	15	4	Allow NULL?
82	YMSADL	Annual Limit (Level 2)	Numeric	Generic Edit	15	2	Allow NULL?
83	YMWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
84	YMCOVA	Amount - Coverage	Numeric	Generic Edit	15	2	Allow NULL?
85	YMZOVR	Override Flag	Character	UDC (05 YB)	1	0	Allow NULL?
86	YMCMAX	Inception to Date Limit	Numeric	Generic Edit	9	2	Allow NULL?
87	YMUAMT	Amount - Uprate	Numeric	Generic Edit	9	3	Allow NULL?
88	YMAR1Y	Accrual Rollover - First Year	Character	UDC (07 AU)	1	0	Allow NULL?
89	YMARSY	Accrual Rollover - Subsequent Years	Character	UDC	1	0	Allow NULL?
90	YMRTAB	Rollover Table	String	Generic Edit	5	0	Allow NULL?
91	YMCTAB	Rollover Table -Subsequent Year	String	Generic Edit	5	0	Allow NULL?
92	YMRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
93	YMPCNO	Payroll Control Number	Numeric	Generic Edit	8	0	Allow NULL?
94	YMODBA	Optional DBA Processing Flag	Character	UDC (05 YN)	1	0	Allow NULL?
95	YMUDBA	Include in Union Plan (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
96	YMGVCH	A/P Voucher (Y N)	Character	UDC (05 YB)	1	0	Allow NULL?
97	YMPLAN	Plan ID	String	Generic Edit	8	0	Allow NULL?
98	YMAOPT	Plan Additional Option	String	Generic Edit	3	0	Allow NULL?
99	YMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
100	YMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
101	YMUPMJ	Date - Updated	Date	Generic Edit	6	0
102	YMPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
103	YMHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
104	YMTSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
105	YMDEFR	Date Effective Rate Control	Character	UDC (07 RN)	1	0	Allow NULL?

TOP 812 | 05 | F06106 INDEXES

Number

Description

Address Number DBA Type +A (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PDBA	DBA Code	Ascending
3	PSDT	Date - Pay Starts	Ascending
4	PRTR	Transaction No. - Payroll	Ascending

Address Number PDBA Type +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PDBA	DBA Code	Ascending
3	PRTR	Transaction No. - Payroll	Ascending

Address Number PDBA Type +B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PDBA	DBA Code	Ascending
3	DISO	DBA Type	Ascending

PDBA Type Address Number +A

Element	Alias	Description	Sequence
1	PDBA	DBA Code	Ascending
2	AN8	Address Number	Ascending
3	PSDT	Date - Pay Starts	Ascending

Address Number Order Adjst +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DPRI	Order To Adjust Ded	Ascending
3	PDBA	DBA Code	Ascending

Address Number DBA Type +B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DISO	DBA Type	Ascending
3	HMCU	Business Unit - Home	Ascending
4	JBCD	Job Type (Craft) Code	Ascending
5	JBST	Job Step	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

105 COLUMNS | 6 INDEXES | 812 | 05 | F06106 TABLE

TOP 812 | 05 | F06106 COLUMNS

TOP 812 | 05 | F06106 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

105 COLUMNS | 6 INDEXES | 812 | 05 | F06106 TABLE

TOP812 | 05 | F06106 COLUMNS

TOP812 | 05 | F06106 INDEXES

TOP 812 | 05 | F06106 COLUMNS

TOP 812 | 05 | F06106 INDEXES