Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00607
Product: FieldService (949)
Series:
Display Name: SVC_Contract_Line_Meter Group Display Name: Service Table Group
Physical Name: SVC00607
Technical Name: SVC_Contract_Line_Meter
Group Technical Name: Service
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | CONSTS | Contract Record Type | Integer | DDL_Contract_Status | 0 |
2 | CONTNBR | Contract Number | String | STR11 | 11 |
3 | LNSEQNBR | Line SEQ Number | Currency | Sequence_Number | 19 |
4 | Meter_Bases_1 | Meter Bases[1] | Long Integer | LI_Meter_Reading | 8 |
5 | Meter_Bases | Meter Bases | LI_Meter_Reading | Long Integer | 8 |
6 | Meter_Bases_2 | Meter Bases[2] | Long Integer | LI_Meter_Reading | 8 |
7 | Meter_Bases_3 | Meter Bases[3] | Long Integer | LI_Meter_Reading | 8 |
8 | Meter_Bases_4 | Meter Bases[4] | Long Integer | LI_Meter_Reading | 8 |
9 | Meter_Bases_5 | Meter Bases[5] | Long Integer | LI_Meter_Reading | 8 |
10 | Meter_Overages_1 | Meter Overages[1] | Long Integer | LI_Meter_Reading | 8 |
11 | Meter_Overages | Meter Overages | LI_Meter_Reading | Long Integer | 8 |
12 | Meter_Overages_2 | Meter Overages[2] | Long Integer | LI_Meter_Reading | 8 |
13 | Meter_Overages_3 | Meter Overages[3] | Long Integer | LI_Meter_Reading | 8 |
14 | Meter_Overages_4 | Meter Overages[4] | Long Integer | LI_Meter_Reading | 8 |
15 | Meter_Overages_5 | Meter Overages[5] | Long Integer | LI_Meter_Reading | 8 |
16 | Meter_Overages_6 | Meter Overages[6] | Long Integer | LI_Meter_Reading | 8 |
17 | Meter_Overages_7 | Meter Overages[7] | Long Integer | LI_Meter_Reading | 8 |
18 | Meter_Overages_8 | Meter Overages[8] | Long Integer | LI_Meter_Reading | 8 |
19 | Meter_Overages_9 | Meter Overages[9] | Long Integer | LI_Meter_Reading | 8 |
20 | Meter_Overages_10 | Meter Overages[10] | Long Integer | LI_Meter_Reading | 8 |
21 | Meter_Overages_11 | Meter Overages[11] | Long Integer | LI_Meter_Reading | 8 |
22 | Meter_Overages_12 | Meter Overages[12] | Long Integer | LI_Meter_Reading | 8 |
23 | Meter_Overages_13 | Meter Overages[13] | Long Integer | LI_Meter_Reading | 8 |
24 | Meter_Overages_14 | Meter Overages[14] | Long Integer | LI_Meter_Reading | 8 |
25 | Meter_Overages_15 | Meter Overages[15] | Long Integer | LI_Meter_Reading | 8 |
26 | Meter_Overages_16 | Meter Overages[16] | Long Integer | LI_Meter_Reading | 8 |
27 | Meter_Overages_17 | Meter Overages[17] | Long Integer | LI_Meter_Reading | 8 |
28 | Meter_Overages_18 | Meter Overages[18] | Long Integer | LI_Meter_Reading | 8 |
29 | Meter_Overages_19 | Meter Overages[19] | Long Integer | LI_Meter_Reading | 8 |
30 | Meter_Overages_20 | Meter Overages[20] | Long Integer | LI_Meter_Reading | 8 |
31 | Meter_Charges_1 | Meter Charges[1] | Currency | DLR_Meter_Charge | 10 |
32 | Meter_Charges_2 | Meter Charges[2] | Currency | DLR_Meter_Charge | 10 |
33 | Meter_Charges_3 | Meter Charges[3] | Currency | DLR_Meter_Charge | 10 |
34 | Meter_Charges | Meter Charges | DLR_Meter_Charge | Currency | 10 |
35 | Meter_Charges_4 | Meter Charges[4] | Currency | DLR_Meter_Charge | 10 |
36 | Meter_Charges_5 | Meter Charges[5] | Currency | DLR_Meter_Charge | 10 |
37 | Meter_Charges_6 | Meter Charges[6] | Currency | DLR_Meter_Charge | 10 |
38 | Meter_Charges_7 | Meter Charges[7] | Currency | DLR_Meter_Charge | 10 |
39 | Meter_Charges_8 | Meter Charges[8] | Currency | DLR_Meter_Charge | 10 |
40 | Meter_Charges_9 | Meter Charges[9] | Currency | DLR_Meter_Charge | 10 |
41 | Meter_Charges_10 | Meter Charges[10] | Currency | DLR_Meter_Charge | 10 |
42 | Meter_Charges_11 | Meter Charges[11] | Currency | DLR_Meter_Charge | 10 |
43 | Meter_Charges_12 | Meter Charges[12] | Currency | DLR_Meter_Charge | 10 |
44 | Meter_Charges_13 | Meter Charges[13] | Currency | DLR_Meter_Charge | 10 |
45 | Meter_Charges_14 | Meter Charges[14] | Currency | DLR_Meter_Charge | 10 |
46 | Meter_Charges_15 | Meter Charges[15] | Currency | DLR_Meter_Charge | 10 |
47 | Meter_Charges_16 | Meter Charges[16] | Currency | DLR_Meter_Charge | 10 |
48 | Meter_Charges_17 | Meter Charges[17] | Currency | DLR_Meter_Charge | 10 |
49 | Meter_Charges_18 | Meter Charges[18] | Currency | DLR_Meter_Charge | 10 |
50 | Meter_Charges_19 | Meter Charges[19] | Currency | DLR_Meter_Charge | 10 |
51 | Meter_Charges_20 | Meter Charges[20] | Currency | DLR_Meter_Charge | 10 |
52 | Meter_Expires_1 | Meter Expires[1] | Boolean | CB | 0 |
53 | Meter_Expires_2 | Meter Expires[2] | Boolean | CB | 0 |
54 | Meter_Expires_3 | Meter Expires[3] | Boolean | CB | 0 |
55 | Meter_Expires_4 | Meter Expires[4] | Boolean | CB | 0 |
56 | Meter_Expires | Meter Expires | CB | Boolean | 0 |
57 | Meter_Expires_5 | Meter Expires[5] | Boolean | CB | 0 |
58 | Meter_Internal_Uses_1 | Meter Internal Uses[1] | Long Integer | LI_Meter_Reading | 8 |
59 | Meter_Internal_Uses_2 | Meter Internal Uses[2] | Long Integer | LI_Meter_Reading | 8 |
60 | Meter_Internal_Uses_3 | Meter Internal Uses[3] | Long Integer | LI_Meter_Reading | 8 |
61 | Meter_Internal_Uses_4 | Meter Internal Uses[4] | Long Integer | LI_Meter_Reading | 8 |
62 | Meter_Internal_Uses | Meter Internal Uses | LI_Meter_Reading | Long Integer | 8 |
63 | Meter_Internal_Uses_5 | Meter Internal Uses[5] | Long Integer | LI_Meter_Reading | 8 |
64 | Meter_Actuals_1 | Meter Actuals[1] | Long Integer | LI_Meter_Reading | 8 |
65 | Meter_Actuals_2 | Meter Actuals[2] | Long Integer | LI_Meter_Reading | 8 |
66 | Meter_Actuals_3 | Meter Actuals[3] | Long Integer | LI_Meter_Reading | 8 |
67 | Meter_Actuals_4 | Meter Actuals[4] | Long Integer | LI_Meter_Reading | 8 |
68 | Meter_Actuals_5 | Meter Actuals[5] | Long Integer | LI_Meter_Reading | 8 |
69 | Meter_Actuals | Meter Actuals | LI_Meter_Reading | Long Integer | 8 |
70 | Meter_Startings_1 | Meter Startings[1] | Long Integer | LI_Meter_Reading | 8 |
71 | Meter_Startings_2 | Meter Startings[2] | Long Integer | LI_Meter_Reading | 8 |
72 | Meter_Startings_3 | Meter Startings[3] | Long Integer | LI_Meter_Reading | 8 |
73 | Meter_Startings_4 | Meter Startings[4] | Long Integer | LI_Meter_Reading | 8 |
74 | Meter_Startings_5 | Meter Startings[5] | Long Integer | LI_Meter_Reading | 8 |
75 | Amount_To_Invoice | Amount To Invoice | Currency | SVCDLR19_$U2 | 19 |
76 | Meter_Startings | Meter Startings | LI_Meter_Reading | Long Integer | 8 |
77 | Invoiced_Amount | Invoiced Amount | Currency | DLR19_$U2 | 19 |
78 | Total_Invoiced | Total Invoiced | Currency | DLR19_$U2 | 19 |
79 | INVODATE | Invoice Date | Date | DT | 8 |
80 | Orig_Amount_To_Invoice | Originating Amount To Invoice | Currency | SVCDLR19_$U2 | 19 |
81 | Orig_Invoiced_Amount | Originating Invoiced Amount | Currency | DLR19_$U2 | 19 |
82 | OrigTotalInvoiced | Originating Total Invoiced | Currency | DLR19_$U2 | 19 |
83 | Originating_Meter_Charge_1 | Originating Meter Charges[1] | Currency | DLR_Meter_Charge | 10 |
84 | Originating_Meter_Charge_2 | Originating Meter Charges[2] | Currency | DLR_Meter_Charge | 10 |
85 | Originating_Meter_Charge_3 | Originating Meter Charges[3] | Currency | DLR_Meter_Charge | 10 |
86 | Originating_Meter_Charge_4 | Originating Meter Charges[4] | Currency | DLR_Meter_Charge | 10 |
87 | Originating_Meter_Charge_5 | Originating Meter Charges[5] | Currency | DLR_Meter_Charge | 10 |
88 | Originating_Meter_Charge_6 | Originating Meter Charges[6] | Currency | DLR_Meter_Charge | 10 |
89 | Originating_Meter_Charge_7 | Originating Meter Charges[7] | Currency | DLR_Meter_Charge | 10 |
90 | Originating_Meter_Charge_8 | Originating Meter Charges[8] | Currency | DLR_Meter_Charge | 10 |
91 | Originating_Meter_Charge | Originating Meter Charges | DLR_Meter_Charge | Currency | 10 |
92 | Originating_Meter_Charge_9 | Originating Meter Charges[9] | Currency | DLR_Meter_Charge | 10 |
93 | Originating_Meter_Charge_10 | Originating Meter Charges[10] | Currency | DLR_Meter_Charge | 10 |
94 | Originating_Meter_Charge_11 | Originating Meter Charges[11] | Currency | DLR_Meter_Charge | 10 |
95 | Originating_Meter_Charge_12 | Originating Meter Charges[12] | Currency | DLR_Meter_Charge | 10 |
96 | Originating_Meter_Charge_13 | Originating Meter Charges[13] | Currency | DLR_Meter_Charge | 10 |
97 | Originating_Meter_Charge_14 | Originating Meter Charges[14] | Currency | DLR_Meter_Charge | 10 |
98 | Originating_Meter_Charge_15 | Originating Meter Charges[15] | Currency | DLR_Meter_Charge | 10 |
99 | Originating_Meter_Charge_16 | Originating Meter Charges[16] | Currency | DLR_Meter_Charge | 10 |
100 | Originating_Meter_Charge_17 | Originating Meter Charges[17] | Currency | DLR_Meter_Charge | 10 |
101 | Originating_Meter_Charge_18 | Originating Meter Charges[18] | Currency | DLR_Meter_Charge | 10 |
102 | Originating_Meter_Charge_19 | Originating Meter Charges[19] | Currency | DLR_Meter_Charge | 10 |
103 | Originating_Meter_Charge_20 | Originating Meter Charges[20] | Currency | DLR_Meter_Charge | 10 |