api_external.deliverables
View
What the caller's engagements owe (Section 4.4.4 Contractor), with their state, fee, the latest submission and any reason the org returned it, while the operational area is open. Who decided never appears.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Deliverable. |
| engagement_id | uuid | Yes | Engagement. |
| record_id | uuid | Yes | Record naming what is owed. |
| record_kind | text | Yes | Record kind. |
| title | text | Yes | What is owed. |
| due_at | timestamp with time zone | Yes | When it is due. |
| deliverable_state | app.deliverable_state | Yes | Open, Submitted, Accepted or Returned. |
| document_id | uuid | Yes | Document handed in. |
| submission_message | text | Yes | The party's message. |
| submitted_at | timestamp with time zone | Yes | When handed in. |
| decided_at | timestamp with time zone | Yes | When accepted or returned. |
| return_reason | text | Yes | Why it was returned. |
| fee_minor | bigint | Yes | Agreed fee in minor units; NULL is unpriced. |
| currency_code | character(3) | Yes | Currency of the fee. |