Table: Sales Brief
Primary Key: Sales
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Sales Brief ID | Long | 4 | ✓ | |
| Sales Brief Number | Text | 255 | ||
| Version Number | Double | 8 | ||
| Been Through Gateway | Boolean | 1 | ||
| Been Revised | Boolean | 1 | ||
| Date Created | DateTime | 8 | ||
| Sales Brief Status ID | Long | 4 | ||
| Date Status Changed | DateTime | 8 | ||
| Status Modified By | Text | 255 | ||
| Solutions Architect | Text | 255 | ||
| Key Account Manager | Text | 255 | ||
| Sales Manager | Text | 255 | ||
| Principal ID | Long | 4 | ||
| Contract Type | Text | 255 | ||
| Contract Duration | Text | 255 | ||
| Contract Duration Other | Text | 255 | ||
| How Lead Generated | Text | 255 | ||
| Channel Partner | Text | 255 | ||
| Client (Lead Generated) | Text | 255 | ||
| Conference (Lead Generated) | Text | 255 | ||
| Solution Architect (Lead Generated) | Text | 255 | ||
| Marketing Campaign (Lead Generated) | Text | 255 | ||
| Which Database (Lead Generated) | Text | 255 | ||
| Raizcorp Management (Lead Generated) | Text | 255 | ||
| Lead Report Frequency | Text | 255 | ||
| Verification Agency Name | Text | 255 | ||
| Principal Verified Date | DateTime | 8 | ||
| VA Pack Date | DateTime | 8 | ||
| Non Standard Bookkeeping Process | Long | 4 | ||
| Efficacy Non Standard Elements | Long | 4 | ||
| Standard Ignition Apply | Long | 4 | ||
| Ignition Description | Text | 255 | ||
| Reporting Frequency ID | Long | 4 | ||
| Additional Marketing Costs | Double | 8 | ||
| Standard Marketing Budget | Double | 8 | ||
| Total Stipend Costs | Double | 8 | ||
| Funding Fee Percentage | Double | 8 | ||
| Funding Fee Added to Programme Fee | Long | 4 | ||
| Funding Notes | Text | 255 | ||
| Contract Payment Terms | Text | 255 | ||
| Invoice Day of Month | Text | 255 | ||
| Invoice Day of Month Other | Text | 255 | ||
| Once Off Invoice Date | DateTime | 8 | ||
| Entity Contracted | Text | 255 | ||
| Channel Partner Percentage | Double | 8 | ||
| Channel Partner Approved | Long | 4 | ||
| Channel Partner Approver | Text | 255 | ||
| Notes | Memo | - | ||
| Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Pricing Mode | Long | 4 | ||
| Contract Start Date | DateTime | 8 | ||
| Contract End Date | DateTime | 8 | ||
| Date Principal Needs Spend | DateTime | 8 | ||
| Procurement Commit to Meeting | Long | 4 | ||
| Project | Text | 50 | ||
| Special Negotiated Price Notes | Text | 255 | ||
| Contract FYE | Text | 50 | ||
| Verification Year | Long | 4 | ||
| Store Standard Marketing Budget | Double | 8 | ||
| DeliveryNotes | Memo | - | ||
| MarketingNotes | Memo | - | ||
| FinanceNotes | Memo | - |
Indexes
- Sales Brief$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Sales Brief$Sales Brief Status ID