Table: vwGarnetRptPartSponsorshipHistory
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Entrepreneur Company Programme Years ID | Long | 4 | ||
| Process Status ID | Long | 4 | ||
| Company Status ID | Long | 4 | ||
| Delivery Location | Text | 255 | ||
| Company Name | Text | 255 | ||
| Entrepreneur | Memo | - | ✓ | |
| Phone | Text | 255 | ||
| Email Address | Text | 255 | ||
| Industry | Text | 255 | ||
| Brief Description of Business | Memo | - | ||
| Product | Text | 255 | ||
| Total Programme Amount | Double | 8 | ||
| Total Allocated | Double | 8 | ✓ | |
| Amount Needed | Double | 8 | ||
| Programme Year | Text | 10 | ||
| Contract Start Date | DateTime | 8 | ||
| Contract End Date | DateTime | 8 |