Skip to content

Table: Archive Submissions

Primary Key: Submission

Fields

Field Type Size Required PK
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

Indexes

  • Archive Submissions$PrimaryKey [PRIMARY KEY] [UNIQUE]