MDW Shopify Table Spec: fact_transaction_shopify
fact_transaction_shopify
Term | Definition | Datatype |
name | name | String(1000) |
String(1000) | ||
order_id | order_id | String(1000) |
total_tax | total_tax | Amount |
created_at | created_at | Date |
customer_id | customer_id | String(1000) |
source__name | source_name | String(1000) |
total_price | total_price | Amount |
total_weight | total_weight | Amount |
subtotal_price | subtotal_price | Amount |
total_discounts | total_discounts | Amount |
financial_status | financial_status | String(1000) |
fulfillment_status | fulfillment_status | String(1000) |
billing_address_zip | billing_address_zip | String(1000) |
billing_address_city | billing_address_city | String(1000) |
billing_address_name | billing_address_name | String(1000) |
billing_address_phone | billing_address_phone | String(1000) |
total_line_items_price | total_line_items_price | Amount |
billing_address_country | billing_address_country | String(1000) |
billing_address_address1 | billing_address_address1 | String(1000) |
billing_address_address2 | billing_address_address2 | String(1000) |
billing_address_province | billing_address_province | String(1000) |
total_shipping_price_set | total_shipping_price_set | Amount |
billing_address_last_name | billing_address_last_name | String(1000) |
billing_address_first_name | billing_address_first_name | String(1000) |
billing_address_country_code | billing_address_country_code | String(1000) |
fulfillments_line_items_quantity | fulfillments_line_items_quantity | Amount |
refunds_refund_line_items_quantity | refunds_refund_line_items_quantity | Amount |
refunds_refund_line_items_subtotal | refunds_refund_line_items_subtotal | Amount |
refunds_refund_line_items_total_tax | refunds_refund_line_items_total_tax | Amount |
refunds_refund_line_items_subtotal_set | refunds_refund_line_items_subtotal_set | Amount |
refunds_refund_line_items_line_item_price | refunds_refund_line_items_line_item_price | Amount |
refunds_refund_line_items_line_item_quantity | refunds_refund_line_items_line_item_quantity | Amount |
batch_id | ${this.batchID} | String(1000) |
line_items_quantity | line_items_quantity | Amount |
line_items_id | line_items_id | String(1000) |
line_items_title | line_items_title | String(1000) |
line_items_price | line_items_price | Amount |
line_items_sku | line_items_sku | Amount |
line_items_product_id | line_items_product_id | String(1000) |
line_items_grams | line_items_grams | Amount |
orders_count | orders_count | Amount |
tags | tags | Amount |
line_items_total_discount | line_items_total_discount | String(1000) |
line_items_pre_tax_price | line_items_pre_tax_price | String(1000) |
line_items_tax_lines | line_items_tax_lines | String(1000) |
discount_applications_type | discount_applications_type | String(1000) |
discount_applications_description | discount_applications_description | String(1000) |
discount_applications_code | discount_applications_code | String(1000) |
shipping_address_zip | shipping_address_zip | String(1000) |
shipping_address_city | shipping_address_city | String(1000) |
shipping_address_name | shipping_address_name | String(1000) |
shipping_address_phone | shipping_address_phone | String(1000) |
shipping_address_price | shipping_address_price | Amount |
shipping_address_country | shipping_address_country | String(1000) |
shipping_address_address1 | shipping_address_address1 | String(1000) |
shipping_address_address2 | shipping_address_address2 | String(1000) |
shipping_address_province | shipping_address_province | String(1000) |
shipping_address_last_name | shipping_address_last_name | String(1000) |
shipping_address_first_name | shipping_address_first_name | String(1000) |
shipping_address_country_code | shipping_address_country_code | String(1000) |
product_cost | product_cost | Amount |
hashed_address | hashed_address | String(1000) |
utm_campaign | utm_campaign | String(1000) |
utm_source | utm_source | String(1000) |
utm_medium | utm_medium | String(1000) |
utm_typeutm_campaign_referrer | utm_campaign_referrer | String(1000) |
utm_source_referrer | utm_source_referrer | String(1000) |
utm_medium_referrer | utm_medium_referrer | String(1000) |
shipping_interval_frequency | shipping_interval_frequency | String(1000) |
shipping_interval_unit_type | shipping_interval_unit_type | String(1000) |
subscription_id | subscription_id | String(1000) |
email_sha256 | email_sha256 | String(1000) |
gateway | gateway | String(1000) |
processing_method | processing_method | String(1000) |
fulfillments_location_id | fulfillments_location_id | String(1000) |
fulfillments_created_at | fulfillments_created_at | Date(1000) |
fulfillments_updated_at | fulfillments_updated_at | Date(1000) |
shop_name | shop_name | String(1000) |
