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 TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_CodeString1615
3WORKDYS SearchWork DaysCBBoolean20
4WORKDYS_1 SearchWork Days[1]CBBoolean20
5WORKDYS_2 SearchWork Days[2]CBBoolean20
6WORKDYS_3 SearchWork Days[3]CBBoolean20
7WORKDYS_4 SearchWork Days[4]CBBoolean20
8WORKDYS_5 SearchWork Days[5]CBBoolean20
9WORKDYS_6 SearchWork Days[6]CBBoolean20
10WORKDYS_7 SearchWork Days[7]CBBoolean20
11WORKSTRT SearchWork StartTM6Time46
12WORKSTRT_1 SearchWork Start[1]TM6Time46
13WORKSTRT_2 SearchWork Start[2]TM6Time46
14WORKSTRT_3 SearchWork Start[3]TM6Time46
15WORKSTRT_4 SearchWork Start[4]TM6Time46
16WORKSTRT_5 SearchWork Start[5]TM6Time46
17WORKSTRT_6 SearchWork Start[6]TM6Time46
18WORKSTRT_7 SearchWork Start[7]TM6Time46
19WORKEND SearchWork EndTM6Time46
20WORKEND_1 SearchWork End[1]TM6Time46
21WORKEND_2 SearchWork End[2]TM6Time46
22WORKEND_3 SearchWork End[3]TM6Time46
23WORKEND_4 SearchWork End[4]TM6Time46
24WORKEND_5 SearchWork End[5]TM6Time46
25WORKEND_6 SearchWork End[6]TM6Time46
26WORKEND_7 SearchWork End[7]TM6Time46
27LSTSRVDTE SearchLast Service DateDT_DateDate46
28SVCAREA SearchService AreaSTR10_LBAUString1210
29OFFID SearchOffice IDSTR10_LBAUString1210
30TECHID SearchTech IDSTR10_LBAUString1210
31TIMEZONE SearchTimeZoneSTR3_LBUString43
32SRVTYPE SearchService TypeSTR10_LBAUString1210
33Bill_To_Customer SearchBill To CustomerSTR15_RM_Customer_NumberString1615
34SVC_Address_Option SearchSVC_Address_OptionDDL_Address_OptionInteger20
35SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeSTR15_Address_CodeString1615
36SVC_PM_Date SearchSVC PM MonthSVC_DDL_MonthInteger20
37SVC_PM_Day SearchSVC PM DaySVC_PM_DayInteger22
38SVC_PM_Allowed SearchSVC PM AllowedCBBoolean20
39SVC_Allow_Contract_0_SOP SearchSVC Allow Contract 0 SOPCBBoolean20
40svcPreferredDay Searchsvc Preferred DayCBBoolean20
41svcPreferredDay_1 Searchsvc Preferred Day[1]CBBoolean20
42svcPreferredDay_2 Searchsvc Preferred Day[2]CBBoolean20
43svcPreferredDay_3 Searchsvc Preferred Day[3]CBBoolean20
44svcPreferredDay_4 Searchsvc Preferred Day[4]CBBoolean20
45svcPreferredDay_5 Searchsvc Preferred Day[5]CBBoolean20
46svcPreferredDay_6 Searchsvc Preferred Day[6]CBBoolean20
47svcPreferredDay_7 Searchsvc Preferred Day[7]CBBoolean20
48svcPreferredStartTime Searchsvc Preferred Start TimeTM6Time46
49svcPreferredStartTime_1 Searchsvc Preferred Start Time[1]TM6Time46
50svcPreferredStartTime_2 Searchsvc Preferred Start Time[2]TM6Time46
51svcPreferredStartTime_3 Searchsvc Preferred Start Time[3]TM6Time46
52svcPreferredStartTime_4 Searchsvc Preferred Start Time[4]TM6Time46
53svcPreferredStartTime_5 Searchsvc Preferred Start Time[5]TM6Time46
54svcPreferredStartTime_6 Searchsvc Preferred Start Time[6]TM6Time46
55svcPreferredStartTime_7 Searchsvc Preferred Start Time[7]TM6Time46
56svcPreferredEndTime Searchsvc Preferred End TimeTM6Time46
57svcPreferredEndTime_1 Searchsvc Preferred End Time[1]TM6Time46
58svcPreferredEndTime_2 Searchsvc Preferred End Time[2]TM6Time46
59svcPreferredEndTime_3 Searchsvc Preferred End Time[3]TM6Time46
60svcPreferredEndTime_4 Searchsvc Preferred End Time[4]TM6Time46
61svcPreferredEndTime_5 Searchsvc Preferred End Time[5]TM6Time46
62svcPreferredEndTime_6 Searchsvc Preferred End Time[6]TM6Time46
63svcPreferredEndTime_7 Searchsvc Preferred End Time[7]TM6Time46
64CNSOLDTD SearchConsolidatedCB_ConsolidatedBoolean20
65svcConsolidateContractIn SearchsvcConsolidateContractInvoiceCBBoolean20
66DEX_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)ProjectCustomer Site Extensions (SVC00950)

Leave a Reply

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