Table: vwGarnetExportEntrepreneurInformationforContractMailMerge
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Entrepreneur ID | Long | 4 | ✓ | |
| Email Address | Text | 255 | ||
| Entrepreneur Company Principal Project ID | Long | 4 | ||
| Project Name | Text | 255 | ||
| Allocated Amount | Double | 8 | ||
| Contract Printed | Boolean | 1 | ||
| Contract Start Date | DateTime | 8 | ||
| Contract End Date | DateTime | 8 | ||
| Date Record Created | DateTime | 8 | ||
| EA Date | DateTime | 8 | ||
| Date Panel Held | DateTime | 8 | ||
| First Name | Text | 255 | ||
| Surname | Text | 255 | ||
| Identity Number | Text | 255 | ||
| Company Name | Text | 255 | ||
| CompanyReg | Text | 255 | ||
| Delivery Location | Text | 255 | ||
| Enterprise Type | Text | 255 | ||
| Principal | Text | 255 | ||
| Committment Fee | Double | 8 | ||
| Product | Text | 255 | ||
| Programme Year | Text | 10 | ||
| Percent Black Owned | Double | 8 | ||
| Percent Women Black Owned | Double | 8 | ||
| BBBEE Pillar Description | Text | 255 | ||
| PP Contact First Name | Text | 255 | ||
| Contact Surname | Text | 255 | ||
| Business Address 1 | Text | 255 | ||
| Business Address 2 | Text | 255 | ||
| Business Address 3 | Text | 255 | ||
| Business Postal Code | Text | 255 | ||
| Trading As | Text | 255 | ||
| Ignition Date | DateTime | 8 |