SalesOrderLines: Mollie Sales Order Lines |
Catalog: Mollie
Schema: V2
Primary Keys: id
Label: Sales Order Lines
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 SalesOrderLines are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
amountCanceled_currency |
string |
Amount Canceled (Currency) |
☑ |
|
amountCanceled_value |
decimal |
Amount Canceled (Value) |
☑ |
|
amountRefunded_currency |
string |
Amount Refunded (Currency) |
☑ |
|
amountRefunded_value |
decimal |
Amount Refunded (Value) |
☑ |
|
amountShipped_currency |
string |
Amount Shipped (Currency) |
☑ |
|
amountShipped_value |
decimal |
Amount Shipped (Value) |
☑ |
|
cancelableQuantity |
int32 |
Cancelable Quantity |
☑ |
|
createdAt |
datetime |
Date Created |
☑ |
|
discountAmount_currency |
string |
Discount Amount (Currency) |
☐ |
|
discountAmount_value |
decimal |
Discount Amount (Value) |
☐ |
|
id |
string |
ID |
☑ |
|
isCancelable |
boolean |
Is Cancelable |
☑ |
|
name |
string |
Name |
☑ |
|
orderId |
string |
Order ID |
☑ |
|
quantity |
int32 |
Quantity |
☑ |
|
quantityCanceled |
int32 |
Quantity Canceled |
☑ |
|
quantityRefunded |
int32 |
Quantity Refunded |
☑ |
|
quantityShipped |
int32 |
Quantity Shipped |
☑ |
|
refundableQuantity |
int32 |
Refundable Quantity |
☑ |
|
shippableQuantity |
int32 |
Shippable Quantity |
☑ |
|
sku |
string |
SKU |
☐ |
|
status |
string |
Status |
☑ |
|
totalAmount_currency |
string |
Total Amount (Currency) |
☑ |
|
totalAmount_value |
decimal |
Total Amount (Value) |
☑ |
|
type |
string |
Type |
☑ |
|
unitPrice_currency |
string |
Unit Price (Currency) |
☑ |
|
unitPrice_value |
decimal |
Unit Price (Value) |
☑ |
|
vatAmount_currency |
string |
VAT Amount (Currency) |
☑ |
|
vatAmount_value |
decimal |
VAT Amount (Value) |
☑ |
|
vatRate |
decimal |
VAT Rate |
☑ |
|
16-08-2023 20:15 Version 22.1.262-BETA+4120