SVC00301 - Serial Meter Readings | Prospr - Dynamics GP Table Reference

SVC00301 - Serial Meter Readings

Query Builder

Select * from SVC00301

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EQUIPID	Equipment ID	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
SERLNMBR	Serial Number	String	22	View
ITEMNMBR	Item Number	String	32	View
METER1	Meter 1	Long Integer	4	View
METER2	Meter 2	Long Integer	4	View
METER3	Meter 3	Long Integer	4	View
LSTDTEDT	Last Date Edited	Date	4	View
Daily_Usage	Daily Usage	Currency	10	View
USERID	User ID	String	16	View
Meters_1	Meters[1]	Long Integer	4	View
Meters_2	Meters[2]	Long Integer	4	View
Meters_3	Meters[3]	Long Integer	4	View
Meters_4	Meters[4]	Long Integer	4	View
Meters_5	Meters[5]	Long Integer	4	View
Dailys_1	Dailys[1]	Currency	10	View
Dailys_2	Dailys[2]	Currency	10	View
Dailys_3	Dailys[3]	Currency	10	View
Dailys_4	Dailys[4]	Currency	10	View
Dailys_5	Dailys[5]	Currency	10	View
Replaces_1	Replaces[1]	Boolean	2	View
Replaces_2	Replaces[2]	Boolean	2	View
Replaces_3	Replaces[3]	Boolean	2	View
Replaces_4	Replaces[4]	Boolean	2	View
Replaces_5	Replaces[5]	Boolean	2	View
Reading_Entered_From	Reading Entered From	String	32	View
Meter_Deltas_1	Meter_Deltas[1]	Long Integer	4	View
Meter_Deltas_2	Meter_Deltas[2]	Long Integer	4	View
Meter_Deltas_3	Meter_Deltas[3]	Long Integer	4	View
Meter_Deltas_4	Meter_Deltas[4]	Long Integer	4	View
Meter_Deltas_5	Meter_Deltas[5]	Long Integer	4	View