Lease Accounting Headers

These are the lease accounting headers.

Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseAccountingHeadersExtractPVO

Primary Keys : LeaseAccountingHeaderTransactionId

Initial Extract Date : LeaseAccountingHeaderCreationDate

Incremental Extract Date : LeaseAccountingHeaderLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
LeaseAccountingHeaderAccountedInGlFlag Indicates if the accounting was done into general ledger.
LeaseAccountingHeaderAccountingDate Indicates the accounting date which will be sent to subledger accounting.
LeaseAccountingHeaderAccountingTiebackDate The date when the accounted amounts are derived and tied back.
LeaseAccountingHeaderBalanceSyncRequestId 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.
LeaseAccountingHeaderCreatedBy Indicates the user who created the row.
LeaseAccountingHeaderCreationDate Indicates the date and time of the creation of the row.
LeaseAccountingHeaderDescription Description of the lease accounting header.
LeaseAccountingHeaderEventId Identifier of the categorization of accounting events that's unique within an application and event class. This is referenced from the XLA_EVENTS table.
LeaseAccountingHeaderJobDefinitionName Indicates the name of the job that created or last updated the row.
LeaseAccountingHeaderJobDefinitionPackage Indicates the package name of the job that created or last updated the row.
LeaseAccountingHeaderLastUpdateDate Indicates the date and time of the last update of the row.
LeaseAccountingHeaderLastUpdateLogin Indicates the session login associated to the user who last updated the row.
LeaseAccountingHeaderLastUpdatedBy Indicates the user who last updated the row.
LeaseAccountingHeaderLeaseDetailId The lease detail's unique identifier. It's referenced from FLA_LEASE_DETAILS table.
LeaseAccountingHeaderLeaseId The lease's unique identifier. It references the primary key of the FLA_LEASES_ALL table.
LeaseAccountingHeaderLedgerId The ledger's unique identifier as defined in General Ledger.
LeaseAccountingHeaderLinkedTransactionId This is the linked transaction ID. This will be used to maintain link between two transactions.
LeaseAccountingHeaderObjectVersionNumber 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.
LeaseAccountingHeaderOrgId Indicates the unique identifier of the business unit associated to the row.
LeaseAccountingHeaderParentTransactionId The source transaction's unique ID. (This transaction is for a reversal).
LeaseAccountingHeaderPeriodName The period based on schedule date or payment item due date.
LeaseAccountingHeaderProcessingSeqNum This is the transaction processing sequence number for the accounting transactions.
LeaseAccountingHeaderRegimeCode The regime code drives the accounting model and reporting for the lease.
LeaseAccountingHeaderRequestId Indicates the LeaseAccountingHeader request ID of the job that created or last updated the row.
LeaseAccountingHeaderReversedFlag Indicates if this transaction is reversed.
LeaseAccountingHeaderSourceReferenceId1 The source reference ID 1. This is for future use.
LeaseAccountingHeaderSourceReferenceId2 The source reference ID 2. This is for future use.
LeaseAccountingHeaderSourceReferenceId3 The source reference ID 3. This is for future use.
LeaseAccountingHeaderSweepProcessFlag Indicates if the transaction is marked for accounting period sweep.
LeaseAccountingHeaderTransactionDate The source reference date. This is payment item's due date or schedule header transaction date or accrual schedule date.
LeaseAccountingHeaderTransactionId The accounting transaction identifier. It's the primary key of the table.
LeaseAccountingHeaderTransactionNumber The accounting transaction reference number.
LeaseAccountingHeaderTransactionStatusCode Indicates the accounting transaction status code.
LeaseAccountingHeaderTransactionTypeCode Indicates the accounting transaction type like booking, accrual, payment, revision, termination, and such.
LeaseAccountingHeaderVersionNum The version number of the lease as captured in FLA_LEASE_DETAILS table.