SV_Service_Assigned_Equipment_MSTR (sv00387)

azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Assigned_Equipment_MSTR (sv00387)

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

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

Display Name: SV_Service_Assigned_Equipment_MSTR
Physical Name: sv00387
Technical Name: SV_Service_Assigned_Equipment_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Service_Call_ID SearchService Call IDSTR17_LBAUString1817
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3Equipment_ID SearchEquipment IDSTR30String3230
4Equipment_Type SearchEquipment TypeSTR30String3230
5Manufacturer_ID SearchManufacturer IDSTR15_LBAUString1615
6Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String2220
7Wennsoft_Serial_Number SearchWennsoft Serial NumberSTR40String4240
8Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
9Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
10Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
11USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_Assigned_Equipment_MSTR'].USERID AS 'SV_Service_Assigned_Equipment_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       sv00387 AS ['SV_Service_Assigned_Equipment_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_Assigned_Equipment_MSTR'].USERID = ['Users Master'].USERID
12Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
13Technician_Team SearchTechnician TeamSTR15_LBAUString1615
14CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Service_Assigned_Equipment_MSTR'].CUSTNMBR AS 'SV_Service_Assigned_Equipment_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       sv00387 AS ['SV_Service_Assigned_Equipment_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Service_Assigned_Equipment_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
15ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
16Priority_of_Call SearchPriority of CallSTR1String21
17Type_Call_Short SearchType Call ShortSTR3_LBAUString43
18Customer_Contract_Number SearchCustomer Contract NumberSTR15String1615
19Contract_Number SearchWS Contract NumberSTR10String1210
20SV_Language_ID SearchSV Language IDINT2Integer22
21Trouble_Code SearchTrouble CodeSTR10String1210
22Resolution_Code SearchResolution CodeSTR10String1210
23Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
24Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency1014
25Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency1014
26Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer46
27Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency1014
28Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer46
29Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency1014
30Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer46
31Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency1014
32Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer46
33Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency1014
34Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer46
35Estimate_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency1014
36Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer46
37Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
38Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
39Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
40Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
41Actual_Equipment SearchActual EquipmentDLR14_RBS0_STR$Currency1014
42Actual_Labor SearchActual LaborDLR14_RBS0_STR$Currency1014
43Actual_Material SearchActual MaterialDLR14_RBS0_STR$Currency1014
44Actual_Subs SearchActual SubsDLR14_RBS0_STR$Currency1014
45Actual_Other SearchActual OtherDLR14_RBS0_STR$Currency1014
46Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency1014
47Actual_Hours SearchActual HoursLI6_S2Long Integer46
48Actual_Labor_1 SearchActual Labor 1DLR14_RBS0_STR$Currency1014
49Actual_Labor_1_Hours SearchActual Labor 1 HoursLI6_S2Long Integer46
50Actual_Labor_2 SearchActual Labor 2DLR14_RBS0_STR$Currency1014
51Actual_Labor_2_Hours SearchActual Labor 2 HoursLI6_S2Long Integer46
52Actual_Labor_3 SearchActual Labor 3DLR14_RBS0_STR$Currency1014
53Actual_Labor_3_Hours SearchActual Labor 3 HoursLI6_S2Long Integer46
54Actual_Labor_4 SearchActual Labor 4DLR14_RBS0_STR$Currency1014
55Actual_Labor_4_Hours SearchActual Labor 4 HoursLI6_S2Long Integer46
56Actual_Labor_5 SearchActual Labor 5DLR14_RBS0_STR$Currency1014
57Actual_Labor_5_Hours SearchActual Labor 5 HoursLI6_S2Long Integer46
58Actual_Total_Labor SearchActual Total LaborDLR14_RBS0_STR$Currency1014
59Actual_Total_Labor_Hrs SearchActual Total Labor HrsLI6_S2Long Integer46
60Billed_Hours SearchBilled HoursLI6_S2Long Integer46
61Billed_Labor SearchBilled LaborDLR11_$S2Currency1014
62Billed_Material SearchBilled MaterialDLR11_$S2Currency1014
63Billed_Other SearchBilled OtherDLR11_$S2Currency1014
64Billed_Subs SearchBilled SubsDLR11_$S2Currency1014
65Billed_Total_Cost SearchBilled Total CostDLR11_$S2Currency1014
66Billed_Labor_1 SearchBilled Labor 1DLR11_$S2Currency1014
67Billed_Labor_1_Hours SearchBilled Labor 1 HoursLI6_S2Long Integer46
68Billed_Labor_2 SearchBilled Labor 2DLR11_$S2Currency1014
69Billed_Labor_2_Hours SearchBilled Labor 2 HoursLI6_S2Long Integer46
70Billed_Labor_3 SearchBilled Labor 3DLR11_$S2Currency1014
71Billed_Labor_3_Hours SearchBilled Labor 3 HoursLI6_S2Long Integer46
72Billed_Labor_4 SearchBilled Labor 4DLR11_$S2Currency1014
73Billed_Labor_4_Hours SearchBilled Labor 4 HoursLI6_S2Long Integer46
74Billed_Labor_5 SearchBilled Labor 5DLR11_$S2Currency1014
75Billed_Labor_5_Hours SearchBilled Labor 5 HoursLI6_S2Long Integer46
76Billed_Total_Labor SearchBilled Total LaborDLR11_$S2Currency1014
77Billed_Total_Labor_Hours SearchBilled Total Labor HoursLI6_S2Long Integer46
78Optional SearchOptionalBooleanBoolean20
79Skill_Level SearchSkill LevelSTR15_LBAUString1615
80Schedule_Date SearchSchedule DateDATEDate46
81Completion_Date SearchSV Completion DateDTDate48
82Material_Kit_Required SearchMaterial Kit RequiredSTR30_Item_NumberString3230
83Tool_Kit_Required SearchTool Kit RequiredSTR15_LBAUString1615
84Service_User_Define_1 SearchService User Define 1STR20String2220
85Service_User_Define_2 SearchService User Define 2STR20String2220
86Service_User_Define_3 SearchService User Define 3STR30String3230
87Service_User_Define_4 SearchService User Define 4STR30String3230
88Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
89Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
90Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer46
91Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer46
92Service_User_Define_9 SearchService User Define 9DTDate48
93Service_User_Define_10 SearchService User Define 10DTDate48
94Service_User_Define_11 SearchService User Define 11DTDate48
95Service_User_Define_12 SearchService User Define 12DTDate48
96Service_User_Define_18 SearchService User Define 18CBBoolean20
97Service_User_Define_19 SearchService User Define 19CBBoolean20
98Service_User_Define_20 SearchService User Define 20CBBoolean20
99Service_User_Define_21 SearchService User Define 21CBBoolean20
100Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
101Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
102Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
103Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency1014
104Subcontractor_ID SearchSubcontractor IDSTR15String1615
105Technician_ID2 SearchTechnician ID2STR15_Employee_IDString1615
106MODIFDT SearchModified DateDTDate48
107Modified_Time SearchModified TimeTM6Time46
108MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_Assigned_Equipment_MSTR'].MDFUSRID AS 'SV_Service_Assigned_Equipment_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       sv00387 AS ['SV_Service_Assigned_Equipment_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_Assigned_Equipment_MSTR'].MDFUSRID = ['Users Master'].USERID
109Time_Zone SearchTime ZoneSTR3String43
110Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
111Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)1014
112Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
113Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)1014
114Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
115WSReserved_CB1 SearchWSReserved CB1CBBoolean20
116WSReserved_CB2 SearchWSReserved CB2CBBoolean20
117WSReserved_CB3 SearchWSReserved CB3CBBoolean20
118WSReserved_CB4 SearchWSReserved CB4CBBoolean20
119WSReserved_CB5 SearchWSReserved CB5CBBoolean20
120WSReserved_STR1 SearchWSReserved STR1STR10String1210
121WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Assigned_Equipment_MSTR (sv00387)

Leave a Reply

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