	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

48 COLUMNS | 6 INDEXES | 812 | 08H | F08601 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08H: Health and Safety
1	812	F08601	HL	48	6	Injury/Illness Case Master	Master Files	08H: Health and Safety	AS400 Coexistence Tables

TOP 812 | 08H | F08601 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	HLCASE	Number - Case/File	Numeric	Generic Edit	8	Allow NULL?
2	HLCSTS	Status - Case	String	UDC (08 CS)	2	Allow NULL?
3	HLOSH	Yes or No - OSHA	Character	UDC (05 YN)	1	Allow NULL?
4	HLAN8	Address Number	Numeric	UDC	8	Allow NULL?
5	HLJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	Allow NULL?
6	HLJBST	Job Step	String	UDC (06 GS)	4	Allow NULL?
7	HLWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	Allow NULL?
8	HLWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	Allow NULL?
9	HLHMCO	Company - Home	String	Generic Edit	5	Allow NULL?
10	HLHMCU	Business Unit - Home	String	Generic Edit	12	Allow NULL?
11	HLANPA	Supervisor	Numeric	Generic Edit	8	Allow NULL?
12	HLXAN8	Address Number - Foreman	Numeric	Generic Edit	8	Allow NULL?
13	HLDIJ	Date - of Injury	Date	Generic Edit	6
14	HLTMAC	Time of Accident	Numeric	Generic Edit	6	Allow NULL?
15	HLWKD	Day of Week	Character	UDC (08 WD)	1	Allow NULL?
16	HLDRP	Date - Injury Reported	Date	Generic Edit	6
17	HLDCLO	Date - Case Closed	Date	Generic Edit	6
18	HLDSIJ	Description - Injury or Illness	String	Generic Edit	40	Allow NULL?
19	HLIR	Injury/Illness Related (IN/IL)	String	UDC (08H IR)	2	Allow NULL?
20	HLRSWA	Restricted Work Activity Y/N	Character	Generic Edit	1	Allow NULL?
21	HLDYSA	Days Away from Work Y/N	Character	Generic Edit	1	Allow NULL?
22	HLNDWA	Number - Days Restricted	Numeric	Generic Edit	5	Allow NULL?
23	HLNDAW	Number - Days Away from Work	Numeric	Generic Edit	5	Allow NULL?
24	HLDDEC	Date - Deceased	Date	Generic Edit	6
25	HLDRT	Date - Returned to Work	Date	Generic Edit	6
26	HLESTB	Number - Establishment of Business Activ	Numeric	Generic Edit	8	Allow NULL?
27	HLCSFX	Suffix - Case Entry Number	Numeric	Generic Edit	3	Allow NULL?
28	HLHH01	Safety Group	String	UDC (08 H1)	3	Allow NULL?
29	HLHH02	Occurrence Location	String	UDC (08 H2)	3	Allow NULL?
30	HLHH03	Occurrence Type	String	UDC (08 H3)	3	Allow NULL?
31	HLHH04	Part of Body	String	UDC (08 H4)	3	Allow NULL?
32	HLHH05	Occupational Illness/Injury	String	UDC (08 H5)	3	Allow NULL?
33	HLHH06	Health & Safety Category Codes 06	String	UDC (08 H6)	3	Allow NULL?
34	HLHH07	Health & Safety Category Codes 07	String	UDC (08 H7)	3	Allow NULL?
35	HLHH08	Health & Safety Category Codes 08	String	UDC (08 H8)	3	Allow NULL?
36	HLHH09	Health & Safety Category Codes 09	String	UDC (08 H9)	3	Allow NULL?
37	HLHH10	Health & Safety Category Codes 10	String	UDC (08 H0)	3	Allow NULL?
38	HLHH11	Health & Safety Category Codes 11	String	UDC (08 HA)	3	Allow NULL?
39	HLHH12	Health & Safety Category Codes 12	String	UDC (08 HB)	3	Allow NULL?
40	HLHH13	Health & Safety Category Codes 13	String	UDC (08 HC)	3	Allow NULL?
41	HLHH14	Health & Safety Category Codes 14	String	UDC (08 HD)	3	Allow NULL?
42	HLHH15	Health & Safety Category Codes 15	String	UDC (08 HE)	3	Allow NULL?
43	HLCTR	Country	String	UDC (00 CN)	3	Allow NULL?
44	HLONPRM	Incident Occured on Employer's Premises	Character	UDC (00 ZO)	1	Allow NULL?
45	HLUSER	User ID	String	Generic Edit	10	Allow NULL?
46	HLPID	Program ID	String	Generic Edit	10	Allow NULL?
47	HLUPMJ	Date - Updated	Date	Generic Edit	6
48	HLJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?

TOP 812 | 08H | F08601 INDEXES

Number

Description

Case Number (Primary/Unique)

Element	Alias	Description	Sequence
1	CASE	Number - Case/File	Ascending

Address Number Date Of Injury

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DIJ	Date - of Injury	Descending

Date Of Injury Time Accident

Element	Alias	Description	Sequence
1	DIJ	Date - of Injury	Descending
2	TMAC	Time of Accident	Ascending

Establisment Case Number

Element	Alias	Description	Sequence
1	ESTB	Number - Establishment of Business Activ	Ascending
2	CASE	Number - Case/File	Ascending

Home Cost Center Case Number

Element	Alias	Description	Sequence
1	HMCU	Business Unit - Home	Ascending
2	CASE	Number - Case/File	Ascending

Osha Date Of Injury Est.

Element	Alias	Description	Sequence
1	OSH	Yes or No - OSHA	Ascending
2	DIJ	Date - of Injury	Ascending
3	ESTB	Number - Establishment of Business Activ	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

48 COLUMNS | 6 INDEXES | 812 | 08H | F08601 TABLE

TOP 812 | 08H | F08601 COLUMNS

TOP 812 | 08H | F08601 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

48 COLUMNS | 6 INDEXES | 812 | 08H | F08601 TABLE

TOP812 | 08H | F08601 COLUMNS

TOP812 | 08H | F08601 INDEXES

TOP 812 | 08H | F08601 COLUMNS

TOP 812 | 08H | F08601 INDEXES