SVC_Contract_Line_Meter_HIST (SVC30607)

azurecurveProductsFieldService (949)ProjectSVC_Contract_Line_Meter_HIST (SVC30607)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC30607

Product: FieldService (949)
Series: Project

Display Name: SVC_Contract_Line_Meter_HIST
Physical Name: SVC30607
Technical Name: SVC_Contract_Line_Meter_HIST

Group Display Name: Service History Table Group
Group Technical Name: Service History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CONSTS SearchContract Record TypeDDL_Contract_StatusInteger20
2CONTNBR SearchContract NumberSTR11String1211
3LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
4Meter_Bases SearchMeter BasesLI_Meter_ReadingLong Integer48
5Meter_Bases_1 SearchMeter Bases[1]LI_Meter_ReadingLong Integer48
6Meter_Bases_2 SearchMeter Bases[2]LI_Meter_ReadingLong Integer48
7Meter_Bases_3 SearchMeter Bases[3]LI_Meter_ReadingLong Integer48
8Meter_Bases_4 SearchMeter Bases[4]LI_Meter_ReadingLong Integer48
9Meter_Bases_5 SearchMeter Bases[5]LI_Meter_ReadingLong Integer48
10Meter_Overages SearchMeter OveragesLI_Meter_ReadingLong Integer48
11Meter_Overages_1 SearchMeter Overages[1]LI_Meter_ReadingLong Integer48
12Meter_Overages_2 SearchMeter Overages[2]LI_Meter_ReadingLong Integer48
13Meter_Overages_3 SearchMeter Overages[3]LI_Meter_ReadingLong Integer48
14Meter_Overages_4 SearchMeter Overages[4]LI_Meter_ReadingLong Integer48
15Meter_Overages_5 SearchMeter Overages[5]LI_Meter_ReadingLong Integer48
16Meter_Overages_6 SearchMeter Overages[6]LI_Meter_ReadingLong Integer48
17Meter_Overages_7 SearchMeter Overages[7]LI_Meter_ReadingLong Integer48
18Meter_Overages_8 SearchMeter Overages[8]LI_Meter_ReadingLong Integer48
19Meter_Overages_9 SearchMeter Overages[9]LI_Meter_ReadingLong Integer48
20Meter_Overages_10 SearchMeter Overages[10]LI_Meter_ReadingLong Integer48
21Meter_Overages_11 SearchMeter Overages[11]LI_Meter_ReadingLong Integer48
22Meter_Overages_12 SearchMeter Overages[12]LI_Meter_ReadingLong Integer48
23Meter_Overages_13 SearchMeter Overages[13]LI_Meter_ReadingLong Integer48
24Meter_Overages_14 SearchMeter Overages[14]LI_Meter_ReadingLong Integer48
25Meter_Overages_15 SearchMeter Overages[15]LI_Meter_ReadingLong Integer48
26Meter_Overages_16 SearchMeter Overages[16]LI_Meter_ReadingLong Integer48
27Meter_Overages_17 SearchMeter Overages[17]LI_Meter_ReadingLong Integer48
28Meter_Overages_18 SearchMeter Overages[18]LI_Meter_ReadingLong Integer48
29Meter_Overages_19 SearchMeter Overages[19]LI_Meter_ReadingLong Integer48
30Meter_Overages_20 SearchMeter Overages[20]LI_Meter_ReadingLong Integer48
31Meter_Charges SearchMeter ChargesDLR_Meter_ChargeCurrency1010
32Meter_Charges_1 SearchMeter Charges[1]DLR_Meter_ChargeCurrency1010
33Meter_Charges_2 SearchMeter Charges[2]DLR_Meter_ChargeCurrency1010
34Meter_Charges_3 SearchMeter Charges[3]DLR_Meter_ChargeCurrency1010
35Meter_Charges_4 SearchMeter Charges[4]DLR_Meter_ChargeCurrency1010
36Meter_Charges_5 SearchMeter Charges[5]DLR_Meter_ChargeCurrency1010
37Meter_Charges_6 SearchMeter Charges[6]DLR_Meter_ChargeCurrency1010
38Meter_Charges_7 SearchMeter Charges[7]DLR_Meter_ChargeCurrency1010
39Meter_Charges_8 SearchMeter Charges[8]DLR_Meter_ChargeCurrency1010
40Meter_Charges_9 SearchMeter Charges[9]DLR_Meter_ChargeCurrency1010
41Meter_Charges_10 SearchMeter Charges[10]DLR_Meter_ChargeCurrency1010
42Meter_Charges_11 SearchMeter Charges[11]DLR_Meter_ChargeCurrency1010
43Meter_Charges_12 SearchMeter Charges[12]DLR_Meter_ChargeCurrency1010
44Meter_Charges_13 SearchMeter Charges[13]DLR_Meter_ChargeCurrency1010
45Meter_Charges_14 SearchMeter Charges[14]DLR_Meter_ChargeCurrency1010
46Meter_Charges_15 SearchMeter Charges[15]DLR_Meter_ChargeCurrency1010
47Meter_Charges_16 SearchMeter Charges[16]DLR_Meter_ChargeCurrency1010
48Meter_Charges_17 SearchMeter Charges[17]DLR_Meter_ChargeCurrency1010
49Meter_Charges_18 SearchMeter Charges[18]DLR_Meter_ChargeCurrency1010
50Meter_Charges_19 SearchMeter Charges[19]DLR_Meter_ChargeCurrency1010
51Meter_Charges_20 SearchMeter Charges[20]DLR_Meter_ChargeCurrency1010
52Meter_Expires SearchMeter ExpiresCBBoolean20
53Meter_Expires_1 SearchMeter Expires[1]CBBoolean20
54Meter_Expires_2 SearchMeter Expires[2]CBBoolean20
55Meter_Expires_3 SearchMeter Expires[3]CBBoolean20
56Meter_Expires_4 SearchMeter Expires[4]CBBoolean20
57Meter_Expires_5 SearchMeter Expires[5]CBBoolean20
58Meter_Internal_Uses SearchMeter Internal UsesLI_Meter_ReadingLong Integer48
59Meter_Internal_Uses_1 SearchMeter Internal Uses[1]LI_Meter_ReadingLong Integer48
60Meter_Internal_Uses_2 SearchMeter Internal Uses[2]LI_Meter_ReadingLong Integer48
61Meter_Internal_Uses_3 SearchMeter Internal Uses[3]LI_Meter_ReadingLong Integer48
62Meter_Internal_Uses_4 SearchMeter Internal Uses[4]LI_Meter_ReadingLong Integer48
63Meter_Internal_Uses_5 SearchMeter Internal Uses[5]LI_Meter_ReadingLong Integer48
64Meter_Actuals SearchMeter ActualsLI_Meter_ReadingLong Integer48
65Meter_Actuals_1 SearchMeter Actuals[1]LI_Meter_ReadingLong Integer48
66Meter_Actuals_2 SearchMeter Actuals[2]LI_Meter_ReadingLong Integer48
67Meter_Actuals_3 SearchMeter Actuals[3]LI_Meter_ReadingLong Integer48
68Meter_Actuals_4 SearchMeter Actuals[4]LI_Meter_ReadingLong Integer48
69Meter_Actuals_5 SearchMeter Actuals[5]LI_Meter_ReadingLong Integer48
70Meter_Startings SearchMeter StartingsLI_Meter_ReadingLong Integer48
71Meter_Startings_1 SearchMeter Startings[1]LI_Meter_ReadingLong Integer48
72Meter_Startings_2 SearchMeter Startings[2]LI_Meter_ReadingLong Integer48
73Meter_Startings_3 SearchMeter Startings[3]LI_Meter_ReadingLong Integer48
74Meter_Startings_4 SearchMeter Startings[4]LI_Meter_ReadingLong Integer48
75Meter_Startings_5 SearchMeter Startings[5]LI_Meter_ReadingLong Integer48
76Amount_To_Invoice SearchAmount To InvoiceSVCDLR19_$U2Currency1019
77Invoiced_Amount SearchInvoiced AmountDLR19_$U2Currency1019
78Total_Invoiced SearchTotal InvoicedDLR19_$U2Currency1019
79INVODATE SearchInvoice DateDTDate48
80Orig_Amount_To_Invoice SearchOriginating Amount To InvoiceSVCDLR19_$U2Currency1019
81Orig_Invoiced_Amount SearchOriginating Invoiced AmountDLR19_$U2Currency1019
82OrigTotalInvoiced SearchOriginating Total InvoicedDLR19_$U2Currency1019
83Originating_Meter_Charge SearchOriginating Meter ChargesDLR_Meter_ChargeCurrency1010
84Originating_Meter_Charge_1 SearchOriginating Meter Charges[1]DLR_Meter_ChargeCurrency1010
85Originating_Meter_Charge_2 SearchOriginating Meter Charges[2]DLR_Meter_ChargeCurrency1010
86Originating_Meter_Charge_3 SearchOriginating Meter Charges[3]DLR_Meter_ChargeCurrency1010
87Originating_Meter_Charge_4 SearchOriginating Meter Charges[4]DLR_Meter_ChargeCurrency1010
88Originating_Meter_Charge_5 SearchOriginating Meter Charges[5]DLR_Meter_ChargeCurrency1010
89Originating_Meter_Charge_6 SearchOriginating Meter Charges[6]DLR_Meter_ChargeCurrency1010
90Originating_Meter_Charge_7 SearchOriginating Meter Charges[7]DLR_Meter_ChargeCurrency1010
91Originating_Meter_Charge_8 SearchOriginating Meter Charges[8]DLR_Meter_ChargeCurrency1010
92Originating_Meter_Charge_9 SearchOriginating Meter Charges[9]DLR_Meter_ChargeCurrency1010
93Originating_Meter_Charge_10 SearchOriginating Meter Charges[10]DLR_Meter_ChargeCurrency1010
94Originating_Meter_Charge_11 SearchOriginating Meter Charges[11]DLR_Meter_ChargeCurrency1010
95Originating_Meter_Charge_12 SearchOriginating Meter Charges[12]DLR_Meter_ChargeCurrency1010
96Originating_Meter_Charge_13 SearchOriginating Meter Charges[13]DLR_Meter_ChargeCurrency1010
97Originating_Meter_Charge_14 SearchOriginating Meter Charges[14]DLR_Meter_ChargeCurrency1010
98Originating_Meter_Charge_15 SearchOriginating Meter Charges[15]DLR_Meter_ChargeCurrency1010
99Originating_Meter_Charge_16 SearchOriginating Meter Charges[16]DLR_Meter_ChargeCurrency1010
100Originating_Meter_Charge_17 SearchOriginating Meter Charges[17]DLR_Meter_ChargeCurrency1010
101Originating_Meter_Charge_18 SearchOriginating Meter Charges[18]DLR_Meter_ChargeCurrency1010
102Originating_Meter_Charge_19 SearchOriginating Meter Charges[19]DLR_Meter_ChargeCurrency1010
103Originating_Meter_Charge_20 SearchOriginating Meter Charges[20]DLR_Meter_ChargeCurrency1010
104SVC_Contract_Version SearchSVC_Contract_VersionINT3Integer23
105DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsFieldService (949)ProjectSVC_Contract_Line_Meter_HIST (SVC30607)

Leave a Reply

Your email address will not be published. Required fields are marked *