api_external.purchase_orders
View
Purchase orders the org sent the caller's account, for its Owner, Admin and Finance members while the account's engagement on the project has the money area open (Section 8.7). Drafts never appear. Totals are NULL while any line is unpriced.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Purchase order. |
| org_id | uuid | Yes | Org. |
| org_name | text | Yes | Org name. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| account_id | uuid | Yes | The caller's account. |
| po_number | bigint | Yes | Order number within the project. |
| currency_code | character(3) | Yes | Currency. |
| po_state | app.po_state | Yes | Sent, Closed or Canceled. |
| total_minor | bigint | Yes | Total in minor units; NULL while any line is unpriced. |
| sent_at | timestamp with time zone | Yes | When the org sent it. |
| acknowledged_at | timestamp with time zone | Yes | When the account acknowledged it. |