api_external.settlements
View
Settlements of the caller's engagements once submitted to them (Section 4.5.8 Artist Settlement), while the money area is open. Drafts and reworked settlements stay hidden until submitted again. The party accepts or disputes through app.respond_to_settlement.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Settlement. |
| engagement_id | uuid | Yes | Engagement settled. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| settlement_number | bigint | Yes | Number from the project sequence. |
| title | text | Yes | Settlement title. |
| currency_code | character(3) | Yes | ISO 4217 currency. |
| settled_on | date | Yes | Date of the show or period settled. |
| settlement_state | app.settlement_state | Yes | Submitted, Accepted, Disputed, Paid or Canceled. |
| net_minor | bigint | Yes | Additions less deductions and withholding in minor units; NULL while any line is unpriced. |
| submitted_at | timestamp with time zone | Yes | When last submitted. |
| responded_at | timestamp with time zone | Yes | When the party last accepted or disputed it. |