SV_Master_Contract_Rev_Summary (SV90012)

azurecurveProductsWennSoft Products (131)3rd PartySV_Master_Contract_Rev_Summary (SV90012)

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

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

Display Name: SV_Master_Contract_Rev_Summary
Physical Name: SV90012
Technical Name: SV_Master_Contract_Rev_Summary

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_Rev_Summary'].CUSTNMBR AS 'SV_Master_Contract_Rev_Summary-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV90012 AS ['SV_Master_Contract_Rev_Summary']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Master_Contract_Rev_Summary'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2Corporate_Contract_Nbr SearchCorporate Contract NumberSTR20_LBAUString2220
3WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer410
4Annual_Contract_Value SearchAnnual Contract ValueDLR14_RBS0_STR$Currency1014
5Forecast_Original_Equip SearchForecast Original EquipmentDLR14_RBS0_STR$Currency1014
6Forecast_Original_Labor SearchForecast Original LaborDLR14_RBS0_STR$Currency1014
7Fore_Orig_Material SearchForecast Original MaterialDLR14_RBS0_STR$Currency1014
8Forecast_Original_Other SearchForecast Original OtherDLR14_RBS0_STR$Currency1014
9Forecast_Original_Subs SearchForecast Original SubsDLR14_RBS0_STR$Currency1014
10Forecast_Orig_Labor_1 SearchForecast Orig Labor 1DLR14_RBS0_STR$Currency1014
11Forecast_Orig_Labor1_Hrs SearchForecast Orig Labor 1 HoursLI6_S2Long Integer46
12Forecast_Orig_Labor_2 SearchForecast Orig Labor 2DLR14_RBS0_STR$Currency1014
13Fore_Orig_Labor_2_Hrs SearchForecast Orig Labor 2 HoursLI6_S2Long Integer46
14Forecast_Orig_Labor_3 SearchForecast Orig Labor 3DLR14_RBS0_STR$Currency1014
15Forecast_Orig_Labor3_Hrs SearchForecast Orig Labor 3 HoursLI6_S2Long Integer46
16Forecast_Orig_Labor_4 SearchForecast Orig Labor 4DLR14_RBS0_STR$Currency1014
17Forecast_Orig_Labor4_Hrs SearchForecast Orig Labor 4 HoursLI6_S2Long Integer46
18Forecast_Orig_Labor_5 SearchForecast Orig Labor 5DLR14_RBS0_STR$Currency1014
19Forecast_Orig_Labor5_Hrs SearchForecast Orig Labor 5 HoursLI6_S2Long Integer46
20Forecast_Orig_Tot_Labor SearchForecast Orig Total LaborDLR14_RBS0_STR$Currency1014
21Fore_Orig_Tot_Lbr_Hrs SearchForecast Orig Total Labor HrsLI6_S2Long Integer46
22Actual_Equipment SearchActual EquipmentDLR14_RBS0_STR$Currency1014
23Actual_Labor SearchActual LaborDLR14_RBS0_STR$Currency1014
24Actual_Material SearchActual MaterialDLR14_RBS0_STR$Currency1014
25Actual_Subs SearchActual SubsDLR14_RBS0_STR$Currency1014
26Actual_Other SearchActual OtherDLR14_RBS0_STR$Currency1014
27Total_Cost_Tax SearchTotal Cost TaxDLR11_$S2Currency1014
28Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency1014
29Actual_Hours SearchActual HoursLI6_S2Long Integer46
30Actual_Labor_1 SearchActual Labor 1DLR14_RBS0_STR$Currency1014
31Actual_Labor_1_Hours SearchActual Labor 1 HoursLI6_S2Long Integer46
32Actual_Labor_2 SearchActual Labor 2DLR14_RBS0_STR$Currency1014
33Actual_Labor_2_Hours SearchActual Labor 2 HoursLI6_S2Long Integer46
34Actual_Labor_3 SearchActual Labor 3DLR14_RBS0_STR$Currency1014
35Actual_Labor_3_Hours SearchActual Labor 3 HoursLI6_S2Long Integer46
36Actual_Labor_4 SearchActual Labor 4DLR14_RBS0_STR$Currency1014
37Actual_Labor_4_Hours SearchActual Labor 4 HoursLI6_S2Long Integer46
38Actual_Labor_5 SearchActual Labor 5DLR14_RBS0_STR$Currency1014
39Actual_Labor_5_Hours SearchActual Labor 5 HoursLI6_S2Long Integer46
40Actual_Total_Labor SearchActual Total LaborDLR14_RBS0_STR$Currency1014
41Actual_Total_Labor_Hrs SearchActual Total Labor HrsLI6_S2Long Integer46
42Actual_Billed SearchActual BilledDLR14_RBS0_STR$Currency1014
43Actual_Contract_Earned SearchActual Contract EarnedDLR14_RBS0_STR$Currency1014
44Actual_Gross_Profit SearchActual Gross ProfitDLR14_RBS0_STR$Currency1014
45Actua_Revenue_Recognized SearchActual Revenue RecognizedDLR14_RBS0_STR$Currency1014
46Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency1014
47Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency1014
48Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
49Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
50Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
51Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
52Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
53Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency1014
54Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer46
55Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency1014
56Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer46
57Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency1014
58Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer46
59Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency1014
60Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer46
61Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency1014
62Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer46
63Estimate_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency1014
64Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer46
65Forecast_Labor SearchForecast LaborDLR14_RBS0_STR$Currency1014
66Forecast_Equipment SearchForecast EquipmentDLR14_RBS0_STR$Currency1014
67Forecast_Material SearchForecast MaterialDLR14_RBS0_STR$Currency1014
68Forecast_Subs SearchForecast SubsDLR14_RBS0_STR$Currency1014
69Forecast_Other SearchForecast OtherDLR14_RBS0_STR$Currency1014
70Forecast_Total_Cost SearchForecast Total CostDLR14_RBS0_STR$Currency1014
71Forecast_Hours SearchForecast HoursLI6_S2Long Integer46
72Forecast_Labor_1 SearchForecast Labor 1DLR14_RBS0_STR$Currency1014
73Forecast_Labor_1_Hours SearchForecast Labor 1 HoursLI6_S2Long Integer46
74Forecast_Labor_2 SearchForecast Labor 2DLR14_RBS0_STR$Currency1014
75Forecast_Labor_2_Hours SearchForecast Labor 2 HoursLI6_S2Long Integer46
76Forecast_Labor_3 SearchForecast Labor 3DLR14_RBS0_STR$Currency1014
77Forecast_Labor_3_Hours SearchForecast Labor 3 HoursLI6_S2Long Integer46
78Forecast_Labor_4 SearchForecast Labor 4DLR14_RBS0_STR$Currency1014
79Forecast_Labor_4_Hours SearchForecast Labor 4 HoursLI6_S2Long Integer46
80Forecast_Labor_5 SearchForecast Labor 5DLR14_RBS0_STR$Currency1014
81Forecast_Labor_5_Hours SearchForecast Labor 5 HoursLI6_S2Long Integer46
82Forecast_Total_Labor SearchForecast Total LaborDLR14_RBS0_STR$Currency1014
83Forecast_Total_Labor_Hrs SearchForecast Total Labor HrsLI6_S2Long Integer46
84YTD_Labor SearchYTD LaborDLR14_RBS0_STR$Currency1014
85YTD_Material SearchYTD MaterialDLR14_RBS0_STR$Currency1014
86YTD_Equipment SearchYTD EquipmentDLR14_RBS0_STR$Currency1014
87YTD_Subcontractor SearchYTD SubcontractorDLR14_RBS0_STR$Currency1014
88YTD_Other SearchYTD OtherDLR14_RBS0_STR$Currency1014
89YTD_Total_Cost SearchYTD Total CostDLR14_RBS0_STR$Currency1014
90YTD_Billed SearchYTD BilledDLR14_RBS0_STR$Currency1014
91YTD_Contract_Earned SearchYTD Contract EarnedDLR14_RBS0_STR$Currency1014
92YTD_Gross_Profit SearchYTD Gross ProfitDLR14_RBS0_STR$Currency1014
93YTD_Revenue_Recognized SearchYTD Revenue RecognizedDLR14_RBS0_STR$Currency1014
94YTDHOURS SearchYTD HoursLI6_S2Long Integer46
95YTD_Labor_1 SearchYTD Labor 1DLR14_RBS0_STR$Currency1014
96YTD_Labor_1_Hours SearchYTD Labor 1 HoursLI6_S2Long Integer46
97YTD_Labor_2 SearchYTD Labor 2DLR14_RBS0_STR$Currency1014
98YTD_Labor_2_Hours SearchYTD Labor 2 HoursLI6_S2Long Integer46
99YTD_Labor_3 SearchYTD Labor 3DLR14_RBS0_STR$Currency1014
100YTD_Labor_3_Hours SearchYTD Labor 3 HoursLI6_S2Long Integer46
101YTD_Labor_4 SearchYTD Labor 4DLR14_RBS0_STR$Currency1014
102YTD_Labor_4_Hours SearchYTD Labor 4 HoursLI6_S2Long Integer46
103YTD_Labor_5 SearchYTD Labor 5DLR14_RBS0_STR$Currency1014
104YTD_Labor_5_Hours SearchYTD Labor 5 HoursLI6_S2Long Integer46
105YTD_Total_Labor SearchYTD Total LaborDLR14_RBS0_STR$Currency1014
106YTD_Total_Labor_Hrs SearchYTD Total Labor HrsLI6_S2Long Integer46
107TTD_Billed SearchTTD BilledDLR14_RBS0_STR$Currency1014
108TTD_Contract_Earned SearchTTD Contract EarnedDLR14_RBS0_STR$Currency1014
109TTD_Gross_Profit SearchTTD Gross ProfitDLR14_RBS0_STR$Currency1014
110TTD_Revenue_Recognized SearchTTD Revenue RecognizedDLR14_RBS0_STR$Currency1014
111TTD_Equipment SearchTTD EquipmentDLR14_RBS0_STR$Currency1014
112TTD_Material SearchTTD MaterialDLR14_RBS0_STR$Currency1014
113TTD_Other SearchTTD OtherDLR14_RBS0_STR$Currency1014
114TTD_Subcontractor SearchTTD SubcontractorDLR14_RBS0_STR$Currency1014
115TTD_Labor SearchTTD LaborDLR14_RBS0_STR$Currency1014
116TTD_Labor1 SearchTTD Labor 1DLR14_RBS0_STR$Currency1014
117TTD_Labor2 SearchTTD Labor 2DLR14_RBS0_STR$Currency1014
118TTD_Labor3 SearchTTD Labor 3DLR14_RBS0_STR$Currency1014
119TTD_Labor4 SearchTTD Labor 4DLR14_RBS0_STR$Currency1014
120TTD_Labor5 SearchTTD Labor 5DLR14_RBS0_STR$Currency1014
121TTD_Total_Cost SearchTTD Total CostDLR14_RBS0_STR$Currency1014
122TTD_Total_Labor_Hrs SearchTTD Total Labor HrsLI6_S2Long Integer46
123Billing_Equipment SearchBilling EquipmentDLR14_RBS0_STR$Currency1014
124Billing_Material SearchBilling MaterialDLR14_RBS0_STR$Currency1014
125Billing_Labor SearchBilling LaborDLR14_RBS0_STR$Currency1014
126Billing_Subs SearchBilling SubsDLR14_RBS0_STR$Currency1014
127Billing_Other SearchBilling OtherDLR14_RBS0_STR$Currency1014
azurecurveProductsWennSoft Products (131)3rd PartySV_Master_Contract_Rev_Summary (SV90012)

Leave a Reply

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