Lease Details
These are the lease details.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseDetailsExtractPVO
Primary Keys : LeaseDetailsLeaseDetailId
Initial Extract Date : LeaseDetailsCreationDate
Incremental Extract Date : LeaseDetailsLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeaseDetailsAmendForIndexFlag | Indicates if the amendment is for finalization of assessments which are for index based agreements. |
| LeaseDetailsAmortizationEndDate | This is the amortization end date. |
| LeaseDetailsApprovalComments | These are comments or details provided by the user who has approved the lease version. |
| LeaseDetailsApprovalStatusCode | This is the lease approval status. |
| LeaseDetailsApprovalSubStatusCode | Indicates the lease version substatus when the version is in working status. |
| LeaseDetailsApprovalTransactionId | Indicates the transaction identifier generated for lease approvals. |
| LeaseDetailsApprovedBy | This is the name of the user who has approved the lease draft to mark it as final. |
| LeaseDetailsApprovedDate | The date where the lease or amendment was approved. |
| LeaseDetailsArrearsPayDtTreatmentCode | Indicates whether the payment due date is included in day count calculation. User choices are Beginning of the Day and End of the Day. |
| LeaseDetailsAttributeCategory | The structure definition of the user descriptive flexfield. |
| LeaseDetailsAttributeChar1 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar10 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar11 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar12 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar13 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar14 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar15 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar2 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar3 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar4 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar5 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar6 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar7 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar8 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeChar9 | A segment of the user descriptive flexfield. |
| LeaseDetailsAttributeDate1 | A date segment of the user descriptive flexfield. |
| LeaseDetailsAttributeDate2 | A date segment of the user descriptive flexfield. |
| LeaseDetailsAttributeDate3 | A date segment of the user descriptive flexfield. |
| LeaseDetailsAttributeDate4 | A date segment of the user descriptive flexfield. |
| LeaseDetailsAttributeDate5 | A date segment of the user descriptive flexfield. |
| LeaseDetailsAttributeNumber1 | A number segment of the user descriptive flexfield. |
| LeaseDetailsAttributeNumber2 | A number segment of the user descriptive flexfield. |
| LeaseDetailsAttributeNumber3 | A number segment of the user descriptive flexfield. |
| LeaseDetailsAttributeNumber4 | A number segment of the user descriptive flexfield. |
| LeaseDetailsAttributeNumber5 | A number segment of the user descriptive flexfield. |
| LeaseDetailsAutoFinalizeVersionFlag | Indicates if the lease should be automatically finalized along with validation and generation of schedules. |
| LeaseDetailsBalanceSyncRequestId | This is the LeaseDetailsBalanceSync request ID of the job that created or last updated the row. |
| LeaseDetailsBalanceSyncStatusCode | Indicates if the balances are up to date for this lease. |
| LeaseDetailsCommencementDate | This is the lease or amendment commencement date. |
| LeaseDetailsCreatedBy | Indicates the user who created the row. |
| LeaseDetailsCreationDate | Indicates the date and time of the creation of the row. |
| LeaseDetailsDataSourceCode | Indicates the source of the asset impairment information. |
| LeaseDetailsExecutionDate | This is the date when the lease was booked. It indicates the day on which the lease is being executed. |
| LeaseDetailsGeneratedBy | The name of the user who has generated the schedules and payments. |
| LeaseDetailsGeneratedDate | This is the date when the schedules and payments were generated. |
| LeaseDetailsIncreaseAccountingCode | Indicates the contingent increase amount accounting treatment for the amendment. Possible values are Contingent Increase and Noncontingent Increase. |
| LeaseDetailsIncreaseGeneratedBy | The user who has submitted the generate payment increase action. |
| LeaseDetailsIncreaseGeneratedDate | The date when the schedules and payments were generated. |
| LeaseDetailsIncreaseImpactFlag | Indicates if the lease is impacted by payment increase agreement. |
| LeaseDetailsInterestMethodCode | This is the Interest calculation method. User choices are daily and periodic. |
| LeaseDetailsJobDefinitionName | Indicates the name of the job that created or last updated the row. |
| LeaseDetailsJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. |
| LeaseDetailsLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeaseDetailsLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeaseDetailsLastUpdatedBy | Indicates the user who last updated the row. |
| LeaseDetailsLeaseAmendmentNotes | The notes created during the amendment. |
| LeaseDetailsLeaseClassificationCode | Indicates the accounting classification of the lease. Possible values are finance lease, operating lease and exempt lease. |
| LeaseDetailsLeaseDetailId | This is the lease detail identifier, the primary key of the table. |
| LeaseDetailsLeaseId | This is the lease identifier. It references the primary key of the FLA_LEASES_ALL table. |
| LeaseDetailsLeaseSecondaryClassifCode | Indicates the secondary classification of the lease. Possible values are finance lease, operating lease and exempt lease. |
| LeaseDetailsLeaseTerminationFlag | Indicates if the lease is being terminated. |
| LeaseDetailsLeaseTrxApprovalFlag | Indicates if the lease approval is enabled for the lease version. |
| LeaseDetailsLeaseVersionDescription | This is lease version description on what changes or amendments has been brought into the lease. |
| LeaseDetailsLeaseVersionName | This is the lease version name, a short identifier of the version. |
| LeaseDetailsObjectVersionNumber | 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. |
| LeaseDetailsOptionTransactionCode | This is the option type selected during an amendment in case the amendment is for exercise or cancel of an option. |
| LeaseDetailsPercentageOfReduction | This is the reduction in right-of-use or liability. The reduction is based on the reduction in time, usage or liability. |
| LeaseDetailsPrimRegimeAdderRate | Adder rate which is used for the primary regime. |
| LeaseDetailsPrimRegimeDiscRateIndexId | The discount rate index that's used for the primary regime. |
| LeaseDetailsPrimRegimeInterestRate | The discount rate index value that's used for the primary regime. |
| LeaseDetailsPrimRegimeScopeChangeCode | The scope change method for leases in the primary accounting standard. Values can be unit based percentage or liability based percentage. |
| LeaseDetailsProcessJobDefinitionName | Indicates the name of the job that created or last updated the row. |
| LeaseDetailsProcessJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. |
| LeaseDetailsProcessRequestCode | Captures the request details executed on the lease. |
| LeaseDetailsProcessRequestId | The request identifier of the job that created or last updated the row. This is used for request created for the purpose of lease balances. |
| LeaseDetailsQuartzJobGroup | This is the group associated with the quartz job. |
| LeaseDetailsQuartzJobName | This is the functional name of the quartz job. |
| LeaseDetailsQuartzRunDate | The scheduling start date of the quartz process. |
| LeaseDetailsReportJobId | The LeaseDetailsReport request ID of the job that created or last updated the row. |
| LeaseDetailsReportJobName | Indicates the name of the job that created or last updated the row. |
| LeaseDetailsReportJobRunDate | The date when the report job was launched. |
| LeaseDetailsRequestId | Indicates the request ID of the job that created or last updated the row in the Enterprise Service Scheduler. |
| LeaseDetailsRequirePropertyDefnFlag | This flag to Indicate if a property definition is mandatory in expense lease. |
| LeaseDetailsResponsibleUser | The name of the lease's responsible user. |
| LeaseDetailsSchedulesRefreshNeededFlag | This flag to indicate if the schedules need to be refreshed. |
| LeaseDetailsSecdRegimeAdderRate | The adder rate which is used for the secondary regime. |
| LeaseDetailsSecdRegimeDiscRateIndexId | The discount rate index that's used for the secondary regime. |
| LeaseDetailsSecdRegimeInterestRate | The discount rate index value that's used for the secondary regime. |
| LeaseDetailsSecdRegimeScopeChangeCode | The scope change method for leases in the secondary accounting standard. Values can be unit based percentage or liability based percentage. |
| LeaseDetailsSubmittedBy | The name of the user who has submitted the lease for approval. |
| LeaseDetailsSubmittedDate | The date when the lease was submitted for approval. |
| LeaseDetailsSystemOriginReference1 | System reference 1 to maintain the source system from which lease is being imported. |
| LeaseDetailsSystemOriginReference2 | System reference 2 to maintain the source system from which lease is being imported. |
| LeaseDetailsTerminationDate | The lease termination date. |
| LeaseDetailsTerminationTransactionCode | The termination type selected during termination. Values can be asset or lease. |
| LeaseDetailsTransactionSubtypeCode | The revision subtype. Possible values are scope increase, scope decrease, scope no change, edit, and so forth. |
| LeaseDetailsTransactionTypeCode | The transaction type which identifies which transaction is being executed. Values include booking, termination, amend, and rescind. |
| LeaseDetailsValidatedBy | The name of the user who has validated the lease. |
| LeaseDetailsValidatedDate | The date when the lease was validated. |
| LeaseDetailsVersionInitiatedBy | The name of the user who initiated the version. |
| LeaseDetailsVersionInitiatedDate | The date when the version was initiated. |
| LeaseDetailsVersionNum | The lease's version number. This indicates the number of versions in the lease. |
| LeaseDetailsVersionPreparedBy | The name of the user who has prepared the version. |
| LeaseDetailsVersionSignedDate | The date the version was signed during an amend. |
| LeaseDetailsVersionTypeCode | The version type code. Possible values are D for draft version and F for final version. |