Table: vwAmberCompanyList
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Company Programme Year Status ID | Long | 4 | ||
| Distribution Model ID | Long | 4 | ||
| Company Status ID | Long | 4 | ||
| Entrepreneur Company ID | Long | 4 | ||
| Company Name | Text | 255 | ||
| Programme Year | Text | 10 | ||
| Product | Text | 255 | ||
| Delivery Location | Text | 255 | ||
| RC Bookkeeper Assigned | Text | 255 | ||
| Own Bookkeeper | Boolean | 1 | ||
| Last Ignition Date | DateTime | 8 | ||
| Last Complete Submission Month | Text | 255 | ||
| Last Complete Submission Year | Long | 4 | ||
| Last Submission Month | Text | 255 | ||
| Last Submission Year | Long | 4 |