	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

222 COLUMNS | 4 INDEXES | 920 | 05T | F06116Z2 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05T: Time Entry
1	920	F06116Z2	VM	222	4	ESS Timecard History	Files	05T: Time Entry

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 VMEDUS, VMEDTY, VMEDSQ, VMEDTN, VMEDCT, VMEDLN, VMEDTS, VMEDFT, VMEDDT, VMEDER, VMEDDL, VMEDSP, VMEDTC, VMEDTR, VMEDBT, VMEDGL, VMPANP, VMAN8, VMPALF, VMPRTR, VMRCCD, VMCKCN, VMAM, VMCO, VMHMCO, VMHMCU, VMMCU, VMOBJ, VMSUB, VMRCO, VMGMCU, VMGOBJ, VMGSUB, VMSBL, VMSBLT, VMWR01, VMMCUO, VMMAIL, VMPHRW, VMOPSQ, VMRILT, VMBDSN, VMPCUN, VMUM, VMPHRT, VMPPRT, VMBHRT, VMPBRT, VMBDRT, VMGPA, VMDPA, VMRCPY, VMSAMT, VMUN, VMJBCD, VMJBST, VMWST, VMWCNT, VMWCTY, VMWCMP, VMWET, VMGENA, VMWCAM, VMWCMB, VMGENB, VMWCMO, VMGENO, VMWCMX, VMGENX, VMHMO, VMPDBA, VMPB, VMDEDM, VMPAYM, VMSHFT, VMSHD, VMSALY, VMNMTH, VMPFRQ, VMFY, VMDGL, VMPN, VMDWK, VMDW, VMPPED, VMPPP, VMDTBT, VMTCDE, VMEQCO, VMEQWO, VMEQCG, VMQOBJ, VMERC, VMEQRT, VMEQGR, VMEQHR, VMEXR, VMP001, VMP002, VMP003, VMP004, VMUSER, VMCMMT, VMCKDT, VMUAMT, VMYST, VMICU, VMGICU, VMDICJ, VMUPMJ, VMPID, VMANI, VMCTRY, VMANN8, VMPGRP, VMPAYG, VMPAYN, VMSFLG, VMWS, VMPCK, VMICC, VMICS, VMCMTH, VMACO, VMAI, VMSEC$, VMOHF, VMDEP1, VMDEP2, VMDEP3, VMDEP4, VMDEP5, VMTT01, VMTT02, VMTT03, VMTT04, VMTT05, VMTT06, VMTT07, VMTT08, VMTT09, VMTT10, VMTT11, VMTT12, VMTT13, VMTT14, VMTT15, VMUSR, VMEPA, VMBFA, VMRTWC, VMGENR, VMADV, VMSTIP, VMALPH, VMIIAP, VMFICM, VMDTAB, VMDTSP, VMYST1, VMSHRT, VMLD, VMACTB, VMABR1, VMABT1, VMABR2, VMABT2, VMABR3, VMABT3, VMABR4, VMABT4, VMITM, VMBLGRT, VMRCHGAMT, VMFBLGRT, VMFRCHGAMT, VMCRR, VMCRCD, VMCRDC, VMRCHGMODE, VMSSFL, VMLTTP, VMRKID, VMPOS, VMOTRULECD, VMTSKID, VMUPMT, VMANPA, VMDOCM, VMSSREID, VMPAYLIA, VMTCFD, VMTCTD, VMHWPD, VMINSTID, VMTCUN, VMTCHC, VMTCHB, VMTCJT, VMTCJS, VMTCRT, VMTCSC, VMTCSD, VMTCBR, VMTCPC, VMTCWC, VMTCWS, VMTCJL, VMTCANI, VMJBLC, VMLDED, VMTCPF, VMCRFL, VMCPTR, VMZ1CR, VMZ1CM, VMELCR, VMTRLX, VMSEQNC, VMLDID, VMDLRB, VMAUSPTWW FROM F06116Z2

TOP 920 | 05T | F06116Z2 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	VMEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	VMEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
3	VMEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
4	VMEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
5	VMEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	VMEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	VMEDTS	EDI - Transaction Set Number	String	Generic Edit	6	0	Allow NULL?
8	VMEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	VMEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	VMEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	VMEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	VMEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	VMEDTC	EDI - Transaction Action	Character	Generic Edit	1	0	Allow NULL?
14	VMEDTR	EDI - Transaction Type	Character	Generic Edit	1	0	Allow NULL?
15	VMEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
16	VMEDGL	Batch File Create G/L Record	Character	Generic Edit	1	0	Allow NULL?
17	VMPANP	Payroll ID - Input (Mode Unknown)	String	Generic Edit	9	0	Allow NULL?
18	VMAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
19	VMPALF	Name - Alpha Sort	String	Generic Edit	12	0	Allow NULL?
20	VMPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
21	VMRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
22	VMCKCN	Check Control Number	Numeric	Generic Edit	8	0	Allow NULL?
23	VMAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
24	VMCO	Company	String	Generic Edit	5	0	Allow NULL?
25	VMHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
26	VMHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
27	VMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
28	VMOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
29	VMSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
30	VMRCO	Company _ Recharge	String	Generic Edit	5	0	Allow NULL?
31	VMGMCU	Business Unit - Recharge	String	Generic Edit	12	0	Allow NULL?
32	VMGOBJ	Object Account - Recharge	String	Generic Edit	6	0	Allow NULL?
33	VMGSUB	Subsidiary - Recharge	String	Generic Edit	8	0	Allow NULL?
34	VMSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
35	VMSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
36	VMWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
37	VMMCUO	Business Unit - Chargeout	String	Generic Edit	12	0	Allow NULL?
38	VMMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
39	VMPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
40	VMOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
41	VMRILT	Labor Type - Routing Instructions	Character	UDC (06 AT)	1	0	Allow NULL?
42	VMBDSN	Serial Number - Bond	String	Generic Edit	22	0	Allow NULL?
43	VMPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
44	VMUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
45	VMPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
46	VMPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
47	VMBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
48	VMPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
49	VMBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
50	VMGPA	Amount - Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
51	VMDPA	Amount - Distributed Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
52	VMRCPY	Recharge Amount	Numeric	Generic Edit	9	2	Allow NULL?
53	VMSAMT	Amount - Sales Generated	Numeric	Generic Edit	11	2	Allow NULL?
54	VMUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
55	VMJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
56	VMJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
57	VMWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
58	VMWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
59	VMWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
60	VMWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
61	VMWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
62	VMGENA	General Liability Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
63	VMWCAM	Workers Comp Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
64	VMWCMB	Workers Comp Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
65	VMGENB	General Liability Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
66	VMWCMO	Workers Comp Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
67	VMGENO	General Liability Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
68	VMWCMX	Workers Comp Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
69	VMGENX	General Liability Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
70	VMHMO	Month - Update of History	Numeric	Generic Edit	2	0	Allow NULL?
71	VMPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
72	VMPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
73	VMDEDM	Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
74	VMPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
75	VMSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
76	VMSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
77	VMSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
78	VMNMTH	Effect on GL	Character	UDC	1	0	Allow NULL?
79	VMPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
80	VMFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
81	VMDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
82	VMPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
83	VMDWK	Date - Worked	Date	Generic Edit	6	0
84	VMDW	Day of the Week	Character	UDC (06 DW)	1	0	Allow NULL?
85	VMPPED	Date - Pay Period Ending	Date	Generic Edit	6	0
86	VMPPP	Pay Period of the Month	Character	UDC (07 MP)	1	0	Allow NULL?
87	VMDTBT	Date - Time Clock Start Date and Time	Numeric	Generic Edit	13	0	Allow NULL?
88	VMTCDE	Date Time Clock End	Numeric	Generic Edit	13	0	Allow NULL?
89	VMEQCO	Company - Equipment	String	Generic Edit	5	0	Allow NULL?
90	VMEQWO	Equipment Worked On	String	Generic Edit	9	0	Allow NULL?
91	VMEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
92	VMQOBJ	Equipment Object Account	String	Generic Edit	6	0	Allow NULL?
93	VMERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
94	VMEQRT	Billing Rate - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
95	VMEQGR	Amount _ Equipment Gross	Numeric	Generic Edit	9	2	Allow NULL?
96	VMEQHR	Hours - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
97	VMEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
98	VMP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
99	VMP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
100	VMP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
101	VMP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
102	VMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
103	VMCMMT	Check Comment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
104	VMCKDT	Date - Pay Check	Date	Generic Edit	6	0
105	VMUAMT	Amount - Uprate	Numeric	Generic Edit	9	3	Allow NULL?
106	VMYST	Processed Code	Character	UDC (07 YW)	1	0	Allow NULL?
107	VMICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
108	VMGICU	General Ledger Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
109	VMDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
110	VMUPMJ	Date - Updated	Date	Generic Edit	6	0
111	VMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
112	VMANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
113	VMCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
114	VMANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
115	VMPGRP	Deduct/Benefit Override Code	String	Generic Edit	2	0	Allow NULL?
116	VMPAYG	Effect on Gross Pay	Character	UDC (07 PA)	1	0	Allow NULL?
117	VMPAYN	Effect on Net Pay	Character	UDC (07 PA)	1	0	Allow NULL?
118	VMSFLG	Void Flag (Y/N)	Character	Generic Edit	1	0	Allow NULL?
119	VMWS	Work Schedule Code	Character	UDC (05A WS)	1	0	Allow NULL?
120	VMPCK	Method of Printing	Character	UDC (05A PT)	1	0	Allow NULL?
121	VMICC	Interim Check Code	Character	UDC (07 IC)	1	0	Allow NULL?
122	VMICS	Interim Check Status	Character	UDC (07 IC)	1	0	Allow NULL?
123	VMCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
124	VMACO	Available DBA	Character	Generic Edit	1	0	Allow NULL?
125	VMAI	Type - Sales	Character	UDC	1	0	Allow NULL?
126	VMSEC$	Security Indicator	Character	Generic Edit	1	0	Allow NULL?
127	VMOHF	Overtime Code	Character	UDC (07 OH)	1	0	Allow NULL?
128	VMDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
129	VMDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
130	VMDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
131	VMDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
132	VMDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
133	VMTT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
134	VMTT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
135	VMTT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
136	VMTT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
137	VMTT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
138	VMTT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
139	VMTT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
140	VMTT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
141	VMTT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
142	VMTT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
143	VMTT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
144	VMTT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
145	VMTT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
146	VMTT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
147	VMTT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
148	VMUSR	Payroll Lockout Identification	String	Generic Edit	18	0	Allow NULL?
149	VMEPA	Amount - Entered Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
150	VMBFA	Benefit Factor	Numeric	Generic Edit	11	8	Allow NULL?
151	VMRTWC	Rate - Workers Comp Insurance	Numeric	Generic Edit	9	5	Allow NULL?
152	VMGENR	Rate - Workers Comp Gen Liability	Numeric	Generic Edit	9	3	Allow NULL?
153	VMADV	Advance on Pay	Character	Generic Edit	1	0	Allow NULL?
154	VMSTIP	Batch Timecard Offsite Flag	Character	Generic Edit	1	0	Allow NULL?
155	VMALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
156	VMIIAP	Auto Pay Methods	Character	UDC (07 II)	1	0	Allow NULL?
157	VMFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
158	VMDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
159	VMDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
160	VMYST1	Status- Payroll 01	Character	UDC (07 YS)	1	0	Allow NULL?
161	VMSHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
162	VMLD	Percent or Amount	Character	UDC (07 LD)	1	0	Allow NULL?
163	VMACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
164	VMABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
165	VMABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
166	VMABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
167	VMABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
168	VMABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
169	VMABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
170	VMABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
171	VMABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
172	VMITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
173	VMBLGRT	Rate - Billing Rate	Numeric	Generic Edit	15	3	Allow NULL?
174	VMRCHGAMT	Rate - Recharge Amount	Numeric	Generic Edit	15	2	Allow NULL?
175	VMFBLGRT	Rate - Billing Foreign	Numeric	Generic Edit	15	3	Allow NULL?
176	VMFRCHGAMT	Rate - Recharge Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
177	VMCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
178	VMCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
179	VMCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
180	VMRCHGMODE	Recharge Mode	Character	UDC (05 RM)	1	0	Allow NULL?
181	VMSSFL	Time Entry Status Flag	Character	Generic Edit	1	0	Allow NULL?
182	VMLTTP	Leave Type	String	UDC (07 LV)	2	0	Allow NULL?
183	VMRKID	Leave Request Number	Numeric	Generic Edit	8	0	Allow NULL?
184	VMPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
185	VMOTRULECD	Code - Overtime Rule	String	UDC (07 OR)	3	0	Allow NULL?
186	VMTSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
187	VMUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
188	VMANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
189	VMDOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
190	VMSSREID	Self Service Record Identifier	String	Generic Edit	9	0	Allow NULL?
191	VMPAYLIA	Pay In Advance	Character	Generic Edit	1	0	Allow NULL?
192	VMTCFD	Timecard From Date	Date	Generic Edit	6	0
193	VMTCTD	Timecard Thru Date	Date	Generic Edit	6	0
194	VMHWPD	Hours Worked Per Day	Numeric	Generic Edit	6	2	Allow NULL?
195	VMINSTID	Instance Identifier	String	Generic Edit	36	0	Allow NULL?
196	VMTCUN	Union Timecard Override	Character	Generic Edit	1	0	Allow NULL?
197	VMTCHC	Home Company Timecard Override	Character	Generic Edit	1	0	Allow NULL?
198	VMTCHB	Home Business Unit Timecard Override	Character	Generic Edit	1	0	Allow NULL?
199	VMTCJT	Job Type Timecard Override	Character	Generic Edit	1	0	Allow NULL?
200	VMTCJS	Job Step Timecard Override	Character	Generic Edit	1	0	Allow NULL?
201	VMTCRT	Hourly Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
202	VMTCSC	Shift Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
203	VMTCSD	Shift Differential Timecard Override	Character	Generic Edit	1	0	Allow NULL?
204	VMTCBR	Billing Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
205	VMTCPC	Piece Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
206	VMTCWC	Workers Comp Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
207	VMTCWS	Workers Comp Sub Class Timecard Override	Character	Generic Edit	1	0	Allow NULL?
208	VMTCJL	Business Unit Chargeout Timecard Overrde	Character	Generic Edit	1	0	Allow NULL?
209	VMTCANI	Account Number Timecard Override	Character	Generic Edit	1	0	Allow NULL?
210	VMJBLC	Contract Labor Category	String	UDC (06 G)	6	0	Allow NULL?
211	VMLDED	Labor Period Ending Date	Date	Generic Edit	6	0
212	VMTCPF	Timecard Processed Flag	Character	Generic Edit	1	0	Allow NULL?
213	VMCRFL	Timecard Corrections Flag	Character	Generic Edit	1	0	Allow NULL?
214	VMCPTR	Correction Timecard Historical Link	Numeric	Generic Edit	9	0	Allow NULL?
215	VMZ1CR	Timecard Change Reason	String	UDC (05T CR)	2	0	Allow NULL?
216	VMZ1CM	Change Comments	String	Generic Edit	100	0	Allow NULL?
217	VMELCR	Corrections Eligibility	Character	Generic Edit	1	0	Allow NULL?
218	VMTRLX	Timecard Transaction Link	Numeric	Generic Edit	9	0	Allow NULL?
219	VMSEQNC	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
220	VMLDID	Labor Distribution Period ID	String	UDC (05T LD)	5	0	Allow NULL?
221	VMDLRB	Delete Rollback	Character	Generic Edit	1	0	Allow NULL?
222	VMAUSPTWW	State Payroll Tax State Where Worked	String	UDC (06 SC)	3	0	Allow NULL?

TOP 920 | 05T | F06116Z2 INDEXES

Number

Description

Edi Sequence Number (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
5	SEQNC	Sequence Number	Ascending

AN8 TRLX SEQNC

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TRLX	Timecard Transaction Link	Ascending
3	SEQNC	Sequence Number	Descending

AN8 EDTN SEQNC ELCR

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	EDTN	EDI - Transaction Number	Ascending
3	SEQNC	Sequence Number	Descending
4	ELCR	Corrections Eligibility	Ascending

AN8 PRTR

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	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

222 COLUMNS | 4 INDEXES | 920 | 05T | F06116Z2 TABLE

TOP 920 | 05T | F06116Z2 COLUMNS

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

222 COLUMNS | 4 INDEXES | 920 | 05T | F06116Z2 TABLE

TOP920 | 05T | F06116Z2 COLUMNS

TOP920 | 05T | F06116Z2 INDEXES

TOP 920 | 05T | F06116Z2 COLUMNS

TOP 920 | 05T | F06116Z2 INDEXES