Lease Accounting Lines

These are the lease accounting lines.

Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseAccountingLinesExtractPVO

Primary Keys : LeaseAccountingLineTransactionLineId

Initial Extract Date : LeaseAccountingLineCreationDate

Incremental Extract Date : LeaseAccountingLineLastUpdateDate

Attributes

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

Name	Description
LeaseAccountingLineAccountedAmount	The functional currency amount.
LeaseAccountingLineAccrualScheduleId	The accrual schedule's unique identifier. This is referenced from FLA_ACCRUAL_SCHEDULES table.
LeaseAccountingLineAppliedToLineId	The business flow transaction line's identifier.
LeaseAccountingLineConversionDate	The exchange rate takes effect from the specified date.
LeaseAccountingLineConversionRate	The rate used to calculate the functional currency amount.
LeaseAccountingLineConversionRateTypeCode	The type of exchange rate for foreign currency amounts.
LeaseAccountingLineCrAccountClassCode	Indicates the account class of the credit account.
LeaseAccountingLineCrCodeCombinationId	Indicates the row identifier in the GL Code Combinations table associated with this distribution. This will be populated if the Lease Accounting Payment Accounts are setup for the payment.
LeaseAccountingLineCreatedBy	Indicates the user who created the row.
LeaseAccountingLineCreationDate	Indicates the date and time of the creation of the row.
LeaseAccountingLineCurrencyCode	The payment currency code as defined in the lease payment.
LeaseAccountingLineDescription	The description of the transaction line.
LeaseAccountingLineDrAccountClassCode	The account class of the debit account.
LeaseAccountingLineDrCodeCombinationId	The row identifier in the GL Code Combinations table associated with this distribution. This will be populated if lease accounting payment accounts are setup for the payment.
LeaseAccountingLineEnteredAmount	The transaction amount in specified currency.
LeaseAccountingLineLastUpdateDate	Indicates the date and time when the row was last updated.
LeaseAccountingLineLastUpdateLogin	Indicates the session login associated to the user who last updated the row.
LeaseAccountingLineLastUpdatedBy	Indicates the user who last updated the row.
LeaseAccountingLineLineNum	Indicates the line number for the accounting transaction line.
LeaseAccountingLineObjectVersionNumber	This is used to implement optimistic locking. This number is incremented every time a 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.
LeaseAccountingLineParentTransactionLineId	The identifier of the parent transaction in the event of a reversal.
LeaseAccountingLinePaymentItemId	The payment item identifier. This is referenced from FLA_PAYMENT_ITEMS table.
LeaseAccountingLinePaymentNumber	This is the payment number. Indicates the payment header associated with the accounting line.
LeaseAccountingLinePreviousConvRateTypeCode	The previous exchange rate type for foreign currency amounts.
LeaseAccountingLinePreviousConversionDate	The previous date exchange rate is effective from. Usually the payment due date.
LeaseAccountingLinePreviousConversionRate	The previous rate used to calculate the functional currency amount.
LeaseAccountingLineReversedFlag	Indicates if this transaction is reversed.
LeaseAccountingLineScheduleHeaderId	The schedule header identifier. This is referenced from FLA_SCHEDULE_HEADERS table.
LeaseAccountingLineScheduleTypeCode	Indicates the schedule type code like INTEREST_EXPENSE, LEASE_LIABILITY, RESERVE, RIGHT_OF_USE, AMORTIZATION, LEASE_EXPENSE and so forth.
LeaseAccountingLineSourceReferenceId1	The source reference ID 1. Source value could be SCHEDULE_HEADER_ID, PAYMENT_ITEM_ID, ACCRUAL_SCHEDULE_ID.
LeaseAccountingLineSourceReferenceId2	The source reference ID 2. This is for future use.
LeaseAccountingLineSourceReferenceId3	The source reference ID 3. This is for future use.
LeaseAccountingLineTransactionId	The accounting transaction header identifier. This is referenced from FLA_ACCOUNTING_HEADERS_ALL.
LeaseAccountingLineTransactionLineId	The identifier of the parent transaction in the event of a reversal.