SV_User_Preference_MSTR (SV00910)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_User_Preference_MSTR
Physical Name: SV00910
Technical Name: SV_User_Preference_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
2Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
3Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
4USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_User_Preference_MSTR'].USERID AS 'SV_User_Preference_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00910 AS ['SV_User_Preference_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_User_Preference_MSTR'].USERID = ['Users Master'].USERID
5Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
6Technician_Team SearchTechnician TeamSTR15_LBAUString1615
7Technician SearchTechnicianSTR10_LBAUString1210
8Service_Area SearchService AreaSTR15_LBAUString1615
9USERNAME SearchUser NameSTR30String3230
10Network_User_Name SearchNetwork User NameSTR255String256255
11Security_Level SearchSecurity LevelSTR15_LBAUString1615
12WS_Preference_Affiliate SearchWS Preference AffiliateSTR15_LBAUString1615
13WS_Preference_Region SearchWS Preference RegionSTR15_LBAUString1615
14WS_Preference_Branch SearchWS Preference BranchSTR15_LBAUString1615
15STRTDATE SearchStart DateDTDate48
16ENDDATE SearchEnd DateDTDate48
17Type_Call_Short SearchType Call ShortSTR3_LBAUString43
18Type_of_Call SearchType of CallSTR15String1615
19Status_of_Call SearchStatus of CallSTR10_LBAUString1210
20Appointment_Status SearchAppointment StatusSTR10_LBAUString1210
21Service_Call_Check_Box SearchService Call Check BoxCB_Service_CallBoolean20
22Closed_Call_Check_Box SearchClosed Call Check BoxCB_Closed_CallBoolean20
23Completed_Call_Check_Box SearchCompleted Call Check BoxCB_Completed_CallBoolean20
24MC_Call_Check_Box SearchMC Call Check BoxCB_MC_CallsBoolean20
25MCC_Call_Check_Box SearchMCC Call Check BoxCB_MCC_CallBoolean20
26Job_Check_Box SearchJob Check BoxCB_JobBoolean20
27Activity_Check_Box SearchActivity Check BoxCB_ActivityBoolean20
28Quote_Check_Box SearchQuote Check BoxQuote_CBBoolean20
29Billable_Check_Box SearchBillable Check BoxCB_BillableBoolean20
30Priority SearchPriorityINT5Integer24
31PriorityUpDown SearchPriorityUpDownINT5Integer24
32Meter_Checkbox SearchMeter CheckboxCBBoolean20
33Wennbox1 SearchWennbox1CBBoolean20
34Wennbox2 SearchWennbox2CBBoolean20
35Wenngroup1 SearchWenngroup1GBInteger20
36Wenngroup2 SearchWenngroup2GBInteger20
37EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
38VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SV_User_Preference_MSTR'].VENDORID AS 'SV_User_Preference_MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SV00910 AS ['SV_User_Preference_MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SV_User_Preference_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
39CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_User_Preference_MSTR'].CUSTNMBR AS 'SV_User_Preference_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV00910 AS ['SV_User_Preference_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_User_Preference_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
40User_Define_1a SearchUser Define 1aSTR30String3230
41User_Define_2a SearchUser Define 2aSTR30String3230
42MODIFDT SearchModified DateDTDate48
43Modified_Time SearchModified TimeTM6Time46
44MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_User_Preference_MSTR'].MDFUSRID AS 'SV_User_Preference_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00910 AS ['SV_User_Preference_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_User_Preference_MSTR'].MDFUSRID = ['Users Master'].USERID
45Time_Zone SearchTime ZoneSTR3String43
46Time_Zone_Tag SearchTime Zone TagSTR4String64
47SV_Language_ID SearchSV Language IDINT2Integer22
48WSReserved_CB1 SearchWSReserved CB1CBBoolean20
49WSReserved_CB2 SearchWSReserved CB2CBBoolean20
50WSReserved_CB3 SearchWSReserved CB3CBBoolean20
51WSReserved_CB4 SearchWSReserved CB4CBBoolean20
52WSReserved_CB5 SearchWSReserved CB5CBBoolean20
53WSReserved_STR1 SearchWSReserved STR1STR10String1210
54WSReserved_STR2 SearchWSReserved STR2STR10String1210
55Allow_Cust_Add SearchAllow Cust AddCBBoolean20
56Allow_Equipment_Add SearchAllow Equipment AddCBBoolean20
57Allow_MC_Add SearchAllow MC AddCBBoolean20
58Allow_Cust_Contract_Add SearchAllow Cust Contract AddCBBoolean20
59Allow_Global_Cust_Add SearchAllow Global Cust AddCBBoolean20
60Edit_Globl_Rec_Id_Filtrs SearchEdit Global Record Identification FiltersCBBoolean20
61Allow_Cust_Location_Add SearchAllow Customer Location AddCBBoolean20
62Create_Calls_SV_Requests SearchSV_Create_Calls_Service_RequestsCBBoolean20
63Service_Option_Box_1 SearchService Option Box 1CBBoolean20
64Service_Option_Box_2 SearchService Option Box 2CBBoolean20
65Service_Option_Box_3 SearchService Option Box 3CBBoolean20
66Service_Option_Box_4 SearchService Option Box 4CBBoolean20
67Service_Option_Box_5 SearchService Option Box 5CBBoolean20
68Service_Option_Box_6 SearchService Option Box 6CBBoolean20
69Service_Option_Box_7 SearchService Option Box 7CBBoolean20
70Service_Option_Box_8 SearchService Option Box 8CBBoolean20
71Service_Option_Box_9 SearchService Option Box 9CBBoolean20
72Service_Option_Box_10 SearchService Option Box 10CBBoolean20

Leave a Reply

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