app.integration_payment_queue
View
Approved payments a Connected accounting connection has not received yet, with the counterparty's provider contact when it is mapped.
| Column | Type | Nullable | Description |
|---|---|---|---|
| integration_connection_id | uuid | Yes | Accounting connection to push to. |
| org_id | uuid | Yes | Org of the payment. |
| payment_id | uuid | Yes | Payment. |
| counterparty_id | uuid | Yes | Counterparty paid or paying. |
| counterparty_external_id | text | Yes | Provider contact of the counterparty, or NULL when it is not mapped yet. |
| direction | app.money_direction | Yes | Payable or Receivable. |
| amount_minor | bigint | Yes | Amount in minor units. |
| currency_code | character(3) | Yes | ISO 4217 currency. |
| minor_unit_exponent | smallint | Yes | Decimal places of the currency's minor unit. |
| paid_on | date | Yes | Date the money moved. |
| reference_identifier | text | Yes | Bank or card reference. |