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. |