SV_Appointment_History_MSTR (SV30301)

azurecurveProductsWennSoft Products (131)3rd PartySV_Appointment_History_MSTR (SV30301)

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

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

Display Name: SV_Appointment_History_MSTR
Physical Name: SV30301
Technical Name: SV_Appointment_History_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1WS_Appointment_ID SearchWS Appointment IDLong IntLong Integer48
2Appointment_Action SearchAppointment ActionSTR17_LBAUString1817
3Service_Call_ID SearchService Call IDSTR17_LBAUString1817
4Appointment SearchAppointmentSTR25String2625
5Appointment_Type SearchAppointment TypeDDL_Appointment_TypeInteger20
6Appointment_Priority SearchAppointment PrioritySTR2String42
7Technician SearchTechnicianSTR10_LBAUString1210
8Skill_Level SearchSkill LevelSTR15_LBAUString1615
9Task_Date SearchTask DateDateDate410
10STRTTIME SearchStart TimeTM6Time46
11ENDTIME SearchEnd TimeTM6Time46
12Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
13Actual_Hours SearchActual HoursLI6_S2Long Integer46
14Technician_Status SearchTechnician StatusSTR17_LBAUString1817
15Appointment_Status SearchAppointment StatusSTR10_LBAUString1210
16Status_Date SearchStatus_DateDTDate48
17Status_Time SearchStatus_TimeTM6Time46
18Completion_Date SearchSV Completion DateDTDate48
19Time_Entered_CB SearchTime_Entered_CBCB_Time_EnteredBoolean20
20Labor_Override SearchLabor OverrideCB_Labor_OverrideBoolean20
21CREATDDT SearchCreated DateDTDate48
22CRUSRID SearchCreated User IDSTR15_User_IDString1615
23MODIFDT SearchModified DateDTDate48
24MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Appointment_History_MSTR'].MDFUSRID AS 'SV_Appointment_History_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV30301 AS ['SV_Appointment_History_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Appointment_History_MSTR'].MDFUSRID = ['Users Master'].USERID
25Modified_Time SearchModified TimeTM6Time46
26USERDEF1 SearchUser Defined 1STR20String2220
27USERDEF2 SearchUser Defined 2STR20String2220
28UDCB1 SearchUser Defined CB 11CBBoolean20
29UDCB2 SearchUser Defined CB 21CBBoolean20
30USRDAT01 SearchUser Defined Date 1DTDate48
31USRDAT02 SearchUser Defined Date 2DTDate48
32UserDD1 SearchUser Defined Dollar 11DLR14_RBS0_STR$Currency1014
33UserDD2 SearchUser Defined Dollar 21DLR14_RBS0_STR$Currency1014
34SV_Tool_ID SearchSV_Tool_IDLI6_ULong Integer40
azurecurveProductsWennSoft Products (131)3rd PartySV_Appointment_History_MSTR (SV30301)

Leave a Reply

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