	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

101 COLUMNS | 6 INDEXES | 920 | 07 | F07UI200 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F07UI200	TH	101	6	Timecard History Work File	Work Files	07: Payroll	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 THVER, THJOBN, THUSER, THAN8, THPRTR, THPALF, THRCCD, THCKCN, THAM, THCO, THHMCO, THHMCU, THMCU, THOBJ, THSUB, THRCO, THGMCU, THGOBJ, THGSUB, THSBL, THSBLT, THWR01, THMCUO, THMAIL, THPHRW, THOPSQ, THRILT, THITM, THPCUN, THUM, THPHRT, THPPRT, THBHRT, THPBRT, THBDRT, THSHRT, THSHFT, THSHD, THPAYM, THLD, THGPA, THDPA, THRCPY, THSAMT, THUN, THJBCD, THJBST, THWST, THWCNT, THWCTY, THWCMP, THWET, THGENA, THWCAM, THWCMB, THGENB, THWCMO, THGENO, THWCMX, THGENX, THWCBN, THHMO, THPDBA, THPB, THDEDM, THSALY, THNMTH, THPFRQ, THFY, THDGL, THPN, THDWK, THDW, THPPED, THPPP, THDTBT, THTCDE, THEQCO, THEQWO, THEQCG, THQOBJ, THERC, THEQRT, THEQGR, THEQHR, THEXR, THP001, THP002, THP003, THP004, THCMMT, THCKDT, THUAMT, THRTWC, THGENR, THCKCS, THGICU, THAID, THCMTH, THALT0, THPOS FROM F07UI200

TOP 920 | 07 | F07UI200 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	THVER	Version	String	Generic Edit	10	0	Allow NULL?
2	THJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
3	THUSER	User ID	String	Generic Edit	10	0	Allow NULL?
4	THAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
5	THPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
6	THPALF	Name - Alpha Sort	String	Generic Edit	12	0	Allow NULL?
7	THRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
8	THCKCN	Check Control Number	Numeric	Generic Edit	8	0	Allow NULL?
9	THAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
10	THCO	Company	String	Generic Edit	5	0	Allow NULL?
11	THHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
12	THHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
13	THMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
14	THOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
15	THSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
16	THRCO	Company _ Recharge	String	Generic Edit	5	0	Allow NULL?
17	THGMCU	Business Unit - Recharge	String	Generic Edit	12	0	Allow NULL?
18	THGOBJ	Object Account - Recharge	String	Generic Edit	6	0	Allow NULL?
19	THGSUB	Subsidiary - Recharge	String	Generic Edit	8	0	Allow NULL?
20	THSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
21	THSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
22	THWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
23	THMCUO	Business Unit - Chargeout	String	Generic Edit	12	0	Allow NULL?
24	THMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
25	THPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
26	THOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
27	THRILT	Labor Type - Routing Instructions	Character	UDC (06 AT)	1	0	Allow NULL?
28	THITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
29	THPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
30	THUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
31	THPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
32	THPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
33	THBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
34	THPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
35	THBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
36	THSHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
37	THSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
38	THSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
39	THPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
40	THLD	Percent or Amount	Character	UDC (07 LD)	1	0	Allow NULL?
41	THGPA	Amount - Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
42	THDPA	Amount - Distributed Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
43	THRCPY	Recharge Amount	Numeric	Generic Edit	9	2	Allow NULL?
44	THSAMT	Amount - Sales Generated	Numeric	Generic Edit	11	2	Allow NULL?
45	THUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
46	THJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
47	THJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
48	THWST	Work State	Numeric	Generic Edit	2	0	Allow NULL?
49	THWCNT	Work County	Numeric	Generic Edit	3	0	Allow NULL?
50	THWCTY	Work City	Numeric	Generic Edit	4	0	Allow NULL?
51	THWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
52	THWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
53	THGENA	General Liability Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
54	THWCAM	Workers Comp Premium Amount	Numeric	Generic Edit	9	2	Allow NULL?
55	THWCMB	Workers Comp Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
56	THGENB	General Liability Premium Base	Numeric	Generic Edit	9	2	Allow NULL?
57	THWCMO	Workers Comp Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
58	THGENO	General Liability Overtime Amount	Numeric	Generic Edit	9	2	Allow NULL?
59	THWCMX	Workers Comp Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
60	THGENX	General Liability Excludable Amount	Numeric	Generic Edit	9	2	Allow NULL?
61	THWCBN	Workers' Compensation Benefit Amount	Numeric	Generic Edit	9	2	Allow NULL?
62	THHMO	Month - Update of History	Numeric	Generic Edit	2	0	Allow NULL?
63	THPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
64	THPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
65	THDEDM	Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
66	THSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
67	THNMTH	Effect on GL	Character	UDC	1	0	Allow NULL?
68	THPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
69	THFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
70	THDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
71	THPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
72	THDWK	Date - Worked	Date	Generic Edit	6	0
73	THDW	Day of the Week	Character	UDC (06 DW)	1	0	Allow NULL?
74	THPPED	Date - Pay Period Ending	Date	Generic Edit	6	0
75	THPPP	Pay Period of the Month	Character	UDC (07 MP)	1	0	Allow NULL?
76	THDTBT	Date - Time Clock Start Date and Time	Numeric	Generic Edit	13	0	Allow NULL?
77	THTCDE	Date Time Clock End	Numeric	Generic Edit	13	0	Allow NULL?
78	THEQCO	Company - Equipment	String	Generic Edit	5	0	Allow NULL?
79	THEQWO	Equipment Worked On	String	Generic Edit	9	0	Allow NULL?
80	THEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
81	THQOBJ	Equipment Object Account	String	Generic Edit	6	0	Allow NULL?
82	THERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
83	THEQRT	Billing Rate - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
84	THEQGR	Amount _ Equipment Gross	Numeric	Generic Edit	9	2	Allow NULL?
85	THEQHR	Hours - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
86	THEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
87	THP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
88	THP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
89	THP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
90	THP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
91	THCMMT	Check Comment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
92	THCKDT	Date - Pay Check	Date	Generic Edit	6	0
93	THUAMT	Amount - Uprate	Numeric	Generic Edit	9	3	Allow NULL?
94	THRTWC	Rate - Workers Comp Insurance	Numeric	Generic Edit	9	5	Allow NULL?
95	THGENR	Rate - Workers Comp Gen Liability	Numeric	Generic Edit	9	3	Allow NULL?
96	THCKCS	Spending Account Claim Number	String	Generic Edit	15	0	Allow NULL?
97	THGICU	General Ledger Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
98	THAID	Account ID	String	Generic Edit	8	0	Allow NULL?
99	THCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
100	THALT0	G/L Posting Code - Alternate 0	Character	Generic Edit	1	0	Allow NULL?
101	THPOS	Position ID	String	Generic Edit	8	0	Allow NULL?

TOP 920 | 07 | F07UI200 INDEXES

Number

Description

VER JOBN USER AN8 PRTR DWK (Primary/Unique)

Element	Alias	Description	Sequence
1	VER	Version	Ascending
2	JOBN	Work Station ID	Ascending
3	USER	User ID	Ascending
4	AN8	Address Number	Ascending
5	PRTR	Transaction No. - Payroll	Ascending
6	DWK	Date - Worked	Ascending

BusinessUnit+A1

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	PPED	Date - Pay Period Ending	Ascending
3	PALF	Name - Alpha Sort	Ascending
4	AN8	Address Number	Ascending
5	JBCD	Job Type (Craft) Code	Ascending
6	JBST	Job Step	Ascending

BusinessUnit+A2

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	UN	Union Code	Ascending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Ascending

BusinessUnit+A3

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	WET	Sub Class - Workers Comp	Ascending
3	WCMP	Worker's Comp. Insurance Code	Ascending
4	PALF	Name - Alpha Sort	Ascending
5	AN8	Address Number	Ascending

BusinessUnit+A4

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	WET	Sub Class - Workers Comp	Ascending
3	PALF	Name - Alpha Sort	Ascending
4	AN8	Address Number	Ascending

BusinessUnit+A5

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	WET	Sub Class - Workers Comp	Ascending
3	WCMP	Worker's Comp. Insurance Code	Ascending
4	PALF	Name - Alpha Sort	Ascending
5	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

101 COLUMNS | 6 INDEXES | 920 | 07 | F07UI200 TABLE

TOP 920 | 07 | F07UI200 COLUMNS

TOP 920 | 07 | F07UI200 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

101 COLUMNS | 6 INDEXES | 920 | 07 | F07UI200 TABLE

TOP920 | 07 | F07UI200 COLUMNS

TOP920 | 07 | F07UI200 INDEXES

TOP 920 | 07 | F07UI200 COLUMNS

TOP 920 | 07 | F07UI200 INDEXES