# OrderLines ## Documentation The items purchased in the orders, from the same answer as the orders. - Catalog: `Webflow` - Schema: `Ecommerce` - Primary Keys: `order_id, line_number` This is a read-only table. The Webflow API may not support changing the data or the Invantive UniversalSQL driver for Webflow does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Webflow API. ## Table Columns The columns of the table `OrderLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `currency` | `varchar2` | | ☐ | The currency, an ISO 4217 code. | | `line_number` | `int32` | | ☑ | The position of the line in the order, from 1. | | `order_id` | `varchar2` | | ☑ | The order. | | `price_value` | `decimal` | | ☐ | The price of one, in the smallest unit of the currency. | | `product_id` | `varchar2` | | ☐ | The product. | | `product_name` | `varchar2` | | ☐ | The name of the product. | | `quantity` | `decimal` | | ☐ | The number sold. | | `row_total_value` | `decimal` | | ☐ | The total of the line, in the smallest unit of the currency. | | `site_id` | `varchar2` | | ☑ | The site. | | `sku_id` | `varchar2` | | ☐ | The SKU sold. | | `sku_name` | `varchar2` | | ☐ | The name of the SKU. | | `sku` | `varchar2` | | ☐ | The code of the SKU the shop chose. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `order_id` | [[Ecommerce-Orders\|Ecommerce.Orders]] | `id` | Declared by the connector, not enforced by the platform | | `product_id` | [[Ecommerce-Products\|Ecommerce.Products]] | `id` | Declared by the connector, not enforced by the platform | | `sku_id` | [[Ecommerce-ProductSkus\|Ecommerce.ProductSkus]] | `id` | Declared by the connector, not enforced by the platform |