Customer Site Extensions (SVC00950)

azurecurveProductsFieldService (949)ProjectCustomer Site Extensions (SVC00950)

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

Product: FieldService (949)
Series:

Display Name: Customer Site Extensions
Physical Name: SVC00950
Technical Name: SVC_Customer_Site_Ext

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Customer Site Extensions'].CUSTNMBR AS 'Customer Site Extensions-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC00950 AS ['Customer Site Extensions']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Customer Site Extensions'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
3WORKDYS SearchWork DaysCBBoolean0
4WORKDYS_1 SearchWork Days[1]BooleanCB0
5WORKDYS_2 SearchWork Days[2]BooleanCB0
6WORKDYS_3 SearchWork Days[3]BooleanCB0
7WORKDYS_4 SearchWork Days[4]BooleanCB0
8WORKDYS_5 SearchWork Days[5]BooleanCB0
9WORKDYS_6 SearchWork Days[6]BooleanCB0
10WORKDYS_7 SearchWork Days[7]BooleanCB0
11WORKSTRT_1 SearchWork Start[1]TimeTM66
12WORKSTRT_2 SearchWork Start[2]TimeTM66
13WORKSTRT SearchWork StartTM6Time6
14WORKSTRT_3 SearchWork Start[3]TimeTM66
15WORKSTRT_4 SearchWork Start[4]TimeTM66
16WORKSTRT_5 SearchWork Start[5]TimeTM66
17WORKSTRT_6 SearchWork Start[6]TimeTM66
18WORKSTRT_7 SearchWork Start[7]TimeTM66
19WORKEND_1 SearchWork End[1]TimeTM66
20WORKEND_2 SearchWork End[2]TimeTM66
21WORKEND SearchWork EndTM6Time6
22WORKEND_3 SearchWork End[3]TimeTM66
23WORKEND_4 SearchWork End[4]TimeTM66
24WORKEND_5 SearchWork End[5]TimeTM66
25WORKEND_6 SearchWork End[6]TimeTM66
26WORKEND_7 SearchWork End[7]TimeTM66
27LSTSRVDTE SearchLast Service DateDateDT_Date6
28SVCAREA SearchService AreaStringSTR10_LBAU10
29OFFID SearchOffice IDStringSTR10_LBAU10
30TECHID SearchTech IDStringSTR10_LBAU10
31TIMEZONE SearchTimeZoneStringSTR3_LBU3
32SRVTYPE SearchService TypeStringSTR10_LBAU10
33Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
34SVC_Address_Option SearchSVC_Address_OptionIntegerDDL_Address_Option0
35SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeStringSTR15_Address_Code15
36SVC_PM_Date SearchSVC PM MonthIntegerSVC_DDL_Month0
37SVC_PM_Day SearchSVC PM DayIntegerSVC_PM_Day2
38SVC_PM_Allowed SearchSVC PM AllowedBooleanCB0
39SVC_Allow_Contract_0_SOP SearchSVC Allow Contract 0 SOPBooleanCB0
40svcPreferredDay_1 Searchsvc Preferred Day[1]BooleanCB0
41svcPreferredDay_2 Searchsvc Preferred Day[2]BooleanCB0
42svcPreferredDay_3 Searchsvc Preferred Day[3]BooleanCB0
43svcPreferredDay_4 Searchsvc Preferred Day[4]BooleanCB0
44svcPreferredDay Searchsvc Preferred DayCBBoolean0
45svcPreferredDay_5 Searchsvc Preferred Day[5]BooleanCB0
46svcPreferredDay_6 Searchsvc Preferred Day[6]BooleanCB0
47svcPreferredDay_7 Searchsvc Preferred Day[7]BooleanCB0
48svcPreferredStartTime_1 Searchsvc Preferred Start Time[1]TimeTM66
49svcPreferredStartTime_2 Searchsvc Preferred Start Time[2]TimeTM66
50svcPreferredStartTime_3 Searchsvc Preferred Start Time[3]TimeTM66
51svcPreferredStartTime_4 Searchsvc Preferred Start Time[4]TimeTM66
52svcPreferredStartTime_5 Searchsvc Preferred Start Time[5]TimeTM66
53svcPreferredStartTime Searchsvc Preferred Start TimeTM6Time6
54svcPreferredStartTime_6 Searchsvc Preferred Start Time[6]TimeTM66
55svcPreferredStartTime_7 Searchsvc Preferred Start Time[7]TimeTM66
56svcPreferredEndTime_1 Searchsvc Preferred End Time[1]TimeTM66
57svcPreferredEndTime_2 Searchsvc Preferred End Time[2]TimeTM66
58svcPreferredEndTime_3 Searchsvc Preferred End Time[3]TimeTM66
59svcPreferredEndTime_4 Searchsvc Preferred End Time[4]TimeTM66
60svcPreferredEndTime_5 Searchsvc Preferred End Time[5]TimeTM66
61svcPreferredEndTime Searchsvc Preferred End TimeTM6Time6
62svcPreferredEndTime_6 Searchsvc Preferred End Time[6]TimeTM66
63svcPreferredEndTime_7 Searchsvc Preferred End Time[7]TimeTM66
64CNSOLDTD SearchConsolidatedBooleanCB_Consolidated0
65svcConsolidateContractIn SearchsvcConsolidateContractInvoiceBooleanCB0
azurecurveProductsFieldService (949)ProjectCustomer Site Extensions (SVC00950)

Leave a Reply

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