SV_Lookup_Tech_MSTR (SV00115)

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

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

Display Name: SV_Lookup_Tech_MSTR
Physical Name: SV00115
Technical Name: SV_Lookup_Tech_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Technician SearchTechnicianSTR10_LBAUString10
2Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
3Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
4Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
5USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Lookup_Tech_MSTR'].USERID AS 'SV_Lookup_Tech_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00115 AS ['SV_Lookup_Tech_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Lookup_Tech_MSTR'].USERID = ['Users Master'].USERID
6Technician_ID SearchTechnician IDSTR15_Employee_IDString15
7Technician_Team SearchTechnician TeamSTR15_LBAUString15
8Technician_Long_Name SearchTechnician Long NameSTR30String30
9EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
10VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SV_Lookup_Tech_MSTR'].VENDORID AS 'SV_Lookup_Tech_MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SV00115 AS ['SV_Lookup_Tech_MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SV_Lookup_Tech_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
11Vendor_Switch SearchVendor SwitchCBBoolean0
12RDC_Access_Number SearchRDC Access NumberSTR14_PhoneString14
13Pager_Number SearchPager NumberSTR14_PhoneString14
14Primary_Skill_Level SearchPrimary Skill LevelSTR15_LBAUString15
15Employee_Vehicle SearchEmployee VehicleSTR15_LBAUString15
16EPACertification SearchEPACertificationSTR50String50
17MODIFDT SearchModified DateDTDate8
18Modified_Time SearchModified TimeTM6Time6
19MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Lookup_Tech_MSTR'].MDFUSRID AS 'SV_Lookup_Tech_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00115 AS ['SV_Lookup_Tech_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Lookup_Tech_MSTR'].MDFUSRID = ['Users Master'].USERID
20Time_Zone SearchTime ZoneSTR3String3
21Time_Zone_Tag SearchTime Zone TagSTR4String4
22SV_Language_ID SearchSV Language IDINT2Integer2
23WSReserved_CB1 SearchWSReserved CB1CBBoolean0
24WSReserved_CB2 SearchWSReserved CB2CBBoolean0
25WSReserved_CB3 SearchWSReserved CB3CBBoolean0
26WSReserved_CB4 SearchWSReserved CB4CBBoolean0
27WSReserved_CB5 SearchWSReserved CB5CBBoolean0
28WSReserved_CB6 SearchWSReserved CB6CBBoolean0
29WSReserved_CB7 SearchWSReserved CB7CBBoolean0
30WSReserved_CB8 SearchWSReserved CB8CBBoolean0
31WSReserved_CB9 SearchWSReserved CB9CBBoolean0
32WSReserved_CB10 SearchWSReserved CB10CBBoolean0
33WSReserved_STR1 SearchWSReserved STR1STR10String10
34WSReserved_STR2 SearchWSReserved STR2STR10String10
35Allowable_Overtime_Hours SearchAllowable Overtime HoursINT2_U0Integer2
36SV_Inactive SearchSV InactiveCB_InactiveBoolean0
37SV_Pager_PIN SearchSV_Pager_PINSTR40_LBString40
38SV_Pager_Vendor_ID SearchSV Pager Vendor IDSTR10_LBAUString10

Leave a Reply

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