Table: vwGarnetRptPrincipalProjectAllocation
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Company Status ID | Long | 4 | ||
| Replacement Status | Text | 255 | ||
| Principal Project Status ID | Long | 4 | ||
| Lump Sum Allocation | Boolean | 1 | ||
| Principal Project | Memo | - | ✓ | |
| BBBEE Pillar | Text | 255 | ||
| Status | Text | 255 | ||
| Company Name | Text | 255 | ||
| Allocated Amount | Double | 8 | ||
| Selection Fee | Double | 8 | ||
| Total Sponsorship | Double | 8 | ✓ | |
| Sum Tot Sponsorship | Double | 8 | ✓ | |
| Amt Sponsored | Double | 8 | ✓ | |
| Contract Start Date | DateTime | 8 | ||
| Contract End Date | DateTime | 8 | ||
| Programme Year | Text | 10 | ||
| Product | Text | 255 | ||
| Delivery Location | Text | 255 | ||
| Ring Fence | Boolean | 1 | ||
| Number of Current Companies by Principal Project | Long | 4 | ||
| Number of Current Entrepreneurs by Principal Project | Long | 4 |