# DW_LEASE_MILESTONE_D (Preview)

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

## Details

Module:

## Key Columns

MILESTONE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
MILESTONE_ID | NUMBER | 38 | 0 | True | Milestone 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. |  |
MILESTONE_NUMBER | VARCHAR2 | 32 |  |  | Milestone number as generated by the system. |  |
LEASE_ID | NUMBER | 38 | 0 |  | Lease identifier |  |
MILESTONE_TYPE_CODE | VARCHAR2 | 32 |  |  | Milestone type as defined by the user. |  |
SOURCE_OBJECT_TYPE_CODE | VARCHAR2 | 32 |  |  | Source for the milestone. |  |
SOURCE_OBJECT_REFERENCE | VARCHAR2 | 32 |  |  | Source identifier for the milestone. |  |
MILESTONE_STATUS_CODE | VARCHAR2 | 32 |  |  | Milestone status. |  |
NOTIFICATION_FREQUENCY_CODE | VARCHAR2 | 32 |  |  | Notification frequency. |  |
NOTICE_DATE | DATE |  |  |  | Notice date as recorded for the milestone. |  |
ACTION_DUE_DATE | DATE |  |  |  | Action due date as recorded for the milestone. |  |
ASSIGNED_TO_USER_NAME | VARCHAR2 | 128 |  |  | User to whom the milestone is assigned. |  |
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.