Table: Principal Projects
Primary Key: Principal
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Principal Project ID | Long | 4 | ✓ | |
| Principal ID | Long | 4 | ||
| Sales Brief ID | Long | 4 | ||
| Sales Brief Number | Text | 255 | ||
| Version Number | Double | 8 | ||
| Project Name | Text | 255 | ||
| Solutions Architect | Text | 255 | ||
| Contract Type | Text | 255 | ||
| Principal Project Status ID | Long | 4 | ||
| Brief Date | DateTime | 8 | ||
| Contract Start Date | DateTime | 8 | ||
| Contract End Date | DateTime | 8 | ||
| Contract Number | Text | 255 | ||
| Client Tier ID | Long | 4 | ||
| Entity Contracted | Text | 255 | ||
| Verification Agency Name | Text | 255 | ||
| Principal Verified Date | DateTime | 8 | ||
| Date Principal Requires Packs | DateTime | 8 | ||
| Reporting Frequency ID | Long | 4 | ||
| Additional Marketing Costs | Double | 8 | ||
| Standard Marketing Budget | Double | 8 | ||
| Last Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Pricing Mode | Long | 4 | ||
| Date Principal Needs Spend | DateTime | 8 | ||
| Procurement Commit to Meeting | Long | 4 | ||
| Key Account Manager | Text | 255 |
Indexes
- Principal Projects$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Principal Projects$Principal ID
- Principal Projects$Principal Project Status ID
- Principal Projects$Sales Brief ID