Skip to content

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