Table: Principals
Primary Key: Principal
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Principal ID | Long | 4 | ✓ | |
| Second Principal ID | Long | 4 | ✓ | |
| First Principal ID | Long | 4 | ✓ | |
| Principal | Text | 255 | ✓ | |
| Principal Address 1 | Text | 255 | ||
| Principal Address 2 | Text | 255 | ||
| Principal Address 3 | Text | 255 | ||
| Principal Address 4 | Text | 255 | ||
| Channel Partner ID | Long | 4 | ||
| Contact First Name | Text | 255 | ||
| Contact Surname | Text | 255 | ||
| Contact Email | Text | 255 | ||
| Marketing Contact First Name | Text | 255 | ||
| Marketing Contact Surname | Text | 255 | ||
| Marketing Contact Email | Text | 255 | ||
| Marketing Contact Phone | Text | 255 | ||
| Industry ID | Long | 4 | ||
| Industry Charter | Text | 255 | ||
| Industry Notes | Text | 255 | ||
| FYE | Text | 255 | ||
| Last Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Transformation Contact First Name | Text | 255 | ||
| Transformation Contact Surname | Text | 255 | ||
| Transformation Contact Position | Text | 255 | ||
| Transformation Contact Email | Text | 255 | ||
| Transformation Contact Cell | Text | 255 | ||
| Procurement Contact First Name | Text | 255 | ||
| Procurement Contact Surname | Text | 255 | ||
| Procurement Contact Position | Text | 255 | ||
| Procurement Contact Email | Text | 255 | ||
| Procurement Contact Cell | Text | 255 |
Indexes
- Principals$Channel Partner ID
- Principals$Industry ID
- Principals$PrimaryKey [PRIMARY KEY] [UNIQUE]