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

Leave a Reply

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