Exchequer Data Information > Exchequer Tables

The Employee table contains details of the employee's which have been defined within the Exchequer Job Costing module.

Relational Links

The employees can be relationally linked to other records using the emCode field. To link employees to their supplier you can use the emSupplier field linking to IdxAcCode in the Supplier file. The emDepartment and emCostCentre fields can be linked to the Department and Cost Centre files linking to the dpCode and ccCode fields respectively.

Key Field: emIdxCode

Field Name	Description	Type	Length
emRecType	J	String	1
emIdxRecSub	JE	String	2
emSubType	E	String	1
emIdxCode	Employee Code	String	10
emCode	Employee Code	String	6
emSurname	Employee Surname	Lstring	21
emIdxSurname	Employee Surname	String	20
emIdxSupplier	Employee Supplier	String	10
emSupplier	Employee Supplier	String	6
emName	Employee Name	Lstring	31
emAddress1	Employee Address Line 1	Lstring	31
emAddress2	Employee Address Line 2	Lstring	31
emAddress3	Employee Address Line 3	Lstring	31
emAddress4	Employee Address Line 4	Lstring	31
emAddress5	Employee Address Line 5	Lstring	31
emPhone	Employee Telephone Number	Lstring	21
emFax	Employee Fax Number	Lstring	21
emMobile	Employee Mobile Number	Lstring	21
emType	Employee Type	Integer	1
emDepartment	Employee Default Department	String	3
emCostCentre	Employee Default Cost Centre	String	3
emPayrollNo	Employee Payroll Number	Lstring	11
em714CertNo	Employee 714 Certificate Number	Lstring	31
em714CertExpiry	Employee 714 Cert Expiry Date	Date	8
emUseOwnRate	Employee - Own Time rates	Logical	1
emUser1	Employee - User 1 Field	Lstring	21
emUser2	Employee - User 2 Field	Lstring	21
emNoteLineCount		Integer	4
emSelfBilling		Logical	1
emGroupCertificate		Integer	1
emCertificateType	Certificate Type	Integer	1
emUser3	Employee - User 3 Field	Lstring	21
emUser4	Employee - User 4 Field	Lstring	21
emNISerialNo	Employee National Insurance No.	Lstring	11
emLabourViaPL	Labour costs via Purchase only	Logical	1
emSpare	Future Use	String	41
emSpare2	Future Use	String	255
emSpare3	Future Use	String	135

Employees