Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01800
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Offline Companies
Physical Name: SY01800
Technical Name: syOfflineCompaniesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Offline Companies'].CMPANYID AS 'Offline Companies-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
SY01800 AS ['Offline Companies']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Offline Companies'].CMPANYID = ['Company Master'].CMPANYID2 Offline_Date Offline Date Date DATE 6 3 Offline_Time Offline Time Time TM6 6 4 Offline_Message_Type Offline Message Type Integer GB 0 5 Offline_User Offline User String User_ID 15 6 Offline_Message Offline Message Text TX500 500