	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

209 COLUMNS | 10 INDEXES | 812 | 05T | F06116Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05T: Time Entry
1	812	F06116Z1	VL	209	10	Employee Transactions - Batch File	Batch Input 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 VLEDUS, VLEDTY, VLEDSQ, VLEDTN, VLEDCT, VLEDLN, VLEDTS, VLEDFT, VLEDDT, VLEDER, VLEDDL, VLEDSP, VLEDTC, VLEDTR, VLEDBT, VLEDGL, VLPANP, VLAN8, VLPALF, VLPRTR, VLRCCD, VLCKCN, VLAM, VLCO, VLHMCO, VLHMCU, VLMCU, VLOBJ, VLSUB, VLRCO, VLGMCU, VLGOBJ, VLGSUB, VLSBL, VLSBLT, VLWR01, VLMCUO, VLMAIL, VLPHRW, VLOPSQ, VLRILT, VLBDSN, VLPCUN, VLUM, VLPHRT, VLPPRT, VLBHRT, VLPBRT, VLBDRT, VLGPA, VLDPA, VLRCPY, VLSAMT, VLUN, VLJBCD, VLJBST, VLWST, VLWCNT, VLWCTY, VLWCMP, VLWET, VLGENA, VLWCAM, VLWCMB, VLGENB, VLWCMO, VLGENO, VLWCMX, VLGENX, VLHMO, VLPDBA, VLPB, VLDEDM, VLPAYM, VLSHFT, VLSHD, VLSALY, VLNMTH, VLPFRQ, VLFY, VLDGL, VLPN, VLDWK, VLDW, VLPPED, VLPPP, VLDTBT, VLTCDE, VLEQCO, VLEQWO, VLEQCG, VLQOBJ, VLERC, VLEQRT, VLEQGR, VLEQHR, VLEXR, VLP001, VLP002, VLP003, VLP004, VLUSER, VLCMMT, VLCKDT, VLUAMT, VLYST, VLICU, VLGICU, VLDICJ, VLUPMJ, VLPID, VLANI, VLCTRY, VLANN8, VLPGRP, VLPAYG, VLPAYN, VLSFLG, VLWS, VLPCK, VLICC, VLICS, VLCMTH, VLACO, VLAI, VLSEC$, VLOHF, VLDEP1, VLDEP2, VLDEP3, VLDEP4, VLDEP5, VLTT01, VLTT02, VLTT03, VLTT04, VLTT05, VLTT06, VLTT07, VLTT08, VLTT09, VLTT10, VLTT11, VLTT12, VLTT13, VLTT14, VLTT15, VLUSR, VLEPA, VLBFA, VLRTWC, VLGENR, VLADV, VLSTIP, VLALPH, VLIIAP, VLFICM, VLDTAB, VLDTSP, VLYST1, VLSHRT, VLLD, VLACTB, VLABR1, VLABT1, VLABR2, VLABT2, VLABR3, VLABT3, VLABR4, VLABT4, VLITM, VLBLGRT, VLRCHGAMT, VLFBLGRT, VLFRCHGAMT, VLCRR, VLCRCD, VLCRDC, VLRCHGMODE, VLSSFL, VLLTTP, VLRKID, VLPOS, VLOTRULECD, VLTSKID, VLUPMT, VLANPA, VLDOCM, VLSSREID, VLPAYLIA, VLTCFD, VLTCTD, VLHWPD, VLINSTID, VLTCUN, VLTCHC, VLTCHB, VLTCJT, VLTCJS, VLTCRT, VLTCSC, VLTCSD, VLTCBR, VLTCPC, VLTCWC, VLTCWS, VLTCJL, VLTCANI FROM F06116Z1

TOP 812 | 05T | F06116Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	VLEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	VLEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
3	VLEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
4	VLEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
5	VLEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	VLEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	VLEDTS	EDI - Transaction Set Number	String	Generic Edit	6	0	Allow NULL?
8	VLEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	VLEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	VLEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	VLEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	VLEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	VLEDTC	EDI - Transaction Action	Character	Generic Edit	1	0	Allow NULL?
14	VLEDTR	EDI - Transaction Type	Character	Generic Edit	1	0	Allow NULL?
15	VLEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
16	VLEDGL	Batch File Create G/L Record	Character	Generic Edit	1	0	Allow NULL?
17	VLPANP	Payroll ID - Input (Mode Unknown)	String	Generic Edit	9	0	Allow NULL?
18	VLAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
19	VLPALF	Name - Alpha Sort	String	Generic Edit	12	0	Allow NULL?
20	VLPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
21	VLRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
22	VLCKCN	Check Control Number	Numeric	Generic Edit	8	0	Allow NULL?
23	VLAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
24	VLCO	Company	String	Generic Edit	5	0	Allow NULL?
25	VLHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
26	VLHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
27	VLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
28	VLOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
29	VLSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
30	VLRCO	Company _ Recharge	String	Generic Edit	5	0	Allow NULL?
31	VLGMCU	Business Unit - Recharge	String	Generic Edit	12	0	Allow NULL?
32	VLGOBJ	Object Account - Recharge	String	Generic Edit	6	0	Allow NULL?
33	VLGSUB	Subsidiary - Recharge	String	Generic Edit	8	0	Allow NULL?
34	VLSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
35	VLSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
36	VLWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
37	VLMCUO	Business Unit - Chargeout	String	Generic Edit	12	0	Allow NULL?
38	VLMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
39	VLPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
40	VLOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
41	VLRILT	Labor Type - Routing Instructions	Character	UDC (06 AT)	1	0	Allow NULL?
42	VLBDSN	Serial Number - Bond	String	Generic Edit	22	0	Allow NULL?
43	VLPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
44	VLUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
45	VLPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
46	VLPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
47	VLBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
48	VLPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
49	VLBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
50	VLGPA	Amount - Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
51	VLDPA	Amount - Distributed Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
52	VLRCPY	Recharge Amount	Numeric	Generic Edit	9	2	Allow NULL?
53	VLSAMT	Amount - Sales Generated	Numeric	Generic Edit	11	2	Allow NULL?
54	VLUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
55	VLJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
56	VLJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
57	VLWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
58	VLWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
59	VLWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
60	VLWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
61	VLWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
62	VLGENA	General Liability Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
63	VLWCAM	Workers Comp Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
64	VLWCMB	Workers Comp Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
65	VLGENB	General Liability Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
66	VLWCMO	Workers Comp Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
67	VLGENO	General Liability Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
68	VLWCMX	Workers Comp Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
69	VLGENX	General Liability Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
70	VLHMO	Month - Update of History	Numeric	Generic Edit	2	0	Allow NULL?
71	VLPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
72	VLPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
73	VLDEDM	Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
74	VLPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
75	VLSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
76	VLSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
77	VLSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
78	VLNMTH	Effect on GL	Character	UDC	1	0	Allow NULL?
79	VLPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
80	VLFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
81	VLDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
82	VLPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
83	VLDWK	Date - Worked	Date	Generic Edit	6	0
84	VLDW	Day of the Week	Character	UDC (06 DW)	1	0	Allow NULL?
85	VLPPED	Date - Pay Period Ending	Date	Generic Edit	6	0
86	VLPPP	Pay Period of the Month	Character	UDC (07 MP)	1	0	Allow NULL?
87	VLDTBT	Date - Time Clock Start Date and Time	Numeric	Generic Edit	13	0	Allow NULL?
88	VLTCDE	Date Time Clock End	Numeric	Generic Edit	13	0	Allow NULL?
89	VLEQCO	Company - Equipment	String	Generic Edit	5	0	Allow NULL?
90	VLEQWO	Equipment Worked On	String	Generic Edit	9	0	Allow NULL?
91	VLEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
92	VLQOBJ	Equipment Object Account	String	Generic Edit	6	0	Allow NULL?
93	VLERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
94	VLEQRT	Billing Rate - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
95	VLEQGR	Amount _ Equipment Gross	Numeric	Generic Edit	9	2	Allow NULL?
96	VLEQHR	Hours - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
97	VLEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
98	VLP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
99	VLP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
100	VLP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
101	VLP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
102	VLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
103	VLCMMT	Check Comment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
104	VLCKDT	Date - Pay Check	Date	Generic Edit	6	0
105	VLUAMT	Amount - Uprate	Numeric	Generic Edit	9	3	Allow NULL?
106	VLYST	Processed Code	Character	UDC (07 YW)	1	0	Allow NULL?
107	VLICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
108	VLGICU	General Ledger Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
109	VLDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
110	VLUPMJ	Date - Updated	Date	Generic Edit	6	0
111	VLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
112	VLANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
113	VLCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
114	VLANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
115	VLPGRP	Deduct/Benefit Override Code	String	Generic Edit	2	0	Allow NULL?
116	VLPAYG	Effect on Gross Pay	Character	UDC (07 PA)	1	0	Allow NULL?
117	VLPAYN	Effect on Net Pay	Character	UDC (07 PA)	1	0	Allow NULL?
118	VLSFLG	Void Flag (Y/N)	Character	Generic Edit	1	0	Allow NULL?
119	VLWS	Work Schedule Code	Character	UDC (05A WS)	1	0	Allow NULL?
120	VLPCK	Method of Printing	Character	UDC (05A PT)	1	0	Allow NULL?
121	VLICC	Interim Check Code	Character	UDC (07 IC)	1	0	Allow NULL?
122	VLICS	Interim Check Status	Character	UDC (07 IC)	1	0	Allow NULL?
123	VLCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
124	VLACO	Available DBA	Character	Generic Edit	1	0	Allow NULL?
125	VLAI	Type - Sales	Character	UDC	1	0	Allow NULL?
126	VLSEC$	Security Indicator	Character	Generic Edit	1	0	Allow NULL?
127	VLOHF	Overtime Code	Character	UDC (07 OH)	1	0	Allow NULL?
128	VLDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
129	VLDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
130	VLDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
131	VLDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
132	VLDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
133	VLTT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
134	VLTT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
135	VLTT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
136	VLTT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
137	VLTT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
138	VLTT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
139	VLTT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
140	VLTT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
141	VLTT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
142	VLTT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
143	VLTT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
144	VLTT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
145	VLTT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
146	VLTT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
147	VLTT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
148	VLUSR	Payroll Lockout Identification	String	Generic Edit	18	0	Allow NULL?
149	VLEPA	Amount - Entered Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
150	VLBFA	Benefit Factor	Numeric	Generic Edit	11	8	Allow NULL?
151	VLRTWC	Rate - Workers Comp Insurance	Numeric	Generic Edit	9	5	Allow NULL?
152	VLGENR	Rate - Workers Comp Gen Liability	Numeric	Generic Edit	9	3	Allow NULL?
153	VLADV	Advance on Pay	Character	Generic Edit	1	0	Allow NULL?
154	VLSTIP	Status - Tip Hist Update	Character	Generic Edit	1	0	Allow NULL?
155	VLALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
156	VLIIAP	Auto Pay Methods	Character	UDC (07 II)	1	0	Allow NULL?
157	VLFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
158	VLDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
159	VLDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
160	VLYST1	Status- Payroll 01	Character	UDC (07 YS)	1	0	Allow NULL?
161	VLSHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
162	VLLD	Percent or Amount	Character	UDC (07 LD)	1	0	Allow NULL?
163	VLACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
164	VLABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
165	VLABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
166	VLABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
167	VLABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
168	VLABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
169	VLABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
170	VLABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
171	VLABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
172	VLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
173	VLBLGRT	Rate - Billing Rate	Numeric	Generic Edit	15	3	Allow NULL?
174	VLRCHGAMT	Rate - Recharge Amount	Numeric	Generic Edit	15	2	Allow NULL?
175	VLFBLGRT	Rate - Billing Foreign	Numeric	Generic Edit	15	3	Allow NULL?
176	VLFRCHGAMT	Rate - Recharge Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
177	VLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
178	VLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
179	VLCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
180	VLRCHGMODE	Recharge Mode	Character	UDC (05 RM)	1	0	Allow NULL?
181	VLSSFL	Time Entry Status Flag	Character	Generic Edit	1	0	Allow NULL?
182	VLLTTP	Leave Type	String	UDC (07 LV)	2	0	Allow NULL?
183	VLRKID	Leave Request Number	Numeric	Generic Edit	8	0	Allow NULL?
184	VLPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
185	VLOTRULECD	Code - Overtime Rule	String	UDC (07 OR)	3	0	Allow NULL?
186	VLTSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
187	VLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
188	VLANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
189	VLDOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
190	VLSSREID	Self Service Record Identifier	String	Generic Edit	9	0	Allow NULL?
191	VLPAYLIA	Pay In Advance	Character	Generic Edit	1	0	Allow NULL?
192	VLTCFD	Timecard From Date	Date	Generic Edit	6	0
193	VLTCTD	Timecard Thru Date	Date	Generic Edit	6	0
194	VLHWPD	Hours Worked Per Day	Numeric	Generic Edit	6	2	Allow NULL?
195	VLINSTID	Instance Identifier	String	Generic Edit	36	0	Allow NULL?
196	VLTCUN	Union Timecard Override	Character	Generic Edit	1	0	Allow NULL?
197	VLTCHC	Home Company Timecard Override	Character	Generic Edit	1	0	Allow NULL?
198	VLTCHB	Home Business Unit Timecard Override	Character	Generic Edit	1	0	Allow NULL?
199	VLTCJT	Job Type Timecard Override	Character	Generic Edit	1	0	Allow NULL?
200	VLTCJS	Job Step Timecard Override	Character	Generic Edit	1	0	Allow NULL?
201	VLTCRT	Hourly Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
202	VLTCSC	Shift Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
203	VLTCSD	Shift Differential Timecard Override	Character	Generic Edit	1	0	Allow NULL?
204	VLTCBR	Billing Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
205	VLTCPC	Piece Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
206	VLTCWC	Workers Comp Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
207	VLTCWS	Workers Comp Sub Class Timecard Override	Character	Generic Edit	1	0	Allow NULL?
208	VLTCJL	Business Unit Chargeout Timecard Overrde	Character	Generic Edit	1	0	Allow NULL?
209	VLTCANI	Account Number Timecard Override	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 05T | F06116Z1 INDEXES

Number

Description

User Batch # + (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

User Batch # AN8 +

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	AN8	Address Number	Ascending
4	DWK	Date - Worked	Ascending
5	ICU	Batch Number	Ascending
6	EDTN	EDI - Transaction Number	Ascending

AN8 DWK PRTR

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

TaskID AN8 DWK

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

EDBT

Element	Alias	Description	Sequence
1	EDBT	EDI - Batch Number	Ascending

AN8 PDBA DWK

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	EDGL	Batch File Create G/L Record	Ascending

EDGL EDUS EDBT EDTN EDLN

Element	Alias	Description	Sequence
1	EDGL	Batch File Create G/L Record	Ascending
2	EDUS	EDI - User ID	Ascending
3	EDBT	EDI - Batch Number	Ascending
4	EDTN	EDI - Transaction Number	Ascending
5	EDLN	EDI - Line Number	Ascending

AN8 PDBA PANP

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PDBA	DBA Code	Ascending
3	PANP	Payroll ID - Input (Mode Unknown)	Ascending

AN8 SSREID DWK

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	SSREID	Self Service Record Identifier	Ascending
3	DWK	Date - Worked	Ascending

Instance ID

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

209 COLUMNS | 10 INDEXES | 812 | 05T | F06116Z1 TABLE

TOP 812 | 05T | F06116Z1 COLUMNS

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

209 COLUMNS | 10 INDEXES | 812 | 05T | F06116Z1 TABLE

TOP812 | 05T | F06116Z1 COLUMNS

TOP812 | 05T | F06116Z1 INDEXES

TOP 812 | 05T | F06116Z1 COLUMNS

TOP 812 | 05T | F06116Z1 INDEXES