Lease Milestones
These are the lease milestones users may define on a lease.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseMilestonesExtractPVO
Primary Keys : LeaseMilestoneMilestoneId
Initial Extract Date : LeaseMilestoneCreationDate
Incremental Extract Date : LeaseMilestoneLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeaseMilestoneActionDueDate | The due date of the action associated with the milestone. |
| LeaseMilestoneAssignedToUserName | The user to whom the milestone is assigned. |
| LeaseMilestoneAttributeCategory | The structure definition of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar1 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar10 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar11 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar12 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar13 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar14 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar15 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar2 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar3 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar4 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar5 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar6 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar7 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar8 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeChar9 | A segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeDate1 | A date segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeDate2 | A date segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeDate3 | A date segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeDate4 | A date segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeDate5 | A date segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeNumber1 | A number segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeNumber2 | A number segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeNumber3 | A number segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeNumber4 | A number segment of the user descriptive flexfield. |
| LeaseMilestoneAttributeNumber5 | A number segment of the user descriptive flexfield. |
| LeaseMilestoneChangeTypeCode | Indicates the type of change. Values include insert, update, and delete. |
| LeaseMilestoneChangedInVersionNum | The version number where the change occurred. |
| LeaseMilestoneCreatedBy | Indicates the user who created the row. |
| LeaseMilestoneCreationDate | Indicates the date and time of the creation of the row. |
| LeaseMilestoneDataSourceCode | Indicates the source of the lease milestone information. |
| LeaseMilestoneDescription | This is the milestone description. |
| LeaseMilestoneLastNotificationDate | Indicates the milestone's latest notification date. |
| LeaseMilestoneLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeaseMilestoneLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeaseMilestoneLastUpdatedBy | Indicates the user who last updated the row. |
| LeaseMilestoneLeaseId | This is the lease identifier. It references the primary key of the FLA_LEASES_ALL table. |
| LeaseMilestoneMilestoneId | This is the milestone's identifier and the primary key of the table. |
| LeaseMilestoneMilestoneNumber | This is the milestone number as generated by the system. |
| LeaseMilestoneMilestoneStatusCode | Indicates the milestone status. Values are Open, Completed, and Canceled. |
| LeaseMilestoneMilestoneTypeCode | This is the milestone type selected by the user. |
| LeaseMilestoneNoticeDate | This is the milestone's notice date. |
| LeaseMilestoneNotificationFrequencyCode | This is the notification frequency. User choices are one time, daily, weekly, monthly and yearly. |
| LeaseMilestoneObjectVersionNumber | This is 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. |
| LeaseMilestoneSourceObjectReference | This is the number of the lease, payment, asset, or option associated with the milestone. |
| LeaseMilestoneSourceObjectTypeCode | This is the lease object type associated with the milestone. Values are lease, payment, option and asset. |
| LeaseMilestoneSystemOriginReference1 | System reference 1 to maintain the source system from which lease is being imported. |
| LeaseMilestoneSystemOriginReference2 | System reference 2 to maintain the source system from which lease is being imported. |
| LeaseMilestoneVersionNum | The version number where the milestone was added. |