SV_Master_Contract_Rev_Summary (SV90012)

azurecurve Products WennSoft 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	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
2	Corporate_Contract_Nbr	Corporate Contract Number	STR20_LBAU	String	20
3	WSMSTRCONTSQ	WS Master Contract Seq Number	LI_Sequence_Number	Long Integer	10
4	Annual_Contract_Value	Annual Contract Value	DLR14_RBS0_STR$	Currency	14
5	Forecast_Original_Equip	Forecast Original Equipment	DLR14_RBS0_STR$	Currency	14
6	Forecast_Original_Labor	Forecast Original Labor	DLR14_RBS0_STR$	Currency	14
7	Fore_Orig_Material	Forecast Original Material	DLR14_RBS0_STR$	Currency	14
8	Forecast_Original_Other	Forecast Original Other	DLR14_RBS0_STR$	Currency	14
9	Forecast_Original_Subs	Forecast Original Subs	DLR14_RBS0_STR$	Currency	14
10	Forecast_Orig_Labor_1	Forecast Orig Labor 1	DLR14_RBS0_STR$	Currency	14
11	Forecast_Orig_Labor1_Hrs	Forecast Orig Labor 1 Hours	LI6_S2	Long Integer	6
12	Forecast_Orig_Labor_2	Forecast Orig Labor 2	DLR14_RBS0_STR$	Currency	14
13	Fore_Orig_Labor_2_Hrs	Forecast Orig Labor 2 Hours	LI6_S2	Long Integer	6
14	Forecast_Orig_Labor_3	Forecast Orig Labor 3	DLR14_RBS0_STR$	Currency	14
15	Forecast_Orig_Labor3_Hrs	Forecast Orig Labor 3 Hours	LI6_S2	Long Integer	6
16	Forecast_Orig_Labor_4	Forecast Orig Labor 4	DLR14_RBS0_STR$	Currency	14
17	Forecast_Orig_Labor4_Hrs	Forecast Orig Labor 4 Hours	LI6_S2	Long Integer	6
18	Forecast_Orig_Labor_5	Forecast Orig Labor 5	DLR14_RBS0_STR$	Currency	14
19	Forecast_Orig_Labor5_Hrs	Forecast Orig Labor 5 Hours	LI6_S2	Long Integer	6
20	Forecast_Orig_Tot_Labor	Forecast Orig Total Labor	DLR14_RBS0_STR$	Currency	14
21	Fore_Orig_Tot_Lbr_Hrs	Forecast Orig Total Labor Hrs	LI6_S2	Long Integer	6
22	Actual_Equipment	Actual Equipment	DLR14_RBS0_STR$	Currency	14
23	Actual_Labor	Actual Labor	DLR14_RBS0_STR$	Currency	14
24	Actual_Material	Actual Material	DLR14_RBS0_STR$	Currency	14
25	Actual_Subs	Actual Subs	DLR14_RBS0_STR$	Currency	14
26	Actual_Other	Actual Other	DLR14_RBS0_STR$	Currency	14
27	Total_Cost_Tax	Total Cost Tax	DLR11_$S2	Currency	14
28	Actual_Total_Cost	Actual Total Cost	DLR14_RBS0_STR$	Currency	14
29	Actual_Hours	Actual Hours	LI6_S2	Long Integer	6
30	Actual_Labor_1	Actual Labor 1	DLR14_RBS0_STR$	Currency	14
31	Actual_Labor_1_Hours	Actual Labor 1 Hours	LI6_S2	Long Integer	6
32	Actual_Labor_2	Actual Labor 2	DLR14_RBS0_STR$	Currency	14
33	Actual_Labor_2_Hours	Actual Labor 2 Hours	LI6_S2	Long Integer	6
34	Actual_Labor_3	Actual Labor 3	DLR14_RBS0_STR$	Currency	14
35	Actual_Labor_3_Hours	Actual Labor 3 Hours	LI6_S2	Long Integer	6
36	Actual_Labor_4	Actual Labor 4	DLR14_RBS0_STR$	Currency	14
37	Actual_Labor_4_Hours	Actual Labor 4 Hours	LI6_S2	Long Integer	6
38	Actual_Labor_5	Actual Labor 5	DLR14_RBS0_STR$	Currency	14
39	Actual_Labor_5_Hours	Actual Labor 5 Hours	LI6_S2	Long Integer	6
40	Actual_Total_Labor	Actual Total Labor	DLR14_RBS0_STR$	Currency	14
41	Actual_Total_Labor_Hrs	Actual Total Labor Hrs	LI6_S2	Long Integer	6
42	Actual_Billed	Actual Billed	DLR14_RBS0_STR$	Currency	14
43	Actual_Contract_Earned	Actual Contract Earned	DLR14_RBS0_STR$	Currency	14
44	Actual_Gross_Profit	Actual Gross Profit	DLR14_RBS0_STR$	Currency	14
45	Actua_Revenue_Recognized	Actual Revenue Recognized	DLR14_RBS0_STR$	Currency	14
46	Estimate_Equipment	Estimate Equipment	DLR14_RBS0_STR$	Currency	14
47	Estimate_Labor	Estimate Labor	DLR14_RBS0_STR$	Currency	14
48	Estimate_Material	Estimate Material	DLR14_RBS0_STR$	Currency	14
49	Estimate_Subs	Estimate Subs	DLR14_RBS0_STR$	Currency	14
50	Estimate_Other	Estimate Other	DLR14_RBS0_STR$	Currency	14
51	Estimate_Total_Cost	Estimate Total Cost	DLR14_RBS0_STR$	Currency	14
52	Estimate_Hours	Estimate Hours	LI6_S2	Long Integer	6
53	Estimate_Labor_1	Estimate Labor 1	DLR14_RBS0_STR$	Currency	14
54	Estimate_Labor_1_Hours	Estimate Labor 1 Hours	LI6_S2	Long Integer	6
55	Estimate_Labor_2	Estimate Labor 2	DLR14_RBS0_STR$	Currency	14
56	Estimate_Labor_2_Hours	Estimate Labor 2 Hours	LI6_S2	Long Integer	6
57	Estimate_Labor_3	Estimate Labor 3	DLR14_RBS0_STR$	Currency	14
58	Estimate_Labor_3_Hours	Estimate Labor 3 Hours	LI6_S2	Long Integer	6
59	Estimate_Labor_4	Estimate Labor 4	DLR14_RBS0_STR$	Currency	14
60	Estimate_Labor_4_Hours	Estimate Labor 4 Hours	LI6_S2	Long Integer	6
61	Estimate_Labor_5	Estimate Labor 5	DLR14_RBS0_STR$	Currency	14
62	Estimate_Labor_5_Hours	Estimate Labor 5 Hours	LI6_S2	Long Integer	6
63	Estimate_Total_Labor	Estimate Total Labor	DLR14_RBS0_STR$	Currency	14
64	Estimate_Total_Labor_Hrs	Estimate Total Labor Hrs	LI6_S2	Long Integer	6
65	Forecast_Labor	Forecast Labor	DLR14_RBS0_STR$	Currency	14
66	Forecast_Equipment	Forecast Equipment	DLR14_RBS0_STR$	Currency	14
67	Forecast_Material	Forecast Material	DLR14_RBS0_STR$	Currency	14
68	Forecast_Subs	Forecast Subs	DLR14_RBS0_STR$	Currency	14
69	Forecast_Other	Forecast Other	DLR14_RBS0_STR$	Currency	14
70	Forecast_Total_Cost	Forecast Total Cost	DLR14_RBS0_STR$	Currency	14
71	Forecast_Hours	Forecast Hours	LI6_S2	Long Integer	6
72	Forecast_Labor_1	Forecast Labor 1	DLR14_RBS0_STR$	Currency	14
73	Forecast_Labor_1_Hours	Forecast Labor 1 Hours	LI6_S2	Long Integer	6
74	Forecast_Labor_2	Forecast Labor 2	DLR14_RBS0_STR$	Currency	14
75	Forecast_Labor_2_Hours	Forecast Labor 2 Hours	LI6_S2	Long Integer	6
76	Forecast_Labor_3	Forecast Labor 3	DLR14_RBS0_STR$	Currency	14
77	Forecast_Labor_3_Hours	Forecast Labor 3 Hours	LI6_S2	Long Integer	6
78	Forecast_Labor_4	Forecast Labor 4	DLR14_RBS0_STR$	Currency	14
79	Forecast_Labor_4_Hours	Forecast Labor 4 Hours	LI6_S2	Long Integer	6
80	Forecast_Labor_5	Forecast Labor 5	DLR14_RBS0_STR$	Currency	14
81	Forecast_Labor_5_Hours	Forecast Labor 5 Hours	LI6_S2	Long Integer	6
82	Forecast_Total_Labor	Forecast Total Labor	DLR14_RBS0_STR$	Currency	14
83	Forecast_Total_Labor_Hrs	Forecast Total Labor Hrs	LI6_S2	Long Integer	6
84	YTD_Labor	YTD Labor	DLR14_RBS0_STR$	Currency	14
85	YTD_Material	YTD Material	DLR14_RBS0_STR$	Currency	14
86	YTD_Equipment	YTD Equipment	DLR14_RBS0_STR$	Currency	14
87	YTD_Subcontractor	YTD Subcontractor	DLR14_RBS0_STR$	Currency	14
88	YTD_Other	YTD Other	DLR14_RBS0_STR$	Currency	14
89	YTD_Total_Cost	YTD Total Cost	DLR14_RBS0_STR$	Currency	14
90	YTD_Billed	YTD Billed	DLR14_RBS0_STR$	Currency	14
91	YTD_Contract_Earned	YTD Contract Earned	DLR14_RBS0_STR$	Currency	14
92	YTD_Gross_Profit	YTD Gross Profit	DLR14_RBS0_STR$	Currency	14
93	YTD_Revenue_Recognized	YTD Revenue Recognized	DLR14_RBS0_STR$	Currency	14
94	YTDHOURS	YTD Hours	LI6_S2	Long Integer	6
95	YTD_Labor_1	YTD Labor 1	DLR14_RBS0_STR$	Currency	14
96	YTD_Labor_1_Hours	YTD Labor 1 Hours	LI6_S2	Long Integer	6
97	YTD_Labor_2	YTD Labor 2	DLR14_RBS0_STR$	Currency	14
98	YTD_Labor_2_Hours	YTD Labor 2 Hours	LI6_S2	Long Integer	6
99	YTD_Labor_3	YTD Labor 3	DLR14_RBS0_STR$	Currency	14
100	YTD_Labor_3_Hours	YTD Labor 3 Hours	LI6_S2	Long Integer	6
101	YTD_Labor_4	YTD Labor 4	DLR14_RBS0_STR$	Currency	14
102	YTD_Labor_4_Hours	YTD Labor 4 Hours	LI6_S2	Long Integer	6
103	YTD_Labor_5	YTD Labor 5	DLR14_RBS0_STR$	Currency	14
104	YTD_Labor_5_Hours	YTD Labor 5 Hours	LI6_S2	Long Integer	6
105	YTD_Total_Labor	YTD Total Labor	DLR14_RBS0_STR$	Currency	14
106	YTD_Total_Labor_Hrs	YTD Total Labor Hrs	LI6_S2	Long Integer	6
107	TTD_Billed	TTD Billed	DLR14_RBS0_STR$	Currency	14
108	TTD_Contract_Earned	TTD Contract Earned	DLR14_RBS0_STR$	Currency	14
109	TTD_Gross_Profit	TTD Gross Profit	DLR14_RBS0_STR$	Currency	14
110	TTD_Revenue_Recognized	TTD Revenue Recognized	DLR14_RBS0_STR$	Currency	14
111	TTD_Equipment	TTD Equipment	DLR14_RBS0_STR$	Currency	14
112	TTD_Material	TTD Material	DLR14_RBS0_STR$	Currency	14
113	TTD_Other	TTD Other	DLR14_RBS0_STR$	Currency	14
114	TTD_Subcontractor	TTD Subcontractor	DLR14_RBS0_STR$	Currency	14
115	TTD_Labor	TTD Labor	DLR14_RBS0_STR$	Currency	14
116	TTD_Labor1	TTD Labor 1	DLR14_RBS0_STR$	Currency	14
117	TTD_Labor2	TTD Labor 2	DLR14_RBS0_STR$	Currency	14
118	TTD_Labor3	TTD Labor 3	DLR14_RBS0_STR$	Currency	14
119	TTD_Labor4	TTD Labor 4	DLR14_RBS0_STR$	Currency	14
120	TTD_Labor5	TTD Labor 5	DLR14_RBS0_STR$	Currency	14
121	TTD_Total_Cost	TTD Total Cost	DLR14_RBS0_STR$	Currency	14
122	TTD_Total_Labor_Hrs	TTD Total Labor Hrs	LI6_S2	Long Integer	6
123	Billing_Equipment	Billing Equipment	DLR14_RBS0_STR$	Currency	14
124	Billing_Material	Billing Material	DLR14_RBS0_STR$	Currency	14
125	Billing_Labor	Billing Labor	DLR14_RBS0_STR$	Currency	14
126	Billing_Subs	Billing Subs	DLR14_RBS0_STR$	Currency	14
127	Billing_Other	Billing Other	DLR14_RBS0_STR$	Currency	14

azurecurve Products WennSoft Products (131)3rd PartySV_Master_Contract_Rev_Summary (SV90012)

Click to show/hide

Leave a Reply Cancel reply