Table: Sales Brief Extra Sponsor Elements
Primary Key: Sales
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Sales Brief Extra Sponsor Elements ID | Long | 4 | ✓ | |
| Sales Brief ID | Long | 4 | ||
| BBBEE Pillar | Text | 50 | ||
| Element Type | Text | 50 | ||
| Sponsorship Amount | Double | 8 | ||
| Admin Fee | Double | 8 | ||
| Number of Entrepreneurs | Long | 4 | ||
| Frequency of Payments | Text | 50 | ||
| Once Off Payment Date | DateTime | 8 | ||
| Monthly Day of Month | Text | 50 | ||
| Payment Amount | Double | 8 |
Indexes
- PK_Sales Brief Extra Sponsor Elements [PRIMARY KEY] [UNIQUE]