SF010502 - Automated Data Collection Matched Records | Prospr

SF010502 - Automated Data Collection Matched Records

Query Builder

Select * from SF010502

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
DATAENTRYTYPEADC_I	Data Entry Type ADC	Integer	2	View
MANUFACTUREORDER_I	Manufacture Order	String	32	View
ITEMNMBR	Item Number	String	32	View
ROUTINGNAME_I	RoutingName	String	32	View
RTSEQNUM_I	rtseqnum	String	12	View
DONECB_I	done_cb	Boolean	2	View
LABORCODE_I	Labor Code	String	12	View
ACTUALSTARTDATE_I	ActualStartDate	Date	4	View
ACTUALSTARTTIME_I	ActualStartTime	Time	4	View
ACTUALFINISHDATE_I	ActualFinishDate	Date	4	View
ACTUALFINISHTIME_I	ActualFinishTime	Time	4	View
IDDSCRPT	ID Description	String	32	View
LABCODEDESC_I	Labor Code Description	String	32	View
LABCODEPAYCODESEL_I	Labor Code PayCode Select	Integer	2	View
ELAPSEDTIME_I	Elapsed Time	Currency	10	View
NUMBERSCRAPPED_I	Number Scrapped	Currency	10	View
PIECES_I	Pieces	Currency	10	View
REJECTS_I	Rejects	Currency	10	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
SEQUENCECOST_I	Sequence Cost	Currency	10	View
SETUPCB_I	Setup CB	Boolean	2	View
CB_I	CB	Boolean	2	View
POSTABLE_I	Postable	Boolean	2	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
PAYUNITRATE_I	Pay Unit Rate	Currency	10	View
PIECECOST_I	Piece Cost	Currency	10	View
OPERATINGCOST_I	Operating Cost	Currency	10	View
FIXOVERMARK_I	Fixed Overhead Markup	Currency	10	View
HOURPIECE1_I	Hour Piece1	Integer	2	View
VAROVERHDMARK_I	Variable Overhead Markup	Currency	10	View
HOURPIECE2_I	Hour Piece2	Integer	2	View
DATACOLLECTERR_I	Data Collection Error	Long Integer	4	View
BACHNUMB	Batch Number	String	16	View
COMPTRNM	Computer TRX Number	Long Integer	4	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
Fixed_Overhead_Amount	Fixed Overhead Amount	Currency	10	View
Variable_Overhead_Amount	Variable Overhead Amount	Currency	10	View
Acct_Array_1	Acct Array[1]	Long Integer	4	View
Acct_Array_2	Acct Array[2]	Long Integer	4	View
Acct_Array_3	Acct Array[3]	Long Integer	4	View
Acct_Array_4	Acct Array[4]	Long Integer	4	View
Acct_Array_5	Acct Array[5]	Long Integer	4	View
Acct_Array_6	Acct Array[6]	Long Integer	4	View
Cost_Array_1	Cost Array[1]	Currency	10	View
Cost_Array_2	Cost Array[2]	Currency	10	View
Cost_Array_3	Cost Array[3]	Currency	10	View
Cost_Array_4	Cost Array[4]	Currency	10	View
Cost_Array_5	Cost Array[5]	Currency	10	View
Cost_Array_6	Cost Array[6]	Currency	10	View
Job_Number	IC Job Number	String	32	View
SEQ_I	Seq	Long Integer	4	View

SF010502 - Automated Data Collection Matched Records

Query Builder

Customer Service

Information

My Account

Contact Us