Lease Headers
These are the lease headers.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseHeadersExtractPVO
Primary Keys : LeaseHeaderLeaseId
Initial Extract Date : LeaseHeaderCreationDate
Incremental Extract Date : LeaseHeaderLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeaseHeaderAbstractedBy | The name of the user who booked the lease. |
| LeaseHeaderAmortizationProrationCode | The day count convention used to prorate payment amounts for partial periods. User choices are 360 Year and Days Month. |
| LeaseHeaderAmortizationStartDate | Indicates the date where opening lease balances are calculated and expense and revenue recognition starts in the lease contract. |
| LeaseHeaderAttributeCategory | The structure definition of the user descriptive flexfield. |
| LeaseHeaderAttributeChar1 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar10 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar11 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar12 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar13 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar14 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar15 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar2 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar3 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar4 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar5 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar6 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar7 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar8 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeChar9 | A segment of the user descriptive flexfield. |
| LeaseHeaderAttributeDate1 | A date segment of the user descriptive flexfield. |
| LeaseHeaderAttributeDate2 | A date segment of the user descriptive flexfield. |
| LeaseHeaderAttributeDate3 | A date segment of the user descriptive flexfield. |
| LeaseHeaderAttributeDate4 | A date segment of the user descriptive flexfield. |
| LeaseHeaderAttributeDate5 | A date segment of the user descriptive flexfield. |
| LeaseHeaderAttributeNumber1 | A number segment of the user descriptive flexfield. |
| LeaseHeaderAttributeNumber2 | A number segment of the user descriptive flexfield. |
| LeaseHeaderAttributeNumber3 | A number segment of the user descriptive flexfield. |
| LeaseHeaderAttributeNumber4 | A number segment of the user descriptive flexfield. |
| LeaseHeaderAttributeNumber5 | A number segment of the user descriptive flexfield. |
| LeaseHeaderBillToCustomerId | This is the lessee or party identifier in a revenue lease. |
| LeaseHeaderContractEndDate | This is the lease contract end date. |
| LeaseHeaderContractStartDate | This is the lease contract start date. |
| LeaseHeaderCreatedBy | Indicates the user who created the row. |
| LeaseHeaderCreationDate | Indicates the date and time of the creation of the row. |
| LeaseHeaderDataSourceCode | This is the source system identifier of the migrated lease. |
| LeaseHeaderEnableSubleasesFlag | Indicates if subleases are allowed on this expense lease. |
| LeaseHeaderHeadleaseLeaseId | This is the head lease identifier in a sublease. |
| LeaseHeaderImportTargetStatusCode | Indicates the target status for the lease in the import process. User choices are Active, Draft and Complete. |
| LeaseHeaderIncreaseApplicableFlag | Indicates if the lease can have payment increase agreements. |
| LeaseHeaderJobDefinitionName | Indicates the name of the job that created or last updated the row in the Enterprise Service Scheduler |
| LeaseHeaderJobDefinitionPackage | Indicates the package name of the job that created or last updated the row in the Enterprise Service Scheduler |
| LeaseHeaderLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeaseHeaderLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeaseHeaderLastUpdatedBy | Indicates the user who last updated the row. |
| LeaseHeaderLeaseAssetTypeCode | Indicates whether the lease is a property lease or an equipment lease. |
| LeaseHeaderLeaseId | This is the lease unique identifier. |
| LeaseHeaderLeaseName | This is the user-defined lease name. |
| LeaseHeaderLeaseNumber | This is the lease number, which is either automatically generated or user entered, depending on user setups. |
| LeaseHeaderLeaseStartDate | This is the lease start date. |
| LeaseHeaderLeaseStatusCode | This is the system-generated lease status. Valid statuses include Active, Terminated, and Hold. |
| LeaseHeaderLeaseTypeCode | Indicates the lease type. The lease type can be Expense, Revenue, or Sublease. |
| LeaseHeaderLegalEntityId | This is the legal entity associated to the lease. |
| LeaseHeaderMigratedLeaseFlag | Indicates whether the lease is migrated. |
| LeaseHeaderMigrationDate | Indicates the migration date for migrated lease. |
| LeaseHeaderObjectVersionNumber | 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. |
| LeaseHeaderOptionLevelAllowedCode | Indicates whether options in the lease will be for individual assets or the entire lease. |
| LeaseHeaderOrgId | This is the lease's business unit. |
| LeaseHeaderRequestId | Indicates the request ID of the job that created or last updated the row in the Enterprise Service Scheduler. |
| LeaseHeaderRouMigrationBasisCode | Indicates whether the right-of-use balance should be entered as a gross or net amount. It applies to migrated leases only. |
| LeaseHeaderSubleaseFlag | Indicates whether the revenue lease is a sublease. |
| LeaseHeaderSystemOriginReference1 | This is the source system first reference number from which the lease is being imported. |
| LeaseHeaderSystemOriginReference2 | This is the source system second reference number from which the lease is being imported. |
| LeaseHeaderVendorId | This is the lessor or party in the expense lease. |