Module List > Module SVC tables SVC30607
You are currently viewing the COMPANY database.
Change

COMPANY..SVC30607 Table Definition

(COMPANY..SVC_Contract_Line_Meter_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CONSTS smallint
0
Field Type...(more) Join Now
CONTNBR char(11)
''
Field Type...(more) Join Now
LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
Meter_Bases_1 int
0
Field Type...(more) Join Now
Meter_Bases_2 int
0
Field Type...(more) Join Now
Meter_Bases_3 int
0
Field Type...(more) Join Now
Meter_Bases_4 int
0
Field Type...(more) Join Now
Meter_Bases_5 int
0
Field Type...(more) Join Now
Meter_Overages_1 int
0
Field Type...(more) Join Now
Meter_Overages_2 int
0
Field Type...(more) Join Now
Meter_Overages_3 int
0
Field Type...(more) Join Now
Meter_Overages_4 int
0
Field Type...(more) Join Now
Meter_Overages_5 int
0
Field Type...(more) Join Now
Meter_Overages_6 int
0
Field Type...(more) Join Now
Meter_Overages_7 int
0
Field Type...(more) Join Now
Meter_Overages_8 int
0
Field Type...(more) Join Now
Meter_Overages_9 int
0
Field Type...(more) Join Now
Meter_Overages_10 int
0
Field Type...(more) Join Now
Meter_Overages_11 int
0
Field Type...(more) Join Now
Meter_Overages_12 int
0
Field Type...(more) Join Now
Meter_Overages_13 int
0
Field Type...(more) Join Now
Meter_Overages_14 int
0
Field Type...(more) Join Now
Meter_Overages_15 int
0
Field Type...(more) Join Now
Meter_Overages_16 int
0
Field Type...(more) Join Now
Meter_Overages_17 int
0
Field Type...(more) Join Now
Meter_Overages_18 int
0
Field Type...(more) Join Now
Meter_Overages_19 int
0
Field Type...(more) Join Now
Meter_Overages_20 int
0
Field Type...(more) Join Now
Meter_Charges_1 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_2 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_3 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_4 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_5 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_6 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_7 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_8 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_9 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_10 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_11 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_12 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_13 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_14 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_15 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_16 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_17 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_18 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_19 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_20 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Expires_1 tinyint
0
Field Type...(more) Join Now
Meter_Expires_2 tinyint
0
Field Type...(more) Join Now
Meter_Expires_3 tinyint
0
Field Type...(more) Join Now
Meter_Expires_4 tinyint
0
Field Type...(more) Join Now
Meter_Expires_5 tinyint
0
Field Type...(more) Join Now
Meter_Internal_Uses_1 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_2 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_3 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_4 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_5 int
0
Field Type...(more) Join Now
Meter_Actuals_1 int
0
Field Type...(more) Join Now
Meter_Actuals_2 int
0
Field Type...(more) Join Now
Meter_Actuals_3 int
0
Field Type...(more) Join Now
Meter_Actuals_4 int
0
Field Type...(more) Join Now
Meter_Actuals_5 int
0
Field Type...(more) Join Now
Meter_Startings_1 int
0
Field Type...(more) Join Now
Meter_Startings_2 int
0
Field Type...(more) Join Now
Meter_Startings_3 int
0
Field Type...(more) Join Now
Meter_Startings_4 int
0
Field Type...(more) Join Now
Meter_Startings_5 int
0
Field Type...(more) Join Now
Amount_To_Invoice numeric(19,5)
0.00
Field Type...(more) Join Now
Invoiced_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
Total_Invoiced numeric(19,5)
0.00
Field Type...(more) Join Now
INVODATE datetime
'1/1/1900'
Field Type...(more) Join Now
Orig_Amount_To_Invoice numeric(19,5)
0.00
Field Type...(more) Join Now
Orig_Invoiced_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
OrigTotalInvoiced numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_1 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_2 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_3 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_4 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_5 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_6 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_7 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_8 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_9 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_10 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_11 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_12 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_13 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_14 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_15 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_16 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_17 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_18 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_19 numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Meter_Charge_20 numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Contract_Version smallint
0
Field Type...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3