SVC00215 - SVC_Service_Call_Billing_WORK | Prospr - Dynamics GP Table Reference

SVC00215 - SVC_Service_Call_Billing_WORK

Query Builder

Select * from SVC00215

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
SRVRECTYPE	Service Record Type	Integer	2	View
CALLNBR	Service Call Number	String	12	View
SRVSTAT	Service Call Status	String	4	View
CUSTNMBR	Customer Number	String	16	View
TECHID	Tech ID	String	12	View
OFFID	Office ID	String	12	View
CUSTNAME	Customer Name	String	66	View
NAME	Name	String	32	View
OFFNAME	Office Name	String	22	View
SRVTYPE	Service Type	String	12	View
SVCDESCR	Service Description	String	62	View
PRETAXTOT	PreTax Total	Currency	10	View
MKDTOPST	Marked To Post	Boolean	2	View
POSTED	Posted	Boolean	2	View
ERMSGNBR	Error Message Number	Integer	2	View
ERMSGTXT	Error Message Text	String	256	View
ERMSGTX2	Error Message Text 2	String	256	View