DW_LEASE_OBLIGATION_D (Preview)

This table requires activation of Lease Accounting functional area. This table stores Lease Obligation Details.

Details

Module:

Key Columns

LEASE_OBLIGATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEASE_OBLIGATION_ID NUMBER 38 0 True Lease obligation identifier. It is the primary key of the table.    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Source record identifier.    
OBLIGATION_NUMBER VARCHAR2 32     Obligation number    
LEASE_ID NUMBER 38 0   Lease identifier.    
LEASE_DETAIL_ID NUMBER 38 0   Lease detail identifier.    
DESCRIPTION VARCHAR2 999     Description of obligation as entered by the user.    
ASSET_NUMBER VARCHAR2 32     Asset associated to the obligation.    
OBLIGATION_STATUS_CODE VARCHAR2 32     Status of the obligation defined.    
OBLIGATION_TYPE_CODE VARCHAR2 32     Type of obligation which is defined.    
RESPONSIBILITY_TYPE_CODE VARCHAR2 32     Responsibility type defined for the obligation.    
START_DATE DATE       State date of the obligation as entered by the user.    
END_DATE DATE       End date of the obligation as entered by the user.    
OBLIGATION_AMOUNT NUMBER       Obligation amount as entered by the user    
PERCENTAGE_PAID NUMBER       Percent of the obligation paid by the supplier    
REFERENCE_DETAILS VARCHAR2 999     Reference details of the obligation.    
OVERSEER_DETAILS VARCHAR2 128     Details of the overseer of the obligation.    
CURRENCY_CODE VARCHAR2 16     Currency code for the obligation amount    
OBLIGATION_PAID_BY VARCHAR2 32     Paid by vendor details.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row.    

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