view: dt_finance_export_uk {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_FINANCE_EXPORT_UK ;;

# Field names labelled to match original report exactly, to support delivery automation.
  dimension: accounting_period_id {
    type: number
    sql: ${TABLE}.accounting_period_id ;;
  }

  dimension: label_id {
    type: number
    sql: ${TABLE}.label_id ;;
    label: "Label Label ID"
  }

  dimension: label_name {
    type: string
    sql: ${TABLE}.label_name ;;
    label: "Label Label Name"
  }

# Following two fields allow aggregation by Owner without changing report template.
  dimension: label_id_placeholder {
    type: string
    sql: ${TABLE}.owner ;;
    label: "Label Label ID"
  }

  dimension: label_name_placeholder {
    type: string
    sql: ${TABLE}.owner ;;
    label: "Label Label Name"
  }

  dimension: owner {
    type: string
    sql: ${TABLE}.owner ;;
    label: "Label Owner"
  }

  dimension: payout_currency {
    type: string
    sql: ${TABLE}.payout_currency ;;
    label: "Currency Payout Currency Code"
  }

  dimension: transactiontypeabbr {
    type: string
    sql: ${TABLE}.transactiontypeabbr ;;
    label: "Transaction Type Transaction Type Abbr"
  }

  dimension: transactiontypedesc {
    type: string
    sql: ${TABLE}.transactiontypedesc ;;
    label: "Transaction Type Transaction Type Desc"
  }

  dimension: vendor_contract_id {
    type: number
    sql: ${TABLE}.id;;
    label: "Vendor Contract ID"
  }

  measure: fx_gross {
    type: sum
    sql: ${TABLE}.fx_gross ;;
    label: "Sales in Client Ccur Fx Gross Revenue"
  }

  measure: fx_net {
    type: sum
    sql: ${TABLE}.fx_net ;;
    label: "Sales in Client Ccur Fx Net Revenue"
  }

  measure: fx_gross_margin {
    type: sum
    sql: ${TABLE}.fx_gross_margin ;;
    label: "Sales in Client Ccur Orchard Gross Margin Ccur"
  }

  measure: fx_reserves_withheld {
    type: sum
    sql: ${TABLE}.fx_reserves_withheld ;;
    label: "Xtra Advanced Fields Reserves Withheld Ccur"
  }

  measure: fx_reserves_released {
    type: sum
    sql: ${TABLE}.fx_reserves_released ;;
    label: "Xtra Advanced Fields Reserves Released Ccur"
  }

# Following two fields allow aggregation by Owner without changing report template.
  measure: fx_reserves_withheld_placeholder {
    type: sum
    sql: 0 ;;
    label: "Xtra Advanced Fields Reserves Withheld Ccur"
  }

  measure: fx_reserves_released_placeholder {
    type: sum
    sql: 0 ;;
    label: "Xtra Advanced Fields Reserves Released Ccur"
  }


}