	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

129 COLUMNS | 26 INDEXES | 812 | 05 | F0618 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	812	F0618	YT	129	26	Employee Transaction History	History Files	05: Time Accounting and HRM Base	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 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, YTRTWC, YTGENR, YTCKCS, YTGICU, YTAID, YTCMTH, YTALT0, YTPOS, YTACTB, YTABR1, YTABT1, YTABR2, YTABT2, YTABR3, YTABT3, YTABR4, YTABT4, YTBLGRT, YTRCHGAMT, YTFBLGRT, YTFRCHGAMT, YTCRR, YTCRCD, YTCRDC, YTRCHGMODE, YTLTTP, YTRKID, YTAPPRCFLG, YTOTRULECD, YTTSKID, YTTAXX, YTSCTR, YTSCRX, YTSVH, YTTCFD, YTTCTD, YTHWPD, YTINSTID FROM F0618

TOP 812 | 05 | F0618 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YTAN8	Address Number	Numeric	UDC	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	YTRTWC	Rate - Workers Comp Insurance	Numeric	Generic Edit	9	5	Allow NULL?
93	YTGENR	Rate - Workers Comp Gen Liability	Numeric	Generic Edit	9	3	Allow NULL?
94	YTCKCS	Spending Account Claim Number	String	Generic Edit	15	0	Allow NULL?
95	YTGICU	General Ledger Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
96	YTAID	Account ID	String	Generic Edit	8	0	Allow NULL?
97	YTCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
98	YTALT0	G/L Posting Code - Alternate 0	Character	Generic Edit	1	0	Allow NULL?
99	YTPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
100	YTACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
101	YTABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
102	YTABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
103	YTABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
104	YTABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
105	YTABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
106	YTABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
107	YTABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
108	YTABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
109	YTBLGRT	Rate - Billing Rate	Numeric	Generic Edit	15	3	Allow NULL?
110	YTRCHGAMT	Rate - Recharge Amount	Numeric	Generic Edit	15	2	Allow NULL?
111	YTFBLGRT	Rate - Billing Foreign	Numeric	Generic Edit	15	3	Allow NULL?
112	YTFRCHGAMT	Rate - Recharge Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
113	YTCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
114	YTCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
115	YTCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
116	YTRCHGMODE	Recharge Mode	Character	UDC (05 RM)	1	0	Allow NULL?
117	YTLTTP	Leave Type	String	UDC (07 LV)	2	0	Allow NULL?
118	YTRKID	Leave Request Number	Numeric	Generic Edit	8	0	Allow NULL?
119	YTAPPRCFLG	Flag - A/P Processed	Character	Generic Edit	1	0	Allow NULL?
120	YTOTRULECD	Code - Overtime Rule	String	UDC (07 OR)	3	0	Allow NULL?
121	YTTSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
122	YTTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
123	YTSCTR	Sick Certificate Required	Character	Generic Edit	1	0	Allow NULL?
124	YTSCRX	Sick Certificate Received	Character	UDC (07 S5)	1	0	Allow NULL?
125	YTSVH	Benefit/Accrual Type	Character	UDC (06 SV)	1	0	Allow NULL?
126	YTTCFD	Timecard From Date	Date	Generic Edit	6	0
127	YTTCTD	Timecard Thru Date	Date	Generic Edit	6	0
128	YTHWPD	Hours Worked Per Day	Numeric	Generic Edit	6	2	Allow NULL?
129	YTINSTID	Instance Identifier	String	Generic Edit	36	0	Allow NULL?

TOP 812 | 05 | F0618 INDEXES

Number

Description

Address Number Date Worked (Primary/Unique)

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

Address Number Check Ctrl +A

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

Business Unit Date Work +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	DWK	Date - Worked	Ascending
3	AN8	Address Number	Ascending
4	JBCD	Job Type (Craft) Code	Ascending

Recharge BU Date Worked

Element	Alias	Description	Sequence
1	GMCU	Business Unit - Recharge	Ascending
2	DWK	Date - Worked	Ascending

Address Number PDBA +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PDBA	DBA Code	Ascending
3	HMO	Month - Update of History	Ascending
4	CKDT	Date - Pay Check	Ascending

Business Unit PDBA +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	DWK	Date - Worked	Ascending
4	PDBA	DBA Code	Ascending

Business Unit Subsiduary +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	SUB	Subsidiary	Ascending
3	AN8	Address Number	Ascending
4	DWK	Date - Worked	Ascending

Chargeout BU Job Type +A

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

Address Number Pay Period +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PPED	Date - Pay Period Ending	Ascending
3	UN	Union Code	Ascending
4	PDBA	DBA Code	Ascending

Chargeour BU Pay Per End +A

Element	Alias	Description	Sequence
1	MCUO	Business Unit - Chargeout	Ascending
2	PPED	Date - Pay Period Ending	Ascending
3	PALF	Name - Alpha Sort	Ascending
4	AN8	Address Number	Ascending

Business Unit Pay Per End

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	PPED	Date - Pay Period Ending	Ascending

Union Pay Period End +A

Element	Alias	Description	Sequence
1	UN	Union Code	Ascending
2	PPED	Date - Pay Period Ending	Ascending
3	AN8	Address Number	Ascending

Address Number Check Cont +A

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

Business Unit Object +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

Transaction Number

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

Address Number Check Date

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKDT	Date - Pay Check	Ascending

Recharge BU Recharge Obj +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

Business Unit Object +B

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

Business Unit Equip OBj +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 Subledger Type +A

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

Recharge Bsness unit Equip +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

Address Number Check Cont +B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKCN	Check Control Number	Ascending
3	PDBA	DBA Code	Ascending
4	PRTR	Transaction No. - Payroll	Ascending

Address Num Assingment 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

Overtime Rule Address Num

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

Leave Type

Element	Alias	Description	Sequence
1	LTTP	Leave Type	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

129 COLUMNS | 26 INDEXES | 812 | 05 | F0618 TABLE

TOP 812 | 05 | F0618 COLUMNS

TOP 812 | 05 | F0618 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

129 COLUMNS | 26 INDEXES | 812 | 05 | F0618 TABLE

TOP812 | 05 | F0618 COLUMNS

TOP812 | 05 | F0618 INDEXES

TOP 812 | 05 | F0618 COLUMNS

TOP 812 | 05 | F0618 INDEXES