view: int_awal_historical_datasets_temp_awal_invoice_pmts_revised {
  sql_table_name: AWAL.AWAL_FINANCE.AWAL_INVOICE_PMTS_REVISED ;;

  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 ;;
  }#tempdone

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

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

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

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

  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

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

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

  dimension: BUDGET_COMMITMENT_ID {
    label: "Budget Commitment ID"
    type: string
    sql: ${TABLE}.BUDGET_COMMITMENT_ID ;;
  }#done

  dimension: BC_DESCRIPTION {
    label: "Budget Commitment Description"
    type: string
    sql: ${TABLE}.BC_DESCRIPTION ;;
  }#done

  dimension: STATUS {
    description: "Budget commitment status"
    label: "Status"
    type: string
    sql: ${TABLE}.STATUS ;;
  }#done

  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: INVOICE_DESCRIPTION {
    label: "Invoice Description"
    type: string
    sql: ${TABLE}.INVOICE_DESCRIPTION ;;
  }#done

  dimension_group: INVOICE_CREATED_DATE {
    label: "Invoice Created Date"
    type: time
    sql: ${TABLE}.INVOICE_CREATED_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: RECHARGE_BATCH_ID {
    label: "Recahrge Batch Id"
    type: string
    sql: ${TABLE}.RECHARGE_BATCH_ID ;;
  }#done

  dimension: RECHARGE_TYPE {
    label: "Recahrge Type"
    type: string
    sql: ${TABLE}.RECHARGE_TYPE ;;
  }#done

  dimension: SUPPLIER_2 {
    view_label: "Supplier"
    label: "Supplier 2"
    type: string
    sql: ${TABLE}.SUPPLIER_2 ;;
  }

  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]
  }#date

  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 ;;
    value_format: "#,##0.00"
  }#done

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

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

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

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

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

  measure: WORKING_BUDGET {
    view_label: "Budget"
    label: "Working Budget"
    type: sum
    sql: ${TABLE}.WORKING_BUDGET ;;
    value_format: "#,##0.00"
  }

  measure: WORKING_BUDGET_USD {
    view_label: "Budget"
    label: "Working Budget USD"
    type: sum
    sql: ${TABLE}.WORKING_BUDGET_USD ;;
    value_format: "$#,##0.00"
  }

  measure: PO_NET_CCY {
    view_label: "PO"
    label: "PO Net Currency"
    type: number
    sql: ${TABLE}.PO_NET_CCY ;;
    value_format: "#,##0.00"
  }

  measure: PO_NET_BUD_CCY {
    view_label: "PO"
    label: "PO Net Budget Currency"
    type: number
    sql: ${TABLE}.PO_NET_BUD_CCY ;;
    value_format: "#,##0.00"
  }

  measure: COMMITTED_AMOUNT_USD {
    label: "Committed Amount USD"
    type: sum
    sql: ${TABLE}.COMMITTED_AMOUNT_USD ;;
    value_format: "$#,##0.00"
  }

}