Sage 50 UK DEPARTMENT Columns

Name	Type	Length	Precision	Notes	Example
NUMBER	SMALLINT	2	5	Department number	0
NAME	VARCHAR	60	60	Department name	Default
REFERENCE	VARCHAR	8	8	User reference	0
RECORD_CREATE_DATE		16	0	Date and time when the record was created.	04/08/2017 14:18:51
RECORD_MODIFY_DATE		16	0	Date and time when the record was modified.	04/08/2017 14:18:51
RECORD_DELETED	TINYINT	2	3	Flag denoting if the record has been deleted or not.	0