	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

133 COLUMNS | 9 INDEXES | 812 | 05 | F069116 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	812	F069116	YC	133	9	Payroll Transaction Constants	Constants 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 YCANN8, YCEXA, YCDC, YCPGRP, YCPAYG, YCPAYN, YCDTAB, YCSPW2, YCPB, YCDESQ, YCMV, YCDISO, YCPDBA, YCPCK, YCDEDM, YCUM, YCRTAM, YCPAYM, YCSHD, YCCMTH, YCPPDL, YCMDL, YCADL, YCPPPL, YCNP, YCAD, YCACO, YCAI, YCHMIN, YCHMAX, YCIIAP, YCDEP1, YCDEP2, YCDEP3, YCDEP4, YCDEP5, YCDEP6, YCTT01, YCTT02, YCTT03, YCTT04, YCTT05, YCTT06, YCTT07, YCTT08, YCTT09, YCTT10, YCTT11, YCTT12, YCTT13, YCTT14, YCTT15, YCNMTH, YCPDED, YCDPRI, YCDGRP, YCDBAL, YCARRR, YCNPER, YCSVCD, YCQDL, YCSVH, YCAAF, YCPTCT, YCCPE, YCEFTB, YCEFTE, YCACEQ, YCSADL, YCSDED, YCAMTS, YCPR01, YCPR02, YCPR03, YCPR04, YCPR05, YCTASF, YCTRPF, YCSALY, YCCOVA, YCTRID, YCTYST, YCBENF, YCPPPM, YCEPRI, YCPTER, YCSTAB, YCCMAX, YCRTAB, YCTARA, YCHMCO, YCPGM1, YCPGM2, YCTDBA, YCCMHU, YCBDT, YCDBAS, YCUDBA, YCAIGR, YCPR06, YCPR07, YCPR08, YCPR09, YCPR10, YCPR11, YCPR12, YCPR13, YCPR14, YCUSER, YCPR15, YCPID, YCPR16, YCUPMJ, YCPR17, YCPR18, YCPR19, YCPR20, YCODBA, YCSACC, YCCALC, YCPPRY, YCGVCH, YCPRTX, YCF415, YCCLCI, YCRYTP, YCAFDT, YCSHDL, YCCHCK, YCLVPT, YCPHISH, YCLPRX, YCDEFR FROM F069116

TOP 812 | 05 | F069116 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YCANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
2	YCEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
3	YCDC	Description - Compressed	String	Generic Edit	40	0	Allow NULL?
4	YCPGRP	Deduct/Benefit Override Code	String	Generic Edit	2	0	Allow NULL?
5	YCPAYG	Effect on Gross Pay	Character	UDC (07 PA)	1	0	Allow NULL?
6	YCPAYN	Effect on Net Pay	Character	UDC (07 PA)	1	0	Allow NULL?
7	YCDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
8	YCSPW2	W-2 IRS Defined Code	String	UDC (06 S2)	2	0	Allow NULL?
9	YCPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
10	YCDESQ	Source of Calculation	Character	UDC (06 DB)	1	0	Allow NULL?
11	YCMV	Effect on Disposable Wage	Character	UDC (05A MV)	1	0	Allow NULL?
12	YCDISO	DBA Type	Character	UDC (05 DI)	1	0	Allow NULL?
13	YCPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
14	YCPCK	Method of Printing	Character	UDC (05A PT)	1	0	Allow NULL?
15	YCDEDM	Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
16	YCUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
17	YCRTAM	Amount or Rate	Numeric	Generic Edit	9	4	Allow NULL?
18	YCPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
19	YCSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
20	YCCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
21	YCPPDL	Pay Period Limit	Numeric	Generic Edit	15	2	Allow NULL?
22	YCMDL	Monthly Limit	Numeric	Generic Edit	15	2	Allow NULL?
23	YCADL	Annual Limit	Numeric	Generic Edit	15	2	Allow NULL?
24	YCPPPL	Limit on Pay Period Percent	Numeric	Generic Edit	15	4	Allow NULL?
25	YCNP	Number of Deduction Periods	Numeric	Generic Edit	4	0	Allow NULL?
26	YCAD	Amount - Due	Numeric	Generic Edit	15	2	Allow NULL?
27	YCACO	Available DBA	Character	Generic Edit	1	0	Allow NULL?
28	YCAI	Type - Sales	Character	UDC	1	0	Allow NULL?
29	YCHMIN	Hours - Minimum	Numeric	Generic Edit	15	2	Allow NULL?
30	YCHMAX	Hours - Maximum	Numeric	Generic Edit	15	2	Allow NULL?
31	YCIIAP	Auto Pay Methods	Character	UDC (07 II)	1	0	Allow NULL?
32	YCDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
33	YCDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
34	YCDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
35	YCDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
36	YCDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
37	YCDEP6	Deduction Period 6	Character	UDC (05A DD)	1	0	Allow NULL?
38	YCTT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
39	YCTT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
40	YCTT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
41	YCTT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
42	YCTT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
43	YCTT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
44	YCTT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
45	YCTT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
46	YCTT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
47	YCTT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
48	YCTT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
49	YCTT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
50	YCTT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
51	YCTT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
52	YCTT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
53	YCNMTH	Effect on GL	Character	UDC	1	0	Allow NULL?
54	YCPDED	DBA For Prior Limit	Numeric	Generic Edit	5	0	Allow NULL?
55	YCDPRI	Order To Adjust Ded	Numeric	Generic Edit	5	0	Allow NULL?
56	YCDGRP	Group Limit Code	String	UDC (06 GR)	2	0	Allow NULL?
57	YCDBAL	Declining Balance (Y N)	Character	Generic Edit	1	0	Allow NULL?
58	YCARRR	Arrearage Method	Character	UDC (05A AR)	1	0	Allow NULL?
59	YCNPER	Number of Deduction Periods	Character	Generic Edit	1	0	Allow NULL?
60	YCSVCD	Date - Service	Date	Generic Edit	6	0
61	YCQDL	Quarterly Limit	Numeric	Generic Edit	15	2	Allow NULL?
62	YCSVH	Benefit/Accrual Type	Character	UDC (06 SV)	1	0	Allow NULL?
63	YCAAF	Vacation Factor	Character	UDC (07 AA)	1	0	Allow NULL?
64	YCPTCT	Pay Type Category	Character	UDC (06 PC)	1	0	Allow NULL?
65	YCCPE	COBRA Plan	Numeric	Generic Edit	5	0	Allow NULL?
66	YCEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
67	YCEFTE	Date - Ending Effective	Date	Generic Edit	6	0
68	YCACEQ	Accrual Equivalent	Numeric	Generic Edit	5	0	Allow NULL?
69	YCSADL	Annual Limit (Level 2)	Numeric	Generic Edit	15	2	Allow NULL?
70	YCSDED	Deduction Number - Subsequent	Numeric	Generic Edit	5	0	Allow NULL?
71	YCAMTS	Amount or Rate - Secondary	Numeric	Generic Edit	15	4	Allow NULL?
72	YCPR01	Report Codes - P/R Transaction 01	String	UDC (06 T1)	3	0	Allow NULL?
73	YCPR02	Report Codes - P/R Transaction 02	String	UDC (06 T2)	3	0	Allow NULL?
74	YCPR03	Report Codes - P/R Transaction 03	String	UDC (06 T3)	3	0	Allow NULL?
75	YCPR04	Report Codes - P/R Transaction 04	String	UDC (06 T4)	3	0	Allow NULL?
76	YCPR05	Report Codes - P/R Transaction 05	String	UDC (06 T5)	3	0	Allow NULL?
77	YCTASF	Limit Method	Character	UDC (07 TL)	1	0	Allow NULL?
78	YCTRPF	Calc For All Emp (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
79	YCSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
80	YCCOVA	Amount - Coverage	Numeric	Generic Edit	15	2	Allow NULL?
81	YCTRID	Trans. Code - Identifier	String	Generic Edit	2	0	Allow NULL?
82	YCTYST	Trans. Code - Status Code	Character	UDC (05 YN)	1	0	Allow NULL?
83	YCBENF	Trans. Code - Beneficiary Flag	Character	UDC (08 DC)	1	0	Allow NULL?
84	YCPPPM	Limit on Pay Period Percent - Minimum	Numeric	Generic Edit	15	4	Allow NULL?
85	YCEPRI	When To Adjust Ded	Character	UDC (05A EP)	1	0	Allow NULL?
86	YCPTER	Canadian EI Allocation Flag	Character	Check Box	1	0	Allow NULL?
87	YCSTAB	Benefit/Deduction Table - Secondary	String	Generic Edit	5	0	Allow NULL?
88	YCCMAX	Inception to Date Limit	Numeric	Generic Edit	9	2	Allow NULL?
89	YCRTAB	Rollover Table	String	Generic Edit	5	0	Allow NULL?
90	YCTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
91	YCHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
92	YCPGM1	Pgm Call 1	String	Generic Edit	10	0	Allow NULL?
93	YCPGM2	Pgm Call 2	String	Generic Edit	10	0	Allow NULL?
94	YCTDBA	Code - Tax Area Deduction	Character	UDC (05 YN)	1	0	Allow NULL?
95	YCCMHU	Calendar Month Method	Character	UDC (52 YN)	1	0	Allow NULL?
96	YCBDT	Based From	String	UDC (06 DT)	4	0	Allow NULL?
97	YCDBAS	Calc Once Per Period	Character	UDC (05 YN)	1	0	Allow NULL?
98	YCUDBA	Include in Union Plan (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
99	YCAIGR	Investment Group Codes	Character	UDC (06 AI)	1	0	Allow NULL?
100	YCPR06	Report Codes - P/R Transaction 06	String	UDC (06 T6)	3	0	Allow NULL?
101	YCPR07	Report Codes - P/R Transaction 07	String	UDC (06 T7)	3	0	Allow NULL?
102	YCPR08	Report Codes - P/R Transaction 08	String	UDC (06 T8)	3	0	Allow NULL?
103	YCPR09	Report Codes - P/R Transaction 09	String	UDC (06 T9)	3	0	Allow NULL?
104	YCPR10	Report Codes - P/R Transaction 10	String	UDC (06 T0)	3	0	Allow NULL?
105	YCPR11	Report Codes - P/R Transaction 11	String	UDC (06 11)	3	0	Allow NULL?
106	YCPR12	Report Codes - P/R Transaction 12	String	UDC (06 12)	3	0	Allow NULL?
107	YCPR13	Report Codes - P/R Transaction 13	String	UDC (06 13)	3	0	Allow NULL?
108	YCPR14	Report Codes - P/R Transaction 14	String	UDC (06 14)	3	0	Allow NULL?
109	YCUSER	User ID	String	Generic Edit	10	0	Allow NULL?
110	YCPR15	Report Codes - P/R Transaction 15	String	UDC (06 15)	3	0	Allow NULL?
111	YCPID	Program ID	String	Generic Edit	10	0	Allow NULL?
112	YCPR16	Report Codes - P/R Transaction 16	String	UDC (06 16)	3	0	Allow NULL?
113	YCUPMJ	Date - Updated	Date	Generic Edit	6	0
114	YCPR17	Report Codes - P/R Transaction 17	String	UDC (06 17)	3	0	Allow NULL?
115	YCPR18	Report Codes - P/R Transaction 18	String	UDC (06 18)	3	0	Allow NULL?
116	YCPR19	Report Codes - P/R Transaction 19	String	UDC (06 19)	3	0	Allow NULL?
117	YCPR20	Report Codes - P/R Transaction 20	String	UDC (06 20)	3	0	Allow NULL?
118	YCODBA	Optional DBA Processing Flag	Character	UDC (05 YN)	1	0	Allow NULL?
119	YCSACC	Spending Account Type	String	UDC (06 FS)	3	0	Allow NULL?
120	YCCALC	Calculate If No Gross (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
121	YCPPRY	Calc in Pre-Payroll (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
122	YCGVCH	A/P Voucher (Y N)	Character	UDC (05 YB)	1	0	Allow NULL?
123	YCPRTX	Pre-Tax Deduction	String	UDC (06 4K)	3	0	Allow NULL?
124	YCF415	415 Testing Code	String	UDC (06 F4)	3	0	Allow NULL?
125	YCCLCI	Calculate During Interim Processing	Character	UDC (05 YN)	1	0	Allow NULL?
126	YCRYTP	Type of Rollover Year	Character	Generic Edit	1	0	Allow NULL?
127	YCAFDT	Anniversary Fiscal Beginning Date	String	UDC (06 AF)	4	0	Allow NULL?
128	YCSHDL	W2 Special Handling Description	String	Generic Edit	4	0	Allow NULL?
129	YCCHCK	Effect on Check	Character	UDC (05A CK)	1	0	Allow NULL?
130	YCLVPT	Leave Pay Type	Character	Generic Edit	1	0	Allow NULL?
131	YCPHISH	Retrieve PDBA History Single Flag	Character	UDC (07 M3)	1	0	Allow NULL?
132	YCLPRX	Anniversary Proration Rule	Character	Generic Edit	1	0	Allow NULL?
133	YCDEFR	Date Effective Rate Control	Character	UDC (07 RN)	1	0	Allow NULL?

TOP 812 | 05 | F069116 INDEXES

Number

Description

Pay Type Ded. Ben. Accrual (Primary/Unique)

Element	Alias	Description	Sequence
1	PDBA	DBA Code	Ascending

PDBA PDBA Type

Element	Alias	Description	Sequence
1	PDBA	DBA Code	Ascending
2	DISO	DBA Type	Ascending

Descr. Compressed PDBA Type

Element	Alias	Description	Sequence
1	DC	Description - Compressed	Ascending
2	DISO	DBA Type	Ascending
3	PDBA	DBA Code	Ascending

PDBA Type PDBA

Element	Alias	Description	Sequence
1	DISO	DBA Type	Ascending
2	PDBA	DBA Code	Ascending

Sick and Vacation PDBA

Element	Alias	Description	Sequence
1	SVH	Benefit/Accrual Type	Ascending
2	PDBA	DBA Code	Ascending

Calc for All emp. PDBA

Element	Alias	Description	Sequence
1	TRPF	Calc For All Emp (Y N)	Ascending
2	PDBA	DBA Code	Ascending

Deduction Group

Element	Alias	Description	Sequence
1	DGRP	Group Limit Code	Ascending

415 Testing

Element	Alias	Description	Sequence
1	F415	415 Testing Code	Ascending

TransactionTypePay

Element	Alias	Description	Sequence
1	DISO	DBA Type	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

133 COLUMNS | 9 INDEXES | 812 | 05 | F069116 TABLE

TOP 812 | 05 | F069116 COLUMNS

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

133 COLUMNS | 9 INDEXES | 812 | 05 | F069116 TABLE

TOP812 | 05 | F069116 COLUMNS

TOP812 | 05 | F069116 INDEXES

TOP 812 | 05 | F069116 COLUMNS

TOP 812 | 05 | F069116 INDEXES