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 TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_LBAUString2220
3WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer410
4Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
5Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
6Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
7USERID SearchUser IDSTR15_User_IDString1615
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_IDString1615
9Technician_Team SearchTechnician TeamSTR15_LBAUString1615
10Forecast_Original_Equip SearchForecast Original EquipmentDLR14_RBS0_STR$Currency1014
11Forecast_Original_Labor SearchForecast Original LaborDLR14_RBS0_STR$Currency1014
12Fore_Orig_Material SearchForecast Original MaterialDLR14_RBS0_STR$Currency1014
13Forecast_Original_Other SearchForecast Original OtherDLR14_RBS0_STR$Currency1014
14Forecast_Original_Subs SearchForecast Original SubsDLR14_RBS0_STR$Currency1014
15Forecast_Orig_Labor_1 SearchForecast Orig Labor 1DLR14_RBS0_STR$Currency1014
16Forecast_Orig_Labor1_Hrs SearchForecast Orig Labor 1 HoursLI6_S2Long Integer46
17Forecast_Orig_Labor_2 SearchForecast Orig Labor 2DLR14_RBS0_STR$Currency1014
18Fore_Orig_Labor_2_Hrs SearchForecast Orig Labor 2 HoursLI6_S2Long Integer46
19Forecast_Orig_Labor_3 SearchForecast Orig Labor 3DLR14_RBS0_STR$Currency1014
20Forecast_Orig_Labor3_Hrs SearchForecast Orig Labor 3 HoursLI6_S2Long Integer46
21Forecast_Orig_Labor_4 SearchForecast Orig Labor 4DLR14_RBS0_STR$Currency1014
22Forecast_Orig_Labor4_Hrs SearchForecast Orig Labor 4 HoursLI6_S2Long Integer46
23Forecast_Orig_Labor_5 SearchForecast Orig Labor 5DLR14_RBS0_STR$Currency1014
24Forecast_Orig_Labor5_Hrs SearchForecast Orig Labor 5 HoursLI6_S2Long Integer46
25Forecast_Orig_Tot_Labor SearchForecast Orig Total LaborDLR14_RBS0_STR$Currency1014
26Fore_Orig_Tot_Lbr_Hrs SearchForecast Orig Total Labor HrsLI6_S2Long Integer46
27Actual_Equipment SearchActual EquipmentDLR14_RBS0_STR$Currency1014
28Actual_Labor SearchActual LaborDLR14_RBS0_STR$Currency1014
29Actual_Material SearchActual MaterialDLR14_RBS0_STR$Currency1014
30Actual_Subs SearchActual SubsDLR14_RBS0_STR$Currency1014
31Actual_Other SearchActual OtherDLR14_RBS0_STR$Currency1014
32Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency1014
33Actual_Hours SearchActual HoursLI6_S2Long Integer46
34Actual_Labor_1 SearchActual Labor 1DLR14_RBS0_STR$Currency1014
35Actual_Labor_1_Hours SearchActual Labor 1 HoursLI6_S2Long Integer46
36Actual_Labor_2 SearchActual Labor 2DLR14_RBS0_STR$Currency1014
37Actual_Labor_2_Hours SearchActual Labor 2 HoursLI6_S2Long Integer46
38Actual_Labor_3 SearchActual Labor 3DLR14_RBS0_STR$Currency1014
39Actual_Labor_3_Hours SearchActual Labor 3 HoursLI6_S2Long Integer46
40Actual_Labor_4 SearchActual Labor 4DLR14_RBS0_STR$Currency1014
41Actual_Labor_4_Hours SearchActual Labor 4 HoursLI6_S2Long Integer46
42Actual_Labor_5 SearchActual Labor 5DLR14_RBS0_STR$Currency1014
43Actual_Labor_5_Hours SearchActual Labor 5 HoursLI6_S2Long Integer46
44Actual_Total_Labor SearchActual Total LaborDLR14_RBS0_STR$Currency1014
45Actual_Total_Labor_Hrs SearchActual Total Labor HrsLI6_S2Long Integer46
46Total_Cost_Tax SearchTotal Cost TaxDLR11_$S2Currency1014
47Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency1014
48Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency1014
49Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
50Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
51Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
52Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
53Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
54Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency1014
55Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer46
56Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency1014
57Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer46
58Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency1014
59Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer46
60Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency1014
61Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer46
62Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency1014
63Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer46
64Estimate_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency1014
65Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer46
66Forecast_Equipment SearchForecast EquipmentDLR14_RBS0_STR$Currency1014
67Forecast_Material SearchForecast MaterialDLR14_RBS0_STR$Currency1014
68Forecast_Labor SearchForecast LaborDLR14_RBS0_STR$Currency1014
69Forecast_Subs SearchForecast SubsDLR14_RBS0_STR$Currency1014
70Forecast_Other SearchForecast OtherDLR14_RBS0_STR$Currency1014
71Forecast_Total_Cost SearchForecast Total CostDLR14_RBS0_STR$Currency1014
72Forecast_Hours SearchForecast HoursLI6_S2Long Integer46
73Forecast_Labor_1 SearchForecast Labor 1DLR14_RBS0_STR$Currency1014
74Forecast_Labor_1_Hours SearchForecast Labor 1 HoursLI6_S2Long Integer46
75Forecast_Labor_2 SearchForecast Labor 2DLR14_RBS0_STR$Currency1014
76Forecast_Labor_2_Hours SearchForecast Labor 2 HoursLI6_S2Long Integer46
77Forecast_Labor_3 SearchForecast Labor 3DLR14_RBS0_STR$Currency1014
78Forecast_Labor_3_Hours SearchForecast Labor 3 HoursLI6_S2Long Integer46
79Forecast_Labor_4 SearchForecast Labor 4DLR14_RBS0_STR$Currency1014
80Forecast_Labor_4_Hours SearchForecast Labor 4 HoursLI6_S2Long Integer46
81Forecast_Labor_5 SearchForecast Labor 5DLR14_RBS0_STR$Currency1014
82Forecast_Labor_5_Hours SearchForecast Labor 5 HoursLI6_S2Long Integer46
83Forecast_Total_Labor SearchForecast Total LaborDLR14_RBS0_STR$Currency1014
84Forecast_Total_Labor_Hrs SearchForecast Total Labor HrsLI6_S2Long Integer46
85PY_Labor SearchPY LaborDLR14_RBS0_STR$Currency1014
86PY_Material SearchPY MaterialDLR14_RBS0_STR$Currency1014
87PY_Equipment SearchPY EquipmentDLR14_RBS0_STR$Currency1014
88PY_Subcontractor SearchPY SubcontractorDLR14_RBS0_STR$Currency1014
89PY_Other SearchPY OtherDLR14_RBS0_STR$Currency1014
90PY_Total_Cost SearchPY Total CostDLR14_RBS0_STR$Currency1014
91PY_Billed SearchPY BilledDLR14_RBS0_STR$Currency1014
92PY_Contract_Earned SearchPY Contract EarnedDLR14_RBS0_STR$Currency1014
93PY_Gross_Profit SearchPY Gross ProfitDLR14_RBS0_STR$Currency1014
94PY_Revenue_Recognized SearchPY Revenue RecognizedDLR14_RBS0_STR$Currency1014
95PY_Hours SearchPY HoursLI6_S2Long Integer46
96PY_Labor_1 SearchPY Labor 1DLR14_RBS0_STR$Currency1014
97PY_Labor_1_Hours SearchPY Labor 1 HoursLI6_S2Long Integer46
98PY_Labor_2 SearchPY Labor 2DLR14_RBS0_STR$Currency1014
99PY_Labor_2_Hours SearchPY Labor 2 HoursLI6_S2Long Integer46
100PY_Labor_3 SearchPY Labor 3DLR14_RBS0_STR$Currency1014
101PY_Labor_3_Hours SearchPY Labor 3 HoursLI6_S2Long Integer46
102PY_Labor_4 SearchPY Labor 4DLR14_RBS0_STR$Currency1014
103PY_Labor_4_Hours SearchPY Labor 4 HoursLI6_S2Long Integer46
104PY_Labor_5 SearchPY Labor 5DLR14_RBS0_STR$Currency1014
105PY_Labor_5_Hours SearchPY Labor 5 HoursLI6_S2Long Integer46
106PY_Total_Labor SearchPY Total LaborDLR14_RBS0_STR$Currency1014
107PY_Total_Labor_Hrs SearchPY Total Labor HrsLI6_S2Long Integer46
108YTD_Labor SearchYTD LaborDLR14_RBS0_STR$Currency1014
109YTD_Material SearchYTD MaterialDLR14_RBS0_STR$Currency1014
110YTD_Equipment SearchYTD EquipmentDLR14_RBS0_STR$Currency1014
111YTD_Subcontractor SearchYTD SubcontractorDLR14_RBS0_STR$Currency1014
112YTD_Other SearchYTD OtherDLR14_RBS0_STR$Currency1014
113YTD_Total_Cost SearchYTD Total CostDLR14_RBS0_STR$Currency1014
114YTD_Billed SearchYTD BilledDLR14_RBS0_STR$Currency1014
115YTD_Contract_Earned SearchYTD Contract EarnedDLR14_RBS0_STR$Currency1014
116YTD_Gross_Profit SearchYTD Gross ProfitDLR14_RBS0_STR$Currency1014
117YTD_Revenue_Recognized SearchYTD Revenue RecognizedDLR14_RBS0_STR$Currency1014
118YTDHOURS SearchYTD HoursLI6_S2Long Integer46
119YTD_Labor_1 SearchYTD Labor 1DLR14_RBS0_STR$Currency1014
120YTD_Labor_1_Hours SearchYTD Labor 1 HoursLI6_S2Long Integer46
121YTD_Labor_2 SearchYTD Labor 2DLR14_RBS0_STR$Currency1014
122YTD_Labor_2_Hours SearchYTD Labor 2 HoursLI6_S2Long Integer46
123YTD_Labor_3 SearchYTD Labor 3DLR14_RBS0_STR$Currency1014
124YTD_Labor_3_Hours SearchYTD Labor 3 HoursLI6_S2Long Integer46
125YTD_Labor_4 SearchYTD Labor 4DLR14_RBS0_STR$Currency1014
126YTD_Labor_4_Hours SearchYTD Labor 4 HoursLI6_S2Long Integer46
127YTD_Labor_5 SearchYTD Labor 5DLR14_RBS0_STR$Currency1014
128YTD_Labor_5_Hours SearchYTD Labor 5 HoursLI6_S2Long Integer46
129YTD_Total_Labor SearchYTD Total LaborDLR14_RBS0_STR$Currency1014
130YTD_Total_Labor_Hrs SearchYTD Total Labor HrsLI6_S2Long Integer46
131TTD_Billed SearchTTD BilledDLR14_RBS0_STR$Currency1014
132TTD_Contract_Earned SearchTTD Contract EarnedDLR14_RBS0_STR$Currency1014
133TTD_Gross_Profit SearchTTD Gross ProfitDLR14_RBS0_STR$Currency1014
134TTD_Revenue_Recognized SearchTTD Revenue RecognizedDLR14_RBS0_STR$Currency1014
135Unbilled_Receivable SearchUnbilled ReceivableDLR14_RBS0_STR$Currency1014
136Contract_NTE_Units SearchContract NTE UnitsLI8Long Integer48
137Contract_Actual_Units SearchContract Actual UnitsLI8Long Integer48
138MODIFDT SearchModified DateDTDate48
139Modified_Time SearchModified TimeTM6Time46
140MDFUSRID SearchModified User IDSTR15String1615
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 3STR30String3230
142Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
143Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
144Service_User_Define_9 SearchService User Define 9DTDate48
145Service_User_Define_10 SearchService User Define 10DTDate48
146Service_User_Define_18 SearchService User Define 18CBBoolean20
147Service_User_Define_19 SearchService User Define 19CBBoolean20
148Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
149Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
150Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
151WSReserved_CB1 SearchWSReserved CB1CBBoolean20
152WSReserved_CB2 SearchWSReserved CB2CBBoolean20
153WSReserved_CB3 SearchWSReserved CB3CBBoolean20
154WSReserved_CB4 SearchWSReserved CB4CBBoolean20
155WSReserved_CB5 SearchWSReserved CB5CBBoolean20
156WSReserved_CB6 SearchWSReserved CB6CBBoolean20
157WSReserved_CB7 SearchWSReserved CB7CBBoolean20
158WSReserved_CB8 SearchWSReserved CB8CBBoolean20
159WSReserved_CB9 SearchWSReserved CB9CBBoolean20
160WSReserved_CB10 SearchWSReserved CB10CBBoolean20
161WSReserved_STR1 SearchWSReserved STR1STR10String1210
162WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartySV_Master_Contract_Financial_MSTR (SV00640)

Leave a Reply

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