SF010501 - Automated Data Collection Records | Prospr

SF010501 - Automated Data Collection Records

Select * from SF010501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DATAENTRYTYPEADC_I	Data Entry Type ADC	Integer	2	View
MANUFACTUREORDER_I	Manufacture Order	String	32	View
RTSEQNUM_I	rtseqnum	String	12	View
DONECB_I	done_cb	Boolean	2	View
EMPLOYID	Employee ID	String	16	View
MACHINEID_I	Machine ID IC	String	12	View
ITEMNMBR	Item Number	String	32	View
ADCDATE_I	ADCDate	Date	4	View
ADCTIME_I	ADCTime	Time	4	View
TRXTYPE	Transaction Type	Integer	2	View
LABORCODE_I	Labor Code	String	12	View
PAYRCORD	Pay Record	String	8	View
PAYTYPE	Pay Type 1. Hourly 2. Salary 3. Piecework 4. Commission 5. Business Expense 6. Overtime 7. Double Time 8. Vacation 9. Sick 10. Holiday 11. Pension 12. Other 13. Earned Income Credit 14. Charged Tips 15. Reported Tips 16. Minimum Wage Balance	Integer	2	View
LABCODEPAYCODESEL_I	Labor Code PayCode Select	Integer	2	View
SETUPCB_I	Setup CB	Boolean	2	View
NUMBERSCRAPPED_I	Number Scrapped	Currency	10	View
PIECES_I	Pieces	Currency	10	View
REJECTS_I	Rejects	Currency	10	View
ADCDEVICEID_I	ADC Device ID	String	16	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
CHANGETIME_I	Change Time	Time	4	View
ADCSTATUS_I	ADCStatus	Integer	2	View
Job_Number	IC Job Number	String	32	View