SVCSOCOV - SVC_Contract_Service_Inquiry | Prospr - Dynamics GP Table Reference

SVCSOCOV - SVC_Contract_Service_Inquiry

Query Builder

Select * from SVCSOCOV

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CONSTS	Contract Record Type	Integer	2	View
CONTNBR	Contract Number	String	12	View
ITEMNMBR	Item Number	String	32	View
SERLNMBR	Serial Number	String	22	View
SRVRECTYPE	Service Record Type	Integer	2	View
CALLNBR	Service Call Number	String	12	View
SRVTYPE	Service Type	String	12	View
SVCDESCR	Service Description	String	62	View
ADRSCODE	Address Code	String	16	View
OFFID	Office ID	String	12	View
SVCAREA	Service Area	String	12	View
TECHID	Tech ID	String	12	View
ENTDTE	Entry Date	Date	4	View
ENTTME	Entry Time	Time	4	View
DISPDTE	Dispatch Date	Date	4	View
DISPTME	Dispatch Time	Time	4	View
ETADTE	ETA Date	Date	4	View
ETATME	ETA Time	Time	4	View
ARRIVDTE	Arrival Date	Date	4	View
ARRIVTME	Arrival Time	Time	4	View
COMPDTE	Complete Date	Date	4	View
COMPTME	Complete Time	Time	4	View
LABSTOTPRC	Labor Sub Total Price	Currency	10	View
LABPCT	Labor Pct	Currency	10	View
LABSTOTCST	Labor Sub Total Cost	Currency	10	View
PARSTOTPRC	Part Sub Total Price	Currency	10	View
PARTPCT	Part Pct	Currency	10	View
PARSTOTCST	Part Sub Total Cost	Currency	10	View
MSCSTOTPRC	Misc Sub Total Price	Currency	10	View
MISCPCT	Misc Pct	Currency	10	View
MISSTOTCST	Misc Sub Total Cost	Currency	10	View
PRETAXTOT	PreTax Total	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
TOTAL	Total	Currency	10	View
Invoiced_Amount	Invoiced Amount	Currency	10	View