SVC00305 - SVC_Serial_MSTR_PM | Prospr - Dynamics GP Table Reference

SVC00305 - SVC_Serial_MSTR_PM

Query Builder

Select * from SVC00305

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EQUIPID	Equipment ID	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
SERLNMBR	Serial Number	String	22	View
SCHEDID	Sched_ID	String	10	View
PMDTLID	PM_DTL_ID	String	10	View
Meter_1_Level	Meter 1 Level	Long Integer	4	View
Meter_2_Level	Meter 2 Level	Long Integer	4	View
CALLNBR	Service Call Number	String	12	View
LSTPMDTE	Last PM Date	Date	4	View
METER1	Meter 1	Long Integer	4	View
METER2	Meter 2	Long Integer	4	View
PMSTAT	PM Status	Integer	2	View
SVCLSTPMPERF	SVC Last PM Performed Date	Date	4	View