SV_Task_List_Tasks_MSTR (SV00592)

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

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

Display Name: SV_Task_List_Tasks_MSTR
Physical Name: SV00592
Technical Name: SV_Task_List_Tasks_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Task_List_ID SearchTask List IDSTR10_LBAUString1210
2Task_Code SearchTask CodeSTR10String1210
3Task_Line_Number SearchTask Line NumberLI_Sequence_NumberLong Integer410
4Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
5Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
6Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
7USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Task_List_Tasks_MSTR'].USERID AS 'SV_Task_List_Tasks_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00592 AS ['SV_Task_List_Tasks_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Task_List_Tasks_MSTR'].USERID = ['Users Master'].USERID
8Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
9Technician_Team SearchTechnician TeamSTR15_LBAUString1615
10Subcontractor_ID SearchSubcontractor IDSTR15String1615
11System SearchWS SystemSTR15_LBAUString1615
12Major SearchWS MajorSTR15_LBAUString1615
13Sub_1 SearchSub 1STR15_LBAUString1615
14Sub_2 SearchSub 2STR15_LBAUString1615
15Sub_3 SearchSub 3STR15_LBAUString1615
16Sub_4 SearchSub 4STR15_LBAUString1615
17Task_Description SearchTask DescriptionSTR60String6260
18Task_Description_Long SearchTask Description LongSTR255String256255
19Wennsoft_Close_Date SearchWennsoft Close DateDTDate48
20INACTIVE SearchInactiveCB_InactiveBoolean20
21Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
22Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency1014
23Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency1014
24Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer46
25Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency1014
26Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer46
27Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency1014
28Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer46
29Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency1014
30Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer46
31Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency1014
32Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer46
33Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency1014
34Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
35Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
36Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
37Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
38Billable_Equipment SearchBillable EquipmentDLR14_RBS0_STR$Currency1014
39Billable_Material SearchBillable MaterialDLR14_RBS0_STR$Currency1014
40Billable_Subs SearchBillable SubsDLR14_RBS0_STR$Currency1014
41Billable_Other SearchBillable OtherDLR14_RBS0_STR$Currency1014
42Billable_Labor_1 SearchBillable Labor 1DLR14_RBS0_STR$Currency1014
43Billable_Labor_2 SearchBillable Labor 2DLR14_RBS0_STR$Currency1014
44Billable_Labor_3 SearchBillable Labor 3DLR14_RBS0_STR$Currency1014
45Billable_Labor_4 SearchBillable Labor 4DLR14_RBS0_STR$Currency1014
46Billable_Labor_5 SearchBillable Labor 5DLR14_RBS0_STR$Currency1014
47Run_Units SearchRun UnitsDLR14_RBS0_STR$Currency1014
48Frequency SearchWS FrequencySTR15_LBAUString1615
49Schedule SearchScheduleINT3Integer23
50Optional SearchOptionalBooleanBoolean20
51Skill_Level SearchSkill LevelSTR15_LBAUString1615
52Schedule_Date SearchSchedule DateDATEDate46
53Completion_Date SearchSV Completion DateDTDate48
54Material_Kit_Required SearchMaterial Kit RequiredSTR30_Item_NumberString3230
55Material_Kit_Quantity SearchMaterial Kit QuantityLI_7Long Integer47
56Tool_Kit_Required SearchTool Kit RequiredSTR15_LBAUString1615
57Coverage_Code SearchCoverage CodeINT5_U0Integer25
58Task_User_Define1 SearchTask User Define1STR20String2220
59Task_User_Define2 SearchTask User Define2STR20String2220
60Task_User_Define3 SearchTask User Define3STR30String3230
61Task_User_Define4 SearchTask User Define4STR30String3230
62Task_User_Define5 SearchTask User Define5LI6_S2Long Integer46
63Task_User_Define6 SearchTask User Define6LI6_S2Long Integer46
64Task_User_Define7 SearchTask User Define7LI6_S2Long Integer46
65Task_User_Define8 SearchTask User Define8LI6_S2Long Integer46
66Task_User_Define9 SearchTask User Define9DTDate48
67Task_User_Define10 SearchTask User Define10DTDate48
68Task_User_Define11 SearchTask User Define11DTDate48
69Task_User_Define12 SearchTask User Define12DTDate48
70Task_User_Define13 SearchTask User Define13DLR14_RBS0_STR$Currency1014
71Task_User_Define14 SearchTask User Define14DLR14_RBS0_STR$Currency1014
72Task_User_Define15 SearchTask User Define15DLR14_RBS0_STR$Currency1014
73Task_User_Define16 SearchTask User Define16DLR14_RBS0_STR$Currency1014
74Task_User_Define17 SearchTask User Define17DLR14_RBS0_STR$Currency1014
75Task_User_Define18 SearchTask User Define18CBBoolean20
76Task_User_Define19 SearchTask User Define19CBBoolean20
77Task_User_Define20 SearchTask User Define20CBBoolean20
78Task_User_Define21 SearchTask User Define21CBBoolean20
79Task_Hours SearchTask HoursLI6_S2Long Integer46
80Week_1 SearchWeek 1CBBoolean20
81Week_2 SearchWeek 2CBBoolean20
82Week_3 SearchWeek 3CBBoolean20
83Week_4 SearchWeek 4CBBoolean20
84Week_5 SearchWeek 5CBBoolean20
85MODIFDT SearchModified DateDTDate48
86Modified_Time SearchModified TimeTM6Time46
87MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Task_List_Tasks_MSTR'].MDFUSRID AS 'SV_Task_List_Tasks_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00592 AS ['SV_Task_List_Tasks_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Task_List_Tasks_MSTR'].MDFUSRID = ['Users Master'].USERID
88Time_Zone SearchTime ZoneSTR3String43
89SV_Language_ID SearchSV Language IDINT2Integer22
90Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
91Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
92Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
93WSReserved_CB1 SearchWSReserved CB1CBBoolean20
94WSReserved_CB2 SearchWSReserved CB2CBBoolean20
95WSReserved_CB3 SearchWSReserved CB3CBBoolean20
96WSReserved_CB4 SearchWSReserved CB4CBBoolean20
97WSReserved_CB5 SearchWSReserved CB5CBBoolean20
98WSReserved_CB6 SearchWSReserved CB6CBBoolean20
99WSReserved_CB7 SearchWSReserved CB7CBBoolean20
100WSReserved_CB8 SearchWSReserved CB8CBBoolean20
101WSReserved_CB9 SearchWSReserved CB9CBBoolean20
102WSReserved_CB10 SearchWSReserved CB10CBBoolean20
103WSReserved_STR1 SearchWSReserved STR1STR10String1210
104WSReserved_STR2 SearchWSReserved STR2STR10String1210
105PM_Group SearchPM GroupSTR3_LBAUString43
106ID_1 SearchID 1STR10_LBAUString1210
107ID_2 SearchID 2STR10_LBAUString1210
108YR_MOD SearchYR MODINT2Integer22
109YR_REM SearchYR REMINT2Integer22
110Auto_Date SearchAuto DateDATEDate46

Leave a Reply

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