Offline Companies (SY01800)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01800

Display Name: Offline Companies
Physical Name: SY01800
Technical Name: syOfflineCompanies

Seq 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'].CMPANYID
2	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