SVC06300 - Depot Schedule | Prospr - Dynamics GP Table Reference

SVC06300 - Depot Schedule

Query Builder

Select * from SVC06300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
STATIONID	Depot Station ID	String	12	View
SEQUENCE1	Sequence	Currency	10	View
Queue_Status	Queue_Status	String	4	View
WORECTYPE	Work Order Record Type	Integer	2	View
WORKORDNUM	Work Order Number	String	12	View
Route_Sequence	Route_Sequence	Currency	10	View
SVC_Depot_Priority	SVC_Depot_Priority	Currency	10	View
Status	Status	Integer	2	View
TECHID	Tech ID	String	12	View
ETTR	ETTR	Currency	10	View
ETADTE	ETA Date	Date	4	View
ETATME	ETA Time	Time	4	View
ECOMPDT	EComp Date	Date	4	View
EComp_Time	EComp Time	Time	4	View
ACTSTRTDTE	Actual Strt Date	Date	4	View
ACTSTRTTME	Actual Start Time	Time	4	View
LSTSTAID	Last Station ID	String	12	View
Last_Sequence	Last Sequence	Currency	10	View
NXTSTATID	Next Station ID	String	12	View
NXTSEQ	Next Sequence	Currency	10	View