1. Tables and Views for Financials
  2. FLA_ACCRUAL_SCHEDULES

FLA_ACCRUAL_SCHEDULES

FLA_ACCRUAL_SCHEDULES contains period wise accural interest, amortization and lease expense.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FLA_ACCRUAL_SCHEDULES_PK

ACCRUAL_SCHEDULE_ID

Columns

Name Datatype Length Precision Not-null Comments
ACCRUAL_SCHEDULE_ID NUMBER 18 Yes ACCRUAL_SCHEDULE_ID. This is the Primary key column.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SCHEDULE_HEADER_ID NUMBER 18 Yes Schedule header identifier from FLA_SCHEDULE_HEADERS.
ACCRUAL_START_DATE DATE Yes Accrual Start Date. Start date of accural period.
SCHEDULE_DATE DATE Yes Schedule date. End date of the accrual period.
PERIOD_NAME VARCHAR2 15 Accrual period in which accrual falls in.
NUMBER_OF_ACCRUAL_DAYS NUMBER 9 Number of days between accural start and end date
PERIOD_REMAINDER_AMOUNT NUMBER Period Remainder. It is used in lease expense calculation of periodic calculation frequency.
INTEREST_AMOUNT NUMBER Interest amount for the accrual period.
SCHEDULE1_AMOUNT NUMBER Accrual Schedule amount for schedule 1.
SCHEDULE1_REMAINDER_AMOUNT NUMBER Accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period.
SCHEDULE2_AMOUNT NUMBER Accrual schedule amount for schedule 2.
SCHEDULE2_REMAINDER_AMOUNT NUMBER Accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period.
SCHEDULE3_AMOUNT NUMBER Accrual schedule amount for schedule 3.
SCHEDULE3_REMAINDER_AMOUNT NUMBER Accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period.
SCHEDULE4_AMOUNT NUMBER Accrual schedule amount for schedule 4.
SCHEDULE4_REMAINDER_AMOUNT NUMBER Accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period.
SCHEDULE5_AMOUNT NUMBER Accrual schedule amount for schedule 5.
SCHEDULE5_REMAINDER_AMOUNT NUMBER Accrual amount remainder leftover for current period due to the rounding logic. This should be included in the next period.
OPENING_FIN_ROU_AMOUNT NUMBER Financial ROU opening balance as of period start date.
CLOSING_FIN_ROU_AMOUNT NUMBER Financial ROU closing balance as of period end date
OPENING_OPER_ROU_AMOUNT NUMBER Operating ROU opening balance as of period start date.
CLOSING_OPER_ROU_AMOUNT NUMBER Operating ROU closing balance as of period end date
GENERATED_FROM_AMEND_FLAG VARCHAR2 1 Yes Indicates if schedule is geneated due to an amendment.
ACCRUED_FLAG VARCHAR2 1 Yes Indicates if schedules are accrued or not.
ACCRUAL_REVERSAL_FLAG VARCHAR2 1 Yes Indicates if this accrual is reversed, in case if amendment comencement date is earlier than latest accrual period.
CATCHUP_FLAG VARCHAR2 1 Yes Indicates if schedules are generated for catchup purpose.
READ_IN_DRAFT_FLAG VARCHAR2 1 Yes Indicates whether the record was considered for generation of accrual schedules in the draft lease.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
SCHEDULING_VERSION_NUM NUMBER 8 Version of the schedule generation.
SCHEDULES_BATCH_ID NUMBER 18 Batch identifier for the schedules generation batch.
EXPIRED_ROU_FLAG VARCHAR2 1 Indicates if the right of use has expired because of an impairment.
PAYMENT_NUMBER VARCHAR2 30 Attribute indicating the payment for which the accruals is being calculated.
VERSION_NUM NUMBER 9 Version number of the lease as captured in FLA_LEASE_DETAILS.
LEASE_ID NUMBER 18 Lease identifier. It is referenced from FLA_LEASES_ALL table to indicate that the liability schedules are pertaining to specific lease.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
FLA_ACCRUAL_SCHEDULES_U1 Unique FUSION_TS_TX_IDX ACCRUAL_SCHEDULE_ID
FLA_ACCRUAL_SCHEDULES_U2 Unique FUSION_TS_TX_IDX SCHEDULE_HEADER_ID, SCHEDULE_DATE