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 |