SV_Task_Codes_MSTR (SV00560)

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

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

Display Name: SV_Task_Codes_MSTR
Physical Name: SV00560
Technical Name: SV_Task_Codes_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Task_Code SearchTask CodeSTR10String10
2Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
3Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
4Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
5USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Task_Codes_MSTR'].USERID AS 'SV_Task_Codes_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00560 AS ['SV_Task_Codes_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Task_Codes_MSTR'].USERID = ['Users Master'].USERID
6Technician_ID SearchTechnician IDSTR15_Employee_IDString15
7Technician_Team SearchTechnician TeamSTR15_LBAUString15
8System SearchWS SystemSTR15_LBAUString15
9Major SearchWS MajorSTR15_LBAUString15
10Sub_1 SearchSub 1STR15_LBAUString15
11Sub_2 SearchSub 2STR15_LBAUString15
12Sub_3 SearchSub 3STR15_LBAUString15
13Sub_4 SearchSub 4STR15_LBAUString15
14ITEMTYPE SearchItem TypeDDL_Item_TypeInteger0
15Task_Description SearchTask DescriptionSTR60String60
16Task_Description_Long SearchTask Description LongSTR255String255
17SV_Language_ID SearchSV Language IDINT2Integer2
18Equipment_Type SearchEquipment TypeSTR30String30
19Estimate_Hours SearchEstimate HoursLI6_S2Long Integer6
20Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency14
21Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency14
22Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency14
23Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency14
24Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency14
25Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency14
26Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer6
27Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency14
28Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer6
29Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency14
30Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer6
31Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency14
32Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer6
33Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency14
34Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer6
35Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency14
36Billable_Equipment SearchBillable EquipmentDLR14_RBS0_STR$Currency14
37Billable_Material SearchBillable MaterialDLR14_RBS0_STR$Currency14
38Billable_Subs SearchBillable SubsDLR14_RBS0_STR$Currency14
39Billable_Other SearchBillable OtherDLR14_RBS0_STR$Currency14
40Billable_Labor_1 SearchBillable Labor 1DLR14_RBS0_STR$Currency14
41Billable_Labor_2 SearchBillable Labor 2DLR14_RBS0_STR$Currency14
42Billable_Labor_3 SearchBillable Labor 3DLR14_RBS0_STR$Currency14
43Billable_Labor_4 SearchBillable Labor 4DLR14_RBS0_STR$Currency14
44Billable_Labor_5 SearchBillable Labor 5DLR14_RBS0_STR$Currency14
45Run_Units SearchRun UnitsDLR14_RBS0_STR$Currency14
46Frequency SearchWS FrequencySTR15_LBAUString15
47Schedule SearchScheduleINT3Integer3
48Optional SearchOptionalBooleanBoolean0
49Skill_Level SearchSkill LevelSTR15_LBAUString15
50Material_Kit_Required SearchMaterial Kit RequiredSTR30_Item_NumberString30
51Material_Kit_Quantity SearchMaterial Kit QuantityLI_7Long Integer7
52Tool_Kit_Required SearchTool Kit RequiredSTR15_LBAUString15
53Coverage_Code SearchCoverage CodeINT5_U0Integer5
54Task_User_Define1 SearchTask User Define1STR20String20
55Task_User_Define2 SearchTask User Define2STR20String20
56Task_User_Define3 SearchTask User Define3STR30String30
57Task_User_Define4 SearchTask User Define4STR30String30
58Task_User_Define5 SearchTask User Define5LI6_S2Long Integer6
59Task_User_Define6 SearchTask User Define6LI6_S2Long Integer6
60Task_User_Define7 SearchTask User Define7LI6_S2Long Integer6
61Task_User_Define8 SearchTask User Define8LI6_S2Long Integer6
62Task_User_Define9 SearchTask User Define9DTDate8
63Task_User_Define10 SearchTask User Define10DTDate8
64Task_User_Define11 SearchTask User Define11DTDate8
65Task_User_Define12 SearchTask User Define12DTDate8
66Task_User_Define13 SearchTask User Define13DLR14_RBS0_STR$Currency14
67Task_User_Define14 SearchTask User Define14DLR14_RBS0_STR$Currency14
68Task_User_Define15 SearchTask User Define15DLR14_RBS0_STR$Currency14
69Task_User_Define16 SearchTask User Define16DLR14_RBS0_STR$Currency14
70Task_User_Define17 SearchTask User Define17DLR14_RBS0_STR$Currency14
71Task_User_Define18 SearchTask User Define18CBBoolean0
72Task_User_Define19 SearchTask User Define19CBBoolean0
73Task_User_Define20 SearchTask User Define20CBBoolean0
74Task_User_Define21 SearchTask User Define21CBBoolean0
75Task_Hours SearchTask HoursLI6_S2Long Integer6
76Week_1 SearchWeek 1CBBoolean0
77Week_2 SearchWeek 2CBBoolean0
78Week_3 SearchWeek 3CBBoolean0
79Week_4 SearchWeek 4CBBoolean0
80Week_5 SearchWeek 5CBBoolean0
81MODIFDT SearchModified DateDTDate8
82Modified_Time SearchModified TimeTM6Time6
83MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Task_Codes_MSTR'].MDFUSRID AS 'SV_Task_Codes_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00560 AS ['SV_Task_Codes_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Task_Codes_MSTR'].MDFUSRID = ['Users Master'].USERID
84Time_Zone SearchTime ZoneSTR3String3
85WSReserved_CB1 SearchWSReserved CB1CBBoolean0
86WSReserved_CB2 SearchWSReserved CB2CBBoolean0
87WSReserved_CB3 SearchWSReserved CB3CBBoolean0
88WSReserved_CB4 SearchWSReserved CB4CBBoolean0
89WSReserved_CB5 SearchWSReserved CB5CBBoolean0
90WSReserved_CB6 SearchWSReserved CB6CBBoolean0
91WSReserved_CB7 SearchWSReserved CB7CBBoolean0
92WSReserved_CB8 SearchWSReserved CB8CBBoolean0
93WSReserved_CB9 SearchWSReserved CB9CBBoolean0
94WSReserved_CB10 SearchWSReserved CB10CBBoolean0
95WSReserved_STR1 SearchWSReserved STR1STR10String10
96WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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