view: orch_app_sm_field_manager {
 sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_SONY_METADATA_SONY_METADATA.FIELD_MANAGER ;;

  dimension: field_manager_id {
    type: number
    sql: ${TABLE}.field_manager_id;;
    hidden: yes
  }

  dimension: financial_label_code {
    label: "Financial Label Code"
    type: string
    sql: ${TABLE}.financial_label_code;;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: gras_imprint_code {
    label: "GRAS Imprint Code"
    type: string
    sql: ${TABLE}.gras_imprint_code;;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: financial_label_name {
    label: "Financial Label Name"
    type: string
    sql: ${TABLE}.financial_label_name;;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: financial_label_name_capitalized {
    label: "Financial Label"
    type: string
    sql: UPPER(${TABLE}.financial_label_name);;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: gras_imprint_name {
    label: "GRAS Imprint Name"
    type: string
    sql: ${TABLE}.gras_imprint_name;;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: rep_owner_code {
    label: "Repertoire Owner Code"
    type: string
    sql: ${TABLE}.rep_owner_code;;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: rep_owner_name {
    label: "Repertoire Owner Name"
    type: string
    sql: ${TABLE}.rep_owner_name;;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: subaccount_id {
    label: "Subaccount ID"
    type: number
    sql: ${TABLE}.subaccount_id;;
    hidden: no
    view_label: "GRAS Registration"
  }

  dimension: vendor_id {
    label: "Label ID"
    type: number
    sql: ${TABLE}.vendor_id;;
    hidden: no
    view_label: "GRAS Registration"
  }

}