Table: vwGarnetExportCompanyInformationforCertificateMailMerge
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Entrepreneur ID | Long | 4 | ✓ | |
| Entrepreneur Company ID | Long | 4 | ✓ | |
| Entrepreneur Company Programme Years ID | Long | 4 | ||
| Company Name | Text | 255 | ||
| First Name | Text | 255 | ||
| Surname | Text | 255 | ||
| Programme Year | Text | 10 | ||
| Certificate Programme Name | Text | 255 | ||
| Product Code | Text | 255 | ||
| Date Status Changed | DateTime | 8 | ||
| Delivery Location | Text | 255 | ||
| Principal | Text | 255 |