view: advertising_requests {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."ORCHARD_NEW_ADVERTISING_REQUESTS" ;;

  dimension: label_name {
    description: "Label Name"
    view_label: "Label Details"
    type: string
    sql: ${TABLE}."LABEL_NAME" ;;
  }

  dimension: label_manager {
    description: "Label Manager"
    view_label: "Label Details"
    type: string
    sql: ${TABLE}."LABEL_MANAGER" ;;
  }

  dimension: label_id {
    description: "Label ID"
    view_label: "Label Details"
    type: string
    sql: ${TABLE}."LABEL_ID" ;;
  }

  dimension: UPC {
    description: "UPC"
    view_label: "Release"
    type: string
    sql: ${TABLE}."UPC" ;;
  }

  dimension: exceptions {
    description: "Exception (from label) (from release UPC)"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."EXCEPTIONS" ;;
  }

  dimension: artist_name {
    description: "Artist Name"
    view_label: "Release"
    type: string
    sql: ${TABLE}."ARTIST_NAME" ;;
  }

  dimension: release_name {
    description: "Release Name"
    view_label: "Release"
    type: string
    sql: ${TABLE}."RELEASE_NAME" ;;
  }

  dimension: invoice_number {
    description: "Invoice Number"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."INVOICE_NUMBER" ;;
  }

## dimension: distribution_fee {
##    description: "Distribution fee"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."DISTRO_FEE" ;;
##  }

##  dimension: campaign_objective {
##    description: "Campaign Objective"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."CAMPAIGN_OBJECTIVE" ;;
##  }

  dimension: status {
    description: "Request Status - The stage at which the request is at"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."STATUS" ;;
  }

  dimension: requester_name {
    description: "Name of the person who submitted the form"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUESTER_NAME" ;;
  }

  dimension: requester_email {
    description: "Email of the person who submitted the form"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUESTER_EMAIL" ;;
  }

##  dimension: request_id {
##    description: "Request ID"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."REQUEST_ID" ;;
##  }

  dimension: request_reference {
    description: "Artist name + release name + request ID"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."REQUEST_REFERENCE" ;;
  }

##  dimension: assigned_to {
##    description: "Who is the request assigned to  - legacy field"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."ASSIGNED_TO" ;;
##  }

  dimension: strategy_assigned_to_name {
    description: "Who is the request assigned to  - newer field"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."STRATEGY_ASSIGNED_TO_NAME" ;;
  }

##  dimension: autonumber {
##    description: "Autonumber"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."AUTONUMBER" ;;
##  }

  dimension: priority {
    description: "Priority Level of Label of the Request"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."PRIORITY" ;;
  }

  dimension: PO_number {
    description: "PO number"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."PO_NUMBER" ;;
  }

  dimension: territory_assignment {
    description: "The territory to which the request was assigned"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."TERRITORY_ASSIGNMENT" ;;
  }

##  dimension: label_tier_request {
##    description: "The Label Tier of requesting Label"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."LABEL_TIER_REQUEST" ;;
##  }

##  dimension: form_version {
##    description: "Which form version was used"
##    view_label: "Advertising"
##    type: string
##    sql: ${TABLE}."FORM_VERSION" ;;
##  }

  dimension: payment {
    description: "Type of payment (Recoupable, invoice, credits etc.)"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."PAYMENT" ;;
  }

  dimension: admin_fee {
    description: "Advertising fee to charge on top of advertising spend"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."ADMIN_FEE" ;;
  }

  measure: allocated_budget {
    description: "The budget allocated to the request"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."ALLOCATED_BUDGET" ;;
    value_format:"$#,##0"
  }

  measure: budget {
    description: "Amount in dollars to spend"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."BUDGET" ;;
    value_format:"$#,##0"
  }

##  measure: new_adjusted_costs {
##    description: "The cumulative `total adjusted costs` from all linked Campaign records.Same as Total Adjusted costs"
##    view_label: "Advertising"
##    type: sum
##    sql: ${TABLE}."NEW_ADJUSTED_COSTS" ;;
##    value_format:"$#,##0"
##  }

  dimension: distro_fee {
    description: "Distro Fee"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."DISTRO_FEE" ;;
  }

  dimension: support_assigned_to_name {
    description: "Who is the request assigned to?"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."SUPPORT_ASSIGNED_TO_NAME" ;;
  }

  dimension: service_tier {
    description: "Service Tier"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."SERVICE_TIER" ;;
  }

  dimension: service_type {
    description: "Service Type"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."SERVICE_TYPE" ;;
  }

  dimension: label_tier {
    description: "Label Tier"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."LABEL_TIER" ;;
  }

  dimension: ad_plan {
    description: "AD Plan"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."AD_PLAN" ;;
  }

  dimension: total_campaign_number {
    description: "Total Campaign Number"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."TOTAL_CAMPAIGN_NUMBER" ;;
  }

  dimension: orhard_label_manager_email {
    description: "Orchard Label Manager Email"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."LABEL_MANAGER_EMAIL" ;;
  }

  dimension: finance_approves {
    description: "Finance Approves"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."FINANCE_APPROVES" ;;
  }

  dimension: invoice_payment_status {
    description: "Invoice Payment Status"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."INVOICE_PAYMENT_STATUS" ;;
  }

  dimension: label_manager_country {
    description: "Label Manager Country"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."LABEL_MANAGER_COUNTRY" ;;
  }

  dimension: label_manager_email {
    description: "Label Manager Email"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."LABEL_MANAGER_EMAIL" ;;
  }

  dimension: manual_financial_trigger {
    description: "Manual Financial Trigger"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."MANUAL_FINANCIAL_TRIGGER" ;;
  }

  dimension: finance_approves_fx {
    description: "Finance Approves FX"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."FINANCE_APPROVES_FX" ;;
  }

  dimension: fee_exception {
    description: "Fee Exception"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."FEE_EXCEPTION" ;;
  }

  dimension: operational_rate {
    description: "Operational Rate"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."OPERATIONAL_RATE" ;;
  }


  dimension: oa_genre {
    description: "OA Genre"
    view_label: "Advertising"
    type: string
    sql: ${TABLE}."OA_GENRE" ;;
  }

  measure: total_adjusted_costs {
    description: "The cumulative `total adjusted costs` from all linked Campaign records. Same as New Adjusted Costs"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."TOTAL_ADJUSTED_COSTS" ;;
    value_format:"$#,##0"
  }

##  measure: new_label_amount {
##    description: "The cumulative `total label amount` from all linked Campaign records. Same as Total Label Amount"
##    view_label: "Advertising"
##    type: sum
##    sql: ${TABLE}."NEW_LABEL_AMOUNT" ;;
##    value_format:"$#,##0"
##  }

  measure: total_label_amount {
    description: "The cumulative `total label amount` from all linked Campaign records. Same as New Label Amount"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."TOTAL_LABEL_AMOUNT" ;;
    value_format:"$#,##0"
  }

  measure: total_fees {
    description: "Sum of the fees that were applied to the various campaigns assigned to the request"
    view_label: "Advertising"
    type: sum
    sql: ${TABLE}."TOTAL_FEES" ;;
    value_format:"$#,##0"
  }

##  measure: new_fees {
##    description: "Commissions charged to date"
##    view_label: "Advertising"
##    type: sum
##    sql: ${TABLE}."NEW_FEES" ;;
##    value_format:"$#,##0"
##  }

  dimension_group: form_submitted{
    description: "When the form was submitted (date)"
    view_label: "Advertising"
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."FORM_SUBMITTED" ;;
  }
}