SVC30200 - Service Call Master History | Prospr

SVC30200 - Service Call Master History

Query Builder

Select * from SVC30200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CALLNBR	Service Call Number	String	12	View
SRVRECTYPE	Service Record Type	Integer	2	View
SRVSTAT	Service Call Status	String	4	View
SRVTYPE	Service Type	String	12	View
SVCDESCR	Service Description	String	62	View
priorityLevel	priorityLevel	Integer	2	View
CUSTNMBR	Customer Number	String	16	View
Customer_Reference	Customer Reference	String	22	View
ADRSCODE	Address Code	String	16	View
CUSTNAME	Customer Name	String	66	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
CNTCPRSN	Contact Person	String	62	View
PHONE1	Phone 1	String	22	View
OFFID	Office ID	String	12	View
SVCAREA	Service Area	String	12	View
TECHID	Tech ID	String	12	View
TIMEZONE	TimeZone	String	4	View
ENTDTE	Entry Date	Date	4	View
ENTTME	Entry Time	Time	4	View
Notify_Date	Notify Date	Date	4	View
Notify_Time	Notify Time	Time	4	View
ETADTE	ETA Date	Date	4	View
ETATME	ETA Time	Time	4	View
DISPDTE	Dispatch Date	Date	4	View
DISPTME	Dispatch Time	Time	4	View
ARRIVDTE	Arrival Date	Date	4	View
ARRIVTME	Arrival Time	Time	4	View
COMPDTE	Complete Date	Date	4	View
COMPTME	Complete Time	Time	4	View
Response_Date	Response Date	Date	4	View
Response_Time	Response Time	Time	4	View
PRICELVL	Price Level	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
SLPRSNID	Salesperson ID	String	16	View
LABSTOTPRC	Labor Sub Total Price	Currency	10	View
LABPCT	Labor Pct	Currency	10	View
LABSTOTCST	Labor Sub Total Cost	Currency	10	View
PARSTOTPRC	Part Sub Total Price	Currency	10	View
PARTPCT	Part Pct	Currency	10	View
PARSTOTCST	Part Sub Total Cost	Currency	10	View
MSCSTOTPRC	Misc Sub Total Price	Currency	10	View
MISCPCT	Misc Pct	Currency	10	View
MISSTOTCST	Misc Sub Total Cost	Currency	10	View
TAXSCHID	Tax Schedule ID	String	16	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
PRETAXTOT	PreTax Total	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
TOTAL	Total	Currency	10	View
Invoiced_Amount	Invoiced Amount	Currency	10	View
METER1	Meter 1	Long Integer	4	View
METER2	Meter 2	Long Integer	4	View
METER3	Meter 3	Long Integer	4	View
PORDNMBR	Purchase Order Number	String	22	View
NOTEINDX	Note Index	Currency	10	View
NOTFYFLAG	Notify Flag	Boolean	2	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
MSTRRECTYPE	Master Service Record Type	Integer	2	View
MSTRCALLNBR	Master Service Call Number	String	12	View
ESCDATE	Escalation Date	Date	4	View
ESCTIME	Escalation Time	Time	4	View
Escalation_Level	Escalation Level	Long Integer	4	View
SPLTTERMS	Split Terms Code	String	12	View
Callback	Callback	Boolean	2	View
PROJCTID	Project ID	String	16	View
ProjectRef1_1	ProjectRef1[1]	String	16	View
ProjectRef1_2	ProjectRef1[2]	String	16	View
ProjectRef1_3	ProjectRef1[3]	String	16	View
ProjectRef1_4	ProjectRef1[4]	String	16	View
CONSTS	Contract Record Type	Integer	2	View
CONTNBR	Contract Number	String	12	View
SVC_Contract_Line_SEQ	SVC_Contract_Line_SEQ_Number	Currency	10	View
ETTR	ETTR	Currency	10	View
SVC_On_Hold	SVC On Hold	Boolean	2	View
Print_to_Web	Print to Web	Boolean	2	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
Meter_Internal_Uses_1	Meter Internal Uses[1]	Long Integer	4	View
Meter_Internal_Uses_2	Meter Internal Uses[2]	Long Integer	4	View
Meter_Internal_Uses_3	Meter Internal Uses[3]	Long Integer	4	View
Meter_Internal_Uses_4	Meter Internal Uses[4]	Long Integer	4	View
Meter_Internal_Uses_5	Meter Internal Uses[5]	Long Integer	4	View
Bill_To_Customer	Bill To Customer	String	16	View
CURNCYID	Currency ID	String	16	View
SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
DECPLACS	Decimal Places	Integer	2	View
TIME1	Time	Time	4	View
RATECALC	Rate Calc Method	Integer	2	View
VIEWMODE	View Mode	Integer	2	View
ISMCTRX	IS MC Trx	Integer	2	View
EXPNDATE	Expiration Date	Date	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
ORIGMISSTOTCST	Originating Misc Sub Total Cost	Currency	10	View
ORIGMSCSTOTPRC	Originating Misc Sub Total Price	Currency	10	View
ORIGLABSUBTOTCOST	Originating Labor Sub Total Cost	Currency	10	View
ORIGLABSTOTPRC	Originating Labor Sub Total Price	Currency	10	View
ORIGPARSTOTCST	Originating Part Sub Total Cost	Currency	10	View
ORIGPARSTOTPRC	Originating Part Sub Total Price	Currency	10	View
ORIGPRETAXTOT	Originating PreTax Total	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
ORIGTOTAL	Originating Service Total	Currency	10	View
Orig_Invoiced_Amount	Originating Invoiced Amount	Currency	10	View
ADDRESS3	Address 3	String	62	View
COUNTRY	Country	String	62	View
SVC_Pre600	SVC_Pre600	Boolean	2	View
SVC_FO_ID	SVC FO ID	String	52	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
Workflow_Approval_Status	Workflow Approval Status 1 – Not Submitted 2 – Submitted 3 – No Approval Needed 4 – Pending Approval 5 – Pending Changes 6 – Approved 7 – Rejected 8 – Workflow Ended 9 – Workflow Not Activated 10 – Workflow Deactivated	Integer	2	View
Workflow_Priority	Workflow Priority	Integer	2	View

SVC30200 - Service Call Master History

Query Builder

Customer Service

Information

My Account

Contact Us