Table: vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Distribution Model ID | Long | 4 | ||
| Entrepreneur Company ID | Long | 4 | ✓ | |
| Company Programme Year Status ID | Long | 4 | ||
| Delivery Location | Text | 255 | ||
| Company Delivery Location ID | Long | 4 | ||
| Principal Project ID | Long | 4 | ||
| Company Name | Text | 255 | ||
| Principal | Text | 255 | ||
| Project Name | Text | 255 | ||
| Contract Start Date | DateTime | 8 | ||
| Contract End Date | DateTime | 8 | ||
| Product ID | Long | 4 | ||
| Company Product | Text | 255 | ||
| Allocated Weight | Double | 8 | ||
| Monthly Allocated Amount | Double | 8 |