Skip to content

Sage 50 UK ECSALES_HEADER Columns

Name Type   Length Precision   Notes  Example
DATE_FROM DATE 2 10 Start date
DATE_TO DATE 2 10 End date
VAT_NUMBER VARCHAR 20 20 Vat number
TAX_BRANCH_ID VARCHAR 20 20 Tax branch ID
QUARTER VARCHAR 3 3 Calender quarter
NAME VARCHAR 60 60 Company name
ADDRESS_1 VARCHAR 60 60 Address line 1
ADDRESS_2 VARCHAR 60 60 Address line 2
ADDRESS_3 VARCHAR 60 60 Address line 3
ADDRESS_4 VARCHAR 60 60 Address line 4
ADDRESS_5 VARCHAR 60 60 Address line 5
ATTEMPTS INTEGER 4 10 Attempts made
ACKNOWLEDGED SMALLINT 2 5 Submission acknowledged
LINES INTEGER 4 10 Lines in return
SALES DOUBLE 8 15 Sales value
REFERENCE VARCHAR 60 60 Reference
TIMESTAMP VARCHAR 30 30 Timestamp
DUE_DATE DATE 2 10 Due date