FLA_ACCRUAL_SUMMARY

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
PAYMENT_NUMBER LEASE_ID LEASE_DETAIL_ID VERSION_NUM ACTIVE_FLAG CURRENCY_CODE ROU_ASSET_FLAG LIABILITY_FLAG ACCRUAL_START_DATE PERIOD_NAME SCHEDULE_DATE NUMBER_OF_ACCRUAL_DAYS IFRS_INTEREST_AMOUNT IFRS_AMORTIZATION IFRS_OPENING_ROU_AMOUNT IFRS_CLOSING_ROU_AMOUNT IFRS_CATCHUP_FLAG IFRS_ADJ_FIN_ROU_AMOUNT ASC_INTEREST_AMOUNT ASC_FIN_AMORTIZATION ASC_OPENING_FIN_ROU_AMOUNT ASC_CLOSING_FIN_ROU_AMOUNT ASC_OPER_AMORTIZATION ASC_LEASE_EXPENSE ASC_OPENING_OPER_ROU_AMOUNT ASC_CLOSING_OPER_ROU_AMOUNT ASC_CATCHUP_FLAG ASC_ADJ_FIN_ROU_AMOUNT ASC_ADJ_OPER_ROU_AMOUNT

Name

PAYMENT_NUMBER

LEASE_ID

LEASE_DETAIL_ID

VERSION_NUM

ACTIVE_FLAG

CURRENCY_CODE

ROU_ASSET_FLAG

LIABILITY_FLAG

ACCRUAL_START_DATE

PERIOD_NAME

SCHEDULE_DATE

NUMBER_OF_ACCRUAL_DAYS

IFRS_INTEREST_AMOUNT

IFRS_AMORTIZATION

IFRS_OPENING_ROU_AMOUNT

IFRS_CLOSING_ROU_AMOUNT

IFRS_CATCHUP_FLAG

IFRS_ADJ_FIN_ROU_AMOUNT

ASC_INTEREST_AMOUNT

ASC_FIN_AMORTIZATION

ASC_OPENING_FIN_ROU_AMOUNT

ASC_CLOSING_FIN_ROU_AMOUNT

ASC_OPER_AMORTIZATION

ASC_LEASE_EXPENSE

ASC_OPENING_OPER_ROU_AMOUNT

ASC_CLOSING_OPER_ROU_AMOUNT

ASC_CATCHUP_FLAG

ASC_ADJ_FIN_ROU_AMOUNT

ASC_ADJ_OPER_ROU_AMOUNT

Query

SQL_Statement
SELECT payment_number , lease_id , lease_detail_id , version_num , active_flag , currency_code , rou_asset_flag , liability_flag , accrual_start_date , period_name , schedule_date , number_of_accrual_days , SUM (ifrs_interest_amount) ifrs_interest_amount , SUM (ifrs_amortization) ifrs_amortization , SUM (ifrs_opening_rou_amount) ifrs_opening_rou_amount , SUM (ifrs_closing_rou_amount) ifrs_closing_rou_amount , MAX (ifrs_catchup_flag) ifrs_catchup_flag , SUM (ifrs_adj_fin_rou_amount) ifrs_adj_fin_rou_amount, SUM (asc_interest_amount) asc_interest_amount , SUM (asc_fin_amortization) asc_fin_amortization , SUM (asc_opening_fin_rou_amount) asc_opening_fin_rou_amount , SUM (asc_closing_fin_rou_amount) asc_closing_fin_rou_amount , SUM (asc_oper_amortization) asc_oper_amortization , SUM (asc_lease_expense) asc_lease_expense , SUM (asc_opening_oper_rou_amount) asc_opening_oper_rou_amount , SUM (asc_closing_oper_rou_amount) asc_closing_oper_rou_amount , MAX (asc_catchup_flag) asc_catchup_flag, SUM (asc_adj_fin_rou_amount) asc_adj_fin_rou_amount, SUM (asc_adj_oper_rou_amount) asc_adj_oper_rou_amount FROM (SELECT payment_number , lease_id , lease_detail_id , version_num , amortization_start_date , amortization_end_date , active_flag , transaction_type_code , accrual_start_date , period_name , schedule_date , number_of_accrual_days , currency_code , rou_asset_flag , liability_flag , ( CASE regime_code WHEN 'IFRS16' THEN interest_amount ELSE 0 END) ifrs_interest_amount , ( CASE regime_code WHEN 'IFRS16' THEN fin_amortization ELSE 0 END) ifrs_amortization , ( CASE regime_code WHEN 'IFRS16' THEN opening_fin_rou_amount ELSE 0 END) ifrs_opening_rou_amount , ( CASE regime_code WHEN 'IFRS16' THEN closing_fin_rou_amount ELSE 0 END) ifrs_closing_rou_amount , ( CASE regime_code WHEN 'IFRS16' THEN catchup_flag ELSE NULL END) ifrs_catchup_flag , ( CASE regime_code WHEN 'IFRS16' THEN adjusted_fin_rou_amount ELSE 0 END) ifrs_adj_fin_rou_amount , ( CASE regime_code WHEN 'ASC842' THEN interest_amount ELSE 0 END) asc_interest_amount , ( CASE regime_code WHEN 'ASC842' THEN fin_amortization ELSE 0 END) asc_fin_amortization , ( CASE regime_code WHEN 'ASC842' THEN opening_fin_rou_amount ELSE 0 END) asc_opening_fin_rou_amount , ( CASE regime_code WHEN 'ASC842' THEN closing_fin_rou_amount ELSE 0 END) asc_closing_fin_rou_amount , ( CASE regime_code WHEN 'ASC842' THEN oper_amortization ELSE 0 END) asc_oper_amortization , ( CASE regime_code WHEN 'ASC842' THEN lease_expense ELSE 0 END) asc_lease_expense , ( CASE regime_code WHEN 'ASC842' THEN opening_oper_rou_amount ELSE 0 END) asc_opening_oper_rou_amount , ( CASE regime_code WHEN 'ASC842' THEN closing_oper_rou_amount ELSE 0 END) asc_closing_oper_rou_amount , ( CASE regime_code WHEN 'ASC842' THEN catchup_flag ELSE NULL END) asc_catchup_flag, ( CASE regime_code WHEN 'ASC842' THEN adjusted_fin_rou_amount ELSE 0 END) asc_adj_fin_rou_amount , ( CASE regime_code WHEN 'ASC842' THEN adjusted_oper_rou_amount ELSE 0 END) asc_adj_oper_rou_amount FROM fla_accrual_schedules_v ) GROUP BY payment_number , lease_id , lease_detail_id , version_num , amortization_start_date , amortization_end_date , active_flag , transaction_type_code , accrual_start_date , period_name , schedule_date , number_of_accrual_days , currency_code , rou_asset_flag , liability_flag

SQL_Statement

SELECT payment_number ,

lease_id ,

lease_detail_id ,

version_num ,

active_flag ,

currency_code ,

rou_asset_flag ,

liability_flag ,

accrual_start_date ,

period_name ,

schedule_date ,

number_of_accrual_days ,

SUM (ifrs_interest_amount) ifrs_interest_amount ,

SUM (ifrs_amortization) ifrs_amortization ,

SUM (ifrs_opening_rou_amount) ifrs_opening_rou_amount ,

SUM (ifrs_closing_rou_amount) ifrs_closing_rou_amount ,

MAX (ifrs_catchup_flag) ifrs_catchup_flag ,

SUM (ifrs_adj_fin_rou_amount) ifrs_adj_fin_rou_amount,

SUM (asc_interest_amount) asc_interest_amount ,

SUM (asc_fin_amortization) asc_fin_amortization ,

SUM (asc_opening_fin_rou_amount) asc_opening_fin_rou_amount ,

SUM (asc_closing_fin_rou_amount) asc_closing_fin_rou_amount ,

SUM (asc_oper_amortization) asc_oper_amortization ,

SUM (asc_lease_expense) asc_lease_expense ,

SUM (asc_opening_oper_rou_amount) asc_opening_oper_rou_amount ,

SUM (asc_closing_oper_rou_amount) asc_closing_oper_rou_amount ,

MAX (asc_catchup_flag) asc_catchup_flag,

SUM (asc_adj_fin_rou_amount) asc_adj_fin_rou_amount,

SUM (asc_adj_oper_rou_amount) asc_adj_oper_rou_amount

FROM

(SELECT payment_number ,

lease_id ,

lease_detail_id ,

version_num ,

amortization_start_date ,

amortization_end_date ,

active_flag ,

transaction_type_code ,

accrual_start_date ,

period_name ,

schedule_date ,

number_of_accrual_days ,

currency_code ,

rou_asset_flag ,

liability_flag ,

(

CASE regime_code

WHEN 'IFRS16'

THEN interest_amount

ELSE 0

END) ifrs_interest_amount ,

(

CASE regime_code

WHEN 'IFRS16'

THEN fin_amortization

ELSE 0

END) ifrs_amortization ,

(

CASE regime_code

WHEN 'IFRS16'

THEN opening_fin_rou_amount

ELSE 0

END) ifrs_opening_rou_amount ,

(

CASE regime_code

WHEN 'IFRS16'

THEN closing_fin_rou_amount

ELSE 0

END) ifrs_closing_rou_amount ,

(

CASE regime_code

WHEN 'IFRS16'

THEN catchup_flag

ELSE NULL

END) ifrs_catchup_flag ,

(

CASE regime_code

WHEN 'IFRS16'

THEN adjusted_fin_rou_amount

ELSE 0

END) ifrs_adj_fin_rou_amount ,

(

CASE regime_code

WHEN 'ASC842'

THEN interest_amount

ELSE 0

END) asc_interest_amount ,

(

CASE regime_code

WHEN 'ASC842'

THEN fin_amortization

ELSE 0

END) asc_fin_amortization ,

(

CASE regime_code

WHEN 'ASC842'

THEN opening_fin_rou_amount

ELSE 0

END) asc_opening_fin_rou_amount ,

(

CASE regime_code

WHEN 'ASC842'

THEN closing_fin_rou_amount

ELSE 0

END) asc_closing_fin_rou_amount ,

(

CASE regime_code

WHEN 'ASC842'

THEN oper_amortization

ELSE 0

END) asc_oper_amortization ,

(

CASE regime_code

WHEN 'ASC842'

THEN lease_expense

ELSE 0

END) asc_lease_expense ,

(

CASE regime_code

WHEN 'ASC842'

THEN opening_oper_rou_amount

ELSE 0

END) asc_opening_oper_rou_amount ,

(

CASE regime_code

WHEN 'ASC842'

THEN closing_oper_rou_amount

ELSE 0

END) asc_closing_oper_rou_amount ,

(

CASE regime_code

WHEN 'ASC842'

THEN catchup_flag

ELSE NULL

END) asc_catchup_flag,

(

CASE regime_code

WHEN 'ASC842'

THEN adjusted_fin_rou_amount

ELSE 0

END) asc_adj_fin_rou_amount ,

(

CASE regime_code

WHEN 'ASC842'

THEN adjusted_oper_rou_amount

ELSE 0

END) asc_adj_oper_rou_amount

FROM fla_accrual_schedules_v

)

GROUP BY payment_number ,

lease_id ,

lease_detail_id ,

version_num ,

amortization_start_date ,

amortization_end_date ,

active_flag ,

transaction_type_code ,

accrual_start_date ,

period_name ,

schedule_date ,

number_of_accrual_days ,

currency_code ,

rou_asset_flag ,

liability_flag