# Payments: Mollie Payments - Catalog: `Mollie` - Schema: `V2` - Primary Keys: `id` - Label: Payments This is a read-only table. The Mollie API may not support changing the data or the Invantive UniversalSQL driver for Mollie does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Mollie API. ## Table Columns The columns of the table `Payments` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount_currency` | `varchar2` | Amount (Currency) | ☑ | | | `amount_value` | `decimal` | Amount (Value) | ☑ | | | `amountRefunded_currency` | `varchar2` | Amount Refunded (Currency) | ☐ | | | `amountRefunded_value` | `decimal` | Amount Refunded (Value) | ☐ | | | `amountRemaining_currency` | `varchar2` | Amount Remaining (Currency) | ☐ | | | `amountRemaining_value` | `decimal` | Amount Remaining (Value) | ☐ | | | `countryCode` | `varchar2` | Country Code | ☐ | | | `createdAt` | `datetime` | Date Created | ☑ | | | `description` | `varchar2` | Description | ☐ | | | `details_consumerAccount` | `varchar2` | Details Consumer Account | ☐ | | | `details_consumerBic` | `varchar2` | Details Consumer BIC | ☐ | | | `details_consumerName` | `varchar2` | Details Consumer Name | ☐ | | | `id` | `varchar2` | ID | ☑ | | | `locale` | `varchar2` | Locale | ☐ | | | `metadata` | `varchar2` | Metadata | ☐ | | | `method` | `varchar2` | Method | ☐ | | | `mode` | `varchar2` | Mode | ☑ | | | `paidAt` | `datetime` | Paid at | ☐ | | | `profileId` | `varchar2` | Profile ID | ☐ | | | `redirectUrl` | `varchar2` | Redirect URL | ☐ | | | `resource` | `varchar2` | Resource | ☑ | | | `sequenceType` | `varchar2` | Sequence Type | ☐ | | | `settlementAmount_currency` | `varchar2` | Settlement Amount (Currency) | ☐ | | | `settlementAmount_value` | `decimal` | Settlement Amount (Value) | ☐ | | | `status` | `varchar2` | Status | ☐ | | | `webhookUrl` | `varchar2` | Webhook (URL) | ☐ | |