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

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 *