app.sponsor_proof_of_performance
Vista
Proof of performance per sponsor entitlement (gate 8): what is owed against what was delivered, NULL-aware. A countable entitlement is met when the counted deliveries reach the quantity owed; an uncountable one when it is marked fulfilled.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| sponsor_entitlement_id | uuid | Sí | Entitlement. |
| project_id | uuid | Sí | Project. |
| counterparty_id | uuid | Sí | Sponsor. |
| description | text | Sí | The entitlement. |
| quantity_owed | numeric | Sí | How many are owed; NULL when not countable. |
| due_on | date | Sí | When owed. |
| fulfilled_at | timestamp with time zone | Sí | When it was marked delivered. |
| delivery_count | bigint | Sí | Deliveries recorded. |
| quantity_delivered | numeric | Sí | Sum delivered; NULL when there are no deliveries or any delivery was not counted. |
| last_delivered_on | date | Sí | Most recent delivery. |
| is_met | boolean | Sí | True when the entitlement is delivered in full. |