Table: Submissions

Primary Key: Submission

Fields

Field	Type	Size	Required
Submission ID	Long	4	✓
Entrepreneur Company ID	Long	4
Date Created	DateTime	8
Date Books Submitted	DateTime	8
Submission Month	Text	255
Submission Year	Long	4
Bookkeeper	Text	255
Submission Status ID	Long	4
Submission Status Notes	Text	255
Quality Score	Double	8
Reviewed by Guide	Boolean	1
Turnover	Double	8
Cost of Sales	Double	8
Direct Labour Costs	Double	8
Expenses Salary	Double	8
Other Income	Double	8
Salaries	Double	8
Net Asset Value	Double	8
Directors	Long	4
Permanent Staff	Long	4
Contract Staff	Long	4
Date Status Changed	DateTime	8
Status Modified By	Text	255
SSMA_TimeStamp	Binary	8	✓
YTD Turnover	Double	8
YTD Cost of Sales	Double	8
YTD Direct Labour Costs	Double	8
YTD Expenses Salary	Double	8
YTD Other Income	Double	8
YTD Salaries	Double	8
YTD Net Asset Value	Double	8
Issue New Permanent Staff	Boolean	1
Issue YTD Does Not Match	Boolean	1