AHRTA330 - Archive_TA_TRX_Detail | Prospr - Dynamics GP Table Reference

AHRTA330 - Archive_TA_TRX_Detail

Query Builder

Select * from AHRTA330

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TRX_I	TRX	Long Integer	4	View
GBTATYPE	GB TA Transaction Type	Integer	2	View
EMPID_I	Emp ID	String	16	View
JOBTITLE	Job Title	String	8	View
DEPRTMNT	Department	String	8	View
DIVISIONCODE_I	Division Code	String	8	View
TIMECODE_I	Time Code	String	8	View
TRXDATE	TRX Date	Date	4	View
TRXENDDT	TRX Ending Date	Date	4	View
TRXERROR_I	TRX Error	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
ACCFLG	Accrual Flag	Boolean	2	View
ACCRUETIMEBENEFITS_I	Accrue Time Benefits	Boolean	2	View
POSTED	Posted	Boolean	2	View
ATTTYP	Attendance Type	String	32	View
ATTRSN	Attendance Reason	String	32	View
ATTTRXSTATUS	Attendance TRX Status	Integer	2	View
BACHNUMB	Batch Number	String	16	View
COMPTRNM	Computer TRX Number	Long Integer	4	View
CMRECNUM	Record Number	Currency	10	View
PAYRCORD	Pay Record	String	8	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
CHANGETIME_I	Change Time	Time	4	View
NOTESINDEX_I	Notes Index	Currency	10	View