data.ml
LKML Ecommerce mattresses

Customers

Customers model for ecommerce mattresses.

inferred

Blocks

customers.view.lkml · 299 lines
inferred 
view: customers {
  sql_table_name: Customers ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.Id ;;
  }

  dimension: address {
    sql: ${TABLE}.Address ;;
  }

  dimension: ar_user_id {
    sql: ${TABLE}.AR_User_Id ;;
  }

  dimension: backorder {
    sql: ${TABLE}.Backorder ;;
  }

  dimension: bag_label_format {
    sql: ${TABLE}.Bag_Label_Format ;;
  }

  dimension: bol_flag {
    sql: ${TABLE}.BOL_Flag ;;
  }

  dimension: borrow_rule {
    sql: ${TABLE}.Borrow_Rule ;;
  }

  dimension: cash_bank_branch {
    sql: ${TABLE}.Cash_Bank_Branch ;;
  }

  dimension: financial_institution_name {
    sql: ${TABLE}.Cash_Bank_Name ;;
  }

  dimension: city {
    sql: ${TABLE}.City ;;
  }

  dimension: country_id {
    type: int
    sql: ${TABLE}.Country_Id ;;
  }

  dimension: credit_check_rule {
    sql: ${TABLE}.Credit_Check_Rule ;;
  }

  dimension: credit_limit {
    type: number
    sql: ${TABLE}.Credit_Limit ;;
  }

  dimension: credit_status {
    sql: ${TABLE}.Credit_Status ;;
  }

  dimension: currency {
    sql: ${TABLE}.Currency ;;
  }

  dimension: customer_bill_id {
    sql: ${TABLE}.Customer_Bill_Id ;;
  }

  dimension: date_format {
    sql: ${TABLE}.Date_Format ;;
  }

  dimension: db_rating {
    sql: ${TABLE}.DB_Rating ;;
  }

  dimension: business_alias {
    sql: ${TABLE}.DBA_Name ;;
  }

  dimension: delivery_agent {
    sql: ${TABLE}.Delivery_Agent ;;
  }

  dimension: delivery_cutoff_time {
    sql: ${TABLE}.Delivery_Cutoff_Time ;;
  }

  dimension: delivery_days {
    sql: ${TABLE}.Delivery_Days ;;
  }

  dimension: delivery_lead_time {
    type: number
    sql: ${TABLE}.Delivery_Lead_Time ;;
  }

  dimension: dock_times {
    sql: ${TABLE}.Dock_Times ;;
  }

  dimension: email {
    sql: ${TABLE}.Email ;;
  }

  dimension: entity {
    type: yesno
    sql: ${TABLE}.Entity ;;
  }

  dimension: facility {
    type: yesno
    sql: ${TABLE}.Facility ;;
  }

  dimension: fax {
    sql: ${TABLE}.Fax ;;
  }

  dimension: fax_rule {
    sql: ${TABLE}.Fax_Rule ;;
  }

  dimension: grid_location {
    sql: ${TABLE}.Grid_Location ;;
  }

  dimension: group {
    sql: ${TABLE}."Group" ;;
  }

  dimension: invoice_rule {
    sql: ${TABLE}.Invoice_Rule ;;
  }

  dimension: language {
    sql: ${TABLE}.Language ;;
  }

  dimension: late_charge_flag {
    sql: ${TABLE}.Late_Charge_Flag ;;
  }

  dimension: lawtag_mfg_text {
    sql: ${TABLE}.Lawtag_MFG_Text ;;
  }

  dimension: lyon {
    sql: ${TABLE}.Lyon ;;
  }

  dimension: name {
    sql: ${TABLE}.Name ;;
  }

  dimension: ohm_id {
    sql: ${TABLE}.OHM_Id ;;
  }

  dimension: our_vendor_id {
    sql: ${TABLE}.Our_Vendor_Id ;;
  }

  dimension: payment_terms {
    sql: ${TABLE}.Payment_Terms ;;
  }

  dimension: phone {
    sql: ${TABLE}.Phone ;;
  }

  dimension: price_check_rule {
    sql: ${TABLE}.Price_Check_Rule ;;
  }

  dimension: price_instructions {
    sql: ${TABLE}.Price_Instructions ;;
  }

  dimension: price_list_id {
    type: int
    sql: ${TABLE}.PriceList_Id ;;
  }

  dimension: primary_contact {
    sql: ${TABLE}.Primary_Contact ;;
  }

  dimension: remit_to_source {
    sql: ${TABLE}.Remit_To_Source ;;
  }

  dimension: route_stop {
    type: number
    sql: ${TABLE}.Route_Stop ;;
  }

  dimension: sales_division {
    sql: ${TABLE}.Sales_Division ;;
  }

  dimension: sales_person {
    sql: ${TABLE}.Sales_Person ;;
  }

  dimension: sales_rep_id {
    type: int
    sql: ${TABLE}.SalesRep_Id ;;
  }

  dimension: service_rep {
    sql: ${TABLE}.Service_Rep ;;
  }

  dimension: ship_days {
    type: number
    sql: ${TABLE}.Ship_Days ;;
  }

  dimension: ship_instructions {
    sql: ${TABLE}.Ship_Instructions ;;
  }

  dimension: ship_via {
    sql: ${TABLE}.Ship_Via ;;
  }

  dimension: abbreviation {
    sql: ${TABLE}.Short_Name ;;
  }

  dimension: spiff_rule {
    sql: ${TABLE}.Spiff_Rule ;;
  }

  dimension: state_id {
    type: int
    sql: ${TABLE}.State_Id ;;
  }

  dimension: state_tax_reference {
    sql: ${TABLE}.State_Tax_Reference ;;
  }

  dimension: statement {
    sql: ${TABLE}.Statement ;;
  }

  dimension: status {
    sql: ${TABLE}.Status ;;
  }

  dimension: tax_reference {
    sql: ${TABLE}.Tax_Reference ;;
  }

  dimension: toll_free {
    sql: ${TABLE}.Toll_Free ;;
  }

  dimension: truck_route {
    sql: ${TABLE}.Truck_Route ;;
  }

  dimension: type {
    sql: ${TABLE}.Type ;;
  }

  dimension: warehouse_facility {
    sql: ${TABLE}.Warehouse_Facility ;;
  }

  dimension: web_address {
    sql: ${TABLE}.Web_Address ;;
  }

  dimension: zero_invoice_rule {
    sql: ${TABLE}.Zero_Invoice_Rule ;;
  }

  dimension: zip {
    type: zipcode
    sql: ${TABLE}.Zip ;;
  }

  dimension_group: date_added {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.Date_Added ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
customers.view.lookml · 164 lines
source-preserved 
- view: customers
  sql_table_name: Customers
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: address
    sql: ${TABLE}.Address
  - dimension: ar_user_id
    sql: ${TABLE}.AR_User_Id
  - dimension: backorder
    sql: ${TABLE}.Backorder
  - dimension: bag_label_format
    sql: ${TABLE}.Bag_Label_Format
  - dimension: bol_flag
    sql: ${TABLE}.BOL_Flag
  - dimension: borrow_rule
    sql: ${TABLE}.Borrow_Rule
  - dimension: cash_bank_branch
    sql: ${TABLE}.Cash_Bank_Branch
  - dimension: financial_institution_name
    sql: ${TABLE}.Cash_Bank_Name
  - dimension: city
    sql: ${TABLE}.City
  - dimension: country_id
    type: int
    sql: ${TABLE}.Country_Id
  - dimension: credit_check_rule
    sql: ${TABLE}.Credit_Check_Rule
  - dimension: credit_limit
    type: number
    sql: ${TABLE}.Credit_Limit
  - dimension: credit_status
    sql: ${TABLE}.Credit_Status
  - dimension: currency
    sql: ${TABLE}.Currency
  - dimension: customer_bill_id
    sql: ${TABLE}.Customer_Bill_Id
  - dimension: date_format
    sql: ${TABLE}.Date_Format
  - dimension: db_rating
    sql: ${TABLE}.DB_Rating
  - dimension: business_alias
    sql: ${TABLE}.DBA_Name
  - dimension: delivery_agent
    sql: ${TABLE}.Delivery_Agent
  - dimension: delivery_cutoff_time
    sql: ${TABLE}.Delivery_Cutoff_Time
  - dimension: delivery_days
    sql: ${TABLE}.Delivery_Days
  - dimension: delivery_lead_time
    type: number
    sql: ${TABLE}.Delivery_Lead_Time
  - dimension: dock_times
    sql: ${TABLE}.Dock_Times
  - dimension: email
    sql: ${TABLE}.Email
  - dimension: entity
    type: yesno
    sql: ${TABLE}.Entity
  - dimension: facility
    type: yesno
    sql: ${TABLE}.Facility
  - dimension: fax
    sql: ${TABLE}.Fax
  - dimension: fax_rule
    sql: ${TABLE}.Fax_Rule
  - dimension: grid_location
    sql: ${TABLE}.Grid_Location
  - dimension: group
    sql: ${TABLE}."Group"
  - dimension: invoice_rule
    sql: ${TABLE}.Invoice_Rule
  - dimension: language
    sql: ${TABLE}.Language
  - dimension: late_charge_flag
    sql: ${TABLE}.Late_Charge_Flag
  - dimension: lawtag_mfg_text
    sql: ${TABLE}.Lawtag_MFG_Text
  - dimension: lyon
    sql: ${TABLE}.Lyon
  - dimension: name
    sql: ${TABLE}.Name
  - dimension: ohm_id
    sql: ${TABLE}.OHM_Id
  - dimension: our_vendor_id
    sql: ${TABLE}.Our_Vendor_Id
  - dimension: payment_terms
    sql: ${TABLE}.Payment_Terms
  - dimension: phone
    sql: ${TABLE}.Phone
  - dimension: price_check_rule
    sql: ${TABLE}.Price_Check_Rule
  - dimension: price_instructions
    sql: ${TABLE}.Price_Instructions
  - dimension: price_list_id
    type: int
    sql: ${TABLE}.PriceList_Id
  - dimension: primary_contact
    sql: ${TABLE}.Primary_Contact
  - dimension: remit_to_source
    sql: ${TABLE}.Remit_To_Source
  - dimension: route_stop
    type: number
    sql: ${TABLE}.Route_Stop
  - dimension: sales_division
    sql: ${TABLE}.Sales_Division
  - dimension: sales_person
    sql: ${TABLE}.Sales_Person
  - dimension: sales_rep_id
    type: int
    sql: ${TABLE}.SalesRep_Id
  - dimension: service_rep
    sql: ${TABLE}.Service_Rep
  - dimension: ship_days
    type: number
    sql: ${TABLE}.Ship_Days
  - dimension: ship_instructions
    sql: ${TABLE}.Ship_Instructions
  - dimension: ship_via
    sql: ${TABLE}.Ship_Via
  - dimension: abbreviation
    sql: ${TABLE}.Short_Name
  - dimension: spiff_rule
    sql: ${TABLE}.Spiff_Rule
  - dimension: state_id
    type: int
    sql: ${TABLE}.State_Id
  - dimension: state_tax_reference
    sql: ${TABLE}.State_Tax_Reference
  - dimension: statement
    sql: ${TABLE}.Statement
  - dimension: status
    sql: ${TABLE}.Status
  - dimension: tax_reference
    sql: ${TABLE}.Tax_Reference
  - dimension: toll_free
    sql: ${TABLE}.Toll_Free
  - dimension: truck_route
    sql: ${TABLE}.Truck_Route
  - dimension: type
    sql: ${TABLE}.Type
  - dimension: warehouse_facility
    sql: ${TABLE}.Warehouse_Facility
  - dimension: web_address
    sql: ${TABLE}.Web_Address
  - dimension: zero_invoice_rule
    sql: ${TABLE}.Zero_Invoice_Rule
  - dimension: zip
    type: zipcode
    sql: ${TABLE}.Zip
  - dimension_group: date_added
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.Date_Added
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • customers.view.lkml
  • customers.view.lookml