Lease Payment Lines
These are lease payment lines.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeasePaymentLinesExtractPVO
Primary Keys : LeasePaymentLinePaymentLineId
Initial Extract Date : LeasePaymentLineCreationDate
Incremental Extract Date : LeasePaymentLineLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeasePaymentLineActualAmount | Indicates the payment amount in the payment currency. |
| LeasePaymentLineActualFuncCurrAmount | Indicates the payment amount in the functional currency. |
| LeasePaymentLineAdjustmentTypeCode | Indicates the adjustment type used while doing the adjustment for the line. |
| LeasePaymentLineAssessableValue | Determines the user-enterable amount to be used as taxable basis. This is for future use. |
| LeasePaymentLineAttributeCategory | The structure definition of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar1 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar10 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar11 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar12 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar13 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar14 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar15 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar2 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar3 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar4 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar5 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar6 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar7 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar8 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeChar9 | A segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeDate1 | A date segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeDate2 | A date segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeDate3 | A date segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeDate4 | A date segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeDate5 | A date segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeNumber1 | A number segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeNumber2 | A number segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeNumber3 | A number segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeNumber4 | A number segment of the user descriptive flexfield. |
| LeasePaymentLineAttributeNumber5 | A number segment of the user descriptive flexfield. |
| LeasePaymentLineChangeTypeCode | Indicates the type of change to the record, whether insert or update or delete. |
| LeasePaymentLineChangedInVersionNum | Specifies the LeasePaymentLineChanged version number in which there was a change, either an Addition or Update, or Delete. |
| LeasePaymentLineCreatedBy | Indicates the user who created the row. |
| LeasePaymentLineCreationDate | Indicates the date and time of the creation of the row. |
| LeasePaymentLineDataSourceCode | This is the feeder system from which lease and payment data was created. |
| LeasePaymentLineEstimatedAmount | Indicates the estimated payment amount in the payment currency. |
| LeasePaymentLineEstimatedFuncCurrAmount | Indicates the estimated payment amount in the functional currency. |
| LeasePaymentLineFirstPaymentDate | Indicates the first payment date for the payment line. |
| LeasePaymentLineLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeasePaymentLineLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeasePaymentLineLastUpdatedBy | Indicates the user who last updated the row. |
| LeasePaymentLineLeaseDetailId | This is the lease detail identifier. it's referenced from the FLA_LEASE_DETAILS table. |
| LeasePaymentLineLeaseId | The lease's identifier. It's referenced from FLA_LEASES_ALL table to indicate that the payment lines are pertaining to specific lease. |
| LeasePaymentLineNoOfPayments | Indicates the number of payments to happen based on the effective dates and frequency. This should be empty in case the stub flag is set to Yes. |
| LeasePaymentLineObjectVersionNumber | 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. |
| LeasePaymentLineOriginalLineEndDate | Indicates the original end date of the line which will be captured if the line is contracted to an earlier date. |
| LeasePaymentLineParentRecordId | The parent record's unique identifier. This identifies the parent record for this record. |
| LeasePaymentLinePaymentLineEndDate | Indicates the date from which the payment is inactive. |
| LeasePaymentLinePaymentLineId | The payment line's identifier. It's the primary key of the table. |
| LeasePaymentLinePaymentLineNum | This is the payment line number. It's a number sequence unique across the lease payment header. |
| LeasePaymentLinePaymentLineStartDate | Indicates the date from which the payment is active. |
| LeasePaymentLinePaymentNumber | The payment header's identifier. Indicates the payment header for the payment line. |
| LeasePaymentLineSourcePaymentLineId | Indicates the source payment line ID for the adjustment line. |
| LeasePaymentLineStubFlag | Indicates whether the payment line is for one time payment for specific period or for regular payment. |
| LeasePaymentLineSystemOriginReference1 | This is the source system first reference number from which the lease is being imported. |
| LeasePaymentLineSystemOriginReference2 | This is the source system second reference number from which the lease is being imported. |