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 |