Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC90100
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Labor_Summary_VIEW
Physical Name: JC90100
Technical Name: JC_Labor_Summary_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID 
Employee ID STR15_Employee_ID String 15 2 WS_Job_Number WS Job Number STR17_LBAU String 17 3 Divisions Divisions STR15_LBAU String 15 4 Project_Number WS Project Number STR170 String 17 5 WS_Job_Name WS Job Name STR30 String 30 6 TRXHRUNT TRX Hours/Units LI6_S2 Long Integer 6 7 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 8 Overhead_1_Cst_Per_Unit Overhead 1 Cost Per Unit DLR8_RBU Currency 8 9 Cost_Code_Act_Cost_TTD Cost Code Actual Cost TTD DLR14_STR Currency 14 10 WS_Labor_Cost WS Labor Cost DLR14_TS Currency 14 11 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC_Labor_Summary_VIEW'].USERID AS 'JC_Labor_Summary_VIEW-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC90100 AS ['JC_Labor_Summary_VIEW']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC_Labor_Summary_VIEW'].USERID = ['Users Master'].USERID