# DW_LEASE_SCHEDULE_DETAIL_CF (Preview)

This table requires activation of Lease Accounting functional area. This fact table contains details of Lease schedule , accrual and liability data

## Details

Module:

## Key Columns

SCHEDULE_HEADER_ID, ACCRUAL_SCHEDULE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SCHEDULE_HEADER_ID | NUMBER | 38 | 0 | True | This column is part of the Primary key . |  |
ACCRUAL_SCHEDULE_ID | NUMBER | 38 | 0 | True | This column is part of the Primary key . |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
LEASE_ID | NUMBER | 38 | 0 |  | Lease identifier indicates that the schedules header is pertaining to specific lease. | DW_LEASE_CONTRACT_D | LEASE_ID
LEASE_DETAIL_ID | NUMBER | 38 | 0 |  | Lease detail identifier. | DW_LEASE_CONTRACT_D | LEASE_DETAIL_ID
PAYMENT_HEADER_ID | NUMBER | 38 | 0 |  | Payment header identifier. | DW_LEASE_PAYMENT_HEADER_CF | PAYMENT_HEADER_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Indicates the business unit identifier associated to the row | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEDGER_ID | NUMBER | 38 | 0 |  | Business unit primary ledger identifier. | DW_LEDGER_D | LEDGER_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier for the lease contract. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
LEASE_ASSET_ID | NUMBER | 38 | 0 |  | Asset identifier to uniquely identify an asset in this table. | DW_LEASE_ASSET_D | LEASE_ASSET_ID
ASSET_LOCATION_ID | NUMBER | 38 | 0 |  | Site information at which the asset is being installed | DW_WORKER_LOCATION_D | LOCATION_ID
INVENTORY_ORG_ID | NUMBER | 38 | 0 |  | Inventory item operating unit identifier. | DW_INVENTORY_ITEM_D | ORGANIZATION_ID
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory item identifier is associated with the item being chosen as asset from the inventory system. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
EMPLOYEE_ID | NUMBER | 38 | 0 |  | Employee with whom the asset is tagged with. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PROPERTY_ID | NUMBER | 38 | 0 |  | Attribute indicating the identifier of the property. | DW_LEASE_PROPERTIES_D | PROPERTY_ID
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier identifier. | DW_PARTY_D | SUPPLIER_ID
SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site identifier. | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
PAYMENT_TERM_ID | NUMBER | 38 | 0 |  | Payment term identifier for calculation of due date. | DW_AP_TERMS_D_TL | PAYMENT_TERMS_ID
PARENT_RECORD_ID | NUMBER | 38 | 0 |  | It contains parent booking or amendement schedule header. |  |
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. Examples are Weekly, Monthly, Quarterly. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Name of the accounting calendar. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Fiscal period in which accrual falls in. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
ACCRUAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Accrual period in which accrual falls in. |  |
ACCRUAL_SCHEDULE_DATE | DATE |  |  |  | End date of the accrual period. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
INTEREST_RATE | NUMBER |  |  |  | Interest rate is derived from Discount rate index selected at lease level. This will be the interest rate for the regime. |  |
ADDER_RATE | NUMBER |  |  |  | This will be the adder rate set for the regime at Lease level. |  |
DAILY_COMPOUNDING_RATE | NUMBER |  |  |  | Daily compounding interest rate for the Lease. |  |
LEASE_EXPENSE_RATE | NUMBER |  |  |  | It contains one day expense rate in case of daily and one month rate in case of periodic. |  |
AMORTIZATION_RATE | NUMBER |  |  |  | It contains one day amortization rate in case of daily and one month rate in case of periodic. |  |
FORECASTED_LIABILITY_AMOUNT | NUMBER |  |  |  | Forecasted Liability Amount for the Payment Term. |  |
FORECASTED_FIN_ROU_AMOUNT | NUMBER |  |  |  | Forecasted Financial ROU Amount for the Payment Term. |  |
FORECASTED_OPER_ROU_AMOUNT | NUMBER |  |  |  | Forecasted Operating ROU Amount for the Payment Term. |  |
FIN_ROU_GROSS_BALANCE_AMOUNT | NUMBER |  |  |  | Finance right of use gross balance amount for migrated leases. |  |
OPER_ROU_GROSS_BALANCE_AMOUNT | NUMBER |  |  |  | Operating right of use gross balance amount for migrated leases. |  |
FINANCE_ACCUM_AMORT_AMOUNT | NUMBER |  |  |  | Finance right of use accumulated amortization amount for migrated leases. |  |
OPERATING_ACCUM_AMORT_AMOUNT | NUMBER |  |  |  | Operating right of use accumulated amortization amount for migrated leases. |  |
ACCRUAL_INTEREST_AMOUNT | NUMBER |  |  |  | Interest amount for the accrual period. |  |
FIN_AMORTIZATION_AMOUNT | NUMBER |  |  |  | Accrual Schedule amount for schedule 1. |  |
OPER_AMORTIZATION_AMOUNT | NUMBER |  |  |  | Accrual schedule amount for schedule 2. |  |
LEASE_EXPENSE_AMOUNT | NUMBER |  |  |  | Accrual schedule amount for schedule 3. |  |
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 |  |
OPENING_LIABILITY_AMOUNT | NUMBER |  |  |  | Liability balance as on period start date |  |
CLOSING_LIABILITY_AMOUNT | NUMBER |  |  |  | Liability balance as on period end date. |  |
LIABILITY_INTEREST_AMOUNT | NUMBER |  |  |  | Interest amount calculated from last calculated date to current due date. |  |
INCREASE_AMOUNT | NUMBER |  |  |  | Increase amount calculated for the period. |  |
CONTINGENT_AMOUNT | NUMBER |  |  |  | Contingent increase amount calculated for the period. |  |
CUMULATIVE_INCREASE_AMOUNT | NUMBER |  |  |  | Cumulative increase amount calculated for the period. |  |
CUMULATIVE_CONTINGENT_AMOUNT | NUMBER |  |  |  | Cumulative contingent increase amount calculated for the period. |  |
OPENING_SHORT_TERM_LIAB_AMOUNT | NUMBER |  |  |  | Opening short term liability amount. |  |
RECLASS_SHORT_TERM_LIAB_AMOUNT | NUMBER |  |  |  | Short term liability reclassification amount. |  |
CLOSING_SHORT_TERM_LIAB_AMOUNT | NUMBER |  |  |  | Closing short term liability amount. |  |
OPENING_LONG_TERM_LIAB_AMOUNT | NUMBER |  |  |  | Opening long term liability amount. |  |
RECLASS_LONG_TERM_LIAB_AMOUNT | NUMBER |  |  |  | Long term liability reclassification amount. |  |
CLOSING_LONG_TERM_LIAB_AMOUNT | NUMBER |  |  |  | Closing long term liability amount. |  |
PAYMENT_ITEM_AMOUNT | NUMBER |  |  |  | Payment item amount in the payment currency. |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Attribute indicating payment currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code associated to the ledger | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
VERSION_NUM | NUMBER | 38 | 0 |  | Version number of the lease. |  |
PAYMENT_NUMBER | VARCHAR2 | 32 |  |  | Schedules are generated for this Payment Number. |  |
ASSET_NUMBER | VARCHAR2 | 32 |  |  | Lease asset number is valid only if asset is associated to the payment term. |  |
REGIME_CODE | VARCHAR2 | 32 |  |  | Regime code drives the accounting model and reporting for the lease. | DW_FLA_REGIME_CODE_LKP_TL | FLA_REGIME_CODE
AMORTIZATION_START_DATE | DATE |  |  |  | Date from which the amortization schedule starts. |  |
AMORTIZATION_END_DATE | DATE |  |  |  | Date when the amortization schedule ends. |  |
ACCRUAL_START_DATE | DATE |  |  |  | Start date of accural period. |  |
LIABILITY_START_DATE | DATE |  |  |  | Start date for liability calculation. |  |
LIABILITY_END_DATE | DATE |  |  |  | End date for liability calculation. |  |
PAYMENT_START_DATE | DATE |  |  |  | Date from which the first payment starts. |  |
PAYMENT_END_DATE | DATE |  |  |  | Date on which the payment ends. |  |
TERMINATION_DATE | DATE |  |  |  | Date when the payment is terminated. |  |
PAYMENT_FREQUENCY_CODE | VARCHAR2 | 32 |  |  | Payment frequency code. | DW_FLA_PAYMENT_FREQUENCY_LKP_TL | PAYMENT_FREQUENCY_CODE
PAYMENT_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of payment. | DW_FLA_PAYMENT_STATUS_LKP_TL | PAYMENT_STATUS_CODE
PAYMENT_PURPOSE_CODE | VARCHAR2 | 32 |  |  | Payment purpose code | DW_FLA_PAYMENT_PURPOSE_LKP_TL | PAYMENT_PURPOSE_CODE
PAYMENT_TYPE_CODE | VARCHAR2 | 32 |  |  | Payment type code | DW_FLA_PAYMENT_TYPE_LKP_TL | PAYMENT_TYPE_CODE
OPTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Option type code. | DW_FLA_LEASE_OPTION_TYPE_LKP_TL | LEASE_OPTION_TYPE_CODE
OPTION_STATUS_CODE | VARCHAR2 | 32 |  |  | Option status code. | DW_FLA_OPTION_STATUS_LKP_TL | LEASE_OPTION_STATUS_CODE
LEASE_CLASSIFICATION_CODE | VARCHAR2 | 32 |  |  | Lease classification code. | DW_FLA_LEASE_CLASSIFICATION_LKP_TL | LEASE_CLASSIFICATION_CODE
REVENUE_METHOD_CODE | VARCHAR2 | 32 |  |  | Indicates the method for spread of generated revenue. | DW_FLA_REVENUE_METHOD_CODE_LKP_TL | REVENUE_METHOD_CODE
SCHEDULE_TYPE_CODE | VARCHAR2 | 32 |  |  | Indicates the type of schedule. | DW_FLA_SCHEDULE_METHOD_CODE_LKP_TL | SCHEDULE_METHOD_CODE
TRANSACTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Transaction type. | DW_FLA_ACCT_TRN_TYPE_LKP_TL | TRANSACTION_TYPE_CODE
TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 32 |  |  | Transaction sub type | DW_FLA_TRN_SUBTYPE_LKP_TL | TRANSACTION_SUBTYPE_CODE
REF_PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 |  |  | Purchase order number for reference purpose. |  |
PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 |  |  | Purchase order number |  |
PURCHASE_ORDER_LINE_NUMBER | NUMBER |  |  |  | Purchase order line number |  |
PAYMENT_TEMPLATE_NAME | VARCHAR2 | 512 |  |  | Payment template name references the template from which the payment term is copied. |  |
PRIMARY_INTENDED_USE | VARCHAR2 | 32 |  |  | Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level. |  |
NUMBER_OF_ACCRUAL_DAYS | NUMBER | 38 | 0 |  | Number of days between accural start and end date |  |
ACCRUED_FLAG | VARCHAR2 | 16 |  |  | Indicates if schedules are accrued or not. | DW_Y_N_D_TL | CODE
ACCRUAL_REVERSAL_FLAG | VARCHAR2 | 16 |  |  | Indicates if this accrual is reversed, in case if amendment commencement date is earlier than latest accrual period. | DW_Y_N_D_TL | CODE
OPTION_FLAG | VARCHAR2 | 16 |  |  | Indicates if this is a payment or an option. | DW_Y_N_D_TL | CODE
EXPIRED_ROU_FLAG | VARCHAR2 | 16 |  |  | Indicates if the right of use has expired because of an impairment. | DW_Y_N_D_TL | CODE
ROU_ASSET_FLAG | VARCHAR2 | 16 |  |  | Indicates whether to generate right of use schedule for respective payment term or not. | DW_Y_N_D_TL | CODE
LIABILITY_FLAG | VARCHAR2 | 16 |  |  | Indicates if liability schedule for respective payment term should be generated or not. | DW_Y_N_D_TL | CODE
ARREARS_FLAG | VARCHAR2 | 16 |  |  | Indicates if the payment is in arrear or not. | DW_Y_N_D_TL | CODE
REVERSAL_FLAG | VARCHAR2 | 16 |  |  | Reversal flag which indicates if the transaction is reversed or pending for reversal. | DW_Y_N_D_TL | CODE
INTERCOMPANY_FLAG | VARCHAR2 | 16 |  |  | Intercompany flag with possible values as Y or N. Mainly used for reporting purposes | DW_Y_N_D_TL | CODE
AMORTIZE_EXEMPT_PAYMENT_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate if the exempt payment should be amortized over the term of the payment. | DW_Y_N_D_TL | CODE
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
SCHD_HDR_CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. |  |
SCHD_HDR_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
SCHD_HDR_LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the row. |  |
SCHD_HDR_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.