Table: vwPurpleGetBEEAndTaxClearanceAlerts
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Entrepreneur ID | Long | 4 | ✓ | |
| Process Status | Text | 255 | ||
| Company Status | Text | 255 | ||
| Process Status ID | Long | 4 | ||
| Company Status ID | Long | 4 | ||
| Date Record Created | DateTime | 8 | ||
| Delivery Location ID | Long | 4 | ||
| Delivery Location | Text | 255 | ||
| First Name | Text | 255 | ||
| Surname | Text | 255 | ||
| Company Name | Text | 255 | ||
| BEE Certificate Expire Date | DateTime | 8 | ||
| Tax Clearance Expire Date | DateTime | 8 | ||
| OwnedBy | Text | 255 |