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 TypeLength
1Service_Call_ID SearchService Call IDSTR17_LBAUString17
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
3Equipment_ID SearchEquipment IDSTR30String30
4Equipment_Type SearchEquipment TypeSTR30String30
5Manufacturer_ID SearchManufacturer IDSTR15_LBAUString15
6Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String20
7Wennsoft_Serial_Number SearchWennsoft Serial NumberSTR40String40
8Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
9Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
10Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
11USERID SearchUser IDSTR15_User_IDString15
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_IDString15
13Technician_Team SearchTechnician TeamSTR15_LBAUString15
14CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_CodeString15
16Priority_of_Call SearchPriority of CallSTR1String1
17Type_Call_Short SearchType Call ShortSTR3_LBAUString3
18Customer_Contract_Number SearchCustomer Contract NumberSTR15String15
19Contract_Number SearchWS Contract NumberSTR10String10
20SV_Language_ID SearchSV Language IDINT2Integer2
21Trouble_Code SearchTrouble CodeSTR10String10
22Resolution_Code SearchResolution CodeSTR10String10
23Estimate_Hours SearchEstimate HoursLI6_S2Long Integer6
24Estimate_Labor SearchEstimate LaborDLR14_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_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency14
36Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer6
37Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency14
38Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency14
39Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency14
40Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency14
41Actual_Equipment SearchActual EquipmentDLR14_RBS0_STR$Currency14
42Actual_Labor SearchActual LaborDLR14_RBS0_STR$Currency14
43Actual_Material SearchActual MaterialDLR14_RBS0_STR$Currency14
44Actual_Subs SearchActual SubsDLR14_RBS0_STR$Currency14
45Actual_Other SearchActual OtherDLR14_RBS0_STR$Currency14
46Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency14
47Actual_Hours SearchActual HoursLI6_S2Long Integer6
48Actual_Labor_1 SearchActual Labor 1DLR14_RBS0_STR$Currency14
49Actual_Labor_1_Hours SearchActual Labor 1 HoursLI6_S2Long Integer6
50Actual_Labor_2 SearchActual Labor 2DLR14_RBS0_STR$Currency14
51Actual_Labor_2_Hours SearchActual Labor 2 HoursLI6_S2Long Integer6
52Actual_Labor_3 SearchActual Labor 3DLR14_RBS0_STR$Currency14
53Actual_Labor_3_Hours SearchActual Labor 3 HoursLI6_S2Long Integer6
54Actual_Labor_4 SearchActual Labor 4DLR14_RBS0_STR$Currency14
55Actual_Labor_4_Hours SearchActual Labor 4 HoursLI6_S2Long Integer6
56Actual_Labor_5 SearchActual Labor 5DLR14_RBS0_STR$Currency14
57Actual_Labor_5_Hours SearchActual Labor 5 HoursLI6_S2Long Integer6
58Actual_Total_Labor SearchActual Total LaborDLR14_RBS0_STR$Currency14
59Actual_Total_Labor_Hrs SearchActual Total Labor HrsLI6_S2Long Integer6
60Billed_Hours SearchBilled HoursLI6_S2Long Integer6
61Billed_Labor SearchBilled LaborDLR11_$S2Currency14
62Billed_Material SearchBilled MaterialDLR11_$S2Currency14
63Billed_Other SearchBilled OtherDLR11_$S2Currency14
64Billed_Subs SearchBilled SubsDLR11_$S2Currency14
65Billed_Total_Cost SearchBilled Total CostDLR11_$S2Currency14
66Billed_Labor_1 SearchBilled Labor 1DLR11_$S2Currency14
67Billed_Labor_1_Hours SearchBilled Labor 1 HoursLI6_S2Long Integer6
68Billed_Labor_2 SearchBilled Labor 2DLR11_$S2Currency14
69Billed_Labor_2_Hours SearchBilled Labor 2 HoursLI6_S2Long Integer6
70Billed_Labor_3 SearchBilled Labor 3DLR11_$S2Currency14
71Billed_Labor_3_Hours SearchBilled Labor 3 HoursLI6_S2Long Integer6
72Billed_Labor_4 SearchBilled Labor 4DLR11_$S2Currency14
73Billed_Labor_4_Hours SearchBilled Labor 4 HoursLI6_S2Long Integer6
74Billed_Labor_5 SearchBilled Labor 5DLR11_$S2Currency14
75Billed_Labor_5_Hours SearchBilled Labor 5 HoursLI6_S2Long Integer6
76Billed_Total_Labor SearchBilled Total LaborDLR11_$S2Currency14
77Billed_Total_Labor_Hours SearchBilled Total Labor HoursLI6_S2Long Integer6
78Optional SearchOptionalBooleanBoolean0
79Skill_Level SearchSkill LevelSTR15_LBAUString15
80Schedule_Date SearchSchedule DateDATEDate6
81Completion_Date SearchSV Completion DateDTDate8
82Material_Kit_Required SearchMaterial Kit RequiredSTR30_Item_NumberString30
83Tool_Kit_Required SearchTool Kit RequiredSTR15_LBAUString15
84Service_User_Define_1 SearchService User Define 1STR20String20
85Service_User_Define_2 SearchService User Define 2STR20String20
86Service_User_Define_3 SearchService User Define 3STR30String30
87Service_User_Define_4 SearchService User Define 4STR30String30
88Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
89Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
90Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer6
91Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer6
92Service_User_Define_9 SearchService User Define 9DTDate8
93Service_User_Define_10 SearchService User Define 10DTDate8
94Service_User_Define_11 SearchService User Define 11DTDate8
95Service_User_Define_12 SearchService User Define 12DTDate8
96Service_User_Define_18 SearchService User Define 18CBBoolean0
97Service_User_Define_19 SearchService User Define 19CBBoolean0
98Service_User_Define_20 SearchService User Define 20CBBoolean0
99Service_User_Define_21 SearchService User Define 21CBBoolean0
100Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
101Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
102Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
103Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency14
104Subcontractor_ID SearchSubcontractor IDSTR15String15
105Technician_ID2 SearchTechnician ID2STR15_Employee_IDString15
106MODIFDT SearchModified DateDTDate8
107Modified_Time SearchModified TimeTM6Time6
108MDFUSRID SearchModified User IDSTR15String15
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 ZoneSTR3String3
110Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString15
111Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
112Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString15
113Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
114Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString15
115WSReserved_CB1 SearchWSReserved CB1CBBoolean0
116WSReserved_CB2 SearchWSReserved CB2CBBoolean0
117WSReserved_CB3 SearchWSReserved CB3CBBoolean0
118WSReserved_CB4 SearchWSReserved CB4CBBoolean0
119WSReserved_CB5 SearchWSReserved CB5CBBoolean0
120WSReserved_STR1 SearchWSReserved STR1STR10String10
121WSReserved_STR2 SearchWSReserved STR2STR10String10
azurecurveProductsWennSoft Products (131)3rd PartySV_Service_Assigned_Equipment_MSTR (sv00387)

Leave a Reply

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