SVC_Codes_Contract_Type (SVC00602)

azurecurve Products FieldService (949)ProjectSVC_Codes_Contract_Type (SVC00602)

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

Display Name: SVC_Codes_Contract_Type
Physical Name: SVC00602
Technical Name: SVC_Codes_Contract_Type

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CNTTYPE	Contract Type	String	STR10_LBAU	10
2	CNTTYPDESC	Contract Type Description	String	STR30	30
3	SRVTYPE	Service Type	String	STR10_LBAU	10
4	GL_Prepaid_Account	GL Prepaid Account Index	Long Integer	LI_14	14
5	GL_Service_Account	GL Service Account Index	Long Integer	LI_14	14
6	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SVC_Codes_Contract_Type'].ITEMNMBR AS 'SVC_Codes_Contract_Type-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC00602 AS ['SVC_Codes_Contract_Type'] INNER JOIN IV00101 AS ['Item Master'] ON ['SVC_Codes_Contract_Type'].ITEMNMBR = ['Item Master'].ITEMNMBR
7	USECVPD_1	Use Coverage Period[1]	Boolean	CB_Day	0
8	USECVPD	Use Coverage Period	CB_Day	Boolean	0
9	USECVPD_2	Use Coverage Period[2]	Boolean	CB_Day	0
10	USECVPD_3	Use Coverage Period[3]	Boolean	CB_Day	0
11	USECVPD_4	Use Coverage Period[4]	Boolean	CB_Day	0
12	USECVPD_5	Use Coverage Period[5]	Boolean	CB_Day	0
13	USECVPD_6	Use Coverage Period[6]	Boolean	CB_Day	0
14	USECVPD_7	Use Coverage Period[7]	Boolean	CB_Day	0
15	Contract_Coverage_Period_1	Contract Coverage Periods End[1]	Time	TM6	6
16	Contract_Coverage_Period_2	Contract Coverage Periods End[2]	Time	TM6	6
17	Contract_Coverage_Period	Contract Coverage Periods End	TM6	Time	6
18	Contract_Coverage_Period_3	Contract Coverage Periods End[3]	Time	TM6	6
19	Contract_Coverage_Period_4	Contract Coverage Periods End[4]	Time	TM6	6
20	Contract_Coverage_Period_5	Contract Coverage Periods End[5]	Time	TM6	6
21	Contract_Coverage_Period_6	Contract Coverage Periods End[6]	Time	TM6	6
22	Contract_Coverage_Period_7	Contract Coverage Periods End[7]	Time	TM6	6
23	CNTCOVPD_1	Contract Coverage Periods Start[1]	Time	TM6	6
24	CNTCOVPD_2	Contract Coverage Periods Start[2]	Time	TM6	6
25	CNTCOVPD_3	Contract Coverage Periods Start[3]	Time	TM6	6
26	CNTCOVPD	Contract Coverage Periods Start	TM6	Time	6
27	CNTCOVPD_4	Contract Coverage Periods Start[4]	Time	TM6	6
28	CNTCOVPD_5	Contract Coverage Periods Start[5]	Time	TM6	6
29	CNTCOVPD_6	Contract Coverage Periods Start[6]	Time	TM6	6
30	CNTCOVPD_7	Contract Coverage Periods Start[7]	Time	TM6	6
31	Grace_Days	Grace Days	Integer	INT3_U0	3
32	Meter_Bases_1	Meter Bases[1]	Long Integer	LI_Meter_Reading	8
33	Meter_Bases_2	Meter Bases[2]	Long Integer	LI_Meter_Reading	8
34	Meter_Bases_3	Meter Bases[3]	Long Integer	LI_Meter_Reading	8
35	Meter_Bases_4	Meter Bases[4]	Long Integer	LI_Meter_Reading	8
36	Meter_Bases	Meter Bases	LI_Meter_Reading	Long Integer	8
37	Meter_Bases_5	Meter Bases[5]	Long Integer	LI_Meter_Reading	8
38	Meter_Overages_1	Meter Overages[1]	Long Integer	LI_Meter_Reading	8
39	Meter_Overages_2	Meter Overages[2]	Long Integer	LI_Meter_Reading	8
40	Meter_Overages_3	Meter Overages[3]	Long Integer	LI_Meter_Reading	8
41	Meter_Overages_4	Meter Overages[4]	Long Integer	LI_Meter_Reading	8
42	Meter_Overages	Meter Overages	LI_Meter_Reading	Long Integer	8
43	Meter_Overages_5	Meter Overages[5]	Long Integer	LI_Meter_Reading	8
44	Meter_Overages_6	Meter Overages[6]	Long Integer	LI_Meter_Reading	8
45	Meter_Overages_7	Meter Overages[7]	Long Integer	LI_Meter_Reading	8
46	Meter_Overages_8	Meter Overages[8]	Long Integer	LI_Meter_Reading	8
47	Meter_Overages_9	Meter Overages[9]	Long Integer	LI_Meter_Reading	8
48	Meter_Overages_10	Meter Overages[10]	Long Integer	LI_Meter_Reading	8
49	Meter_Overages_11	Meter Overages[11]	Long Integer	LI_Meter_Reading	8
50	Meter_Overages_12	Meter Overages[12]	Long Integer	LI_Meter_Reading	8
51	Meter_Overages_13	Meter Overages[13]	Long Integer	LI_Meter_Reading	8
52	Meter_Overages_14	Meter Overages[14]	Long Integer	LI_Meter_Reading	8
53	Meter_Overages_15	Meter Overages[15]	Long Integer	LI_Meter_Reading	8
54	Meter_Overages_16	Meter Overages[16]	Long Integer	LI_Meter_Reading	8
55	Meter_Overages_17	Meter Overages[17]	Long Integer	LI_Meter_Reading	8
56	Meter_Overages_18	Meter Overages[18]	Long Integer	LI_Meter_Reading	8
57	Meter_Overages_19	Meter Overages[19]	Long Integer	LI_Meter_Reading	8
58	Meter_Overages_20	Meter Overages[20]	Long Integer	LI_Meter_Reading	8
59	Meter_Charges_1	Meter Charges[1]	Currency	DLR_Meter_Charge	10
60	Meter_Charges_2	Meter Charges[2]	Currency	DLR_Meter_Charge	10
61	Meter_Charges_3	Meter Charges[3]	Currency	DLR_Meter_Charge	10
62	Meter_Charges_4	Meter Charges[4]	Currency	DLR_Meter_Charge	10
63	Meter_Charges_5	Meter Charges[5]	Currency	DLR_Meter_Charge	10
64	Meter_Charges_6	Meter Charges[6]	Currency	DLR_Meter_Charge	10
65	Meter_Charges	Meter Charges	DLR_Meter_Charge	Currency	10
66	Meter_Charges_7	Meter Charges[7]	Currency	DLR_Meter_Charge	10
67	Meter_Charges_8	Meter Charges[8]	Currency	DLR_Meter_Charge	10
68	Meter_Charges_9	Meter Charges[9]	Currency	DLR_Meter_Charge	10
69	Meter_Charges_10	Meter Charges[10]	Currency	DLR_Meter_Charge	10
70	Meter_Charges_11	Meter Charges[11]	Currency	DLR_Meter_Charge	10
71	Meter_Charges_12	Meter Charges[12]	Currency	DLR_Meter_Charge	10
72	Meter_Charges_13	Meter Charges[13]	Currency	DLR_Meter_Charge	10
73	Meter_Charges_14	Meter Charges[14]	Currency	DLR_Meter_Charge	10
74	Meter_Charges_15	Meter Charges[15]	Currency	DLR_Meter_Charge	10
75	Meter_Charges_16	Meter Charges[16]	Currency	DLR_Meter_Charge	10
76	Meter_Charges_17	Meter Charges[17]	Currency	DLR_Meter_Charge	10
77	Meter_Charges_18	Meter Charges[18]	Currency	DLR_Meter_Charge	10
78	Meter_Charges_19	Meter Charges[19]	Currency	DLR_Meter_Charge	10
79	Meter_Charges_20	Meter Charges[20]	Currency	DLR_Meter_Charge	10
80	Meter_Expires_1	Meter Expires[1]	Boolean	CB	0
81	Meter_Expires_2	Meter Expires[2]	Boolean	CB	0
82	Meter_Expires_3	Meter Expires[3]	Boolean	CB	0
83	Meter_Expires_4	Meter Expires[4]	Boolean	CB	0
84	Meter_Expires_5	Meter Expires[5]	Boolean	CB	0
85	SVC_Invoice_Detail	SVC Invoice Detail	Boolean	CB_Invoice_Detail	0
86	PREPAID	Pre Paid	Boolean	CB	0
87	Meter_Expires	Meter Expires	CB	Boolean	0
88	SVC_Contract_Batch_ID	SVC Contract Batch ID	String	STR15_LBAU	15
89	SVC_Contract_Document_ID	SVC Contract Document ID	String	STR15_LBAU	15
90	Contract_Response_Time	Contract Response Time	String	STR_Bill_Time	6
91	SVC_Discount_Flag	SVC Discount Flag	Boolean	CB	0
92	SVC_Discount_Account	SVC Discount Account	Long Integer	LI_14	14
93	SVC_C_Credit_Batch_ID	SVC C Credit Batch ID	String	STR15_LBAU	15
94	SVC_C_Credit_Document_ID	SVC C Credit Document ID	String	STR15_LBAU	15
95	priorityLevel	priorityLevel	Integer	INT4	4
96	svcBillingExchangeRate	svcBillingExchangeRate	Integer	svcExchangeRateUse	0
97	svcRevenueExchangeRate	svcRevenueExchangeRate	Integer	svcExchangeRateUse	0

azurecurve Products FieldService (949)ProjectSVC_Codes_Contract_Type (SVC00602)

Click to show/hide

Leave a Reply Cancel reply