Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV99650
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Maint_Master_Contract_Spending_Plan
Physical Name: SV99650
Technical Name: SV_Maint_Master_Contract_Spending_PlanSeq 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_Master_Contract_Spending_Plan'].CUSTNMBR AS 'SV_Maint_Master_Contract_Spending_Plan-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV99650 AS ['SV_Maint_Master_Contract_Spending_Plan']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Maint_Master_Contract_Spending_Plan'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 Corporate_Contract_Nbr Corporate Contract Number STR20_LBAU String 20 3 WSMSTRCONTSQ WS Master Contract Seq Number LI_Sequence_Number Long Integer 10 4 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 5 YEAR1 Year Year Integer 4 6 MNTHNMBR Month Number INT Integer 0 7 Estimated_Cost Estimated Cost DLR14_RBS0_STR$ Currency 14 8 Estimated_Hours Estimated Hours LI6_S2 Long Integer 6 9 Estimated_Percentage Estimated Percentage DLR5_%2 Currency 8