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 |