SalesOrders: Mollie Sales Orders |
Catalog: Mollie
Schema: V2
Primary Keys: id
Label: Sales Orders
This is a read-only table. The Mollie API may not support changing the data or the Invantive SQL 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 SalesOrders are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
amount_currency |
string |
Amount (Currency) |
☑ |
|
amount_value |
decimal |
Amount (Value) |
☑ |
|
amountCaptured_currency |
string |
Amount Captured (Currency) |
☐ |
|
amountCaptured_value |
decimal |
Amount Captured (Value) |
☐ |
|
amountRefunded_currency |
string |
Amount Refunded (Currency) |
☐ |
|
amountRefunded_value |
decimal |
Amount Refunded (Value) |
☐ |
|
authorizedAt |
datetime |
Authorized at |
☐ |
|
billingAddress_city |
string |
Billing Address City |
☐ |
|
billingAddress_country |
string |
Billing Address Country |
☐ |
|
billingAddress_email |
string |
Billing Address Email |
☐ |
|
billingAddress_familyName |
string |
Billing Address Family Name |
☐ |
|
billingAddress_givenName |
string |
Billing Address Given Name |
☐ |
|
billingAddress_organizationName |
string |
Billing Address Organization Name |
☐ |
|
billingAddress_phone |
string |
Billing Address Phone |
☐ |
|
billingAddress_postalCode |
string |
Billing Address Postal Code |
☐ |
|
billingAddress_region |
string |
Billing Address Region |
☐ |
|
billingAddress_streetAdditional |
string |
Billing Address Street Additional |
☐ |
|
billingAddress_streetAndNumber |
string |
Billing Address Street and Number |
☐ |
|
billingAddress_title |
string |
Billing Address Title |
☐ |
|
canceledAt |
datetime |
Canceled at |
☐ |
|
cancelUrl |
string |
Cancel (URL) |
☐ |
|
completedAt |
datetime |
Completed at |
☐ |
|
consumerDateOfBirth |
datetime |
Consumer Date of Birth |
☐ |
|
createdAt |
datetime |
Date Created |
☑ |
|
expiresAt |
datetime |
Expires at |
☐ |
|
id |
string |
ID |
☑ |
|
isCancelable |
boolean |
Is Cancelable |
☑ |
|
locale |
string |
Locale |
☐ |
|
metadata |
string |
Metadata |
☐ |
|
method |
string |
Method |
☐ |
|
mode |
string |
Mode |
☑ |
|
orderNumber |
string |
Order Number |
☑ |
|
paidAt |
datetime |
Paid at |
☐ |
|
profileId |
string |
Profile ID |
☐ |
|
redirectUrl |
string |
Redirect URL |
☐ |
|
resource |
string |
Resource |
☑ |
|
shippingAddress_city |
string |
Shipping Address City |
☐ |
|
shippingAddress_country |
string |
Shipping Address Country |
☐ |
|
shippingAddress_email |
string |
Shipping Address Email |
☐ |
|
shippingAddress_familyName |
string |
Shipping Address Family Name |
☐ |
|
shippingAddress_givenName |
string |
Shipping Address Given Name |
☐ |
|
shippingAddress_organizationName |
string |
Shipping Address Organization Name |
☐ |
|
shippingAddress_phone |
string |
Shipping Address Phone |
☐ |
|
shippingAddress_postalCode |
string |
Shipping Address Postal Code |
☐ |
|
shippingAddress_region |
string |
Shipping Address Region |
☐ |
|
shippingAddress_streetAdditional |
string |
Shipping Address Street Additional |
☐ |
|
shippingAddress_streetAndNumber |
string |
Shipping Address Street and Number |
☐ |
|
shippingAddress_title |
string |
Shipping Address Title |
☐ |
|
shopperCountryMustMatchBillingCountry |
boolean |
Shopper Country must match Billing Country |
☑ |
|
status |
string |
Status |
☑ |
|
webhookUrl |
string |
Webhook (URL) |
☐ |
|
16-08-2023 20:15 Version 22.1.262-BETA+4120