Orders Data Lake Schema [Up to date as of Nov 6, 2023]

[
  {
    "Name": "id",
    "Type": "string"
  },
  {
    "Name": "wdc_order_id",
    "Type": "string"
  },
  {
    "Name": "wdc_website_id",
    "Type": "string"
  },
  {
    "Name": "tenant_id",
    "Type": "string"
  },
  {
    "Name": "wdc_order_status_id",
    "Type": "string"
  },
  {
    "Name": "wdc_order_payment_status_id",
    "Type": "string"
  },
  {
    "Name": "wdc_order_shipping_status_id",
    "Type": "string"
  },
  {
    "Name": "wdc_order_type",
    "Type": "string"
  },
  {
    "Name": "wdc_order_status",
    "Type": "string"
  },
  {
    "Name": "wdc_order_payment_status",
    "Type": "string"
  },
  {
    "Name": "wdc_order_shipping_status",
    "Type": "string"
  },
  {
    "Name": "order_status",
    "Type": "string"
  },
  {
    "Name": "order_payment_status",
    "Type": "string"
  },
  {
    "Name": "fulfillment_status",
    "Type": "string"
  },
  {
    "Name": "order_number",
    "Type": "int"
  },
  {
    "Name": "original_order_date",
    "Type": "timestamp"
  },
  {
    "Name": "wdc_member_id",
    "Type": "string"
  },
  {
    "Name": "is_non_taxable",
    "Type": "boolean"
  },
  {
    "Name": "date_completed",
    "Type": "timestamp"
  },
  {
    "Name": "wdc_wholesale_number",
    "Type": "string"
  },
  {
    "Name": "bypass_fulfillment",
    "Type": "boolean"
  },
  {
    "Name": "is_shipping_price_override",
    "Type": "string"
  },
  {
    "Name": "future_ship_date",
    "Type": "timestamp"
  },
  {
    "Name": "requested_ship_date",
    "Type": "string"
  },
  {
    "Name": "customer_id",
    "Type": "string"
  },
  {
    "Name": "wdc_sales_associate",
    "Type": "string"
  },
  {
    "Name": "wdc_loyalty_points_earned",
    "Type": "int"
  },
  {
    "Name": "wdc_loyalty_points_redeemed",
    "Type": "int"
  },
  {
    "Name": "subtotal_inc_tax",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "subtotal_ex_tax",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "shipping_total_ex_tax",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "handling_cost_ex_tax",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "wdc_liter_tax_total",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "wdc_tip",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "total_inc_tax",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "total_ex_tax",
    "Type": "decimal(10,2)"
  },
  {
    "Name": "updated_at",
    "Type": "timestamp"
  },
  {
    "Name": "staff_notes",
    "Type": "string"
  },
  {
    "Name": "deleted_at",
    "Type": "timestamp"
  },
  {
    "Name": "currency",
    "Type": "string"
  },
  {
    "Name": "wdc_date_modified",
    "Type": "timestamp"
  },
  {
    "Name": "wdc_platform_application",
    "Type": "string"
  },
  {
    "Name": "data_source_name",
    "Type": "string"
  },
  {
    "Name": "created_at",
    "Type": "timestamp"
  },
  {
    "Name": "payments",
    "Type": "array<struct<wdc_order_id:string,wdc_order_tender_id:string,wdc_payment_status_id:string,payment_type:string,amount:decimal(10,2),credit_card_type:string,payment_timestamp:timestamp,is_successful:boolean,data_source_name:string,gateway_transaction_id:string,gateway:string,wdc_payment_status:string>>"
  },
  {
    "Name": "billing_infos",
    "Type": "array<struct<wdc_order_id:string,tenant_id:string,birthdate:date,first_name:string,last_name:string,company:string,street_1:string,street_2:string,city:string,subdivision:string,zip:string,country:string,phone:string,email:string,is_pickup:boolean,data_source_name:string>>"
  },
  {
    "Name": "discounts",
    "Type": "array<struct<tenant_id:string,wdc_order_id:string,discount_name:string,discount_code:string,discount_amount:decimal(10,2),discount_value:decimal(10,2),data_source_name:string>>"
  },
  {
    "Name": "order_items",
    "Type": "array<struct<wdc_order_item_id:string,wdc_order_id:string,order_id:string,order_item_group_id:string,bc_order_product_id:string,bc_product_variant_id:string,variant_id:string,wdc_is_sub_sku:boolean,wdc_parent_sku_id:string,wdc_product_id:string,product_id:string,bc_product_id:string,wdc_product_sku:string,brand_name:string,external_sku:string,wdc_product_title:string,is_digital_product:boolean,weight:decimal(10,2),weight_unit:string,is_non_taxable:boolean,is_price_override:boolean,original_price:decimal(10,2),price:decimal(10,2),quantity:int,currency:string,deposit:decimal(10,2),created_at:timestamp,updated_at:timestamp,deleted_at:timestamp,wdc_cost_of_good:decimal(10,2),data_source_name:string>>"
  },
  {
    "Name": "order_options",
    "Type": "array<struct<wdc_order_id:string,order_level:string,option_type:string,option_value:string,created_at:timestamp,updated_at:timestamp,order_item_group_id:string,order_item_id:string,data_source_name:string>>"
  },
  {
    "Name": "refunds",
    "Type": "array<struct<wdc_order_id:string,wdc_refund_order_id:string,refund_amount:decimal(10,2),tenant_id:string,order_level:string,currency:string,refund_type:string,created_at:timestamp,updated_at:timestamp,order_item_group_id:string,order_item_id:string,payment_id:string,order_payment_id:string,bc_order_payment_id:string,deleted_at:timestamp,data_source_name:string>>"
  },
  {
    "Name": "shipping_infos",
    "Type": "array<struct<wdc_order_id:string,tenant_id:string,order_level:string,bc_shipping_id:string,birthdate:date,first_name:string,last_name:string,company:string,street_1:string,street_2:string,city:string,subdivision:string,zip:string,country:string,phone:string,email:string,total_items_count:int,shipping_cost_ex_tax:decimal(10,2),shipping_cost_inc_tax:decimal(10,2),handling_cost_ex_tax:decimal(10,2),handling_cost_inc_tax:decimal(10,2),is_shipping_price_override:boolean,original_price:decimal(10,2),shipping_total_wo_discount:decimal(10,2),shipping_total_with_discount:decimal(10,2),currency:string,shipping_instructions:string,future_ship_date:timestamp,created_at:timestamp,updated_at:timestamp,order_item_group_id:string,order_item_id:string,deleted_at:timestamp,data_source_name:string>>"
  },
  {
    "Name": "taxes",
    "Type": "array<struct<wdc_order_id:string,wdc_order_item_id:string,tax_amount:decimal(10,2),tax_type:string,included_in_price:boolean,order_level:string,data_source_name:string,name:string>>"
  },
  {
    "Name": "anwd_channel_type",
    "Type": "string"
  },
  { 
    "Name": "sale_type", 
    "Type": "string" 
  },
  {
    "Name": "year",
    "Type": "string",
    "PartitionKey": "Partition (0)"
  },
  {
    "Name": "month",
    "Type": "string",
    "PartitionKey": "Partition (1)"
  },
  {
    "Name": "day",
    "Type": "string",
    "PartitionKey": "Partition (2)"
  },
  {
    "Name": "source",
    "Type": "string",
    "PartitionKey": "Partition (3)"
  }
]