Table: vwPurpleEntrepreneurListCurrentPrincipalProjects
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Process Status ID | Long | 4 | ||
| Entrepreneur Company ID | Long | 4 | ||
| Entrepreneur ID | Long | 4 | ✓ | |
| First Name | Text | 255 | ||
| Surname | Text | 255 | ||
| Company Name | Text | 255 | ||
| Company Status ID | Long | 4 | ||
| Date Status Changed | DateTime | 8 | ||
| Status Modified By | Text | 255 | ||
| Status | Text | 255 | ||
| Lead Type | Text | 255 | ||
| Province | Text | 255 | ||
| Industry | Text | 255 | ||
| Division | Text | 255 | ||
| Delivery Location | Text | 255 | ||
| OwnedBy | Text | 255 | ||
| Date Record Created | DateTime | 8 | ||
| Date Modified | DateTime | 8 | ||
| Last Modified By | Text | 255 | ||
| Principal | Text | 255 | ||
| Project Name | Text | 255 | ||
| Process Date | DateTime | 8 | ||
| Ring Fencing | Boolean | 1 | ||
| Recommended Product | Text | 255 | ||
| Email Address | Text | 255 |