	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

157 COLUMNS | 8 INDEXES | 812 | 05T | F06278 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05T: Time Entry
1	812	F06278	YT	157	8	Retro Timecard Detail File	Extra Features Files	05T: Time Entry	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 YTVERS, YTAN8, YTSSN, YTOEMP, YTPALF, YTPRTR, YTRCCD, YTCKCN, YTAM, YTCO, YTHMCO, YTHMCU, YTMCU, YTOBJ, YTSUB, YTRCO, YTGMCU, YTGOBJ, YTGSUB, YTSBL, YTSBLT, YTWR01, YTMCUO, YTMAIL, YTPHRW, YTOPSQ, YTRILT, YTITM, YTPCUN, YTUM, YTPHRT, YTPPRT, YTBHRT, YTPBRT, YTBDRT, YTGPA, YTDPA, YTRCPY, YTSAMT, YTUN, YTJBCD, YTJBST, YTWST, YTWCNT, YTWCTY, YTWCMP, YTWET, YTGENA, YTWCAM, YTWCMB, YTGENB, YTWCMO, YTGENO, YTWCMX, YTGENX, YTHMO, YTPDBA, YTPB, YTDEDM, YTPAYM, YTSHFT, YTSHD, YTSALY, YTNMTH, YTPFRQ, YTFY, YTDGL, YTPN, YTDWK, YTDW, YTPPED, YTPPP, YTDTBT, YTTCDE, YTEQCO, YTEQWO, YTEQCG, YTQOBJ, YTERC, YTEQRT, YTEQGR, YTEQHR, YTEXR, YTP001, YTP002, YTP003, YTP004, YTUSER, YTCMMT, YTCKDT, YTUAMT, YTYST, YTICU, YTGICU, YTDICJ, YTUPMJ, YTPID, YTANI, YTCTRY, YTANN8, YTPGRP, YTPAYG, YTPAYN, YTSFLG, YTWS, YTPCK, YTICC, YTICS, YTCMTH, YTACO, YTAI, YTSEC$, YTOHF, YTDEP1, YTDEP2, YTDEP3, YTDEP4, YTDEP5, YTTT01, YTTT02, YTTT03, YTTT04, YTTT05, YTTT06, YTTT07, YTTT08, YTTT09, YTTT10, YTTT11, YTTT12, YTTT13, YTTT14, YTTT15, YTUSR, YTEPA, YTBFA, YTRTWC, YTGENR, YTADV, YTSTIP, YTALPH, YTIIAP, YTFICM, YTDTAB, YTDTSP, YTYST1, YTRPM, YTRTHR, YTRTBR, YTRTPR, YTRTGP, YTRTBP, YTRTDP, YTRTGE, YTRTAC, YTRTCS, YTRTRT FROM F06278

TOP 812 | 05T | F06278 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YTVERS	Version History	String	Generic Edit	10	0	Allow NULL?
2	YTAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
3	YTSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
4	YTOEMP	Additional Employee No	String	Generic Edit	8	0	Allow NULL?
5	YTPALF	Name - Alpha Sort	String	Generic Edit	12	0	Allow NULL?
6	YTPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
7	YTRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
8	YTCKCN	Check Control Number	Numeric	Generic Edit	8	0	Allow NULL?
9	YTAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
10	YTCO	Company	String	Generic Edit	5	0	Allow NULL?
11	YTHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
12	YTHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
13	YTMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
14	YTOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
15	YTSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
16	YTRCO	Company _ Recharge	String	Generic Edit	5	0	Allow NULL?
17	YTGMCU	Business Unit - Recharge	String	Generic Edit	12	0	Allow NULL?
18	YTGOBJ	Object Account - Recharge	String	Generic Edit	6	0	Allow NULL?
19	YTGSUB	Subsidiary - Recharge	String	Generic Edit	8	0	Allow NULL?
20	YTSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
21	YTSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
22	YTWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
23	YTMCUO	Business Unit - Chargeout	String	Generic Edit	12	0	Allow NULL?
24	YTMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
25	YTPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
26	YTOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
27	YTRILT	Labor Type - Routing Instructions	Character	UDC (06 AT)	1	0	Allow NULL?
28	YTITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
29	YTPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
30	YTUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
31	YTPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
32	YTPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
33	YTBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
34	YTPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
35	YTBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
36	YTGPA	Amount - Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
37	YTDPA	Amount - Distributed Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
38	YTRCPY	Recharge Amount	Numeric	Generic Edit	9	2	Allow NULL?
39	YTSAMT	Amount - Sales Generated	Numeric	Generic Edit	11	2	Allow NULL?
40	YTUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
41	YTJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
42	YTJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
43	YTWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
44	YTWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
45	YTWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
46	YTWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
47	YTWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
48	YTGENA	General Liability Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
49	YTWCAM	Workers Comp Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
50	YTWCMB	Workers Comp Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
51	YTGENB	General Liability Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
52	YTWCMO	Workers Comp Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
53	YTGENO	General Liability Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
54	YTWCMX	Workers Comp Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
55	YTGENX	General Liability Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
56	YTHMO	Month - Update of History	Numeric	Generic Edit	2	0	Allow NULL?
57	YTPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
58	YTPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
59	YTDEDM	Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
60	YTPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
61	YTSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
62	YTSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
63	YTSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
64	YTNMTH	Effect on GL	Character	UDC	1	0	Allow NULL?
65	YTPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
66	YTFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
67	YTDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
68	YTPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
69	YTDWK	Date - Worked	Date	Generic Edit	6	0
70	YTDW	Day of the Week	Character	UDC (06 DW)	1	0	Allow NULL?
71	YTPPED	Date - Pay Period Ending	Date	Generic Edit	6	0
72	YTPPP	Pay Period of the Month	Character	UDC (07 MP)	1	0	Allow NULL?
73	YTDTBT	Date - Time Clock Start Date and Time	Numeric	Generic Edit	13	0	Allow NULL?
74	YTTCDE	Date Time Clock End	Numeric	Generic Edit	13	0	Allow NULL?
75	YTEQCO	Company - Equipment	String	Generic Edit	5	0	Allow NULL?
76	YTEQWO	Equipment Worked On	String	Generic Edit	9	0	Allow NULL?
77	YTEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
78	YTQOBJ	Equipment Object Account	String	Generic Edit	6	0	Allow NULL?
79	YTERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
80	YTEQRT	Billing Rate - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
81	YTEQGR	Amount _ Equipment Gross	Numeric	Generic Edit	9	2	Allow NULL?
82	YTEQHR	Hours - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
83	YTEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
84	YTP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
85	YTP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
86	YTP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
87	YTP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
88	YTUSER	User ID	String	Generic Edit	10	0	Allow NULL?
89	YTCMMT	Check Comment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
90	YTCKDT	Date - Pay Check	Date	Generic Edit	6	0
91	YTUAMT	Amount - Uprate	Numeric	Generic Edit	9	3	Allow NULL?
92	YTYST	Processed Code	Character	UDC (07 YW)	1	0	Allow NULL?
93	YTICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
94	YTGICU	General Ledger Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
95	YTDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
96	YTUPMJ	Date - Updated	Date	Generic Edit	6	0
97	YTPID	Program ID	String	Generic Edit	10	0	Allow NULL?
98	YTANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
99	YTCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
100	YTANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
101	YTPGRP	Deduct/Benefit Override Code	String	Generic Edit	2	0	Allow NULL?
102	YTPAYG	Effect on Gross Pay	Character	UDC (07 PA)	1	0	Allow NULL?
103	YTPAYN	Effect on Net Pay	Character	UDC (07 PA)	1	0	Allow NULL?
104	YTSFLG	Void Flag (Y/N)	Character	Generic Edit	1	0	Allow NULL?
105	YTWS	Work Schedule Code	Character	UDC (05A WS)	1	0	Allow NULL?
106	YTPCK	Method of Printing	Character	UDC (05A PT)	1	0	Allow NULL?
107	YTICC	Interim Check Code	Character	UDC (07 IC)	1	0	Allow NULL?
108	YTICS	Interim Check Status	Character	UDC (07 IC)	1	0	Allow NULL?
109	YTCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
110	YTACO	Available DBA	Character	Generic Edit	1	0	Allow NULL?
111	YTAI	Type - Sales	Character	UDC	1	0	Allow NULL?
112	YTSEC$	Security Indicator	Character	Generic Edit	1	0	Allow NULL?
113	YTOHF	Overtime Code	Character	UDC (07 OH)	1	0	Allow NULL?
114	YTDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
115	YTDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
116	YTDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
117	YTDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
118	YTDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
119	YTTT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
120	YTTT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
121	YTTT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
122	YTTT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
123	YTTT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
124	YTTT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
125	YTTT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
126	YTTT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
127	YTTT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
128	YTTT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
129	YTTT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
130	YTTT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
131	YTTT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
132	YTTT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
133	YTTT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
134	YTUSR	Payroll Lockout Identification	String	Generic Edit	18	0	Allow NULL?
135	YTEPA	Amount - Entered Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
136	YTBFA	Benefit Factor	Numeric	Generic Edit	11	8	Allow NULL?
137	YTRTWC	Rate - Workers Comp Insurance	Numeric	Generic Edit	9	5	Allow NULL?
138	YTGENR	Rate - Workers Comp Gen Liability	Numeric	Generic Edit	9	3	Allow NULL?
139	YTADV	Advance on Pay	Character	Generic Edit	1	0	Allow NULL?
140	YTSTIP	Status - Tip Hist Update	Character	Generic Edit	1	0	Allow NULL?
141	YTALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
142	YTIIAP	Auto Pay Methods	Character	UDC (07 II)	1	0	Allow NULL?
143	YTFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
144	YTDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
145	YTDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
146	YTYST1	Status- Payroll 01	Character	UDC (07 YS)	1	0	Allow NULL?
147	YTRPM	Payment Method	Character	UDC	1	0	Allow NULL?
148	YTRTHR	Rate - Retro Amount/Rate	Numeric	Generic Edit	9	3	Allow NULL?
149	YTRTBR	Rate - Retro Billing Rate	Numeric	Generic Edit	9	3	Allow NULL?
150	YTRTPR	Rate - Retro Pice Rate	Numeric	Generic Edit	9	3	Allow NULL?
151	YTRTGP	Amount - Retro Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
152	YTRTBP	Amount - Retro Recharge Pay	Numeric	Generic Edit	9	2	Allow NULL?
153	YTRTDP	Amount - Retro Distr. Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
154	YTRTGE	Amount - Entered Gross Pay	Numeric	Generic Edit	15	2	Allow NULL?
155	YTRTAC	Approval Code	Character	UDC	1	0	Allow NULL?
156	YTRTCS	Summarization Code	Character	Generic Edit	1	0	Allow NULL?
157	YTRTRT	Record Type - Retro	Character	UDC	1	0	Allow NULL?

TOP 812 | 05T | F06278 INDEXES

Number

Description

Version Address Number +A (Primary/Unique)

Element	Alias	Description	Sequence
1	VERS	Version History	Ascending
2	AN8	Address Number	Ascending
3	UN	Union Code	Ascending
4	DWK	Date - Worked	Ascending

Version Employee Tax ID +A

Element	Alias	Description	Sequence
1	VERS	Version History	Ascending
2	SSN	Employee Tax ID	Ascending
3	UN	Union Code	Ascending
4	DWK	Date - Worked	Ascending

Version Address Number +B

Element	Alias	Description	Sequence
1	VERS	Version History	Ascending
2	AN8	Address Number	Ascending
3	PDBA	DBA Code	Ascending

Version Union +A

Element	Alias	Description	Sequence
1	VERS	Version History	Ascending
2	UN	Union Code	Ascending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Ascending

Version Address Number +C

Element	Alias	Description	Sequence
1	VERS	Version History	Ascending
2	AN8	Address Number	Ascending
3	DWK	Date - Worked	Ascending

Version Job Category +A

Element	Alias	Description	Sequence
1	VERS	Version History	Ascending
2	JBCD	Job Type (Craft) Code	Ascending
3	JBST	Job Step	Ascending

Version Address Number +D

Element	Alias	Description	Sequence
1	VERS	Version History	Ascending
2	AN8	Address Number	Ascending
3	PRTR	Transaction No. - Payroll	Ascending

Address Number

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

157 COLUMNS | 8 INDEXES | 812 | 05T | F06278 TABLE

TOP 812 | 05T | F06278 COLUMNS

TOP 812 | 05T | F06278 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

157 COLUMNS | 8 INDEXES | 812 | 05T | F06278 TABLE

TOP812 | 05T | F06278 COLUMNS

TOP812 | 05T | F06278 INDEXES

TOP 812 | 05T | F06278 COLUMNS

TOP 812 | 05T | F06278 INDEXES