Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV90585
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Contract_Task_Subtask_Join
Physical Name: SV90585
Technical Name: SV_Contract_Task_Subtask_JoinSeq 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_Contract_Task_Subtask_Join'].CUSTNMBR AS 'SV_Contract_Task_Subtask_Join-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV90585 AS ['SV_Contract_Task_Subtask_Join']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Contract_Task_Subtask_Join'].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 Equipment_ID Equipment ID STR30 String 30 6 Contract_Task_List_ID Contract Task List ID STR10_LBAU String 10 7 Task_Code Task Code STR10 String 10 8 Task_Line_Number Task Line Number LI_Sequence_Number Long Integer 10 9 Task_Code_Display Task Code Display STR10 String 10 10 Task_Description Task Description STR60 String 60 11 Task_Description_Long Task Description Long STR255 String 255 12 Sub_Task_Code Sub Task Code STR10 String 10 13 Sub_Task_Line_Number Sub Task Line Number LI_Sequence_Number Long Integer 10 14 HDRFTRTY Header Footer Type INT_STORAGE Integer 0