SV_Equipment_Type_Task_Codes_MSTR_TRX (SV00538)

azurecurveProductsWennSoft Products (131)3rd PartySV_Equipment_Type_Task_Codes_MSTR_TRX (SV00538)

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

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

Display Name: SV_Equipment_Type_Task_Codes_MSTR_TRX
Physical Name: SV00538
Technical Name: SV_Equipment_Type_Task_Codes_MSTR_TRX

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Equipment_Type SearchEquipment TypeSTR30String3230
2Task_Code SearchTask CodeSTR10String1210
3Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
4Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
5Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
6USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Equipment_Type_Task_Codes_MSTR_TRX'].USERID AS 'SV_Equipment_Type_Task_Codes_MSTR_TRX-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00538 AS ['SV_Equipment_Type_Task_Codes_MSTR_TRX']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Equipment_Type_Task_Codes_MSTR_TRX'].USERID = ['Users Master'].USERID
7Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
8Technician_Team SearchTechnician TeamSTR15_LBAUString1615
9Subcontractor_ID SearchSubcontractor IDSTR15String1615
10System SearchWS SystemSTR15_LBAUString1615
11Major SearchWS MajorSTR15_LBAUString1615
12Sub_1 SearchSub 1STR15_LBAUString1615
13Sub_2 SearchSub 2STR15_LBAUString1615
14Sub_3 SearchSub 3STR15_LBAUString1615
15Sub_4 SearchSub 4STR15_LBAUString1615
16Long_Task_Description SearchLong Task DescriptionSTR10_LBAUString1210
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_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency1014
34Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer46
35Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
36Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
37Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
38Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
39Frequency SearchWS FrequencySTR15_LBAUString1615
40Schedule SearchScheduleINT3Integer23
41Optional SearchOptionalBooleanBoolean20
42Skill_Level SearchSkill LevelSTR15_LBAUString1615
43Schedule_Date SearchSchedule DateDATEDate46
44Completion_Date SearchSV Completion DateDTDate48
45Material_Kit_Required SearchMaterial Kit RequiredSTR30_Item_NumberString3230
46Material_Kit_Quantity SearchMaterial Kit QuantityLI_7Long Integer47
47Tool_Kit_Required SearchTool Kit RequiredSTR15_LBAUString1615
48Coverage_Code SearchCoverage CodeINT5_U0Integer25
49Task_User_Define1 SearchTask User Define1STR20String2220
50Task_User_Define2 SearchTask User Define2STR20String2220
51Task_User_Define3 SearchTask User Define3STR30String3230
52Task_User_Define4 SearchTask User Define4STR30String3230
53Task_User_Define5 SearchTask User Define5LI6_S2Long Integer46
54Task_User_Define6 SearchTask User Define6LI6_S2Long Integer46
55Task_User_Define7 SearchTask User Define7LI6_S2Long Integer46
56Task_User_Define8 SearchTask User Define8LI6_S2Long Integer46
57Task_User_Define9 SearchTask User Define9DTDate48
58Task_User_Define10 SearchTask User Define10DTDate48
59Task_User_Define11 SearchTask User Define11DTDate48
60Task_User_Define12 SearchTask User Define12DTDate48
61Task_User_Define13 SearchTask User Define13DLR14_RBS0_STR$Currency1014
62Task_User_Define14 SearchTask User Define14DLR14_RBS0_STR$Currency1014
63Task_User_Define15 SearchTask User Define15DLR14_RBS0_STR$Currency1014
64Task_User_Define16 SearchTask User Define16DLR14_RBS0_STR$Currency1014
65Task_User_Define17 SearchTask User Define17DLR14_RBS0_STR$Currency1014
66Task_User_Define18 SearchTask User Define18CBBoolean20
67Task_User_Define19 SearchTask User Define19CBBoolean20
68Task_User_Define20 SearchTask User Define20CBBoolean20
69Task_User_Define21 SearchTask User Define21CBBoolean20
70Task_Hours SearchTask HoursLI6_S2Long Integer46
71Jan_Required SearchJan RequiredCBBoolean20
72Jan_Completed SearchJan CompletedCBBoolean20
73Jan_Completed_Date SearchJan Completed DateDTDate48
74Jan_Service_ID SearchJan Service IDSTR17_LBAUString1817
75Jan_Est_Hours SearchJan Est HoursLI6_S2Long Integer46
76Feb_Required SearchFeb RequiredCBBoolean20
77Feb_Completed SearchFeb CompletedCBBoolean20
78Feb_Completed_Date SearchFeb Completed DateDTDate48
79Feb_Service_ID SearchFeb Service IDSTR17_LBAUString1817
80Feb_Est_Hours SearchFeb Est HoursLI6_S2Long Integer46
81March_Required SearchMarch RequiredCBBoolean20
82March_Completed SearchMarch CompletedCBBoolean20
83March_Completed_Date SearchMarch Completed DateDTDate48
84March_Service_ID SearchMarch Service IDSTR17_LBAUString1817
85March_Est_Hours SearchMarch Est HoursLI6_S2Long Integer46
86April_Required SearchApril RequiredCBBoolean20
87April_Completed SearchApril CompletedCBBoolean20
88April_Completed_Date SearchApril Completed DateDTDate48
89April_Service_ID SearchApril Service IDSTR17_LBAUString1817
90April_Est_Hours SearchApril Est HoursLI6_S2Long Integer46
91May_Required SearchMay RequiredCBBoolean20
92May_Completed SearchMay CompletedCBBoolean20
93May_Completed_Date SearchMay Completed DateDTDate48
94May_Service_ID SearchMay Service IDSTR17_LBAUString1817
95May_Est_Hours SearchMay Est HoursLI6_S2Long Integer46
96June_Required SearchJune RequiredCBBoolean20
97June_Completed SearchJune CompletedCBBoolean20
98June_Completed_Date SearchJune Completed DateDTDate48
99June_Service_ID SearchJune Service IDSTR17_LBAUString1817
100June_Est_Hours SearchJune Est HoursLI6_S2Long Integer46
101July_Required SearchJuly RequiredCBBoolean20
102July_Completed SearchJuly CompletedCBBoolean20
103July_Completed_Date SearchJuly Completed DateDTDate48
104July_Service_ID SearchJuly Service IDSTR17_LBAUString1817
105July_Est_Hours SearchJuly Est HoursLI6_S2Long Integer46
106Aug_Required SearchAug RequiredCBBoolean20
107Aug_Completed SearchAug CompletedCBBoolean20
108Aug_Completed_Date SearchAug Completed DateDTDate48
109Aug_Service_ID SearchAug Service IDSTR17_LBAUString1817
110Aug_Est_Hours SearchAug Est HoursLI6_S2Long Integer46
111Sept_Required SearchSept RequiredCBBoolean20
112Sept_Completed SearchSept CompletedCBBoolean20
113Sept_Completed_Date SearchSept Completed DateDTDate48
114Sept_Service_ID SearchSept Service IDSTR17_LBAUString1817
115Sept_Est_Hours SearchSept Est HoursLI6_S2Long Integer46
116Oct_Required SearchOct RequiredCBBoolean20
117Oct_Completed SearchOct CompletedCBBoolean20
118Oct_Completed_Date SearchOct Completed DateDTDate48
119Oct_Service_ID SearchOct Service IDSTR17_LBAUString1817
120Oct_Est_Hours SearchOct Est HoursLI6_S2Long Integer46
121Nov_Required SearchNov RequiredCBBoolean20
122Nov_Completed SearchNov CompletedCBBoolean20
123Nov_Completed_Date SearchNov Completed DateDTDate48
124Nov_Service_ID SearchNov Service IDSTR17_LBAUString1817
125Nov_Est_Hours SearchNov Est HoursLI6_S2Long Integer46
126Dec_Required SearchDec RequiredCBBoolean20
127Dec_Completed SearchDec CompletedCBBoolean20
128Dec_Completed_Date SearchDec Completed DateDTDate48
129Dec_Service_ID SearchDec Service IDSTR17_LBAUString1817
130Dec_Est_Hours SearchDec Est HoursLI6_S2Long Integer46
131Week_1 SearchWeek 1CBBoolean20
132Week_2 SearchWeek 2CBBoolean20
133Week_3 SearchWeek 3CBBoolean20
134Week_4 SearchWeek 4CBBoolean20
135Week_5 SearchWeek 5CBBoolean20
136MODIFDT SearchModified DateDTDate48
137Modified_Time SearchModified TimeTM6Time46
138MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Equipment_Type_Task_Codes_MSTR_TRX'].MDFUSRID AS 'SV_Equipment_Type_Task_Codes_MSTR_TRX-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00538 AS ['SV_Equipment_Type_Task_Codes_MSTR_TRX']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Equipment_Type_Task_Codes_MSTR_TRX'].MDFUSRID = ['Users Master'].USERID
139Time_Zone SearchTime ZoneSTR3String43
140SV_Language_ID SearchSV Language IDINT2Integer22
141Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
142Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
143Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
144WSReserved_CB1 SearchWSReserved CB1CBBoolean20
145WSReserved_CB2 SearchWSReserved CB2CBBoolean20
146WSReserved_CB3 SearchWSReserved CB3CBBoolean20
147WSReserved_CB4 SearchWSReserved CB4CBBoolean20
148WSReserved_CB5 SearchWSReserved CB5CBBoolean20
149WSReserved_CB6 SearchWSReserved CB6CBBoolean20
150WSReserved_CB7 SearchWSReserved CB7CBBoolean20
151WSReserved_CB8 SearchWSReserved CB8CBBoolean20
152WSReserved_CB9 SearchWSReserved CB9CBBoolean20
153WSReserved_CB10 SearchWSReserved CB10CBBoolean20
154WSReserved_STR1 SearchWSReserved STR1STR10String1210
155WSReserved_STR2 SearchWSReserved STR2STR10String1210
156PM_Group SearchPM GroupSTR3_LBAUString43
157ID_1 SearchID 1STR10_LBAUString1210
158ID_2 SearchID 2STR10_LBAUString1210
159YR_MOD SearchYR MODINT2Integer22
160YR_REM SearchYR REMINT2Integer22
161Auto_Date SearchAuto DateDATEDate46
azurecurveProductsWennSoft Products (131)3rd PartySV_Equipment_Type_Task_Codes_MSTR_TRX (SV00538)

Leave a Reply

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