Sage 50 UK ECSALES_FILL Columns

Name	Type	Length	Precision	Notes	Example
COUNTRY_CODE	VARCHAR	2	2	Country Code
VAT_NUMBER	VARCHAR	20	20	Customer VAT Number
NET	DOUBLE	8	15	Net
PENCE	VARCHAR	8	8	Pence
INDICATOR	VARCHAR	8	8	Indicator
SUBMISSION	VARCHAR	16	16	Submission
ACCOUNT_REF	VARCHAR	60	60	Customer Reference
COLLECTION_KEY	VARCHAR	60	60	Collection key
SUBMISSION_ATTEMPTS	SMALLINT	2	5	Submission attempts
SUBMISSION_ACKNOWLEDGED	SMALLINT	2	5	Submission acknowledged
SUBMISSION_ERRORS	VARCHAR	3071	3071	Submission errors