Sage 50 UK ECSALES_SPLIT Columns
| Name | Type | Length | Precision | Notes | Example |
|---|---|---|---|---|---|
| TYPE | VARCHAR | 3 | 3 | Transaction type | |
| ID | INTEGER | 4 | 10 | Transaction ID | |
| NOMINAL_CODE | VARCHAR | 8 | 8 | Nominal code | |
| DATE | DATE | 2 | 10 | Date | |
| REF | VARCHAR | 60 | 60 | Reference | |
| DETAILS | VARCHAR | 60 | 60 | Details | |
| NET | DOUBLE | 8 | 15 | Net | |
| TRIANGULATED | SMALLINT | 2 | 5 | Triangulated | |
| COUNTRY_CODE | VARCHAR | 2 | 2 | Country code | |
| VAT_NUMBER | VARCHAR | 20 | 20 | Customer VAT number | |
| ACCOUNT_REF | VARCHAR | 60 | 60 | Customer reference | |
| INDICATOR | VARCHAR | 8 | 8 | Indicator |