SV_Technician_Shift_Exception_View (SV90300)

azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Shift_Exception_View (SV90300)

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

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

Display Name: SV_Technician_Shift_Exception_View
Physical Name: SV90300
Technical Name: SV_Technician_Shift_Exception_View

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Service_Call_ID SearchService Call IDSTR17_LBAUString1817
2Appointment SearchAppointmentSTR25String2625
3Appointment_Type SearchAppointment TypeDDL_Appointment_TypeInteger20
4Technician SearchTechnicianSTR10_LBAUString1210
5Skill_Level SearchSkill LevelSTR15_LBAUString1615
6Task_Date SearchTask DateDateDate410
7STRTTIME SearchStart TimeTM6Time46
8Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
9Technician_Status SearchTechnician StatusSTR17_LBAUString1817
10Appointment_Status SearchAppointment StatusSTR10_LBAUString1210
11Completion_Date SearchSV Completion DateDTDate48
12CREATDDT SearchCreated DateDTDate48
13CRUSRID SearchCreated User IDSTR15_User_IDString1615
14MODIFDT SearchModified DateDTDate48
15MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Technician_Shift_Exception_View'].MDFUSRID AS 'SV_Technician_Shift_Exception_View-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV90300 AS ['SV_Technician_Shift_Exception_View']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Technician_Shift_Exception_View'].MDFUSRID = ['Users Master'].USERID
16Modified_Time SearchModified TimeTM6Time46
17USERDEF1 SearchUser Defined 1STR20String2220
18USERDEF2 SearchUser Defined 2STR20String2220
19UDCB1 SearchUser Defined CB 11CBBoolean20
20UDCB2 SearchUser Defined CB 21CBBoolean20
21USRDAT01 SearchUser Defined Date 1DTDate48
22USRDAT02 SearchUser Defined Date 2DTDate48
23UserDD1 SearchUser Defined Dollar 11DLR14_RBS0_STR$Currency1014
24UserDD2 SearchUser Defined Dollar 21DLR14_RBS0_STR$Currency1014
azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Shift_Exception_View (SV90300)

Leave a Reply

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