SV_Service_Appointments_MSTR (SV00301)

azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Appointments_MSTR (SV00301)

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

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

Display Name: SV_Service_Appointments_MSTR
Physical Name: SV00301
Technical Name: SV_Service_Appointments_MSTR

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
5WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
6WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
7Cost_Code_Alias SearchCost Code AliasSTR26String2826
8Appointment_Group_ID SearchAppointment Group IDSTR25String2625
9Appointment_Description SearchAppointment DescriptionSTR50String5250
10UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString86
11Skill_Level SearchSkill LevelSTR15_LBAUString1615
12Task_Date SearchTask DateDateDate410
13STRTTIME SearchStart TimeTM6Time46
14ENDTIME SearchEnd TimeTM6Time46
15Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
16Actual_Hours SearchActual HoursLI6_S2Long Integer46
17Technician_Status SearchTechnician StatusSTR17_LBAUString1817
18Appointment_Status SearchAppointment StatusSTR10_LBAUString1210
19Appointment_Priority SearchAppointment PrioritySTR2String42
20Completion_Date SearchSV Completion DateDTDate48
21Time_Entered_CB SearchTime_Entered_CBCB_Time_EnteredBoolean20
22Labor_Override SearchLabor OverrideCB_Labor_OverrideBoolean20
23Cancelled_Reason SearchCancelled ReasonSTR25String2625
24CREATDDT SearchCreated DateDTDate48
25CRUSRID SearchCreated User IDSTR15_User_IDString1615
26MODIFDT SearchModified DateDTDate48
27MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_Appointments_MSTR'].MDFUSRID AS 'SV_Service_Appointments_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00301 AS ['SV_Service_Appointments_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_Appointments_MSTR'].MDFUSRID = ['Users Master'].USERID
28Modified_Time SearchModified TimeTM6Time46
29USERDEF1 SearchUser Defined 1STR20String2220
30USERDEF2 SearchUser Defined 2STR20String2220
31UDCB1 SearchUser Defined CB 11CBBoolean20
32UDCB2 SearchUser Defined CB 21CBBoolean20
33USRDAT01 SearchUser Defined Date 1DTDate48
34USRDAT02 SearchUser Defined Date 2DTDate48
35UserDD1 SearchUser Defined Dollar 11DLR14_RBS0_STR$Currency1014
36UserDD2 SearchUser Defined Dollar 21DLR14_RBS0_STR$Currency1014
37Service_User_Define_1 SearchService User Define 1STR20String2220
38Service_User_Define_2 SearchService User Define 2STR20String2220
39Service_User_Define_3 SearchService User Define 3STR30String3230
40Service_User_Define_4 SearchService User Define 4STR30String3230
41Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
42Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
43Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer46
44Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer46
45Service_User_Define_9 SearchService User Define 9DTDate48
46Service_User_Define_10 SearchService User Define 10DTDate48
47Service_User_Define_11 SearchService User Define 11DTDate48
48Service_User_Define_12 SearchService User Define 12DTDate48
49Service_User_Define_18 SearchService User Define 18CBBoolean20
50Service_User_Define_19 SearchService User Define 19CBBoolean20
51Service_User_Define_20 SearchService User Define 20CBBoolean20
52Service_User_Define_21 SearchService User Define 21CBBoolean20
53SV_Tool_ID SearchSV_Tool_IDLI6_ULong Integer40
azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Appointments_MSTR (SV00301)

Leave a Reply

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