SVC00300 - Serial Master | Prospr - Dynamics GP Table Reference

SVC00300 - Serial Master

Query Builder

Select * from SVC00300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EQUIPID	Equipment ID	Long Integer	4	View
SERLNMBR	Serial Number	String	22	View
ITEMNMBR	Item Number	String	32	View
REFRENCE	Reference	String	32	View
Version	Version	String	22	View
SRLSTAT	Equipment Status	String	12	View
INSTDTE	Install Date	Date	4	View
CUSTNMBR	Customer Number	String	16	View
ADRSCODE	Address Code	String	16	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
COUNTRY	Country	String	62	View
CNTCPRSN	Contact Person	String	62	View
LSTPMDTE	Last PM Date	Date	4	View
LSTSRVDTE	Last Service Date	Date	4	View
TECHID	Tech ID	String	12	View
TECHID2	Tech ID2	String	12	View
OFFID	Office ID	String	12	View
SVCAREA	Service Area	String	12	View
TIMEZONE	TimeZone	String	4	View
WARRCDE	Warranty Code	String	12	View
WARREND	Warranty End	Date	4	View
WARRSTART	Warranty Start	Date	4	View
SLRWARR	Seller Warranty Code	String	12	View
SLRWEND	Seller Warranty End	Date	4	View
SLRWSTART	Seller Warranty Start	Date	4	View
NOTEINDX	Note Index	Currency	10	View
MTTR	MTTR	Currency	10	View
MTBF	MTBF	Currency	10	View
MTBI	MTBI	Currency	10	View
Last_Calc_Date	Last Calc Date	Date	4	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
MTBFs_1	MTBFs[1]	Currency	10	View
MTBFs_2	MTBFs[2]	Currency	10	View
MTBFs_3	MTBFs[3]	Currency	10	View
MTBFs_4	MTBFs[4]	Currency	10	View
MTBFs_5	MTBFs[5]	Currency	10	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
SVC_PM_Date	SVC PM Month	Integer	2	View
SVC_PM_Day	SVC PM Day	Integer	2	View
VENDORID	Vendor ID	String	16	View
ADDRESS3	Address 3	String	62	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USRDEF03	User Defined 3	String	22	View
USRDEF04	User Defined 4	String	22	View
USRDEF05	User Defined 5	String	22	View
SVC_Serial_ID	SVC Serial ID	String	22	View
QUANTITY	QTY	Currency	10	View
SVC_Asset_Tag	SVC Asset Tag	String	22	View
Shipped_Date	Shipped Date	Date	4	View
SVC_Register_Date	SVC Register Date	Date	4	View
SOPNUMBE	SOP Number	String	22	View

SVC00300 - Serial Master

Query Builder

Customer Service

Information

My Account

Contact Us