Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01801
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Offline Companies History
Physical Name: SY01801
Technical Name: syOfflineCompaniesHistorySeq 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 History'].CMPANYID AS 'Offline Companies History-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
SY01801 AS ['Offline Companies History']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Offline Companies History'].CMPANYID = ['Company Master'].CMPANYID2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 Offline_Date Offline Date Date DATE 6 4 Offline_Time Offline Time Time TM6 6 5 Offline_User Offline User String User_ID 15 6 Online_Date Online Date Date DATE 6 7 Online_Time Online Time Time TM6 6 8 Online_User Online User String User_ID 15