SV_Master_Contract_Financial_MSTR (SV00640)

azurecurveProductsWennSoft Products (131)3rd PartySV_Master_Contract_Financial_MSTR (SV00640)

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

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

Display Name: SV_Master_Contract_Financial_MSTR
Physical Name: SV00640
Technical Name: SV_Master_Contract_Financial_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Master_Contract_Financial_MSTR'].CUSTNMBR AS 'SV_Master_Contract_Financial_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV00640 AS ['SV_Master_Contract_Financial_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Master_Contract_Financial_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2Corporate_Contract_Nbr SearchCorporate Contract NumberSTR20_LBAUString20
3WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer10
4Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
5Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
6Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
7USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Master_Contract_Financial_MSTR'].USERID AS 'SV_Master_Contract_Financial_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00640 AS ['SV_Master_Contract_Financial_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Master_Contract_Financial_MSTR'].USERID = ['Users Master'].USERID
8Technician_ID SearchTechnician IDSTR15_Employee_IDString15
9Technician_Team SearchTechnician TeamSTR15_LBAUString15
10Forecast_Original_Equip SearchForecast Original EquipmentDLR14_RBS0_STR$Currency14
11Forecast_Original_Labor SearchForecast Original LaborDLR14_RBS0_STR$Currency14
12Fore_Orig_Material SearchForecast Original MaterialDLR14_RBS0_STR$Currency14
13Forecast_Original_Other SearchForecast Original OtherDLR14_RBS0_STR$Currency14
14Forecast_Original_Subs SearchForecast Original SubsDLR14_RBS0_STR$Currency14
15Forecast_Orig_Labor_1 SearchForecast Orig Labor 1DLR14_RBS0_STR$Currency14
16Forecast_Orig_Labor1_Hrs SearchForecast Orig Labor 1 HoursLI6_S2Long Integer6
17Forecast_Orig_Labor_2 SearchForecast Orig Labor 2DLR14_RBS0_STR$Currency14
18Fore_Orig_Labor_2_Hrs SearchForecast Orig Labor 2 HoursLI6_S2Long Integer6
19Forecast_Orig_Labor_3 SearchForecast Orig Labor 3DLR14_RBS0_STR$Currency14
20Forecast_Orig_Labor3_Hrs SearchForecast Orig Labor 3 HoursLI6_S2Long Integer6
21Forecast_Orig_Labor_4 SearchForecast Orig Labor 4DLR14_RBS0_STR$Currency14
22Forecast_Orig_Labor4_Hrs SearchForecast Orig Labor 4 HoursLI6_S2Long Integer6
23Forecast_Orig_Labor_5 SearchForecast Orig Labor 5DLR14_RBS0_STR$Currency14
24Forecast_Orig_Labor5_Hrs SearchForecast Orig Labor 5 HoursLI6_S2Long Integer6
25Forecast_Orig_Tot_Labor SearchForecast Orig Total LaborDLR14_RBS0_STR$Currency14
26Fore_Orig_Tot_Lbr_Hrs SearchForecast Orig Total Labor HrsLI6_S2Long Integer6
27Actual_Equipment SearchActual EquipmentDLR14_RBS0_STR$Currency14
28Actual_Labor SearchActual LaborDLR14_RBS0_STR$Currency14
29Actual_Material SearchActual MaterialDLR14_RBS0_STR$Currency14
30Actual_Subs SearchActual SubsDLR14_RBS0_STR$Currency14
31Actual_Other SearchActual OtherDLR14_RBS0_STR$Currency14
32Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency14
33Actual_Hours SearchActual HoursLI6_S2Long Integer6
34Actual_Labor_1 SearchActual Labor 1DLR14_RBS0_STR$Currency14
35Actual_Labor_1_Hours SearchActual Labor 1 HoursLI6_S2Long Integer6
36Actual_Labor_2 SearchActual Labor 2DLR14_RBS0_STR$Currency14
37Actual_Labor_2_Hours SearchActual Labor 2 HoursLI6_S2Long Integer6
38Actual_Labor_3 SearchActual Labor 3DLR14_RBS0_STR$Currency14
39Actual_Labor_3_Hours SearchActual Labor 3 HoursLI6_S2Long Integer6
40Actual_Labor_4 SearchActual Labor 4DLR14_RBS0_STR$Currency14
41Actual_Labor_4_Hours SearchActual Labor 4 HoursLI6_S2Long Integer6
42Actual_Labor_5 SearchActual Labor 5DLR14_RBS0_STR$Currency14
43Actual_Labor_5_Hours SearchActual Labor 5 HoursLI6_S2Long Integer6
44Actual_Total_Labor SearchActual Total LaborDLR14_RBS0_STR$Currency14
45Actual_Total_Labor_Hrs SearchActual Total Labor HrsLI6_S2Long Integer6
46Total_Cost_Tax SearchTotal Cost TaxDLR11_$S2Currency14
47Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency14
48Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency14
49Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency14
50Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency14
51Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency14
52Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency14
53Estimate_Hours SearchEstimate HoursLI6_S2Long Integer6
54Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency14
55Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer6
56Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency14
57Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer6
58Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency14
59Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer6
60Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency14
61Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer6
62Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency14
63Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer6
64Estimate_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency14
65Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer6
66Forecast_Equipment SearchForecast EquipmentDLR14_RBS0_STR$Currency14
67Forecast_Material SearchForecast MaterialDLR14_RBS0_STR$Currency14
68Forecast_Labor SearchForecast LaborDLR14_RBS0_STR$Currency14
69Forecast_Subs SearchForecast SubsDLR14_RBS0_STR$Currency14
70Forecast_Other SearchForecast OtherDLR14_RBS0_STR$Currency14
71Forecast_Total_Cost SearchForecast Total CostDLR14_RBS0_STR$Currency14
72Forecast_Hours SearchForecast HoursLI6_S2Long Integer6
73Forecast_Labor_1 SearchForecast Labor 1DLR14_RBS0_STR$Currency14
74Forecast_Labor_1_Hours SearchForecast Labor 1 HoursLI6_S2Long Integer6
75Forecast_Labor_2 SearchForecast Labor 2DLR14_RBS0_STR$Currency14
76Forecast_Labor_2_Hours SearchForecast Labor 2 HoursLI6_S2Long Integer6
77Forecast_Labor_3 SearchForecast Labor 3DLR14_RBS0_STR$Currency14
78Forecast_Labor_3_Hours SearchForecast Labor 3 HoursLI6_S2Long Integer6
79Forecast_Labor_4 SearchForecast Labor 4DLR14_RBS0_STR$Currency14
80Forecast_Labor_4_Hours SearchForecast Labor 4 HoursLI6_S2Long Integer6
81Forecast_Labor_5 SearchForecast Labor 5DLR14_RBS0_STR$Currency14
82Forecast_Labor_5_Hours SearchForecast Labor 5 HoursLI6_S2Long Integer6
83Forecast_Total_Labor SearchForecast Total LaborDLR14_RBS0_STR$Currency14
84Forecast_Total_Labor_Hrs SearchForecast Total Labor HrsLI6_S2Long Integer6
85PY_Labor SearchPY LaborDLR14_RBS0_STR$Currency14
86PY_Material SearchPY MaterialDLR14_RBS0_STR$Currency14
87PY_Equipment SearchPY EquipmentDLR14_RBS0_STR$Currency14
88PY_Subcontractor SearchPY SubcontractorDLR14_RBS0_STR$Currency14
89PY_Other SearchPY OtherDLR14_RBS0_STR$Currency14
90PY_Total_Cost SearchPY Total CostDLR14_RBS0_STR$Currency14
91PY_Billed SearchPY BilledDLR14_RBS0_STR$Currency14
92PY_Contract_Earned SearchPY Contract EarnedDLR14_RBS0_STR$Currency14
93PY_Gross_Profit SearchPY Gross ProfitDLR14_RBS0_STR$Currency14
94PY_Revenue_Recognized SearchPY Revenue RecognizedDLR14_RBS0_STR$Currency14
95PY_Hours SearchPY HoursLI6_S2Long Integer6
96PY_Labor_1 SearchPY Labor 1DLR14_RBS0_STR$Currency14
97PY_Labor_1_Hours SearchPY Labor 1 HoursLI6_S2Long Integer6
98PY_Labor_2 SearchPY Labor 2DLR14_RBS0_STR$Currency14
99PY_Labor_2_Hours SearchPY Labor 2 HoursLI6_S2Long Integer6
100PY_Labor_3 SearchPY Labor 3DLR14_RBS0_STR$Currency14
101PY_Labor_3_Hours SearchPY Labor 3 HoursLI6_S2Long Integer6
102PY_Labor_4 SearchPY Labor 4DLR14_RBS0_STR$Currency14
103PY_Labor_4_Hours SearchPY Labor 4 HoursLI6_S2Long Integer6
104PY_Labor_5 SearchPY Labor 5DLR14_RBS0_STR$Currency14
105PY_Labor_5_Hours SearchPY Labor 5 HoursLI6_S2Long Integer6
106PY_Total_Labor SearchPY Total LaborDLR14_RBS0_STR$Currency14
107PY_Total_Labor_Hrs SearchPY Total Labor HrsLI6_S2Long Integer6
108YTD_Labor SearchYTD LaborDLR14_RBS0_STR$Currency14
109YTD_Material SearchYTD MaterialDLR14_RBS0_STR$Currency14
110YTD_Equipment SearchYTD EquipmentDLR14_RBS0_STR$Currency14
111YTD_Subcontractor SearchYTD SubcontractorDLR14_RBS0_STR$Currency14
112YTD_Other SearchYTD OtherDLR14_RBS0_STR$Currency14
113YTD_Total_Cost SearchYTD Total CostDLR14_RBS0_STR$Currency14
114YTD_Billed SearchYTD BilledDLR14_RBS0_STR$Currency14
115YTD_Contract_Earned SearchYTD Contract EarnedDLR14_RBS0_STR$Currency14
116YTD_Gross_Profit SearchYTD Gross ProfitDLR14_RBS0_STR$Currency14
117YTD_Revenue_Recognized SearchYTD Revenue RecognizedDLR14_RBS0_STR$Currency14
118YTDHOURS SearchYTD HoursLI6_S2Long Integer6
119YTD_Labor_1 SearchYTD Labor 1DLR14_RBS0_STR$Currency14
120YTD_Labor_1_Hours SearchYTD Labor 1 HoursLI6_S2Long Integer6
121YTD_Labor_2 SearchYTD Labor 2DLR14_RBS0_STR$Currency14
122YTD_Labor_2_Hours SearchYTD Labor 2 HoursLI6_S2Long Integer6
123YTD_Labor_3 SearchYTD Labor 3DLR14_RBS0_STR$Currency14
124YTD_Labor_3_Hours SearchYTD Labor 3 HoursLI6_S2Long Integer6
125YTD_Labor_4 SearchYTD Labor 4DLR14_RBS0_STR$Currency14
126YTD_Labor_4_Hours SearchYTD Labor 4 HoursLI6_S2Long Integer6
127YTD_Labor_5 SearchYTD Labor 5DLR14_RBS0_STR$Currency14
128YTD_Labor_5_Hours SearchYTD Labor 5 HoursLI6_S2Long Integer6
129YTD_Total_Labor SearchYTD Total LaborDLR14_RBS0_STR$Currency14
130YTD_Total_Labor_Hrs SearchYTD Total Labor HrsLI6_S2Long Integer6
131TTD_Billed SearchTTD BilledDLR14_RBS0_STR$Currency14
132TTD_Contract_Earned SearchTTD Contract EarnedDLR14_RBS0_STR$Currency14
133TTD_Gross_Profit SearchTTD Gross ProfitDLR14_RBS0_STR$Currency14
134TTD_Revenue_Recognized SearchTTD Revenue RecognizedDLR14_RBS0_STR$Currency14
135Unbilled_Receivable SearchUnbilled ReceivableDLR14_RBS0_STR$Currency14
136Contract_NTE_Units SearchContract NTE UnitsLI8Long Integer8
137Contract_Actual_Units SearchContract Actual UnitsLI8Long Integer8
138MODIFDT SearchModified DateDTDate8
139Modified_Time SearchModified TimeTM6Time6
140MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Master_Contract_Financial_MSTR'].MDFUSRID AS 'SV_Master_Contract_Financial_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00640 AS ['SV_Master_Contract_Financial_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Master_Contract_Financial_MSTR'].MDFUSRID = ['Users Master'].USERID
141Service_User_Define_3 SearchService User Define 3STR30String30
142Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
143Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
144Service_User_Define_9 SearchService User Define 9DTDate8
145Service_User_Define_10 SearchService User Define 10DTDate8
146Service_User_Define_18 SearchService User Define 18CBBoolean0
147Service_User_Define_19 SearchService User Define 19CBBoolean0
148Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
149Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
150Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
151WSReserved_CB1 SearchWSReserved CB1CBBoolean0
152WSReserved_CB2 SearchWSReserved CB2CBBoolean0
153WSReserved_CB3 SearchWSReserved CB3CBBoolean0
154WSReserved_CB4 SearchWSReserved CB4CBBoolean0
155WSReserved_CB5 SearchWSReserved CB5CBBoolean0
156WSReserved_CB6 SearchWSReserved CB6CBBoolean0
157WSReserved_CB7 SearchWSReserved CB7CBBoolean0
158WSReserved_CB8 SearchWSReserved CB8CBBoolean0
159WSReserved_CB9 SearchWSReserved CB9CBBoolean0
160WSReserved_CB10 SearchWSReserved CB10CBBoolean0
161WSReserved_STR1 SearchWSReserved STR1STR10String10
162WSReserved_STR2 SearchWSReserved STR2STR10String10
azurecurveProductsWennSoft Products (131)3rd PartySV_Master_Contract_Financial_MSTR (SV00640)

Leave a Reply

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