SVC30607 - SVC_Contract_Line_Meter_HIST | Prospr

SVC30607 - SVC_Contract_Line_Meter_HIST

Query Builder

Select * from SVC30607

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CONSTS	Contract Record Type	Integer	2	View
CONTNBR	Contract Number	String	12	View
LNSEQNBR	Line SEQ Number	Currency	10	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
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
Meter_Actuals_1	Meter Actuals[1]	Long Integer	4	View
Meter_Actuals_2	Meter Actuals[2]	Long Integer	4	View
Meter_Actuals_3	Meter Actuals[3]	Long Integer	4	View
Meter_Actuals_4	Meter Actuals[4]	Long Integer	4	View
Meter_Actuals_5	Meter Actuals[5]	Long Integer	4	View
Meter_Startings_1	Meter Startings[1]	Long Integer	4	View
Meter_Startings_2	Meter Startings[2]	Long Integer	4	View
Meter_Startings_3	Meter Startings[3]	Long Integer	4	View
Meter_Startings_4	Meter Startings[4]	Long Integer	4	View
Meter_Startings_5	Meter Startings[5]	Long Integer	4	View
Amount_To_Invoice	Amount To Invoice	Currency	10	View
Invoiced_Amount	Invoiced Amount	Currency	10	View
Total_Invoiced	Total Invoiced	Currency	10	View
INVODATE	Invoice Date	Date	4	View
Orig_Amount_To_Invoice	Originating Amount To Invoice	Currency	10	View
Orig_Invoiced_Amount	Originating Invoiced Amount	Currency	10	View
OrigTotalInvoiced	Originating Total Invoiced	Currency	10	View
Originating_Meter_Charge_1	Originating Meter Charges[1]	Currency	10	View
Originating_Meter_Charge_2	Originating Meter Charges[2]	Currency	10	View
Originating_Meter_Charge_3	Originating Meter Charges[3]	Currency	10	View
Originating_Meter_Charge_4	Originating Meter Charges[4]	Currency	10	View
Originating_Meter_Charge_5	Originating Meter Charges[5]	Currency	10	View
Originating_Meter_Charge_6	Originating Meter Charges[6]	Currency	10	View
Originating_Meter_Charge_7	Originating Meter Charges[7]	Currency	10	View
Originating_Meter_Charge_8	Originating Meter Charges[8]	Currency	10	View
Originating_Meter_Charge_9	Originating Meter Charges[9]	Currency	10	View
Originating_Meter_Charge_10	Originating Meter Charges[10]	Currency	10	View
Originating_Meter_Charge_11	Originating Meter Charges[11]	Currency	10	View
Originating_Meter_Charge_12	Originating Meter Charges[12]	Currency	10	View
Originating_Meter_Charge_13	Originating Meter Charges[13]	Currency	10	View
Originating_Meter_Charge_14	Originating Meter Charges[14]	Currency	10	View
Originating_Meter_Charge_15	Originating Meter Charges[15]	Currency	10	View
Originating_Meter_Charge_16	Originating Meter Charges[16]	Currency	10	View
Originating_Meter_Charge_17	Originating Meter Charges[17]	Currency	10	View
Originating_Meter_Charge_18	Originating Meter Charges[18]	Currency	10	View
Originating_Meter_Charge_19	Originating Meter Charges[19]	Currency	10	View
Originating_Meter_Charge_20	Originating Meter Charges[20]	Currency	10	View
SVC_Contract_Version	SVC_Contract_Version	Integer	2	View

SVC30607 - SVC_Contract_Line_Meter_HIST

Query Builder

Customer Service

Information

My Account

Contact Us