Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV99548
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Quote_Schedule_View
Physical Name: SV99548
Technical Name: SV_Quote_Schedule_ViewSeq 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_Quote_Schedule_View'].CUSTNMBR AS 'SV_Quote_Schedule_View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV99548 AS ['SV_Quote_Schedule_View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Quote_Schedule_View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Quote_Number Quote Number STR10 String 10 4 Task_Code Task Code STR10 String 10 5 Equipment_ID Equipment ID STR30 String 30 6 Quote_Task_List_ID Quote Task List ID STR10_LBAU String 10 7 Jan_Est_Hours Jan Est Hours LI6_S2 Long Integer 6 8 Feb_Est_Hours Feb Est Hours LI6_S2 Long Integer 6 9 March_Est_Hours March Est Hours LI6_S2 Long Integer 6 10 April_Est_Hours April Est Hours LI6_S2 Long Integer 6 11 May_Est_Hours May Est Hours LI6_S2 Long Integer 6 12 June_Est_Hours June Est Hours LI6_S2 Long Integer 6 13 July_Est_Hours July Est Hours LI6_S2 Long Integer 6 14 Aug_Est_Hours Aug Est Hours LI6_S2 Long Integer 6 15 Sept_Est_Hours Sept Est Hours LI6_S2 Long Integer 6 16 Oct_Est_Hours Oct Est Hours LI6_S2 Long Integer 6 17 Nov_Est_Hours Nov Est Hours LI6_S2 Long Integer 6 18 Dec_Est_Hours Dec Est Hours LI6_S2 Long Integer 6 19 Contract_Year Contract Year INT Integer 0 20 Quote_Type Quote Type DDL_Quote_Type Integer 0