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