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: Project

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 NumberSTR15_RM_Customer_NumberString15
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 CodeSTR15_Address_CodeString15
3WORKDYS SearchWork DaysCBBoolean0
4WORKDYS_1 SearchWork Days[1]CBBoolean0
5WORKDYS_2 SearchWork Days[2]CBBoolean0
6WORKDYS_3 SearchWork Days[3]CBBoolean0
7WORKDYS_4 SearchWork Days[4]CBBoolean0
8WORKDYS_5 SearchWork Days[5]CBBoolean0
9WORKDYS_6 SearchWork Days[6]CBBoolean0
10WORKDYS_7 SearchWork Days[7]CBBoolean0
11WORKSTRT SearchWork StartTM6Time6
12WORKSTRT_1 SearchWork Start[1]TM6Time6
13WORKSTRT_2 SearchWork Start[2]TM6Time6
14WORKSTRT_3 SearchWork Start[3]TM6Time6
15WORKSTRT_4 SearchWork Start[4]TM6Time6
16WORKSTRT_5 SearchWork Start[5]TM6Time6
17WORKSTRT_6 SearchWork Start[6]TM6Time6
18WORKSTRT_7 SearchWork Start[7]TM6Time6
19WORKEND SearchWork EndTM6Time6
20WORKEND_1 SearchWork End[1]TM6Time6
21WORKEND_2 SearchWork End[2]TM6Time6
22WORKEND_3 SearchWork End[3]TM6Time6
23WORKEND_4 SearchWork End[4]TM6Time6
24WORKEND_5 SearchWork End[5]TM6Time6
25WORKEND_6 SearchWork End[6]TM6Time6
26WORKEND_7 SearchWork End[7]TM6Time6
27LSTSRVDTE SearchLast Service DateDT_DateDate6
28SVCAREA SearchService AreaSTR10_LBAUString10
29OFFID SearchOffice IDSTR10_LBAUString10
30TECHID SearchTech IDSTR10_LBAUString10
31TIMEZONE SearchTimeZoneSTR3_LBUString3
32SRVTYPE SearchService TypeSTR10_LBAUString10
33Bill_To_Customer SearchBill To CustomerSTR15_RM_Customer_NumberString15
34SVC_Address_Option SearchSVC_Address_OptionDDL_Address_OptionInteger0
35SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeSTR15_Address_CodeString15
36SVC_PM_Date SearchSVC PM MonthSVC_DDL_MonthInteger0
37SVC_PM_Day SearchSVC PM DaySVC_PM_DayInteger2
38SVC_PM_Allowed SearchSVC PM AllowedCBBoolean0
39SVC_Allow_Contract_0_SOP SearchSVC Allow Contract 0 SOPCBBoolean0
40svcPreferredDay Searchsvc Preferred DayCBBoolean0
41svcPreferredDay_1 Searchsvc Preferred Day[1]CBBoolean0
42svcPreferredDay_2 Searchsvc Preferred Day[2]CBBoolean0
43svcPreferredDay_3 Searchsvc Preferred Day[3]CBBoolean0
44svcPreferredDay_4 Searchsvc Preferred Day[4]CBBoolean0
45svcPreferredDay_5 Searchsvc Preferred Day[5]CBBoolean0
46svcPreferredDay_6 Searchsvc Preferred Day[6]CBBoolean0
47svcPreferredDay_7 Searchsvc Preferred Day[7]CBBoolean0
48svcPreferredStartTime Searchsvc Preferred Start TimeTM6Time6
49svcPreferredStartTime_1 Searchsvc Preferred Start Time[1]TM6Time6
50svcPreferredStartTime_2 Searchsvc Preferred Start Time[2]TM6Time6
51svcPreferredStartTime_3 Searchsvc Preferred Start Time[3]TM6Time6
52svcPreferredStartTime_4 Searchsvc Preferred Start Time[4]TM6Time6
53svcPreferredStartTime_5 Searchsvc Preferred Start Time[5]TM6Time6
54svcPreferredStartTime_6 Searchsvc Preferred Start Time[6]TM6Time6
55svcPreferredStartTime_7 Searchsvc Preferred Start Time[7]TM6Time6
56svcPreferredEndTime Searchsvc Preferred End TimeTM6Time6
57svcPreferredEndTime_1 Searchsvc Preferred End Time[1]TM6Time6
58svcPreferredEndTime_2 Searchsvc Preferred End Time[2]TM6Time6
59svcPreferredEndTime_3 Searchsvc Preferred End Time[3]TM6Time6
60svcPreferredEndTime_4 Searchsvc Preferred End Time[4]TM6Time6
61svcPreferredEndTime_5 Searchsvc Preferred End Time[5]TM6Time6
62svcPreferredEndTime_6 Searchsvc Preferred End Time[6]TM6Time6
63svcPreferredEndTime_7 Searchsvc Preferred End Time[7]TM6Time6
64CNSOLDTD SearchConsolidatedCB_ConsolidatedBoolean0
65svcConsolidateContractIn SearchsvcConsolidateContractInvoiceCBBoolean0
66DEX_ROW_ID Searchintint10

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)ProjectCustomer Site Extensions (SVC00950)

Leave a Reply

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