| 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
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|