SV_Service_Tasks_Equipment_MSTR_View (SV99302)

azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Tasks_Equipment_MSTR_View (SV99302)

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

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

Display Name: SV_Service_Tasks_Equipment_MSTR_View
Physical Name: SV99302
Technical Name: SV_Service_Tasks_Equipment_MSTR_View

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Service_Tasks_Equipment_MSTR_View'].CUSTNMBR AS 'SV_Service_Tasks_Equipment_MSTR_View-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV99302 AS ['SV_Service_Tasks_Equipment_MSTR_View']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Service_Tasks_Equipment_MSTR_View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
3Service_Call_ID SearchService Call IDSTR17_LBAUString1817
4Equipment_ID SearchEquipment IDSTR30String3230
5Wennsoft_Master_Equip_ID SearchWennsoft Master Equipment IDSTR30String3230
6CMPTFLAG SearchComponent FlagCB_Component_ItemBoolean20
7Task_Line_Number SearchTask Line NumberLI_Sequence_NumberLong Integer410
8Task_Code SearchTask CodeSTR10String1210
9Sub_Task_Line_Number SearchSub Task Line NumberLI_Sequence_NumberLong Integer410
10Sub_Task_Code SearchSub Task CodeSTR10String1210
11Task_List_ID SearchTask List IDSTR10_LBAUString1210
12Task_Description SearchTask DescriptionSTR60String6260
13Task_Description_Long SearchTask Description LongSTR255String256255
14Skill_Level SearchSkill LevelSTR15_LBAUString1615
15Location_Equipment SearchLocation EquipmentSTR50_LBUString5250
16Completion_Date SearchSV Completion DateDTDate48
17Resolution_Code SearchResolution CodeSTR10String1210
18Trouble_Code SearchTrouble CodeSTR10String1210
19Task_Status SearchTask StatusSTR10_LBAUString1210
20System SearchWS SystemSTR15_LBAUString1615
21Major SearchWS MajorSTR15_LBAUString1615
22Sub_1 SearchSub 1STR15_LBAUString1615
23Sub_2 SearchSub 2STR15_LBAUString1615
24Sub_3 SearchSub 3STR15_LBAUString1615
25Sub_4 SearchSub 4STR15_LBAUString1615
26Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
27Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
28Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency1014
29Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency1014
30Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
31Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
32Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
33Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency1014
34Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer46
35Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency1014
36Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer46
37Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency1014
38Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer46
39Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency1014
40Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer46
41Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency1014
42Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer46
43Billable_Equipment SearchBillable EquipmentDLR14_RBS0_STR$Currency1014
44Billable_Material SearchBillable MaterialDLR14_RBS0_STR$Currency1014
45Billable_Subs SearchBillable SubsDLR14_RBS0_STR$Currency1014
46Billable_Other SearchBillable OtherDLR14_RBS0_STR$Currency1014
47Billable_Labor_1 SearchBillable Labor 1DLR14_RBS0_STR$Currency1014
48Billable_Labor_2 SearchBillable Labor 2DLR14_RBS0_STR$Currency1014
49Billable_Labor_3 SearchBillable Labor 3DLR14_RBS0_STR$Currency1014
50Billable_Labor_4 SearchBillable Labor 4DLR14_RBS0_STR$Currency1014
51Billable_Labor_5 SearchBillable Labor 5DLR14_RBS0_STR$Currency1014
52Material_Kit_Required SearchMaterial Kit RequiredSTR30_Item_NumberString3230
53Material_Kit_Quantity SearchMaterial Kit QuantityLI_7Long Integer47
54Tool_Kit_Required SearchTool Kit RequiredSTR15_LBAUString1615
55SV_Actual_Time SearchSV Actual TimeLI6_S2Long Integer46
56Coverage_Code SearchCoverage CodeINT5_U0Integer25
57ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
58Equipment_Type SearchEquipment TypeSTR30String3230
59Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
60Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
61Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
62CREATDDT SearchCreated DateDTDate48
63CRUSRID SearchCreated User IDSTR15_User_IDString1615
64MODIFDT SearchModified DateDTDate48
65Modified_Time SearchModified TimeTM6Time46
66MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_Tasks_Equipment_MSTR_View'].MDFUSRID AS 'SV_Service_Tasks_Equipment_MSTR_View-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV99302 AS ['SV_Service_Tasks_Equipment_MSTR_View']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_Tasks_Equipment_MSTR_View'].MDFUSRID = ['Users Master'].USERID
67Time_Zone SearchTime ZoneSTR3String43
68Task_User_Define1 SearchTask User Define1STR20String2220
69Task_User_Define2 SearchTask User Define2STR20String2220
70Task_User_Define3 SearchTask User Define3STR30String3230
71Task_User_Define4 SearchTask User Define4STR30String3230
72Task_User_Define5 SearchTask User Define5LI6_S2Long Integer46
73Task_User_Define6 SearchTask User Define6LI6_S2Long Integer46
74Task_User_Define7 SearchTask User Define7LI6_S2Long Integer46
75Task_User_Define8 SearchTask User Define8LI6_S2Long Integer46
76Task_User_Define9 SearchTask User Define9DTDate48
77Task_User_Define10 SearchTask User Define10DTDate48
78Task_User_Define11 SearchTask User Define11DTDate48
79Task_User_Define12 SearchTask User Define12DTDate48
80Task_User_Define13 SearchTask User Define13DLR14_RBS0_STR$Currency1014
81Task_User_Define14 SearchTask User Define14DLR14_RBS0_STR$Currency1014
82Task_User_Define15 SearchTask User Define15DLR14_RBS0_STR$Currency1014
83Task_User_Define16 SearchTask User Define16DLR14_RBS0_STR$Currency1014
84Task_User_Define17 SearchTask User Define17DLR14_RBS0_STR$Currency1014
85Task_User_Define18 SearchTask User Define18CBBoolean20
86Task_User_Define19 SearchTask User Define19CBBoolean20
87Task_User_Define20 SearchTask User Define20CBBoolean20
88Task_User_Define21 SearchTask User Define21CBBoolean20
89Run_Units SearchRun UnitsDLR14_RBS0_STR$Currency1014
90Current_Run_Units SearchCurrent Run UnitsDLR14_RBS0_STR$Currency1014
91Last_Run_Units SearchLast Run UnitsDLR14_RBS0_STR$Currency1014
92User_Define_1a SearchUser Define 1aSTR30String3230
93Task_Comment_1 SearchTask Comment 1STR120String122120
94Task_Comment_2 SearchTask Comment 2STR120String122120
95Task_Comment_3 SearchTask Comment 3STR120String122120
96WSReserved_STR1 SearchWSReserved STR1STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Tasks_Equipment_MSTR_View (SV99302)

Leave a Reply

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