MDW Shopify Table Spec: fact_transaction_shopify_aggregate
fact_transaction_shopify_aggregate
Term | Definition | Datatype |
name | name | String(1000) |
order_id | order_id | String(1000) |
total_tax | total_tax | Amount(1000) |
created_at | created_at | Date |
source_name | source_name | String(1000) |
total_price | total_price | Amount(1000) |
subtotal_price | subtotal_price | Amount(1000) |
total_discounts | total_discounts | Amount(1000) |
financial_status | financial_status | String(1000) |
fulfillment_status | fulfillment_status | String(1000) |
billing_address_zip | billing_address_zip | String(1000) |
total_line_items_price | total_line_items_price | Amount(1000) |
billing_address_country | billing_address_country | String(1000) |
total_shipping_price_set_shop_money_amount | total_shipping_price_set_shop_money_amount | Amount(1000) |
billing_address_country_code | billing_address_country_code | String(1000) |
tags | tags | String(1000) |
subscription_id | subscription_id | String(1000) |
gateway | gateway | String(1000) |
processing_method | processing_method | String(1000) |
cancelled_at | cancelled_at | Date |
closed_at | closed_at | Date |
app_id | app_id | Amount(1000) |
cancel_reason | cancel_reason | String(1000) |
currency | currency | String(1000) |
current_subtotal_price | current_subtotal_price | Amount(1000) |
current_total_discounts | current_total_discounts | Amount(1000) |
current_total_tax | current_total_tax | Amount(1000) |
location_id | location_id | Amount(1000) |
number | number | Amount(1000) |
order_number | order_number | Amount(1000) |
payment_gateway_names_joined | payment_gateway_names_joined | String(1000) |
updated_at | updated_at | Date |
orders_count | orders_count | Amount(1000) |
last_order_id | last_order_id | String(1000) |
last_order_name | last_order_name | String(1000) |
billing_address_province_code | billing_address_province_code | String(1000) |
customer_id | customer_id | String(1000) |
batch_id | ${this.batchID} | String(1000) |
shop_name | shop_name | String(1000) |
billing_address_province | billing_address_province | String(1000) |
processed_at | processed_at | Date |
