view: int_dbt_prod_awal_all_pos_model {
  sql_table_name: AWAL.AWAL_FINANCE.AWAL_ALL_POS ;;

  dimension: client_id {
    view_label: "Client"
    type: string
    sql: ${TABLE}.client_id ;;

  }

  dimension: agreement_id {
    view_label: "Agreement"
    type: string
    sql: ${TABLE}.agr ;;
  }

  dimension: budget_id {
    view_label: "Campaign"
    type: string
    sql: ${TABLE}.budget_id ;;
  }

  dimension: campaign {
    view_label: "Campaign"
    type: string
    sql: ${TABLE}.campaign ;;
  }

  dimension: po_number {
    view_label: "PO"
    type: string
    sql: ${TABLE}.po_number ;;
  }

  dimension: sax_po_id {
    view_label: "PO"
    type: string
    sql: ${TABLE}.sax_po_id ;;
  }

  dimension: cost_category {
    view_label: "Cost"
    type: string
    sql: ${TABLE}.cost_category ;;
  }

  dimension: bc_desc {
    view_label: "Cost"
    type: string
    sql: ${TABLE}.bc_desc ;;
  }

  dimension: cost_category_id {
    view_label: "Cost"
    type: string
    sql: ${TABLE}.cost_category_id ;;
  }

  dimension: status {
    view_label: "Cost"
    type: string
    sql: ${TABLE}.status ;;
  }

  dimension: supplier {
    view_label: "Cost"
    type: string
    sql: ${TABLE}.supplier ;;
  }

  dimension: territory_desc {
    view_label: "Cost"
    type: string
    sql: ${TABLE}.territory_desc ;;
  }

  dimension: po_owner {
    view_label: "PO"
    type: string
    sql: ${TABLE}.po_owner ;;
  }

  dimension_group: po_date {
    view_label: "PO"
    type: time
    sql: ${TABLE}.po_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  dimension: po_ccy_id {
    view_label: "PO"
    type: string
    sql: ${TABLE}.po_ccy_id ;;
  }

  dimension: bud_ccy_id {
    view_label: "Budget"
    type: string
    sql: ${TABLE}.bud_ccy_id ;;
  }

  dimension: bud_ccy {
    view_label: "Budget"
    type: string
    sql: ${TABLE}.bud_ccy ;;
  }

  measure: po_bet_ccy {
    view_label: "PO"
    type: sum
    sql: ${TABLE}.po_bet_ccy ;;
    value_format: "#,##0.00"
  }

  measure: po_net_bud_ccy {
    view_label: "PO"
    type: sum
    sql: ${TABLE}.po_net_bud_ccy ;;
    value_format: "#,##0.00"
  }

  dimension: exchange_rate {
    view_label: "Cost"
    type: number
    sql: ${TABLE}.exchange_rate ;;
  }

}