Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC00600
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Project_Master_Bill_Codes
Physical Name: JC00600
Technical Name: JC_Project_Master_Bill_CodesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Bill_Code_Number 
Bill Code Number STR26 String 26 2 Bill_Code_Description Bill Code Description STR30 String 30 3 Bill_Code_Alias Bill Code Alias STR30 String 30 4 Cost_Element Cost Element INT3_RB0_U Integer 3 5 Reimbursable Reimbursable CB_Reimbursable Boolean 0 6 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC_Project_Master_Bill_Codes'].MDFUSRID AS 'JC_Project_Master_Bill_Codes-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC00600 AS ['JC_Project_Master_Bill_Codes']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC_Project_Master_Bill_Codes'].MDFUSRID = ['Users Master'].USERID7 MODIFDT Modified Date DT Date 8 8 Modified_Time Modified Time TM6 Time 6 9 WSReserved_CB1 WSReserved CB1 CB Boolean 0 10 WSReserved_CB2 WSReserved CB2 CB Boolean 0 11 WSReserved_STR1 WSReserved STR1 STR10 String 10 12 WSReserved_STR2 WSReserved STR2 STR10 String 10