Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC90102
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Job_MSTR_VIEW
Physical Name: JC90102
Technical Name: JC_Job_MSTR_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 WS_Job_Number 
WS Job Number STR17_LBAU String 17 2 WS_Inactive_STR WS Inactive STR STR10 String 10 3 Project_Number WS Project Number STR170 String 17 4 WS_Job_Name WS Job Name STR30 String 30 5 Divisions Divisions STR15_LBAU String 15 6 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['JC_Job_MSTR_VIEW'].CUSTNMBR AS 'JC_Job_MSTR_VIEW-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
JC90102 AS ['JC_Job_MSTR_VIEW']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['JC_Job_MSTR_VIEW'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR7 CUSTNAME Customer Name STR64_Customer_Name String 64 8 WS_Manager_ID WS Manager ID STR15_Employee_ID String 15 9 WS_Manager_Name WS Manager Name STR40 String 40 10 Estimator_ID Estimator ID STR15_Employee_ID String 15 11 WS_Estimator_Name WS Estimator Name STR40 String 40 12 Contract_Type Contract Type DDL_Contract_Type Integer 0 13 WS_Billing_Type WS Billing Type DDL Integer 0 14 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 15 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 16 Wennsoft_Region Wennsoft Region STR15_LBAU String 15