view: int_awal_historical_datasets_temp_awal_invoice_pmts {
  sql_table_name: AWAL.AWAL_FINANCE.AWAL_INVOICE_PMTS ;;

  dimension: CLIENT_ID {
    label: "Client ID"
    type: string
    sql: ${TABLE}.CLIENT_ID ;;
  }#done

  dimension: CLIENT_NAME {
    label: "Client Name"
    type: string
    sql: ${TABLE}.CLIENT_NAME ;;
  }#done

  dimension: AWAL_SEGMENT {
    label: "Awal Segment"
    type: string
    sql: ${TABLE}.AWAL_SEGMENT ;;
  }#done

  dimension: AGREEMENT_ID {
    label: "Agreement ID"
    type: string
    sql: ${TABLE}.AGREEMENT_ID ;;
  }

  dimension: COST_CATEGORY_GROUP {
    label: "Cost Category Group"
    type: string
    sql: ${TABLE}.COST_CATEGORY_GROUP ;;
  }

  dimension: COST_CATEGORY_NAME {
    label: "Cost Category Name"
    type: string
    sql: ${TABLE}.COST_CATEGORY_NAME ;;
  }

  dimension: TOP_COST_CATEGORY_NAME {
    label: "Top Cost Category Name"
    type: string
    sql: ${TABLE}.TOP_COST_CATEGORY_NAME ;;
  }

  dimension: BUDGET_ID {
    label: "Budget ID"
    type: string
    sql: ${TABLE}.BUDGET_ID ;;
  }

  dimension: CAMPAIGN {
    label: "Campaign"
    type: string
    sql: ${TABLE}.CAMPAIGN ;;
  }#done

  dimension: ADMINISTERED_BY {
    label: "Administered By"
    type: string
    sql: ${TABLE}.ADMINISTERED_BY ;;
  }#done

  dimension: TERRITORY_DESCRIPTION {
    label: "Territory Description"
    type: string
    sql: ${TABLE}.TERRITORY_DESCRIPTION ;;
  }#done

  measure: COMMITED_AMOUNT_USD {
    label: "Commited amount USD"
    type: sum
    sql: ${TABLE}.COMMITED_AMOUNT_USD ;;
  }#done

  dimension: SUPPLIER {
    label: "Supplier"
    type: string
    sql: ${TABLE}.SUPPLIER ;;
  }

  dimension: PO_NUMBER {
   label: "PO Number"
   type: string
    sql: ${TABLE}.PO_NUMBER ;;
  }

  dimension: INVOICE_ID {
    label: "Invoice ID"
    type: string
    sql: ${TABLE}.INVOICE_ID ;;
  }#done

  dimension: BCINV_INVOICE_NUMBER {
    label: "BCINV Invoice Number"
    type: string
    sql: ${TABLE}.BCINV_INVOICE_NUMBER ;;
  }#done

  dimension_group: INVOICED_DATE {
    label: "Invoice Date"
    type: time
    sql: ${TABLE}.INVOICED_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]
  } #done

  dimension_group: PAYMENT_DATE {
    label: "Payment Date"
    type: time
    sql: ${TABLE}.PAYMENT_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]
  }#done

  dimension: IS_PAID {
    label: "Is Paid"
    type: string
    sql: ${TABLE}.IS_PAID ;;
  }#done

  dimension: INVOICE_CURRENCY_ID {
    label: "Invoice Currency ID"
    type: string
    sql: ${TABLE}.INVOICE_CURRENCY_ID ;;
  }#done

  measure: PAID_NET_AMOUNT {
    label: "Paid Net Amount"
    type: sum
    sql: ${TABLE}.PAID_NET_AMOUNT ;;
  }#done

  measure: PAID_NET_AMOUNT_ADJ {
    label: "Paid Net Amount Adjusted"
    type: sum
    sql: ${TABLE}.PAID_NET_AMOUNT_ADJ ;;
  }#done

  measure: PAID_NET_AMOUNT_USD {
    label: "Paid Net Amount USD"
    type: sum
    sql: ${TABLE}.PAID_NET_AMOUNT_USD ;;
  }#done

  measure: PAID_NET_AMOUNT_ADJ_USD {
    label: "Paid Net Amount Adjusted USD"
    type: sum
    sql: ${TABLE}.PAID_NET_AMOUNT_ADJ_USD ;;
  }#done

  measure: PAID_NET_AMOUNT_BUD {
    label: "Paid Net Amount BUD"
    type: sum
    sql: ${TABLE}.PAID_NET_AMOUNT_BUD ;;
  }#done

  measure: PAID_NET_AMOUNT_ADJ_BUD {
    label: "Paid Net Amount Adjusted BUD"
    type: sum
    sql: ${TABLE}.PAID_NET_AMOUNT_ADJ_BUD ;;
  }#done

  measure: WORKING_BUDGET {
    label: "Working Budget"
    type: sum
    sql: ${TABLE}.WORKING_BUDGET ;;
  }

  measure: WORKING_BUDGET_USD {
    label: "Working Budget USD"
    type: sum
    sql: ${TABLE}.WORKING_BUDGET_USD ;;
  }

  measure: PO_NET_CCY {
    label: "PO Net CCY"
    type: sum
    sql: ${TABLE}.PO_NET_CCY ;;
  }

  measure: PO_NET_BUD_CCY{
    label: "PO Net BUD CCY"
    type: sum
    sql: ${TABLE}.PO_NET_BUD_CCY ;;
  }

}