SVC_Contract_Line_Meter_HIST (SVC30607)

azurecurve Products FieldService (949)ProjectSVC_Contract_Line_Meter_HIST (SVC30607)

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

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 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_Startings_1	Meter Startings[1]	Long Integer	LI_Meter_Reading	8
70	Meter_Actuals	Meter Actuals	LI_Meter_Reading	Long Integer	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	Invoiced_Amount	Invoiced Amount	Currency	DLR19_$U2	19
77	Meter_Startings	Meter Startings	LI_Meter_Reading	Long Integer	8
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
104	SVC_Contract_Version	SVC_Contract_Version	Integer	INT3	3

azurecurve Products FieldService (949)ProjectSVC_Contract_Line_Meter_HIST (SVC30607)

Leave a Reply Cancel reply