AHRTA130 - Archive_TA_MSTR_Types | Prospr - Dynamics GP Table Reference

AHRTA130 - Archive_TA_MSTR_Types

Select * from AHRTA130

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
TIMECODE_I	Time Code	String	8	View
INACTIVE	Inactive	Boolean	2	View
TIMETYPE_I	Time Type	Integer	2	View
PAYPEROD	Pay Period	Integer	2	View
PRNAVAILTMEPYRL	Print Available Time on Payroll Checks	Boolean	2	View
WRNTIMEFALLSBLWZERO	Warn Time Falls Below Zero	Boolean	2	View
SENIORITY_I	Seniority	String	8	View
SENIORITYDATE_I	Seniority Date	Date	4	View
NEXTACCRUALDATE_I	Next Accrual Date	Date	4	View
NEXTSENIORITYDATE_I	Next Seniority Date	Date	4	View
ACCRUETIMEBENEFITS_I	Accrue Time Benefits	Boolean	2	View
WCID_I	WC ID	String	12	View
TRXCOUNT_I	TRX Count	Integer	2	View
HOURS_I	Hours	Long Integer	4	View
HOURSAVAILABLE_I	Hours Available	Long Integer	4	View
DAYSWRDK	Days Worked	Long Integer	4	View
WKSWRKD	Weeks Worked	Long Integer	4	View
HOURSACCYTD_I	Hours Acc YTD	Long Integer	4	View
HOURSCARRIEDOVER_I	Hours Carried Over	Long Integer	4	View
HOURSPERYEAR_I	Hours Per Year	Long Integer	4	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
NOTESINDEX_I	Notes Index	Currency	10	View