Order Entity Id Entity Id | | Field ID | orders/entity_id | | Type | NUMBER | | Data Type | dimension |
|
Order Increment Id Increment Id | | Field ID | orders/increment_id | | Type | TEXT | | Data Type | dimension |
|
Order is Virtual Increment Id | | Field ID | orders/is_virtual | | Type | BOOLEAN | | Data Type | dimension |
|
Order Applied Rule Ids Increment Id | | Field ID | orders/applied_rule_ids | | Type | TEXT | | Data Type | dimension |
|
Order Base Currency Code Base Currency Code | | Field ID | orders/base_currency_code | | Type | TEXT | | Data Type | dimension |
|
Order Base Discount Amount Base Discount Amount | | Field ID | orders/base_discount_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Base Discount Canceled Base Discount Canceled | | Field ID | orders/base_discount_canceled | | Type | NUMBER | | Data Type | dimension |
|
Order Base Discount Invoiced Base Discount Invoiced | | Field ID | orders/base_discount_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Base Discount Refunded Base Discount Refunded | | Field ID | orders/base_discount_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Base Discount Tax Compensation Amount Base Discount Tax Compensation Amount | | Field ID | orders/base_discount_tax_compensation_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Base Discount Tax Compensation Invoiced Base Discount Tax Compensation Invoiced | | Field ID | orders/base_discount_tax_compensation_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Base Discount Tax Compensation Refunded Base Discount Tax Compensation Refunded | | Field ID | orders/base_discount_tax_compensation_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Base Grand Total Base Grand Total | | Field ID | orders/base_grand_total | | Type | NUMBER | | Data Type | dimension |
|
Order Base Shipping Amount Base Shipping Amount | | Field ID | orders/base_shipping_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Base Shipping Incl Tax Base Shipping Incl Tax | | Field ID | orders/base_shipping_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Base Shipping Tax Amount Base Shipping Tax Amount | | Field ID | orders/base_shipping_tax_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Base Subtotal Base Subtotal | | Field ID | orders/base_subtotal | | Type | NUMBER | | Data Type | dimension |
|
Order Base Subtotal Incl Tax Base Subtotal Incl Tax | | Field ID | orders/base_subtotal_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Base Tax Amount Base Tax Amount | | Field ID | orders/base_tax_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Base Total Due Base Total Due | | Field ID | orders/base_total_due | | Type | NUMBER | | Data Type | dimension |
|
Order Base To Global Rate Base To Global Rate | | Field ID | orders/base_to_global_rate | | Type | NUMBER | | Data Type | dimension |
|
Order Base To Order Rate Base To Order Rate | | Field ID | orders/base_to_order_rate | | Type | NUMBER | | Data Type | dimension |
|
Order Billing Address Id Billing Address Id | | Field ID | orders/billing_address_id | | Type | NUMBER | | Data Type | dimension |
|
Order Customer Id Customer Id | | Field ID | orders/customer_id | | Type | NUMBER | | Data Type | dimension |
|
Order Customer Group Id Customer Group Id | | Field ID | orders/customer_group_id | | Type | NUMBER | | Data Type | dimension |
|
Order Customer Email Customer Email | | Field ID | orders/customer_email | | Type | TEXT | | Data Type | dimension |
|
Order Customer Fullname Customer Fullname | | Field ID | orders/customer_full_name | | Type | TEXT | | Data Type | dimension |
|
Order Customer Is Guest Customer Is Guest | | Field ID | orders/customer_is_guest | | Type | BOOLEAN | | Data Type | dimension |
|
Order Discount Amount Discount Amount | | Field ID | orders/discount_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Discount Canceled Discount Canceled | | Field ID | orders/discount_canceled | | Type | NUMBER | | Data Type | dimension |
|
Order Discount Invoiced Discount Invoiced | | Field ID | orders/discount_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Discount Refunded Discount Refunded | | Field ID | orders/discount_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Discount Tax Compensation Amount Discount Tax Compensation Amount | | Field ID | orders/discount_tax_compensation_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Discount Tax Compensation Invoiced Discount Tax Compensation Invoiced | | Field ID | orders/discount_tax_compensation_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Discount Tax Compensation Refunded Discount Tax Compensation Refunded | | Field ID | orders/discount_tax_compensation_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Email Sent Email Sent | | Field ID | orders/email_sent | | Type | BOOLEAN | | Data Type | dimension |
|
Order Global Currency Code Global Currency Code | | Field ID | orders/global_currency_code | | Type | TEXT | | Data Type | dimension |
|
Order Grand Total Grand Total | | Field ID | orders/grand_total | | Type | NUMBER | | Data Type | dimension |
|
Order Currency Code Order Currency Code | | Field ID | orders/order_currency_code | | Type | TEXT | | Data Type | dimension |
|
Order Payment Method Payment Method | | Field ID | orders/payment_method | | Type | TEXT | | Data Type | dimension |
|
Order Protect Code Protect Code | | Field ID | orders/protect_code | | Type | TEXT | | Data Type | dimension |
|
Order Quote Id Quote Id | | Field ID | orders/quote_id | | Type | NUMBER | | Data Type | dimension |
|
Order Remote Ip Remote Ip | | Field ID | orders/remote_ip | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Amount Shipping Amount | | Field ID | orders/shipping_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Canceled Shipping Canceled | | Field ID | orders/shipping_canceled | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Discount Amount Shipping Discount Amount | | Field ID | orders/shipping_discount_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Discount Tax Compensation Amount Shipping Discount Tax Compensation Amount | | Field ID | orders/shipping_discount_tax_compensation_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Incl Tax Shipping Incl Tax | | Field ID | orders/shipping_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Invoiced Shipping Invoiced | | Field ID | orders/shipping_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Refunded Shipping Refunded | | Field ID | orders/shipping_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Tax Amount Shipping Tax Amount | | Field ID | orders/shipping_tax_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Tax Refunded Shipping Tax Refunded | | Field ID | orders/shipping_tax_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Shipping Method Shipping Method | | Field ID | orders/shipping_method | | Type | TEXT | | Data Type | dimension |
|
Order Shipping City Shipping City | | Field ID | orders/shipping_city | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Region Shipping Region | | Field ID | orders/shipping_region | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Region Code Shipping Region Code | | Field ID | orders/shipping_region_code | | Type | TEXT | | Data Type | dimension |
|
Order Shipping Country Code Shipping Country Code | | Field ID | orders/shipping_country_code | | Type | TEXT | | Data Type | dimension |
|
Order Status Status | | Field ID | orders/status | | Type | TEXT | | Data Type | dimension |
|
Order Store Currency Code Store Currency Code | | Field ID | orders/store_currency_code | | Type | TEXT | | Data Type | dimension |
|
Order Store Id Store Id | | Field ID | orders/store_id | | Type | NUMBER | | Data Type | dimension |
|
Order Store Name Store Name | | Field ID | orders/store_name | | Type | TEXT | | Data Type | dimension |
|
Order Store To Base Rate Store To Base Rate | | Field ID | orders/store_to_base_rate | | Type | NUMBER | | Data Type | dimension |
|
Order Store To Order Rate Store To Order Rate | | Field ID | orders/store_to_order_rate | | Type | NUMBER | | Data Type | dimension |
|
Order Subtotal Subtotal | | Field ID | orders/subtotal | | Type | NUMBER | | Data Type | dimension |
|
Order Subtotal Incl Tax Subtotal Incl Tax | | Field ID | orders/subtotal_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Subtotal Cancelled Subtotal Cancelled | | Field ID | orders/subtotal_cancelled | | Type | NUMBER | | Data Type | dimension |
|
Order Subtotal Invoiced Subtotal Invoiced | | Field ID | orders/subtotal_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Subtotal Refunded Subtotal Refunded | | Field ID | orders/subtotal_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Tax Amount Tax Amount | | Field ID | orders/tax_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Tax Canceled Tax Canceled | | Field ID | orders/tax_canceled | | Type | NUMBER | | Data Type | dimension |
|
Order Tax Invoiced Tax Invoiced | | Field ID | orders/tax_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Tax Refunded Tax Refunded | | Field ID | orders/tax_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Total Cancelled Total Cancelled | | Field ID | orders/total_cancelled | | Type | NUMBER | | Data Type | dimension |
|
Order Total Due Total Due | | Field ID | orders/total_due | | Type | NUMBER | | Data Type | dimension |
|
Order Total Invoiced Total Invoiced | | Field ID | orders/total_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Total Item Count Total Item Count | | Field ID | orders/total_item_count | | Type | NUMBER | | Data Type | dimension |
|
Order Total Offline Refunded Total Offline Refunded | | Field ID | orders/total_offline_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Total Online Refunded Total Online Refunded | | Field ID | orders/total_online_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Total Paid Total Paid | | Field ID | orders/total_paid | | Type | NUMBER | | Data Type | dimension |
|
Order Total Qty Ordered Total Qty Ordered | | Field ID | orders/total_qty_ordered | | Type | NUMBER | | Data Type | dimension |
|
Order Total Refunded Total Refunded | | Field ID | orders/total_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Weight Weight | | Field ID | orders/weight | | Type | NUMBER | | Data Type | dimension |
|
Order Created At Created At | | Field ID | orders/created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Order Updated At Updated At | | Field ID | orders/updated_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Year Year such as 2017. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR | | Type | YEAR | | Data Type | dimension |
|
Year Quarter Year and quarter. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | | Type | YEAR_QUARTER | | Data Type | dimension |
|
Year month Year and month. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | | Type | YEAR_MONTH | | Data Type | dimension |
|
Year week Year and week. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | | Type | YEAR_WEEK | | Data Type | dimension |
|
Date Year, month, and day. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Year month day hour Year, month, day, and hour. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | | Type | YEAR_MONTH_DAY_HOUR | | Data Type | dimension |
|
Quarter of the year Quarter of the year | | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | | Type | QUARTER | | Data Type | dimension |
|
Month of the year Month of the year | | Field ID | _NORMALIZED_DATE_FIELD_MONTH | | Type | MONTH | | Data Type | dimension |
|
Week of the year Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK | | Type | WEEK | | Data Type | dimension |
|
Week of the year (start Sunday) Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY | | Type | WEEK | | Data Type | dimension |
|
Month and day Month and day | | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | | Type | MONTH_DAY | | Data Type | dimension |
|
Day of the week Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | | Type | DAY_OF_WEEK | | Data Type | dimension |
|
Day of the month Day of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY | | Type | DAY | | Data Type | dimension |
|
Hour of the day Hour of the day | | Field ID | _NORMALIZED_DATE_FIELD_HOUR | | Type | HOUR | | Data Type | dimension |
|
Amount Refunded Order Item Amount refunded | | Field ID | order_items/amount_refunded | | Type | NUMBER | | Data Type | dimension |
|
Applied Rule Ids Order Item Applied rule ids | | Field ID | order_items/applied_rule_ids | | Type | TEXT | | Data Type | dimension |
|
Order Item Base Amount Refunded Order Item Base amount refunded | | Field ID | order_items/base_amount_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Discount Amount Order Item Base discount amount | | Field ID | order_items/base_discount_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Discount Invoiced Order Item Base discount invoiced | | Field ID | order_items/base_discount_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Discount Tax Compensation Amount Order Item Base discount tax compensation amount | | Field ID | order_items/base_discount_tax_compensation_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Original Price Order Item Base original price | | Field ID | order_items/base_original_price | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Price Order Item Base price | | Field ID | order_items/base_price | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Price Incl Tax Order Item Base price incl tax | | Field ID | order_items/base_price_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Row Invoiced Order Item Base row invoiced | | Field ID | order_items/base_row_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Row Total Order Item Base row total | | Field ID | order_items/base_row_total | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Row Total Incl Tax Order Item Base row total incl tax | | Field ID | order_items/base_row_total_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Tax Amount Order Item Base tax amount | | Field ID | order_items/base_tax_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Item Base Tax Invoiced Order Item Base tax invoiced | | Field ID | order_items/base_tax_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Item Created At Order Item created at | | Field ID | order_items/created_at | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Order Item Discount Amount Order Item discount amount | | Field ID | order_items/discount_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Item Discount Invoiced Order Item discount invoiced | | Field ID | order_items/discount_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Item Discount Percent Order Item discount percent | | Field ID | order_items/discount_percent | | Type | NUMBER | | Data Type | dimension |
|
Order Item Discount Tax Compensation Amount Order Item discount tax compensation amount | | Field ID | order_items/discount_tax_compensation_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Item Is Qty Decimal Order Item is qty decimal | | Field ID | order_items/is_qty_decimal | | Type | NUMBER | | Data Type | dimension |
|
Order Item Is Virtual Order Item is virtual | | Field ID | order_items/is_virtual | | Type | NUMBER | | Data Type | dimension |
|
Order Item Id Order Item id | | Field ID | order_items/item_id | | Type | NUMBER | | Data Type | dimension |
|
Order Item Name Order Item name | | Field ID | order_items/name | | Type | TEXT | | Data Type | dimension |
|
Order Item No Discount Order Item no discount | | Field ID | order_items/no_discount | | Type | NUMBER | | Data Type | dimension |
|
Order Item Order Id Order Item order id | | Field ID | order_items/order_id | | Type | NUMBER | | Data Type | dimension |
|
Order Item Original Price Order Item original price | | Field ID | order_items/original_price | | Type | NUMBER | | Data Type | dimension |
|
Order Item Price Order Item price | | Field ID | order_items/price | | Type | NUMBER | | Data Type | dimension |
|
Order Item Price Incl Tax Order Item price incl tax | | Field ID | order_items/price_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Item Product Id Order Item product id | | Field ID | order_items/product_id | | Type | NUMBER | | Data Type | dimension |
|
Order Item Product Type Order Item product type | | Field ID | order_items/product_type | | Type | TEXT | | Data Type | dimension |
|
Order Item Qty Canceled Order Item qty canceled | | Field ID | order_items/qty_canceled | | Type | NUMBER | | Data Type | dimension |
|
Order Item Qty Invoiced Order Item qty invoiced | | Field ID | order_items/qty_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Item Qty Ordered Order Item qty ordered | | Field ID | order_items/qty_ordered | | Type | NUMBER | | Data Type | dimension |
|
Order Item Qty Refunded Order Item qty refunded | | Field ID | order_items/qty_refunded | | Type | NUMBER | | Data Type | dimension |
|
Order Item Qty Shipped Order Item qty shipped | | Field ID | order_items/qty_shipped | | Type | NUMBER | | Data Type | dimension |
|
Order Item Row Invoiced Order Item row invoiced | | Field ID | order_items/row_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Item Row Total Order Item row total | | Field ID | order_items/row_total | | Type | NUMBER | | Data Type | dimension |
|
Order Item Row Total Incl Tax Order Item row total incl tax | | Field ID | order_items/row_total_incl_tax | | Type | NUMBER | | Data Type | dimension |
|
Order Item Row Weight Order Item row weight | | Field ID | order_items/row_weight | | Type | NUMBER | | Data Type | dimension |
|
Order Item Sku Order Item sku | | Field ID | order_items/sku | | Type | TEXT | | Data Type | dimension |
|
Order Item Store Id Order Item store id | | Field ID | order_items/store_id | | Type | NUMBER | | Data Type | dimension |
|
Order Item Tax Amount Order Item tax amount | | Field ID | order_items/tax_amount | | Type | NUMBER | | Data Type | dimension |
|
Order Item Tax Invoiced Order Item tax invoiced | | Field ID | order_items/tax_invoiced | | Type | NUMBER | | Data Type | dimension |
|
Order Item Tax Percent Order Item tax percent | | Field ID | order_items/tax_percent | | Type | NUMBER | | Data Type | dimension |
|
Order Item Updated At Order Item updated at | | Field ID | order_items/updated_at | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Order Item Weight Order Item weight | | Field ID | order_items/weight | | Type | NUMBER | | Data Type | dimension |
|
Extracted Date The date where the extraction take times. | | Field ID | _catchr_date_extract | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Platform Name Return the platform name | | Field ID | _catchr_platform_name | | Type | TEXT | | Data Type | dimension |
|
.svg){kind=logo}