1. Tables and Views for Financials
  2. FV_XLA_CMR_REF_V

FV_XLA_CMR_REF_V

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: VIEW

Columns

Name

EVENT_ID

LINE_NUMBER

FUND_VALUE

APPORTIONMENT_CATEGORY_CODE

TAS_EXPIRED_STATUS_CODE

FEDERAL_PRIOR_YEAR_FLAG

ENT_UNPAID_OBLIG_AMOUNT

ACC_UNPAID_OBLIG_AMOUNT

ENT_UNPAID_OBLIG_PYA_AMOUNT

ACC_UNPAID_OBLIG_PYA_AMOUNT

ENT_UNPAID_OBLIG_PYA_OFF_AMT

ACC_UNPAID_OBLIG_PYA_OFF_AMT

ENT_ANTICIPATED_RECOVERY_AMT

ACC_ANTICIPATED_RECOVERY_AMT

ENT_BUDGET_AMOUNT

ACC_BUDGET_AMOUNT

ENT_PAID_EXPEND_AMOUNT

ACC_PAID_EXPEND_AMOUNT

ENT_PAID_EXPEND_PYA_AMOUNT

ACC_PAID_EXPEND_PYA_AMOUNT

ENT_PAID_EXP_PYA_OFF_AMOUNT

ACC_PAID_EXP_PYA_OFF_AMOUNT

ENT_UNPAID_EXPEND_AMOUNT

ACC_UNPAID_EXPEND_AMOUNT

ENT_UNPAID_EXPEND_PYA_AMT

ACC_UNPAID_EXPEND_PYA_AMT

ENT_UNPAID_EXPEND_PYA_OFF_AMT

ACC_UNPAID_EXPEND_PYA_OFF_AMT

FED_LEDGER_ID

ENT_ANTICIPATED_RESOURCE_AMT

ACC_ANTICIPATED_RESOURCE_AMT

ENT_PAID_OBLIG_AMOUNT

ACC_PAID_OBLIG_AMOUNT

ACC_EXPENDED_APPROP_AMOUNT

ENT_EXPENDED_APPROP_AMOUNT

ACC_UNEXPENDED_APPROP_AMOUNT

ENT_UNEXPENDED_APPROP_AMOUNT

DIRECT_OR_REIMBURSABLE_CODE

FUNDING_DERIVATION_TYPE_CODE

ACC_EXP_APPROP_ACCRUED_AMT

ENT_EXP_APPROP_ACCRUED_AMT

ACC_EXP_APPROP_DISBURSED_AMT

ENT_EXP_APPROP_DISBURSED_AMT

ACC_UNEXP_APPROP_ACCRUED_AMT

ENT_UNEXP_APPROP_ACCRUED_AMT

ACC_UNEXP_APPROP_DISBURSED_AMT

ENT_UNEXP_APPROP_DISBURSED_AMT

Query

SQL_Statement

SELECT G.EVENT_ID EVENT_ID,

G.LINE_NUMBER LINE_NUMBER,

G.FUND_VALUE FUND_VALUE,

G.APPORTIONMENT_CATEGORY_CODE APPORTIONMENT_CATEGORY_CODE,

G.TAS_EXPIRED_STATUS_CODE TAS_EXPIRED_STATUS_CODE,

G.PRIOR_YEAR_FLAG FEDERAL_PRIOR_YEAR_FLAG,

G.ENT_UNPAID_OBLIG_AMOUNT ENT_UNPAID_OBLIG_AMOUNT,

G.ACC_UNPAID_OBLIG_AMOUNT ACC_UNPAID_OBLIG_AMOUNT,

G.ENT_UNPAID_OBLIG_PYA_AMOUNT ENT_UNPAID_OBLIG_PYA_AMOUNT,

G.ACC_UNPAID_OBLIG_PYA_AMOUNT ACC_UNPAID_OBLIG_PYA_AMOUNT,

G.ENT_UNPAID_OBLIG_PYA_OFF_AMT ENT_UNPAID_OBLIG_PYA_OFF_AMT,

G.ACC_UNPAID_OBLIG_PYA_OFF_AMT ACC_UNPAID_OBLIG_PYA_OFF_AMT,

G.ENT_ANTICIPATED_RECOVERY_AMT ENT_ANTICIPATED_RECOVERY_AMT,

G.ACC_ANTICIPATED_RECOVERY_AMT ACC_ANTICIPATED_RECOVERY_AMT,

G.ENT_BUDGET_AMOUNT ENT_BUDGET_AMOUNT,

G.ACC_BUDGET_AMOUNT ACC_BUDGET_AMOUNT,

G.ENT_PAID_EXPEND_AMOUNT ENT_PAID_EXPEND_AMOUNT,

G.ACC_PAID_EXPEND_AMOUNT ACC_PAID_EXPEND_AMOUNT,

G.ENT_PAID_EXPEND_PYA_AMOUNT ENT_PAID_EXPEND_PYA_AMOUNT,

G.ACC_PAID_EXPEND_PYA_AMOUNT ACC_PAID_EXPEND_PYA_AMOUNT,

G.ENT_PAID_EXP_PYA_OFF_AMOUNT ENT_PAID_EXP_PYA_OFF_AMOUNT,

G.ACC_PAID_EXP_PYA_OFF_AMOUNT ACC_PAID_EXP_PYA_OFF_AMOUNT,

G.ENT_UNPAID_EXPEND_AMOUNT ENT_UNPAID_EXPEND_AMOUNT,

G.ACC_UNPAID_EXPEND_AMOUNT ACC_UNPAID_EXPEND_AMOUNT,

G.ENT_UNPAID_EXPEND_PYA_AMT ENT_UNPAID_EXPEND_PYA_AMT,

G.ACC_UNPAID_EXPEND_PYA_AMT ACC_UNPAID_EXPEND_PYA_AMT,

G.ENT_UNPAID_EXPEND_PYA_OFF_AMT ENT_UNPAID_EXPEND_PYA_OFF_AMT,

G.ACC_UNPAID_EXPEND_PYA_OFF_AMT ACC_UNPAID_EXPEND_PYA_OFF_AMT,

G.LEDGER_ID FED_LEDGER_ID,

-1*G.ENT_ANTICIPATED_RECOVERY_AMT ENT_ANTICIPATED_RESOURCE_AMT,

-1*G.ACC_ANTICIPATED_RECOVERY_AMT ACC_ANTICIPATED_RESOURCE_AMT,

G.ENT_PAID_OBLIG_AMOUNT ENT_PAID_OBLIG_AMOUNT,

G.ACC_PAID_OBLIG_AMOUNT ACC_PAID_OBLIG_AMOUNT,

G.ACC_EXPENDED_APPROP_AMOUNT ACC_EXPENDED_APPROP_AMOUNT,

G.ENT_EXPENDED_APPROP_AMOUNT ENT_EXPENDED_APPROP_AMOUNT,

-1*G.ACC_EXPENDED_APPROP_AMOUNT ACC_UNEXPENDED_APPROP_AMOUNT,

-1*G.ENT_EXPENDED_APPROP_AMOUNT ENT_UNEXPENDED_APPROP_AMOUNT,

G.DIRECT_OR_REIMBURSABLE_CODE DIRECT_OR_REIMBURSABLE_CODE,

G.FUNDING_DERIVATION_TYPE_CODE FUNDING_DERIVATION_TYPE_CODE,

G.ACC_APPROP_ACCRUED_AMT ACC_EXP_APPROP_ACCRUED_AMT,

G.ENT_APPROP_ACCRUED_AMT ENT_EXP_APPROP_ACCRUED_AMT,

G.ACC_APPROP_DISBURSED_AMT ACC_EXP_APPROP_DISBURSED_AMT,

G.ENT_APPROP_DISBURSED_AMT ENT_EXP_APPROP_DISBURSED_AMT,

-1*G.ACC_APPROP_ACCRUED_AMT ACC_UNEXP_APPROP_ACCRUED_AMT,

-1*G.ENT_APPROP_ACCRUED_AMT ENT_UNEXP_APPROP_ACCRUED_AMT,

-1*G.ACC_APPROP_DISBURSED_AMT ACC_UNEXP_APPROP_DISBURSED_AMT,

-1*G.ENT_APPROP_DISBURSED_AMT ENT_UNEXP_APPROP_DISBURSED_AMT

FROM FV_XLA_TRANSACTION_LINES G

WHERE APPLICATION_ID IN (10096, 707)