1. Tables and Views for Financials
  2. FV_XLA_PO_REF_V

FV_XLA_PO_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_COMMITMENT_AMOUNT

ACC_COMMITMENT_AMOUNT

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

FED_LEDGER_ID

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_COMMITMENT_AMOUNT ENT_COMMITMENT_AMOUNT,

G.ACC_COMMITMENT_AMOUNT ACC_COMMITMENT_AMOUNT,

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.LEDGER_ID FED_LEDGER_ID

FROM FV_XLA_TRANSACTION_LINES G

WHERE APPLICATION_ID = 201