SVC_Codes_Contract_Type (SVC00602)

azurecurveProductsFieldService (949)ProjectSVC_Codes_Contract_Type (SVC00602)

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

Product: FieldService (949)
Series: Project

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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CNTTYPE SearchContract TypeSTR10_LBAUString1210
2CNTTYPDESC SearchContract Type DescriptionSTR30String3230
3SRVTYPE SearchService TypeSTR10_LBAUString1210
4GL_Prepaid_Account SearchGL Prepaid Account IndexLI_14Long Integer414
5GL_Service_Account SearchGL Service Account IndexLI_14Long Integer414
6ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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
7USECVPD SearchUse Coverage PeriodCB_DayBoolean20
8USECVPD_1 SearchUse Coverage Period[1]CB_DayBoolean20
9USECVPD_2 SearchUse Coverage Period[2]CB_DayBoolean20
10USECVPD_3 SearchUse Coverage Period[3]CB_DayBoolean20
11USECVPD_4 SearchUse Coverage Period[4]CB_DayBoolean20
12USECVPD_5 SearchUse Coverage Period[5]CB_DayBoolean20
13USECVPD_6 SearchUse Coverage Period[6]CB_DayBoolean20
14USECVPD_7 SearchUse Coverage Period[7]CB_DayBoolean20
15Contract_Coverage_Period SearchContract Coverage Periods EndTM6Time46
16Contract_Coverage_Period_1 SearchContract Coverage Periods End[1]TM6Time46
17Contract_Coverage_Period_2 SearchContract Coverage Periods End[2]TM6Time46
18Contract_Coverage_Period_3 SearchContract Coverage Periods End[3]TM6Time46
19Contract_Coverage_Period_4 SearchContract Coverage Periods End[4]TM6Time46
20Contract_Coverage_Period_5 SearchContract Coverage Periods End[5]TM6Time46
21Contract_Coverage_Period_6 SearchContract Coverage Periods End[6]TM6Time46
22Contract_Coverage_Period_7 SearchContract Coverage Periods End[7]TM6Time46
23CNTCOVPD SearchContract Coverage Periods StartTM6Time46
24CNTCOVPD_1 SearchContract Coverage Periods Start[1]TM6Time46
25CNTCOVPD_2 SearchContract Coverage Periods Start[2]TM6Time46
26CNTCOVPD_3 SearchContract Coverage Periods Start[3]TM6Time46
27CNTCOVPD_4 SearchContract Coverage Periods Start[4]TM6Time46
28CNTCOVPD_5 SearchContract Coverage Periods Start[5]TM6Time46
29CNTCOVPD_6 SearchContract Coverage Periods Start[6]TM6Time46
30CNTCOVPD_7 SearchContract Coverage Periods Start[7]TM6Time46
31Grace_Days SearchGrace DaysINT3_U0Integer23
32Meter_Bases SearchMeter BasesLI_Meter_ReadingLong Integer48
33Meter_Bases_1 SearchMeter Bases[1]LI_Meter_ReadingLong Integer48
34Meter_Bases_2 SearchMeter Bases[2]LI_Meter_ReadingLong Integer48
35Meter_Bases_3 SearchMeter Bases[3]LI_Meter_ReadingLong Integer48
36Meter_Bases_4 SearchMeter Bases[4]LI_Meter_ReadingLong Integer48
37Meter_Bases_5 SearchMeter Bases[5]LI_Meter_ReadingLong Integer48
38Meter_Overages SearchMeter OveragesLI_Meter_ReadingLong Integer48
39Meter_Overages_1 SearchMeter Overages[1]LI_Meter_ReadingLong Integer48
40Meter_Overages_2 SearchMeter Overages[2]LI_Meter_ReadingLong Integer48
41Meter_Overages_3 SearchMeter Overages[3]LI_Meter_ReadingLong Integer48
42Meter_Overages_4 SearchMeter Overages[4]LI_Meter_ReadingLong Integer48
43Meter_Overages_5 SearchMeter Overages[5]LI_Meter_ReadingLong Integer48
44Meter_Overages_6 SearchMeter Overages[6]LI_Meter_ReadingLong Integer48
45Meter_Overages_7 SearchMeter Overages[7]LI_Meter_ReadingLong Integer48
46Meter_Overages_8 SearchMeter Overages[8]LI_Meter_ReadingLong Integer48
47Meter_Overages_9 SearchMeter Overages[9]LI_Meter_ReadingLong Integer48
48Meter_Overages_10 SearchMeter Overages[10]LI_Meter_ReadingLong Integer48
49Meter_Overages_11 SearchMeter Overages[11]LI_Meter_ReadingLong Integer48
50Meter_Overages_12 SearchMeter Overages[12]LI_Meter_ReadingLong Integer48
51Meter_Overages_13 SearchMeter Overages[13]LI_Meter_ReadingLong Integer48
52Meter_Overages_14 SearchMeter Overages[14]LI_Meter_ReadingLong Integer48
53Meter_Overages_15 SearchMeter Overages[15]LI_Meter_ReadingLong Integer48
54Meter_Overages_16 SearchMeter Overages[16]LI_Meter_ReadingLong Integer48
55Meter_Overages_17 SearchMeter Overages[17]LI_Meter_ReadingLong Integer48
56Meter_Overages_18 SearchMeter Overages[18]LI_Meter_ReadingLong Integer48
57Meter_Overages_19 SearchMeter Overages[19]LI_Meter_ReadingLong Integer48
58Meter_Overages_20 SearchMeter Overages[20]LI_Meter_ReadingLong Integer48
59Meter_Charges SearchMeter ChargesDLR_Meter_ChargeCurrency1010
60Meter_Charges_1 SearchMeter Charges[1]DLR_Meter_ChargeCurrency1010
61Meter_Charges_2 SearchMeter Charges[2]DLR_Meter_ChargeCurrency1010
62Meter_Charges_3 SearchMeter Charges[3]DLR_Meter_ChargeCurrency1010
63Meter_Charges_4 SearchMeter Charges[4]DLR_Meter_ChargeCurrency1010
64Meter_Charges_5 SearchMeter Charges[5]DLR_Meter_ChargeCurrency1010
65Meter_Charges_6 SearchMeter Charges[6]DLR_Meter_ChargeCurrency1010
66Meter_Charges_7 SearchMeter Charges[7]DLR_Meter_ChargeCurrency1010
67Meter_Charges_8 SearchMeter Charges[8]DLR_Meter_ChargeCurrency1010
68Meter_Charges_9 SearchMeter Charges[9]DLR_Meter_ChargeCurrency1010
69Meter_Charges_10 SearchMeter Charges[10]DLR_Meter_ChargeCurrency1010
70Meter_Charges_11 SearchMeter Charges[11]DLR_Meter_ChargeCurrency1010
71Meter_Charges_12 SearchMeter Charges[12]DLR_Meter_ChargeCurrency1010
72Meter_Charges_13 SearchMeter Charges[13]DLR_Meter_ChargeCurrency1010
73Meter_Charges_14 SearchMeter Charges[14]DLR_Meter_ChargeCurrency1010
74Meter_Charges_15 SearchMeter Charges[15]DLR_Meter_ChargeCurrency1010
75Meter_Charges_16 SearchMeter Charges[16]DLR_Meter_ChargeCurrency1010
76Meter_Charges_17 SearchMeter Charges[17]DLR_Meter_ChargeCurrency1010
77Meter_Charges_18 SearchMeter Charges[18]DLR_Meter_ChargeCurrency1010
78Meter_Charges_19 SearchMeter Charges[19]DLR_Meter_ChargeCurrency1010
79Meter_Charges_20 SearchMeter Charges[20]DLR_Meter_ChargeCurrency1010
80Meter_Expires SearchMeter ExpiresCBBoolean20
81Meter_Expires_1 SearchMeter Expires[1]CBBoolean20
82Meter_Expires_2 SearchMeter Expires[2]CBBoolean20
83Meter_Expires_3 SearchMeter Expires[3]CBBoolean20
84Meter_Expires_4 SearchMeter Expires[4]CBBoolean20
85Meter_Expires_5 SearchMeter Expires[5]CBBoolean20
86SVC_Invoice_Detail SearchSVC Invoice DetailCB_Invoice_DetailBoolean20
87PREPAID SearchPre PaidCBBoolean20
88SVC_Contract_Batch_ID SearchSVC Contract Batch IDSTR15_LBAUString1615
89SVC_Contract_Document_ID SearchSVC Contract Document IDSTR15_LBAUString1615
90Contract_Response_Time SearchContract Response TimeSTR_Bill_TimeString86
91SVC_Discount_Flag SearchSVC Discount FlagCBBoolean20
92SVC_Discount_Account SearchSVC Discount AccountLI_14Long Integer414
93SVC_C_Credit_Batch_ID SearchSVC C Credit Batch IDSTR15_LBAUString1615
94SVC_C_Credit_Document_ID SearchSVC C Credit Document IDSTR15_LBAUString1615
95priorityLevel SearchpriorityLevelINT4Integer24
96svcBillingExchangeRate SearchsvcBillingExchangeRatesvcExchangeRateUseInteger20
97svcRevenueExchangeRate SearchsvcRevenueExchangeRatesvcExchangeRateUseInteger20
98DEX_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_Codes_Contract_Type (SVC00602)

Leave a Reply

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