	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	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

23 COLUMNS | 5 INDEXES | 812 | 08 | F08710 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08: Human Resources
1	812	F08710	ES	23	5	Employee Setup Master	Master Files	08: Human Resources	No

TOP 812 | 08 | F08710 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	ESESID	Employee Setup ID	Numeric	Generic Edit	8	Allow NULL?
2	ESAN8	Address Number	Numeric	UDC	8	Allow NULL?
3	ESSUSTS	Employee Setup Status	String	UDC (08 S1)	2	Allow NULL?
4	ESARVDT	Arrival Date	Date	Generic Edit	6
5	ESCRTN	Date Created	Date	Generic Edit	6
6	ESSUAC	Employee Setup Action	Character	UDC (08 S3)	1	Allow NULL?
7	ESOFC	OfficeNumber	String	Generic Edit	20	Allow NULL?
8	ESL001	Location Code 001	String	UDC (08 L1)	10	Allow NULL?
9	ESL002	Location Code 002	String	UDC (08 L2)	10	Allow NULL?
10	ESL003	Location Code 003	String	UDC (08 L3)	10	Allow NULL?
11	ESL004	Location Code 004	String	UDC (08 L4)	10	Allow NULL?
12	ESL005	Location Code 005	String	UDC (08 L5)	10	Allow NULL?
13	ESL006	Location Code 006	String	UDC (08 L6)	10	Allow NULL?
14	ESL007	Location Code 007	String	UDC (08 L7)	10	Allow NULL?
15	ESL008	Location Code 008	String	UDC (08 L8)	10	Allow NULL?
16	ESL009	Location Code 009	String	UDC (08 L9)	10	Allow NULL?
17	ESL010	Location Code 010	String	UDC (08 L0)	10	Allow NULL?
18	ESUPMJ	Date - Updated	Date	Generic Edit	6
19	ESUSER	User ID	String	Generic Edit	10	Allow NULL?
20	ESJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
21	ESPID	Program ID	String	Generic Edit	10	Allow NULL?
22	ESAPRV	Address Number - Approved by	Numeric	Generic Edit	8	Allow NULL?
23	ESANPA	Supervisor	Numeric	Generic Edit	8	Allow NULL?

Number

Description

SetupID (Primary/Unique)

Element	Alias	Description	Sequence
1	ESID	Employee Setup ID	Ascending

AddressNumber

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

Status

Element	Alias	Description	Sequence
1	SUSTS	Employee Setup Status	Ascending

Approved By

Element	Alias	Description	Sequence
1	APRV	Address Number - Approved by	Ascending

Supervisor

Element	Alias	Description	Sequence
1	ANPA	Supervisor	Ascending