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:

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 TypeLength
1CNTTYPE SearchContract TypeStringSTR10_LBAU10
2CNTTYPDESC SearchContract Type DescriptionStringSTR3030
3SRVTYPE SearchService TypeStringSTR10_LBAU10
4GL_Prepaid_Account SearchGL Prepaid Account IndexLong IntegerLI_1414
5GL_Service_Account SearchGL Service Account IndexLong IntegerLI_1414
6ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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_1 SearchUse Coverage Period[1]BooleanCB_Day0
8USECVPD SearchUse Coverage PeriodCB_DayBoolean0
9USECVPD_2 SearchUse Coverage Period[2]BooleanCB_Day0
10USECVPD_3 SearchUse Coverage Period[3]BooleanCB_Day0
11USECVPD_4 SearchUse Coverage Period[4]BooleanCB_Day0
12USECVPD_5 SearchUse Coverage Period[5]BooleanCB_Day0
13USECVPD_6 SearchUse Coverage Period[6]BooleanCB_Day0
14USECVPD_7 SearchUse Coverage Period[7]BooleanCB_Day0
15Contract_Coverage_Period_1 SearchContract Coverage Periods End[1]TimeTM66
16Contract_Coverage_Period_2 SearchContract Coverage Periods End[2]TimeTM66
17Contract_Coverage_Period SearchContract Coverage Periods EndTM6Time6
18Contract_Coverage_Period_3 SearchContract Coverage Periods End[3]TimeTM66
19Contract_Coverage_Period_4 SearchContract Coverage Periods End[4]TimeTM66
20Contract_Coverage_Period_5 SearchContract Coverage Periods End[5]TimeTM66
21Contract_Coverage_Period_6 SearchContract Coverage Periods End[6]TimeTM66
22Contract_Coverage_Period_7 SearchContract Coverage Periods End[7]TimeTM66
23CNTCOVPD_1 SearchContract Coverage Periods Start[1]TimeTM66
24CNTCOVPD_2 SearchContract Coverage Periods Start[2]TimeTM66
25CNTCOVPD_3 SearchContract Coverage Periods Start[3]TimeTM66
26CNTCOVPD SearchContract Coverage Periods StartTM6Time6
27CNTCOVPD_4 SearchContract Coverage Periods Start[4]TimeTM66
28CNTCOVPD_5 SearchContract Coverage Periods Start[5]TimeTM66
29CNTCOVPD_6 SearchContract Coverage Periods Start[6]TimeTM66
30CNTCOVPD_7 SearchContract Coverage Periods Start[7]TimeTM66
31Grace_Days SearchGrace DaysIntegerINT3_U03
32Meter_Bases_1 SearchMeter Bases[1]Long IntegerLI_Meter_Reading8
33Meter_Bases_2 SearchMeter Bases[2]Long IntegerLI_Meter_Reading8
34Meter_Bases_3 SearchMeter Bases[3]Long IntegerLI_Meter_Reading8
35Meter_Bases_4 SearchMeter Bases[4]Long IntegerLI_Meter_Reading8
36Meter_Bases SearchMeter BasesLI_Meter_ReadingLong Integer8
37Meter_Bases_5 SearchMeter Bases[5]Long IntegerLI_Meter_Reading8
38Meter_Overages_1 SearchMeter Overages[1]Long IntegerLI_Meter_Reading8
39Meter_Overages_2 SearchMeter Overages[2]Long IntegerLI_Meter_Reading8
40Meter_Overages_3 SearchMeter Overages[3]Long IntegerLI_Meter_Reading8
41Meter_Overages_4 SearchMeter Overages[4]Long IntegerLI_Meter_Reading8
42Meter_Overages SearchMeter OveragesLI_Meter_ReadingLong Integer8
43Meter_Overages_5 SearchMeter Overages[5]Long IntegerLI_Meter_Reading8
44Meter_Overages_6 SearchMeter Overages[6]Long IntegerLI_Meter_Reading8
45Meter_Overages_7 SearchMeter Overages[7]Long IntegerLI_Meter_Reading8
46Meter_Overages_8 SearchMeter Overages[8]Long IntegerLI_Meter_Reading8
47Meter_Overages_9 SearchMeter Overages[9]Long IntegerLI_Meter_Reading8
48Meter_Overages_10 SearchMeter Overages[10]Long IntegerLI_Meter_Reading8
49Meter_Overages_11 SearchMeter Overages[11]Long IntegerLI_Meter_Reading8
50Meter_Overages_12 SearchMeter Overages[12]Long IntegerLI_Meter_Reading8
51Meter_Overages_13 SearchMeter Overages[13]Long IntegerLI_Meter_Reading8
52Meter_Overages_14 SearchMeter Overages[14]Long IntegerLI_Meter_Reading8
53Meter_Overages_15 SearchMeter Overages[15]Long IntegerLI_Meter_Reading8
54Meter_Overages_16 SearchMeter Overages[16]Long IntegerLI_Meter_Reading8
55Meter_Overages_17 SearchMeter Overages[17]Long IntegerLI_Meter_Reading8
56Meter_Overages_18 SearchMeter Overages[18]Long IntegerLI_Meter_Reading8
57Meter_Overages_19 SearchMeter Overages[19]Long IntegerLI_Meter_Reading8
58Meter_Overages_20 SearchMeter Overages[20]Long IntegerLI_Meter_Reading8
59Meter_Charges_1 SearchMeter Charges[1]CurrencyDLR_Meter_Charge10
60Meter_Charges_2 SearchMeter Charges[2]CurrencyDLR_Meter_Charge10
61Meter_Charges_3 SearchMeter Charges[3]CurrencyDLR_Meter_Charge10
62Meter_Charges_4 SearchMeter Charges[4]CurrencyDLR_Meter_Charge10
63Meter_Charges_5 SearchMeter Charges[5]CurrencyDLR_Meter_Charge10
64Meter_Charges_6 SearchMeter Charges[6]CurrencyDLR_Meter_Charge10
65Meter_Charges SearchMeter ChargesDLR_Meter_ChargeCurrency10
66Meter_Charges_7 SearchMeter Charges[7]CurrencyDLR_Meter_Charge10
67Meter_Charges_8 SearchMeter Charges[8]CurrencyDLR_Meter_Charge10
68Meter_Charges_9 SearchMeter Charges[9]CurrencyDLR_Meter_Charge10
69Meter_Charges_10 SearchMeter Charges[10]CurrencyDLR_Meter_Charge10
70Meter_Charges_11 SearchMeter Charges[11]CurrencyDLR_Meter_Charge10
71Meter_Charges_12 SearchMeter Charges[12]CurrencyDLR_Meter_Charge10
72Meter_Charges_13 SearchMeter Charges[13]CurrencyDLR_Meter_Charge10
73Meter_Charges_14 SearchMeter Charges[14]CurrencyDLR_Meter_Charge10
74Meter_Charges_15 SearchMeter Charges[15]CurrencyDLR_Meter_Charge10
75Meter_Charges_16 SearchMeter Charges[16]CurrencyDLR_Meter_Charge10
76Meter_Charges_17 SearchMeter Charges[17]CurrencyDLR_Meter_Charge10
77Meter_Charges_18 SearchMeter Charges[18]CurrencyDLR_Meter_Charge10
78Meter_Charges_19 SearchMeter Charges[19]CurrencyDLR_Meter_Charge10
79Meter_Charges_20 SearchMeter Charges[20]CurrencyDLR_Meter_Charge10
80Meter_Expires_1 SearchMeter Expires[1]BooleanCB0
81Meter_Expires_2 SearchMeter Expires[2]BooleanCB0
82Meter_Expires_3 SearchMeter Expires[3]BooleanCB0
83Meter_Expires_4 SearchMeter Expires[4]BooleanCB0
84Meter_Expires_5 SearchMeter Expires[5]BooleanCB0
85SVC_Invoice_Detail SearchSVC Invoice DetailBooleanCB_Invoice_Detail0
86PREPAID SearchPre PaidBooleanCB0
87Meter_Expires SearchMeter ExpiresCBBoolean0
88SVC_Contract_Batch_ID SearchSVC Contract Batch IDStringSTR15_LBAU15
89SVC_Contract_Document_ID SearchSVC Contract Document IDStringSTR15_LBAU15
90Contract_Response_Time SearchContract Response TimeStringSTR_Bill_Time6
91SVC_Discount_Flag SearchSVC Discount FlagBooleanCB0
92SVC_Discount_Account SearchSVC Discount AccountLong IntegerLI_1414
93SVC_C_Credit_Batch_ID SearchSVC C Credit Batch IDStringSTR15_LBAU15
94SVC_C_Credit_Document_ID SearchSVC C Credit Document IDStringSTR15_LBAU15
95priorityLevel SearchpriorityLevelIntegerINT44
96svcBillingExchangeRate SearchsvcBillingExchangeRateIntegersvcExchangeRateUse0
97svcRevenueExchangeRate SearchsvcRevenueExchangeRateIntegersvcExchangeRateUse0
azurecurveProductsFieldService (949)ProjectSVC_Codes_Contract_Type (SVC00602)

Leave a Reply

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