	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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

223 COLUMNS | 6 INDEXES | 920 | 18 | F186602 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
18: Timecard Automation
1	920	F186602	TF	223	6	Labor Rules Tag File	Files	18: Timecard Automation	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 TFPRTR, TFLRSBAT, TFAN8, TFLRSPTN, TFLRSCHF, TFLRSORID, TFLRSOPT, TFLRSODWK, TFLRSOHW, TFLRSOHR, TFLRSOGP, TFUSER, TFPID, TFJOBN, TFUPMJ, TFTDAY, TFPALF, TFRCCD, TFCKCN, TFAM, TFCO, TFHMCO, TFHMCU, TFMCU, TFOBJ, TFSUB, TFRCO, TFGMCU, TFGOBJ, TFGSUB, TFSBL, TFSBLT, TFWR01, TFMCUO, TFMAIL, TFOPSQ, TFRILT, TFITM, TFPCUN, TFUM, TFPPRT, TFBHRT, TFPBRT, TFBDRT, TFSHRT, TFSHFT, TFSHD, TFPAYM, TFLD, TFDPA, TFRCPY, TFSAMT, TFUN, TFJBCD, TFJBST, TFWST, TFWCNT, TFWCTY, TFWCMP, TFWET, TFGENA, TFWCAM, TFWCMB, TFGENB, TFWCMO, TFGENO, TFWCMX, TFGENX, TFWCBN, TFHMO, TFPB, TFDEDM, TFSALY, TFNMTH, TFPFRQ, TFFY, TFDGL, TFPN, TFDW, TFPPED, TFPPP, TFDTBT, TFTCDE, TFEQCO, TFEQWO, TFEQCG, TFQOBJ, TFERC, TFEQRT, TFEQGR, TFEQHR, TFEXR, TFP001, TFP002, TFP003, TFP004, TFCMMT, TFCKDT, TFUAMT, TFYST, TFICU, TFGICU, TFDICJ, TFANI, TFCTRY, TFANN8, TFPGRP, TFPAYG, TFPAYN, TFSFLG, TFWS, TFPCK, TFICC, TFICS, TFCMTH, TFACO, TFAI, TFSEC$, TFOHF, TFDEP1, TFDEP2, TFDEP3, TFDEP4, TFDEP5, TFDEP6, TFTT01, TFTT02, TFTT03, TFTT04, TFTT05, TFTT06, TFTT07, TFTT08, TFTT09, TFTT10, TFTT11, TFTT12, TFTT13, TFTT14, TFTT15, TFUSR, TFEPA, TFBFA, TFRTWC, TFGENR, TFADV, TFSTIP, TFALPH, TFIIAP, TFFICM, TFDTAB, TFDTSP, TFYST1, TFCKCS, TFALT0, TFPOS, TFACTB, TFABR1, TFABT1, TFABR2, TFABT2, TFABR3, TFABT3, TFABR4, TFABT4, TFBLGRT, TFRCHGAMT, TFFBLGRT, TFFRCHGAMT, TFCRR, TFCRCD, TFCRDC, TFRCHGMODE, TFLTTP, TFRKID, TFTELKFLG, TFAPPRCFLG, TFOTRULECD, TFTSKID, TFUPMT, TFTAXX, TFSCTR, TFSCRX, TFSVH, TFTCFD, TFTCTD, TFHWPD, TFINSTID, TFTCUN, TFTCHC, TFTCHB, TFTCJT, TFTCJS, TFTCRT, TFTCSC, TFTCSD, TFTCBR, TFTCPC, TFTCWC, TFTCWS, TFTCJL, TFTCANI, TFTCRFLG, TFJBLC, TFCOPX, TFBPTX, TFCOPB, TFCMED, TFCOPR, TFGLBN, TFWCEX, TFGLEX, TFLDID, TFLDED, TFTTAP, TFINVA, TFINRA, TFINEA, TFCRFL, TFCPTR, TFPCOR, TFAUSPTWW, TFAUBP FROM F186602

TOP 920 | 18 | F186602 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	TFPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
2	TFLRSBAT	LRS Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
3	TFAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
4	TFLRSPTN	Parent Transaction Number	Numeric	Generic Edit	9	0	Allow NULL?
5	TFLRSCHF	Current/History Flag	Character	Generic Edit	1	0	Allow NULL?
6	TFLRSORID	Overtime Rule ID	Numeric	Generic Edit	15	0	Allow NULL?
7	TFLRSOPT	Original Pay Type	Numeric	Generic Edit	3	0	Allow NULL?
8	TFLRSODWK	Original Date Worked	Date	Generic Edit	6	0
9	TFLRSOHW	Original Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
10	TFLRSOHR	Original Hourly Rate	Numeric	Generic Edit	9	3	Allow NULL?
11	TFLRSOGP	Original Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
12	TFUSER	User ID	String	Generic Edit	10	0	Allow NULL?
13	TFPID	Program ID	String	Generic Edit	10	0	Allow NULL?
14	TFJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
15	TFUPMJ	Date - Updated	Date	Generic Edit	6	0
16	TFTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
17	TFPALF	Name - Alpha Sort	String	Generic Edit	12	0	Allow NULL?
18	TFRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
19	TFCKCN	Check Control Number	Numeric	Generic Edit	8	0	Allow NULL?
20	TFAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
21	TFCO	Company	String	Generic Edit	5	0	Allow NULL?
22	TFHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
23	TFHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
24	TFMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
25	TFOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
26	TFSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
27	TFRCO	Company _ Recharge	String	Generic Edit	5	0	Allow NULL?
28	TFGMCU	Business Unit - Recharge	String	Generic Edit	12	0	Allow NULL?
29	TFGOBJ	Object Account - Recharge	String	Generic Edit	6	0	Allow NULL?
30	TFGSUB	Subsidiary - Recharge	String	Generic Edit	8	0	Allow NULL?
31	TFSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
32	TFSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
33	TFWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
34	TFMCUO	Business Unit - Chargeout	String	Generic Edit	12	0	Allow NULL?
35	TFMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
36	TFOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
37	TFRILT	Labor Type - Routing Instructions	Character	UDC (06 AT)	1	0	Allow NULL?
38	TFITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
39	TFPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
40	TFUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
41	TFPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
42	TFBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
43	TFPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
44	TFBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
45	TFSHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
46	TFSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
47	TFSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
48	TFPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
49	TFLD	Percent or Amount	Character	UDC (07 LD)	1	0	Allow NULL?
50	TFDPA	Amount - Distributed Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
51	TFRCPY	Recharge Amount	Numeric	Generic Edit	9	2	Allow NULL?
52	TFSAMT	Amount - Sales Generated	Numeric	Generic Edit	11	2	Allow NULL?
53	TFUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
54	TFJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
55	TFJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
56	TFWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
57	TFWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
58	TFWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
59	TFWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
60	TFWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
61	TFGENA	General Liability Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
62	TFWCAM	Workers Comp Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
63	TFWCMB	Workers Comp Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
64	TFGENB	General Liability Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
65	TFWCMO	Workers Comp Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
66	TFGENO	General Liability Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
67	TFWCMX	Workers Comp Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
68	TFGENX	General Liability Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
69	TFWCBN	Workers' Compensation Benefit Amount	Numeric	Generic Edit	9	2	Allow NULL?
70	TFHMO	Month - Update of History	Numeric	Generic Edit	2	0	Allow NULL?
71	TFPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
72	TFDEDM	Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
73	TFSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
74	TFNMTH	Effect on GL	Character	UDC	1	0	Allow NULL?
75	TFPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
76	TFFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
77	TFDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
78	TFPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
79	TFDW	Day of the Week	Character	UDC (06 DW)	1	0	Allow NULL?
80	TFPPED	Date - Pay Period Ending	Date	Generic Edit	6	0
81	TFPPP	Pay Period of the Month	Character	UDC (07 MP)	1	0	Allow NULL?
82	TFDTBT	Date - Time Clock Start Date and Time	Numeric	Generic Edit	13	0	Allow NULL?
83	TFTCDE	Date Time Clock End	Numeric	Generic Edit	13	0	Allow NULL?
84	TFEQCO	Company - Equipment	String	Generic Edit	5	0	Allow NULL?
85	TFEQWO	Equipment Worked On	String	Generic Edit	9	0	Allow NULL?
86	TFEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
87	TFQOBJ	Equipment Object Account	String	Generic Edit	6	0	Allow NULL?
88	TFERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
89	TFEQRT	Billing Rate - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
90	TFEQGR	Amount _ Equipment Gross	Numeric	Generic Edit	9	2	Allow NULL?
91	TFEQHR	Hours - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
92	TFEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
93	TFP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
94	TFP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
95	TFP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
96	TFP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
97	TFCMMT	Check Comment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
98	TFCKDT	Date - Pay Check	Date	Generic Edit	6	0
99	TFUAMT	Amount - Uprate	Numeric	Generic Edit	9	3	Allow NULL?
100	TFYST	Processed Code	Character	UDC (07 YW)	1	0	Allow NULL?
101	TFICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
102	TFGICU	General Ledger Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
103	TFDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
104	TFANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
105	TFCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
106	TFANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
107	TFPGRP	Deduct/Benefit Override Code	String	Generic Edit	2	0	Allow NULL?
108	TFPAYG	Effect on Gross Pay	Character	UDC (07 PA)	1	0	Allow NULL?
109	TFPAYN	Effect on Net Pay	Character	UDC (07 PA)	1	0	Allow NULL?
110	TFSFLG	Void Flag (Y/N)	Character	Generic Edit	1	0	Allow NULL?
111	TFWS	Work Schedule Code	Character	UDC (05A WS)	1	0	Allow NULL?
112	TFPCK	Method of Printing	Character	UDC (05A PT)	1	0	Allow NULL?
113	TFICC	Interim Check Code	Character	UDC (07 IC)	1	0	Allow NULL?
114	TFICS	Interim Check Status	Character	UDC (07 IC)	1	0	Allow NULL?
115	TFCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
116	TFACO	Available DBA	Character	Generic Edit	1	0	Allow NULL?
117	TFAI	Type - Sales	Character	UDC	1	0	Allow NULL?
118	TFSEC$	Security Indicator	Character	Generic Edit	1	0	Allow NULL?
119	TFOHF	Overtime Code	Character	UDC (07 OH)	1	0	Allow NULL?
120	TFDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
121	TFDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
122	TFDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
123	TFDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
124	TFDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
125	TFDEP6	Deduction Period 6	Character	UDC (05A DD)	1	0	Allow NULL?
126	TFTT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
127	TFTT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
128	TFTT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
129	TFTT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
130	TFTT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
131	TFTT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
132	TFTT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
133	TFTT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
134	TFTT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
135	TFTT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
136	TFTT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
137	TFTT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
138	TFTT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
139	TFTT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
140	TFTT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
141	TFUSR	Payroll Lockout Identification	String	Generic Edit	18	0	Allow NULL?
142	TFEPA	Amount - Entered Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
143	TFBFA	Benefit Factor	Numeric	Generic Edit	11	8	Allow NULL?
144	TFRTWC	Rate - Workers Comp Insurance	Numeric	Generic Edit	9	5	Allow NULL?
145	TFGENR	Rate - Workers Comp Gen Liability	Numeric	Generic Edit	9	3	Allow NULL?
146	TFADV	Advance on Pay	Character	Generic Edit	1	0	Allow NULL?
147	TFSTIP	Batch Timecard Offsite Flag	Character	Generic Edit	1	0	Allow NULL?
148	TFALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
149	TFIIAP	Auto Pay Methods	Character	UDC (07 II)	1	0	Allow NULL?
150	TFFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
151	TFDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
152	TFDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
153	TFYST1	Status- Payroll 01	Character	UDC (07 YS)	1	0	Allow NULL?
154	TFCKCS	Spending Account Claim Number	String	Generic Edit	15	0	Allow NULL?
155	TFALT0	G/L Posting Code - Alternate 0	Character	Generic Edit	1	0	Allow NULL?
156	TFPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
157	TFACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
158	TFABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
159	TFABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
160	TFABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
161	TFABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
162	TFABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
163	TFABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
164	TFABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
165	TFABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
166	TFBLGRT	Rate - Billing Rate	Numeric	Generic Edit	15	3	Allow NULL?
167	TFRCHGAMT	Rate - Recharge Amount	Numeric	Generic Edit	15	2	Allow NULL?
168	TFFBLGRT	Rate - Billing Foreign	Numeric	Generic Edit	15	3	Allow NULL?
169	TFFRCHGAMT	Rate - Recharge Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
170	TFCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
171	TFCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
172	TFCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
173	TFRCHGMODE	Recharge Mode	Character	UDC (05 RM)	1	0	Allow NULL?
174	TFLTTP	Leave Type	String	UDC (07 LV)	2	0	Allow NULL?
175	TFRKID	Leave Request Number	Numeric	Generic Edit	8	0	Allow NULL?
176	TFTELKFLG	Flag - Time Entry Lockout	Character	UDC (07 LK)	1	0	Allow NULL?
177	TFAPPRCFLG	Timecard Offsite Flag	Character	Generic Edit	1	0	Allow NULL?
178	TFOTRULECD	Code - Overtime Rule	String	UDC (07 OR)	3	0	Allow NULL?
179	TFTSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
180	TFUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
181	TFTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
182	TFSCTR	Sick Certificate Required	Character	Generic Edit	1	0	Allow NULL?
183	TFSCRX	Sick Certificate Received	Character	UDC (07 S5)	1	0	Allow NULL?
184	TFSVH	Benefit/Accrual Type	Character	UDC (06 SV)	1	0	Allow NULL?
185	TFTCFD	Timecard From Date	Date	Generic Edit	6	0
186	TFTCTD	Timecard Thru Date	Date	Generic Edit	6	0
187	TFHWPD	Hours Worked Per Day	Numeric	Generic Edit	6	2	Allow NULL?
188	TFINSTID	Instance Identifier	String	Generic Edit	36	0	Allow NULL?
189	TFTCUN	Union Timecard Override	Character	Generic Edit	1	0	Allow NULL?
190	TFTCHC	Home Company Timecard Override	Character	Generic Edit	1	0	Allow NULL?
191	TFTCHB	Home Business Unit Timecard Override	Character	Generic Edit	1	0	Allow NULL?
192	TFTCJT	Job Type Timecard Override	Character	Generic Edit	1	0	Allow NULL?
193	TFTCJS	Job Step Timecard Override	Character	Generic Edit	1	0	Allow NULL?
194	TFTCRT	Hourly Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
195	TFTCSC	Shift Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
196	TFTCSD	Shift Differential Timecard Override	Character	Generic Edit	1	0	Allow NULL?
197	TFTCBR	Billing Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
198	TFTCPC	Piece Rate Timecard Override	Character	Generic Edit	1	0	Allow NULL?
199	TFTCWC	Workers Comp Code Timecard Override	Character	Generic Edit	1	0	Allow NULL?
200	TFTCWS	Workers Comp Sub Class Timecard Override	Character	Generic Edit	1	0	Allow NULL?
201	TFTCJL	Business Unit Chargeout Timecard Overrde	Character	Generic Edit	1	0	Allow NULL?
202	TFTCANI	Account Number Timecard Override	Character	Generic Edit	1	0	Allow NULL?
203	TFTCRFLG	Timecard Reprocess Flag	Character	Generic Edit	1	0	Allow NULL?
204	TFJBLC	Contract Labor Category	String	UDC (06 G)	6	0	Allow NULL?
205	TFCOPX	Component Pay Flag	Character	Generic Edit	1	0	Allow NULL?
206	TFBPTX	Base Pay Transaction Number	Numeric	Generic Edit	9	0	Allow NULL?
207	TFCOPB	Component Pay Basis	Numeric	Generic Edit	15	2	Allow NULL?
208	TFCMED	Component Pay Calculation Method	Character	UDC (05T CM)	1	0	Allow NULL?
209	TFCOPR	Component Pay Amount Or Rate	Numeric	Generic Edit	9	3	Allow NULL?
210	TFGLBN	General Liability Benefit Amount	Numeric	Generic Edit	15	2	Allow NULL?
211	TFWCEX	Workers' Comp Excess Amount	Numeric	Generic Edit	15	2	Allow NULL?
212	TFGLEX	General Liability Excess Amount	Numeric	Generic Edit	15	2	Allow NULL?
213	TFLDID	Labor Distribution Period ID	String	UDC (05T LD)	5	0	Allow NULL?
214	TFLDED	Labor Period Ending Date	Date	Generic Edit	6	0
215	TFTTAP	Total Time Accounting Processing	Character	Generic Edit	1	0	Allow NULL?
216	TFINVA	Invalid Labor Account Number	String	Generic Edit	29	0	Allow NULL?
217	TFINRA	Invalid Recharge Account Number	String	Generic Edit	29	0	Allow NULL?
218	TFINEA	Invalid Equipment Account Number	String	Generic Edit	29	0	Allow NULL?
219	TFCRFL	Timecard Corrections Flag	Character	Generic Edit	1	0	Allow NULL?
220	TFCPTR	Correction Timecard Historical Link	Numeric	Generic Edit	9	0	Allow NULL?
221	TFPCOR	Processed Correction	Character	Generic Edit	1	0	Allow NULL?
222	TFAUSPTWW	State Payroll Tax State Where Worked	String	UDC (06 SC)	3	0	Allow NULL?
223	TFAUBP	Australia Payment Type	Character	UDC (75A BP)	1	0	Allow NULL?

TOP 920 | 18 | F186602 INDEXES

Number

Description

LRSBatchNo TransNo (Primary/Unique)

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

TransNo

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

AddressNo

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

ParentTransactionNo LRSBatch

Element	Alias	Description	Sequence
1	LRSPTN	Parent Transaction Number	Ascending
2	LRSBAT	LRS Batch Number	Ascending

LRSBatch AddrNo ParenTransNo

Element	Alias	Description	Sequence
1	LRSBAT	LRS Batch Number	Ascending
2	AN8	Address Number	Ascending
3	LRSPTN	Parent Transaction Number	Ascending

TransNo LRSBatch AddrNo

Element	Alias	Description	Sequence
1	PRTR	Transaction No. - Payroll	Ascending
2	LRSBAT	LRS Batch Number	Ascending
3	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

223 COLUMNS | 6 INDEXES | 920 | 18 | F186602 TABLE

TOP 920 | 18 | F186602 COLUMNS

TOP 920 | 18 | F186602 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

223 COLUMNS | 6 INDEXES | 920 | 18 | F186602 TABLE

TOP920 | 18 | F186602 COLUMNS

TOP920 | 18 | F186602 INDEXES

TOP 920 | 18 | F186602 COLUMNS

TOP 920 | 18 | F186602 INDEXES