Table: Sales Brief Selection Marketing
Primary Key: Sales
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Sales Brief Selection Marketing ID | Long | 4 | ✓ | |
| Sales Brief ID | Long | 4 | ||
| BBBEE Pillar | Text | 255 | ||
| DELETE Product ID | Long | 4 | ||
| DELETE Sponsorship Amount | Double | 8 | ||
| Minimum Companies Required | Long | 4 | ||
| Marketing Campaign Required | Long | 4 | ||
| Principal Campaign Branded | Long | 4 | ||
| Launch Required | Long | 4 | ||
| Principal Launch Budget | Double | 8 | ||
| Raizcorp Launch Budget | Double | 8 | ||
| Who Arranges Launch | Long | 4 | ||
| PR Type | Text | 255 | ||
| Info Session Type | Text | 255 | ||
| Principal Approve Candidate Leads | Long | 4 | ||
| Principal Approve Candidate | Long | 4 | ||
| Cohort Ignition Qtr | Text | 255 | ||
| Cohort Ignition Year | Long | 4 | ||
| Principal Subsidise Assessment Fee | Long | 4 | ||
| Subsidised Assessment Amount | Double | 8 | ||
| Supply Chain Requirement | Text | 255 | ||
| Supporting Doc Affidavit (EME) | Boolean | 1 | ||
| Supporting Doc BEE Certificate | Boolean | 1 | ||
| Supporting Doc Certified ID Copy | Boolean | 1 | ||
| Supporting Doc CK1 Document | Boolean | 1 | ||
| Supporting Doc EMP201 | Boolean | 1 | ||
| Supporting Doc Employee Payslips | Boolean | 1 | ||
| Supporting Doc IRP5 | Boolean | 1 | ||
| Supporting Doc VAT Registration | Boolean | 1 | ||
| Supporting Doc Proof of Turnover | Boolean | 1 | ||
| Supporting Doc Tax Clearance Certificate | Boolean | 1 | ||
| Supporting Doc Other | Boolean | 1 | ||
| Supporting Doc Other Text | Text | 255 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Supporting Doc Employee Contract | Boolean | 1 |
Indexes
- Sales Brief Selection Marketing$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Sales Brief Selection Marketing$Product ID
- Sales Brief Selection Marketing$Sales Brief ID