Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV99503
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Maint_Contract_Spending_Plan_Report
Physical Name: SV99503
Technical Name: SV_Maint_Contract_Spending_Plan_ReportSeq 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_Maint_Contract_Spending_Plan_Report'].CUSTNMBR AS 'SV_Maint_Contract_Spending_Plan_Report-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV99503 AS ['SV_Maint_Contract_Spending_Plan_Report']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Maint_Contract_Spending_Plan_Report'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Contract_Number WS Contract Number STR10 String 10 4 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 5 Divisions Divisions STR15_LBAU String 15 6 YEAR1 Year Year Integer 4 7 MNTHNMBR Month Number INT Integer 0 8 MONTH1 Month STR12_Month String 12 9 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 10 Estimated_Cost Estimated Cost DLR14_RBS0_STR$ Currency 14 11 Estimated_Hours Estimated Hours LI6_S2 Long Integer 6 12 Total_Estimated_Cost Total Estimated Cost DLR14_TS Currency 14 13 Total_Cost_All Total Cost All DLR14_RBS0_UTR$ Currency 14 14 Actual_Billed Actual Billed DLR14_RBS0_STR$ Currency 14 15 Profit_Amount Profit Amount DLR14_TS Currency 14 16 TTD_Billed TTD Billed DLR14_RBS0_STR$ Currency 14 17 TTD_Revenue_Recognized TTD Revenue Recognized DLR14_RBS0_STR$ Currency 14 18 Actual_Amount Actual Amount DLR19_$S2 Currency 19 19 Actual_Hours Actual Hours LI6_S2 Long Integer 6 20 RPTGRIND Report Group Index INT Integer 0