SF010200 - Data Collection Transaction Log | Prospr - Dynamics GP Table Reference

SF010200 - Data Collection Transaction Log

Query Builder

Select * from SF010200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DATAENTRYTYPE_I	Data Entry Type	Integer	2	View
EMPLOYID	Employee ID	String	16	View
LABORCODE_I	Labor Code	String	12	View
MANUFACTUREORDER_I	Manufacture Order	String	32	View
RTSEQNUM_I	rtseqnum	String	12	View
ACTUALSTARTDATE_I	ActualStartDate	Date	4	View
ACTUALSTARTTIME_I	ActualStartTime	Time	4	View
DATE1	Date	Date	4	View
TIME1	Time	Time	4	View
ACTUALFINISHDATE_I	ActualFinishDate	Date	4	View
ACTUALFINISHTIME_I	ActualFinishTime	Time	4	View
ELAPSEDTIME_I	Elapsed Time	Currency	10	View
ITEMNMBR	Item Number	String	32	View
PIECES_I	Pieces	Currency	10	View
REJECTS_I	Rejects	Currency	10	View
PAYRCORD	Pay Record	String	8	View
LABCODEPAYCODESEL_I	Labor Code PayCode Select	Integer	2	View
COMPTRNM	Computer TRX Number	Long Integer	4	View
UPRBCHOR	UPR Batch Origin	Integer	2	View
BACHNUMB	Batch Number	String	16	View
SUCPAYROLLTRX_I	SuccessfulPayrollTrx	Boolean	2	View
TRANSACTIONRESULT_I	Transaction Result	Integer	2	View
COMMENTS1000_I	Comments1000	Text	2	View