	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

26 COLUMNS | 4 INDEXES | 920 | 05 | F054111W TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	920	F054111W	EC	26	4	Employee Emergency Contact Work Table	Files	05: Time Accounting and HRM Base

TOP 920 | 05 | F054111W COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	ECAN8	Address Number	Numeric	Generic Edit	8	Allow NULL?
2	ECIDLN	Who's Who Line Number - ID	Numeric	Generic Edit	5	Allow NULL?
3	ECSLNM	Salutation Name	String	Generic Edit	40	Allow NULL?
4	ECMLNM	Name - Mailing	String	Generic Edit	40	Allow NULL?
5	ECGNNM	Name - Given	String	Generic Edit	25	Allow NULL?
6	ECIMN	Initial - Middle Name (Govt Rpts)	Character	Generic Edit	1	Allow NULL?
7	ECSRNM	Name - Surname	String	Generic Edit	25	Allow NULL?
8	ECADD1	Address Line 1	String	Generic Edit	40	Allow NULL?
9	ECCTY1	City	String	Generic Edit	25	Allow NULL?
10	ECADDS	State	String	UDC (00 S)	3	Allow NULL?
11	ECADDZ	Postal Code	String	Generic Edit	12	Allow NULL?
12	ECCTR	Country	String	UDC (00 CN)	3	Allow NULL?
13	ECTYC	Type Code	Character	UDC (01 W0)	1	Allow NULL?
14	ECATTL	Professional Title	String	Generic Edit	40	Allow NULL?
15	ECDSS5	Display Sequence- 5.2	Numeric	Generic Edit	5	Allow NULL?
16	ECREM1	Remark 1	String	Generic Edit	40	Allow NULL?
17	ECACFL	Action Flag	Character	UDC (08 AC)	1	Allow NULL?
18	ECUSER	User ID	String	Generic Edit	10	Allow NULL?
19	ECPID	Program ID	String	Generic Edit	10	Allow NULL?
20	ECJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
21	ECUPMJ	Date - Updated	Date	Generic Edit	6
22	ECUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
23	ECESIGN	E-Signature ID	String	Generic Edit	16	Allow NULL?
24	ECMUMJ	Update Date	Date	Generic Edit	6
25	ECMUMT	Update Time	Numeric	Generic Edit	6	Allow NULL?
26	ECUPID	Updated By	String	Generic Edit	10	Allow NULL?

Number

Description

Employee Number Line Id (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	IDLN	Who's Who Line Number - ID	Ascending

Employee Number Line ID(Desc)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	IDLN	Who's Who Line Number - ID	Descending

Employee Number Action Flag

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ACFL	Action Flag	Ascending

Employee Number E-Signature

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ESIGN	E-Signature ID	Ascending