SV_Service_Appointments_MSTR_Archive (SVA0301)

azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Appointments_MSTR_Archive (SVA0301)

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

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

Display Name: SV_Service_Appointments_MSTR_Archive
Physical Name: SVA0301
Technical Name: SV_Service_Appointments_MSTR_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Service_Call_ID SearchService Call IDSTR17_LBAUString17
2Appointment SearchAppointmentSTR25String25
3Appointment_Type SearchAppointment TypeDDL_Appointment_TypeInteger0
4Technician SearchTechnicianSTR10_LBAUString10
5WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer8
6WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
7Cost_Code_Alias SearchCost Code AliasSTR26String26
8Appointment_Group_ID SearchAppointment Group IDSTR25String25
9Appointment_Description SearchAppointment DescriptionSTR50String50
10UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString6
11Skill_Level SearchSkill LevelSTR15_LBAUString15
12Task_Date SearchTask DateDateDate10
13STRTTIME SearchStart TimeTM6Time6
14ENDTIME SearchEnd TimeTM6Time6
15Estimate_Hours SearchEstimate HoursLI6_S2Long Integer6
16Actual_Hours SearchActual HoursLI6_S2Long Integer6
17Technician_Status SearchTechnician StatusSTR17_LBAUString17
18Appointment_Status SearchAppointment StatusSTR10_LBAUString10
19Appointment_Priority SearchAppointment PrioritySTR2String2
20Completion_Date SearchSV Completion DateDTDate8
21Time_Entered_CB SearchTime_Entered_CBCB_Time_EnteredBoolean0
22Labor_Override SearchLabor OverrideCB_Labor_OverrideBoolean0
23Cancelled_Reason SearchCancelled ReasonSTR25String25
24CREATDDT SearchCreated DateDTDate8
25CRUSRID SearchCreated User IDSTR15_User_IDString15
26MODIFDT SearchModified DateDTDate8
27MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

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

Leave a Reply

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