	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

219 COLUMNS | 35 INDEXES | 920 | 05T | F06116 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05T: Time Entry
1	920	F06116	YT	219	35	Employee Transaction Detail File	Transaction Files	05T: Time Entry	Business Data

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 YTAN8, 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, YTSHRT, YTSHFT, YTSHD, YTPAYM, YTLD, YTGPA, YTDPA, YTRCPY, YTSAMT, YTUN, YTJBCD, YTJBST, YTWST, YTWCNT, YTWCTY, YTWCMP, YTWET, YTGENA, YTWCAM, YTWCMB, YTGENB, YTWCMO, YTGENO, YTWCMX, YTGENX, YTWCBN, YTHMO, YTPDBA, YTPB, YTDEDM, 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, YTDEP6, 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, YTCKCS, YTALT0, YTPOS, YTACTB, YTABR1, YTABT1, YTABR2, YTABT2, YTABR3, YTABT3, YTABR4, YTABT4, YTBLGRT, YTRCHGAMT, YTFBLGRT, YTFRCHGAMT, YTCRR, YTCRCD, YTCRDC, YTRCHGMODE, YTLTTP, YTRKID, YTTELKFLG, YTAPPRCFLG, YTOTRULECD, YTTSKID, YTUPMT, YTTAXX, YTTELKPP, YTSCTR, YTSCRX, YTSVH, YTPAYLIA, YTTCFD, YTTCTD, YTHWPD, YTINSTID, YTTCUN, YTTCHC, YTTCHB, YTTCJT, YTTCJS, YTTCRT, YTTCSC, YTTCSD, YTTCBR, YTTCPC, YTTCWC, YTTCWS, YTTCJL, YTTCANI, YTTCRFLG, YTJBLC, YTCOPX, YTBPTX, YTCOPB, YTCMED, YTCOPR, YTGLBN, YTWCEX, YTGLEX, YTLDID, YTLDED, YTTTAP, YTINVA, YTINRA, YTINEA, YTCRFL, YTCPTR, YTPCOR, YTAUSPTWW, YTAUBP FROM F06116

TOP 920 | 05T | F06116 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YTAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	YTPALF	Name - Alpha Sort	String	Generic Edit	12	0	Allow NULL?
3	YTPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
4	YTRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
5	YTCKCN	Check Control Number	Numeric	Generic Edit	8	0	Allow NULL?
6	YTAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
7	YTCO	Company	String	Generic Edit	5	0	Allow NULL?
8	YTHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
9	YTHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
10	YTMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
11	YTOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
12	YTSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
13	YTRCO	Company _ Recharge	String	Generic Edit	5	0	Allow NULL?
14	YTGMCU	Business Unit - Recharge	String	Generic Edit	12	0	Allow NULL?
15	YTGOBJ	Object Account - Recharge	String	Generic Edit	6	0	Allow NULL?
16	YTGSUB	Subsidiary - Recharge	String	Generic Edit	8	0	Allow NULL?
17	YTSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
18	YTSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
19	YTWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
20	YTMCUO	Business Unit - Chargeout	String	Generic Edit	12	0	Allow NULL?
21	YTMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
22	YTPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
23	YTOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
24	YTRILT	Labor Type - Routing Instructions	Character	UDC (06 AT)	1	0	Allow NULL?
25	YTITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
26	YTPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
27	YTUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
28	YTPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
29	YTPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
30	YTBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
31	YTPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
32	YTBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
33	YTSHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
34	YTSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
35	YTSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
36	YTPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
37	YTLD	Percent or Amount	Character	UDC (07 LD)	1	0	Allow NULL?
38	YTGPA	Amount - Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
39	YTDPA	Amount - Distributed Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
40	YTRCPY	Recharge Amount	Numeric	Generic Edit	9	2	Allow NULL?
41	YTSAMT	Amount - Sales Generated	Numeric	Generic Edit	11	2	Allow NULL?
42	YTUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
43	YTJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
44	YTJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
45	YTWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
46	YTWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
47	YTWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
48	YTWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
49	YTWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
50	YTGENA	General Liability Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
51	YTWCAM	Workers Comp Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
52	YTWCMB	Workers Comp Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
53	YTGENB	General Liability Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
54	YTWCMO	Workers Comp Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
55	YTGENO	General Liability Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
56	YTWCMX	Workers Comp Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
57	YTGENX	General Liability Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
58	YTWCBN	Workers' Compensation Benefit Amount	Numeric	Generic Edit	9	2	Allow NULL?
59	YTHMO	Month - Update of History	Numeric	Generic Edit	2	0	Allow NULL?
60	YTPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
61	YTPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
62	YTDEDM	Method of Calculation	Character	UDC (06 DM)	1	0	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	YTDEP6	Deduction Period 6	Character	UDC (05A DD)	1	0	Allow NULL?
120	YTTT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
121	YTTT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
122	YTTT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
123	YTTT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
124	YTTT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
125	YTTT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
126	YTTT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
127	YTTT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
128	YTTT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
129	YTTT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
130	YTTT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
131	YTTT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
132	YTTT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
133	YTTT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
134	YTTT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
135	YTUSR	Payroll Lockout Identification	String	Generic Edit	18	0	Allow NULL?
136	YTEPA	Amount - Entered Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
137	YTBFA	Benefit Factor	Numeric	Generic Edit	11	8	Allow NULL?
138	YTRTWC	Rate - Workers Comp Insurance	Numeric	Generic Edit	9	5	Allow NULL?
139	YTGENR	Rate - Workers Comp Gen Liability	Numeric	Generic Edit	9	3	Allow NULL?
140	YTADV	Advance on Pay	Character	Generic Edit	1	0	Allow NULL?
141	YTSTIP	Batch Timecard Offsite Flag	Character	Generic Edit	1	0	Allow NULL?
142	YTALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
143	YTIIAP	Auto Pay Methods	Character	UDC (07 II)	1	0	Allow NULL?
144	YTFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
145	YTDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
146	YTDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
147	YTYST1	Status- Payroll 01	Character	UDC (07 YS)	1	0	Allow NULL?
148	YTCKCS	Spending Account Claim Number	String	Generic Edit	15	0	Allow NULL?
149	YTALT0	G/L Posting Code - Alternate 0	Character	Generic Edit	1	0	Allow NULL?
150	YTPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
151	YTACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
152	YTABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
153	YTABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
154	YTABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
155	YTABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
156	YTABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
157	YTABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
158	YTABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
159	YTABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
160	YTBLGRT	Rate - Billing Rate	Numeric	Generic Edit	15	3	Allow NULL?
161	YTRCHGAMT	Rate - Recharge Amount	Numeric	Generic Edit	15	2	Allow NULL?
162	YTFBLGRT	Rate - Billing Foreign	Numeric	Generic Edit	15	3	Allow NULL?
163	YTFRCHGAMT	Rate - Recharge Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
164	YTCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
165	YTCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
166	YTCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
167	YTRCHGMODE	Recharge Mode	Character	UDC (05 RM)	1	0	Allow NULL?
168	YTLTTP	Leave Type	String	UDC (07 LV)	2	0	Allow NULL?
169	YTRKID	Leave Request Number	Numeric	Generic Edit	8	0	Allow NULL?
170	YTTELKFLG	Flag - Time Entry Lockout	Character	UDC (07 LK)	1	0	Allow NULL?
171	YTAPPRCFLG	Timecard Offsite Flag	Character	Generic Edit	1	0	Allow NULL?
172	YTOTRULECD	Code - Overtime Rule	String	UDC (07 OR)	3	0	Allow NULL?
173	YTTSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
174	YTUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
175	YTTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
176	YTTELKPP	Public Flag	Character	UDC (05T PP)	1	0	Allow NULL?
177	YTSCTR	Sick Certificate Required	Character	Generic Edit	1	0	Allow NULL?
178	YTSCRX	Sick Certificate Received	Character	UDC (07 S5)	1	0	Allow NULL?
179	YTSVH	Benefit/Accrual Type	Character	UDC (06 SV)	1	0	Allow NULL?
180	YTPAYLIA	Pay In Advance	Character	Generic Edit	1	0	Allow NULL?
181	YTTCFD	Timecard From Date	Date	Generic Edit	6	0
182	YTTCTD	Timecard Thru Date	Date	Generic Edit	6	0
183	YTHWPD	Hours Worked Per Day	Numeric	Generic Edit	6	2	Allow NULL?
184	YTINSTID	Instance Identifier	String	Generic Edit	36	0	Allow NULL?
185	YTTCUN	Union Timecard Override	Character	Generic Edit	1	0	Allow NULL?
186	YTTCHC	Home Company Timecard Override	Character	Generic Edit	1	0	Allow NULL?
187	YTTCHB	Home Business Unit Timecard Override	Character	Generic Edit	1	0	Allow NULL?
188	YTTCJT	Job Type Timecard Override	Character	Generic Edit	1	0	Allow NULL?
189	YTTCJS	Job Step Timecard Override	Character	Generic Edit	1	0	Allow NULL?
190	YTTCRT	Hourly Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
191	YTTCSC	Shift Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
192	YTTCSD	Shift Differential Timecard Override	Character	Generic Edit	1	0	Allow NULL?
193	YTTCBR	Billing Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
194	YTTCPC	Piece Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
195	YTTCWC	Workers Comp Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
196	YTTCWS	Workers Comp Sub Class Timecard Override	Character	Generic Edit	1	0	Allow NULL?
197	YTTCJL	Business Unit Chargeout Timecard Overrde	Character	Generic Edit	1	0	Allow NULL?
198	YTTCANI	Account Number Timecard Override	Character	Generic Edit	1	0	Allow NULL?
199	YTTCRFLG	Timecard Reprocess Flag	Character	Generic Edit	1	0	Allow NULL?
200	YTJBLC	Contract Labor Category	String	UDC (06 G)	6	0	Allow NULL?
201	YTCOPX	Component Pay Flag	Character	Generic Edit	1	0	Allow NULL?
202	YTBPTX	Base Pay Transaction Number	Numeric	Generic Edit	9	0	Allow NULL?
203	YTCOPB	Component Pay Basis	Numeric	Generic Edit	15	2	Allow NULL?
204	YTCMED	Component Pay Calculation Method	Character	UDC (05T CM)	1	0	Allow NULL?
205	YTCOPR	Component Pay Amount Or Rate	Numeric	Generic Edit	9	3	Allow NULL?
206	YTGLBN	General Liability Benefit Amount	Numeric	Generic Edit	15	2	Allow NULL?
207	YTWCEX	Workers' Comp Excess Amount	Numeric	Generic Edit	15	2	Allow NULL?
208	YTGLEX	General Liability Excess Amount	Numeric	Generic Edit	15	2	Allow NULL?
209	YTLDID	Labor Distribution Period ID	String	UDC (05T LD)	5	0	Allow NULL?
210	YTLDED	Labor Period Ending Date	Date	Generic Edit	6	0
211	YTTTAP	Total Time Accounting Processing	Character	Generic Edit	1	0	Allow NULL?
212	YTINVA	Invalid Labor Account Number	String	Generic Edit	29	0	Allow NULL?
213	YTINRA	Invalid Recharge Account Number	String	Generic Edit	29	0	Allow NULL?
214	YTINEA	Invalid Equipment Account Number	String	Generic Edit	29	0	Allow NULL?
215	YTCRFL	Timecard Corrections Flag	Character	Generic Edit	1	0	Allow NULL?
216	YTCPTR	Correction Timecard Historical Link	Numeric	Generic Edit	9	0	Allow NULL?
217	YTPCOR	Processed Correction	Character	Generic Edit	1	0	Allow NULL?
218	YTAUSPTWW	State Payroll Tax State Where Worked	String	UDC (06 SC)	3	0	Allow NULL?
219	YTAUBP	Australia Payment Type	Character	UDC (75A BP)	1	0	Allow NULL?

TOP 920 | 05T | F06116 INDEXES

Number

Description

Address Num Date Work +B (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DWK	Date - Worked	Ascending
3	PRTR	Transaction No. - Payroll	Ascending

Address Num Date Work +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DWK	Date - Worked	Ascending
3	PHRT	Rate - Hourly	Ascending

GL Batch

Element	Alias	Description	Sequence
1	GICU	General Ledger Batch Number	Ascending

Address Num Check Cntrl +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKCN	Check Control Number	Ascending
3	WST	Work State	Ascending
4	WCNT	Work County	Ascending
5	WCTY	Work City	Ascending

Address Num Check Cntrl +B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKCN	Check Control Number	Ascending
3	PDBA	DBA Code	Ascending
4	SHRT	Rate - Hourly	Ascending

Cost Center Date Work +A

Element	Alias	Description	Sequence
1	MCUO	Business Unit - Chargeout	Ascending
2	DWK	Date - Worked	Ascending
3	ICU	Batch Number	Ascending
4	PDBA	DBA Code	Ascending
5	AN8	Address Number	Ascending
6	SUB	Subsidiary	Ascending

Batch PR Trans Num

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	PRTR	Transaction No. - Payroll	Ascending

Company Home Address Num +A

Element	Alias	Description	Sequence
1	HMCO	Company - Home	Ascending
2	AN8	Address Number	Ascending
3	WST	Work State	Ascending
4	WCMP	Worker's Comp. Insurance Code	Ascending
5	WET	Sub Class - Workers Comp	Ascending
6	RTWC	Rate - Workers Comp Insurance	Ascending
7	DEDM	Method of Calculation	Ascending

Cost Center Address Num +A

Element	Alias	Description	Sequence
1	MCUO	Business Unit - Chargeout	Ascending
2	AN8	Address Number	Ascending
3	MAIL	Routing Code - Check	Ascending
4	JBCD	Job Type (Craft) Code	Ascending

Address Num Check Cntrl +C

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKCN	Check Control Number	Ascending
3	DWK	Date - Worked	Ascending

PR Lockout

Element	Alias	Description	Sequence
1	USR	Payroll Lockout Identification	Ascending

Cost Center Home Routing Code

Element	Alias	Description	Sequence
1	HMCU	Business Unit - Home	Ascending
2	MAIL	Routing Code - Check	Ascending

Date Work Batch +A

Element	Alias	Description	Sequence
1	DWK	Date - Worked	Ascending
2	ICU	Batch Number	Ascending
3	PDBA	DBA Code	Ascending
4	AN8	Address Number	Ascending

Batch Date Work +A

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DWK	Date - Worked	Ascending
3	AN8	Address Number	Ascending

PR Transaction

Element	Alias	Description	Sequence
1	PRTR	Transaction No. - Payroll	Ascending

Address Num Pay Deduct Ben

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

Cost Center Object Account +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	SBL	Subledger - G/L	Ascending
5	SBLT	Subledger Type	Ascending
6	DGL	Date - For G/L (and Voucher)	Ascending
7	GICU	General Ledger Batch Number	Ascending
8	PDBA	DBA Code	Ascending
9	JBCD	Job Type (Craft) Code	Ascending
10	JBST	Job Step	Ascending

Rech Cost C Rech Obj Act +A

Element	Alias	Description	Sequence
1	GMCU	Business Unit - Recharge	Ascending
2	GOBJ	Object Account - Recharge	Ascending
3	GSUB	Subsidiary - Recharge	Ascending
4	SBL	Subledger - G/L	Ascending
5	SBLT	Subledger Type	Ascending
6	DGL	Date - For G/L (and Voucher)	Ascending
7	GICU	General Ledger Batch Number	Ascending
8	PDBA	DBA Code	Ascending
9	JBCD	Job Type (Craft) Code	Ascending
10	JBST	Job Step	Ascending

Cost Center Eq Obj Act +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	QOBJ	Equipment Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	SBL	Subledger - G/L	Ascending
5	SBLT	Subledger Type	Ascending
6	DGL	Date - For G/L (and Voucher)	Ascending
7	GICU	General Ledger Batch Number	Ascending

Subledger Subledg Type +A

Element	Alias	Description	Sequence
1	SBL	Subledger - G/L	Ascending
2	SBLT	Subledger Type	Ascending
3	OPSQ	Sequence Number - Operations	Ascending

Rech Cost C Eq Obj Accnt +A

Element	Alias	Description	Sequence
1	GMCU	Business Unit - Recharge	Ascending
2	QOBJ	Equipment Object Account	Ascending
3	GSUB	Subsidiary - Recharge	Ascending
4	SBL	Subledger - G/L	Ascending
5	SBLT	Subledger Type	Ascending
6	DGL	Date - For G/L (and Voucher)	Ascending
7	GICU	General Ledger Batch Number	Ascending

Batch Address Num +A

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	AN8	Address Number	Ascending
3	PRTR	Transaction No. - Payroll	Ascending

Address Num Assignment ID

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TSKID	Task Unique Key ID	Ascending

Assignment ID

Element	Alias	Description	Sequence
1	TSKID	Task Unique Key ID	Ascending
2	AN8	Address Number	Ascending
3	DWK	Date - Worked	Ascending
4	PDBA	DBA Code	Ascending

Overtime Rule Address Num

Element	Alias	Description	Sequence
1	OTRULECD	Code - Overtime Rule	Ascending
2	AN8	Address Number	Ascending

Address Num PDBA +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PDBA	DBA Code	Ascending
3	TAXX	Tax Identification Number	Ascending

Check Control Payroll Lockout

Element	Alias	Description	Sequence
1	CKCN	Check Control Number	Ascending
2	USR	Payroll Lockout Identification	Ascending
3	AN8	Address Number	Ascending
4	PDBA	DBA Code	Ascending
5	DWK	Date - Worked	Ascending
6	PRTR	Transaction No. - Payroll	Ascending

AN8. TCDE

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TCDE	Date Time Clock End	Ascending

AN8 TELKPP

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TELKPP	Public Flag	Ascending

AN8 PAYLIA

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PAYLIA	Pay In Advance	Ascending

Leave Type

Element	Alias	Description	Sequence
1	LTTP	Leave Type	Ascending

Instance ID

Element	Alias	Description	Sequence
1	INSTID	Instance Identifier	Ascending

AN8 BPTX

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	BPTX	Base Pay Transaction Number	Ascending

AN8 TTAP LDED PDBA

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TTAP	Total Time Accounting Processing	Ascending
3	LDED	Labor Period Ending Date	Ascending
4	PDBA	DBA Code	Ascending

Batch User id AN8 Wrkdt PRTR

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	USER	User ID	Ascending
3	AN8	Address Number	Ascending
4	DWK	Date - Worked	Ascending
5	PRTR	Transaction No. - Payroll	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

219 COLUMNS | 35 INDEXES | 920 | 05T | F06116 TABLE

TOP 920 | 05T | F06116 COLUMNS

TOP 920 | 05T | F06116 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

219 COLUMNS | 35 INDEXES | 920 | 05T | F06116 TABLE

TOP920 | 05T | F06116 COLUMNS

TOP920 | 05T | F06116 INDEXES

TOP 920 | 05T | F06116 COLUMNS

TOP 920 | 05T | F06116 INDEXES