SVC0202V - SVC_Service_MSTR_Equipment_View | Prospr

SVC0202V - SVC_Service_MSTR_Equipment_View

Select * from SVC0202V

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EQUIPID	Equipment ID	Long Integer	4	View
EQPLINE	Equipment Line Item Sequence	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
CALLNBR	Service Call Number	String	12	View
SRVRECTYPE	Service Record Type	Integer	2	View
TECHID	Tech ID	String	12	View
SRVTYPE	Service Type	String	12	View
ENTDTE	Entry Date	Date	4	View
COMPDTE	Complete Date	Date	4	View
COMPTME	Complete Time	Time	4	View
PROBCDE	Problem Code	String	12	View
OFFID	Office ID	String	12	View
SRVSTAT	Service Call Status	String	4	View
CONTNBR	Contract Number	String	12	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View