APR10100 - APR Transaction Import WORK | Prospr - Dynamics GP Table Reference

APR10100 - APR Transaction Import WORK

Query Builder

Select * from APR10100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
COMPTRNM	Computer TRX Number	Long Integer	4	View
BACHNUMB	Batch Number	String	16	View
EMPLOYID	Employee ID	String	16	View
COMPTRTP	Computer TRX Type	Integer	2	View
UPRTRXCD	UPR TRX Code	String	8	View
TRXBEGDT	TRX Beginning Date	Date	4	View
TRXENDDT	TRX Ending Date	Date	4	View
TRXHRUNT	TRX Hours/Units	Long Integer	4	View
DAYSWRDK	Days Worked	Long Integer	4	View
WKSWRKD	Weeks Worked	Long Integer	4	View
INTERID	Intercompany ID	String	6	View
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
LOCATNID	Location ID	String	16	View
SHFTCODE	Shift Code	String	8	View
STATECD	State Code	String	4	View
SUTASTAT	Suta State	String	4	View
PAYRTAMT	Pay Rate Amount	Currency	10	View
APR_Import_Group	APR Import Group	String	16	View