AHPSLH01 - Archive_HRP_Salary_History | Prospr - Dynamics GP Table Reference

AHPSLH01 - Archive_HRP_Salary_History

Query Builder

Select * from AHPSLH01

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
PAYRCORD	Pay Record	String	8	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
PAYRTAMT	Pay Rate Amount	Currency	10	View
PAYUNIT	Pay Unit	String	26	View
PAYUNPER	Pay Unit Period	Integer	2	View
PAYPEROD	Pay Period	Integer	2	View
PAYPRPRD	Pay Per Period	Currency	10	View
ANNUALSALARY_I	Annual Salary	Currency	10	View
CHANGEREASON_I	Change Reason	String	32	View
USERID	User ID	String	16	View
CHANGEDATE_I	Change Date	Date	4	View