SVC00602 - SVC_Codes_Contract_Type | Prospr - Dynamics GP Table Reference

SVC00602 - SVC_Codes_Contract_Type

Query Builder

Select * from SVC00602

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CNTTYPE	Contract Type	String	12	View
CNTTYPDESC	Contract Type Description	String	32	View
SRVTYPE	Service Type	String	12	View
GL_Prepaid_Account	GL Prepaid Account Index	Long Integer	4	View
GL_Service_Account	GL Service Account Index	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
USECVPD_1	Use Coverage Period[1]	Boolean	2	View
USECVPD_2	Use Coverage Period[2]	Boolean	2	View
USECVPD_3	Use Coverage Period[3]	Boolean	2	View
USECVPD_4	Use Coverage Period[4]	Boolean	2	View
USECVPD_5	Use Coverage Period[5]	Boolean	2	View
USECVPD_6	Use Coverage Period[6]	Boolean	2	View
USECVPD_7	Use Coverage Period[7]	Boolean	2	View
Contract_Coverage_Period_1	Contract Coverage Periods End[1]	Time	4	View
Contract_Coverage_Period_2	Contract Coverage Periods End[2]	Time	4	View
Contract_Coverage_Period_3	Contract Coverage Periods End[3]	Time	4	View
Contract_Coverage_Period_4	Contract Coverage Periods End[4]	Time	4	View
Contract_Coverage_Period_5	Contract Coverage Periods End[5]	Time	4	View
Contract_Coverage_Period_6	Contract Coverage Periods End[6]	Time	4	View
Contract_Coverage_Period_7	Contract Coverage Periods End[7]	Time	4	View
CNTCOVPD_1	Contract Coverage Periods Start[1]	Time	4	View
CNTCOVPD_2	Contract Coverage Periods Start[2]	Time	4	View
CNTCOVPD_3	Contract Coverage Periods Start[3]	Time	4	View
CNTCOVPD_4	Contract Coverage Periods Start[4]	Time	4	View
CNTCOVPD_5	Contract Coverage Periods Start[5]	Time	4	View
CNTCOVPD_6	Contract Coverage Periods Start[6]	Time	4	View
CNTCOVPD_7	Contract Coverage Periods Start[7]	Time	4	View
Grace_Days	Grace Days	Integer	2	View
Meter_Bases_1	Meter Bases[1]	Long Integer	4	View
Meter_Bases_2	Meter Bases[2]	Long Integer	4	View
Meter_Bases_3	Meter Bases[3]	Long Integer	4	View
Meter_Bases_4	Meter Bases[4]	Long Integer	4	View
Meter_Bases_5	Meter Bases[5]	Long Integer	4	View
Meter_Overages_1	Meter Overages[1]	Long Integer	4	View
Meter_Overages_2	Meter Overages[2]	Long Integer	4	View
Meter_Overages_3	Meter Overages[3]	Long Integer	4	View
Meter_Overages_4	Meter Overages[4]	Long Integer	4	View
Meter_Overages_5	Meter Overages[5]	Long Integer	4	View
Meter_Overages_6	Meter Overages[6]	Long Integer	4	View
Meter_Overages_7	Meter Overages[7]	Long Integer	4	View
Meter_Overages_8	Meter Overages[8]	Long Integer	4	View
Meter_Overages_9	Meter Overages[9]	Long Integer	4	View
Meter_Overages_10	Meter Overages[10]	Long Integer	4	View
Meter_Overages_11	Meter Overages[11]	Long Integer	4	View
Meter_Overages_12	Meter Overages[12]	Long Integer	4	View
Meter_Overages_13	Meter Overages[13]	Long Integer	4	View
Meter_Overages_14	Meter Overages[14]	Long Integer	4	View
Meter_Overages_15	Meter Overages[15]	Long Integer	4	View
Meter_Overages_16	Meter Overages[16]	Long Integer	4	View
Meter_Overages_17	Meter Overages[17]	Long Integer	4	View
Meter_Overages_18	Meter Overages[18]	Long Integer	4	View
Meter_Overages_19	Meter Overages[19]	Long Integer	4	View
Meter_Overages_20	Meter Overages[20]	Long Integer	4	View
Meter_Charges_1	Meter Charges[1]	Currency	10	View
Meter_Charges_2	Meter Charges[2]	Currency	10	View
Meter_Charges_3	Meter Charges[3]	Currency	10	View
Meter_Charges_4	Meter Charges[4]	Currency	10	View
Meter_Charges_5	Meter Charges[5]	Currency	10	View
Meter_Charges_6	Meter Charges[6]	Currency	10	View
Meter_Charges_7	Meter Charges[7]	Currency	10	View
Meter_Charges_8	Meter Charges[8]	Currency	10	View
Meter_Charges_9	Meter Charges[9]	Currency	10	View
Meter_Charges_10	Meter Charges[10]	Currency	10	View
Meter_Charges_11	Meter Charges[11]	Currency	10	View
Meter_Charges_12	Meter Charges[12]	Currency	10	View
Meter_Charges_13	Meter Charges[13]	Currency	10	View
Meter_Charges_14	Meter Charges[14]	Currency	10	View
Meter_Charges_15	Meter Charges[15]	Currency	10	View
Meter_Charges_16	Meter Charges[16]	Currency	10	View
Meter_Charges_17	Meter Charges[17]	Currency	10	View
Meter_Charges_18	Meter Charges[18]	Currency	10	View
Meter_Charges_19	Meter Charges[19]	Currency	10	View
Meter_Charges_20	Meter Charges[20]	Currency	10	View
Meter_Expires_1	Meter Expires[1]	Boolean	2	View
Meter_Expires_2	Meter Expires[2]	Boolean	2	View
Meter_Expires_3	Meter Expires[3]	Boolean	2	View
Meter_Expires_4	Meter Expires[4]	Boolean	2	View
Meter_Expires_5	Meter Expires[5]	Boolean	2	View
SVC_Invoice_Detail	SVC Invoice Detail	Boolean	2	View
PREPAID	Pre Paid	Boolean	2	View
SVC_Contract_Batch_ID	SVC Contract Batch ID	String	16	View
SVC_Contract_Document_ID	SVC Contract Document ID	String	16	View
Contract_Response_Time	Contract Response Time	String	8	View
SVC_Discount_Flag	SVC Discount Flag	Boolean	2	View
SVC_Discount_Account	SVC Discount Account	Long Integer	4	View
SVC_C_Credit_Batch_ID	SVC C Credit Batch ID	String	16	View
SVC_C_Credit_Document_ID	SVC C Credit Document ID	String	16	View
priorityLevel	priorityLevel	Integer	2	View
svcBillingExchangeRate	svcBillingExchangeRate	Integer	2	View
svcRevenueExchangeRate	svcRevenueExchangeRate	Integer	2	View

SVC00602 - SVC_Codes_Contract_Type

Query Builder

Customer Service

Information

My Account

Contact Us