Lease Payment Items
These are lease payment items.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeasePaymentItemsExtractPVO
Primary Keys : LeasePaymentItemPaymentItemId
Initial Extract Date : LeasePaymentItemCreationDate
Incremental Extract Date : LeasePaymentItemLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeasePaymentItemAccountedFlag | Indicates if the payment item is transferred for accounting. |
| LeasePaymentItemActualAmount | The payment item amount in the payment currency. |
| LeasePaymentItemActualFuncCurrAmount | The actual payment item amount in the functional currency. |
| LeasePaymentItemAdjustmentDate | Indicates the date when the payment item adjustment is made. |
| LeasePaymentItemAdjustmentFlag | Indicates if the payment item is created because of an adjustment. |
| LeasePaymentItemAgreementNumber | This is the payment increase agreement number referenced from the FLA_INCREMENT_HEADERS table. |
| LeasePaymentItemApprovalBatchId | Specifies the batch identifier of the batch which was picked and processed for invoice and accounting approval. |
| LeasePaymentItemApprovalDate | Indicates the date on which the approval for the payment item was done. |
| LeasePaymentItemApprovalStatusCode | Indicates if the payment item is approved for Payables invoice creation. |
| LeasePaymentItemApprovedBy | Indicates the user who has done the approval of the payment item. |
| LeasePaymentItemArInvoiceId | The invoice's identifier of the Receivables invoice. |
| LeasePaymentItemArInvoiceLineId | The invoice line's identifier of the Receivables invoice line. |
| LeasePaymentItemAssessableValue | Indicates the amount entered by the user to be used as taxable basis. |
| LeasePaymentItemAssessmentDate | Indicates the date when the payment increase assessment is performed. |
| LeasePaymentItemAssetNumber | This is the asset number which is associated to the payment. |
| LeasePaymentItemAttribute1 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute10 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute11 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute12 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute13 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute14 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute15 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute2 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute3 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute4 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute5 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute6 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute7 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute8 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttribute9 | A segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeCategory | The structure definition of the user descriptive flexfield. |
| LeasePaymentItemAttributeDate1 | A date segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeDate2 | A date segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeDate3 | A date segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeDate4 | A date segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeDate5 | A date segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeNumber1 | A number segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeNumber2 | A number segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeNumber3 | A number segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeNumber4 | A number segment of the user descriptive flexfield. |
| LeasePaymentItemAttributeNumber5 | A number segment of the user descriptive flexfield. |
| LeasePaymentItemBillToCustomerId | The bill-to customer identifier for the billing. |
| LeasePaymentItemBillToSiteUseId | The bill-to customer site use identifier. |
| LeasePaymentItemChargeAccountCcid | The account's unique identifier. The code combination of the primary ledger charge account stored on the payment. Charge account will be sent to Payables during invoice creation. |
| LeasePaymentItemComments | These are the comments or details provided by the user who has approved or exported the payment item. |
| LeasePaymentItemContingentAmount | This is the contingent amount captured for the payment increase per payment period. |
| LeasePaymentItemCreatedBy | Indicates the user who created the row. |
| LeasePaymentItemCreationDate | Indicates the date and time of the creation of the row. |
| LeasePaymentItemCumulativeIncreaseFlag | Indicates if the payment is generated for cumulative increase amount of payment increase line. |
| LeasePaymentItemCurrencyCode | The payment item currency code. This is based on the payment currency code. |
| LeasePaymentItemCustomerTrxTypeId | The transaction type ID to be sent to receivables. |
| LeasePaymentItemDistributionSetId | The distribution set ID. It's passed into Payables. |
| LeasePaymentItemDocumentSubType | This is the classification used by a tax authority to categorize a document associated with a transaction for a tax. |
| LeasePaymentItemDueDate | Indicates the due date of the payment item as per the schedule in payment lines. |
| LeasePaymentItemEndDate | Indicates the ending date of the payment item. This is based on the payment line. |
| LeasePaymentItemEstimatedAmount | Indicates the estimated payment item amount in the payment currency. |
| LeasePaymentItemEstimatedFuncCurrAmount | Indicates the estimated payment item amount in the functional currency. |
| LeasePaymentItemExportGroupCode | Indicates the payables invoice grouping purpose. This is for future use. |
| LeasePaymentItemFirstPtyRegId | The deploying company's tax registration number. |
| LeasePaymentItemFuncCurrConvDate | Indicates the date from which the exchange rate is effective. Usually the payment due date. |
| LeasePaymentItemFuncCurrConvRate | Indicates the rate used to calculate the functional currency amount. |
| LeasePaymentItemFuncCurrConvRateType | Indicates the exchange rate type for foreign currency amounts. |
| LeasePaymentItemIntercompanyFlag | The intercompany flag with possible values as Y or N. This is mainly used for reporting purposes. |
| LeasePaymentItemInterfaceDate | Indicates the date on which the payment item status was updated. |
| LeasePaymentItemInterfaceEligibilityCode | Indicates the payment item export status to Payables. Various statuses can be yes, no, or hold. This is entered by the user. |
| LeasePaymentItemInterfaceStatusCode | Indicates the payment item export status to Payables. Various statuses can be pending, in progress, hold, interfaced, and abandoned. |
| LeasePaymentItemInvoiceCreationStatusCode | Indicates the status of Payables invoice, whether the invoice was generated successfully. This is for future use. |
| LeasePaymentItemInvoiceLineNumber | Indicates the invoice line number generated and sent to Payables for the payment item. |
| LeasePaymentItemInvoiceNum | Indicates the invoice number generated and sent to Payables for the payment item. |
| LeasePaymentItemJobDefinitionName | Indicates the name of the job that created or last updated the row. |
| LeasePaymentItemJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. |
| LeasePaymentItemLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeasePaymentItemLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeasePaymentItemLastUpdatedBy | Indicates the user who last updated the row. |
| LeasePaymentItemLeaseDetailId | This is the lease detail identifier. it's referenced from the FLA_LEASE_DETAILS table. |
| LeasePaymentItemLeaseId | This is the lease identifier. It references the primary key of the FLA_LEASES_ALL table. |
| LeasePaymentItemLiabilityAccountCcid | The account's unique identifier. Code combination of the primary ledger liability account stored on the payment. Liability account will be sent to Payables during invoice creation. |
| LeasePaymentItemManualActionCode | Indicates the manual action that has happened on the payment item before it was approved. Possible values can be modified or manually created. |
| LeasePaymentItemObjectVersionNumber | 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. |
| LeasePaymentItemOptionFlag | The option flag indicates if the payment items are generated for an option or not. |
| LeasePaymentItemParentPaymentItemId | This identifies the parent payment item for this payment item. |
| LeasePaymentItemPaymentIncreaseFlag | Indicates if the payment is generated for a payment increase line. |
| LeasePaymentItemPaymentItemForStubFlag | Indicates whether the payment item was generated for a stub payment line. |
| LeasePaymentItemPaymentItemId | This is the primary key of the table. |
| LeasePaymentItemPaymentItemTypeCode | Indicates the type of payment item. Values can be regular, recoverable, and nonrecoverable. |
| LeasePaymentItemPaymentLineNum | The payment line number. Payment item is part of this payment line. |
| LeasePaymentItemPaymentNumber | The payment number. Payment item is part of this payment header. |
| LeasePaymentItemPaymentPurposeCode | Indicates the payment purpose. Values are derived from the ORA_FLA_PAYMENT_PURPOSE lookup. |
| LeasePaymentItemPaymentTaxLineNumber | The payment tax line number. This is system-generated by using a document sequence. |
| LeasePaymentItemPaymentTemplateId | The payment template ID. References the payment template from which the payment is created. |
| LeasePaymentItemPaymentTermId | The payment's term ID for calculation of the due date. |
| LeasePaymentItemPaymentTypeCode | Indicates the payment type. Values are derived from the ORA_FLA_PAYMENT_TYPE lookup. |
| LeasePaymentItemPeriodName | This is the period in which payment item falls. |
| LeasePaymentItemPrimaryIntendedUse | Indicates the purpose for which a product may be used. The actual use is stored at the distribution level. |
| LeasePaymentItemProductCategory | Identifies the taxable nature of a noninventory based item for tax determination or tax reporting. |
| LeasePaymentItemProductFiscalClassification | Indicates the product fiscal classification. |
| LeasePaymentItemProductType | Indicates the type of product. Possible values are goods and services. This value defaults from inventory item attributes or is entered by the user. |
| LeasePaymentItemReadInDraftFlag | Indicates whether the payment item was considered for generation in the draft lease. |
| LeasePaymentItemReferencePaymentItemId | Indicates the reference payment item identifier for which the credit memo is being generated. |
| LeasePaymentItemReportFromInceptionFlag | Indicates whether the streams are generated from the inception of the lease or not. |
| LeasePaymentItemRequestId | Indicates the LeasePaymentItem request ID of the job that created or last updated the row. |
| LeasePaymentItemResponsibleUserName | The name of the user responsible for the update to the payment item amount. |
| LeasePaymentItemRevenueMethodCode | Indicates the method for spread of generated revenue, valid values are lease revenue and nonlease revenue. |
| LeasePaymentItemReversalFlag | Indicates if the payment item is created because of a reversal of generated payment items. |
| LeasePaymentItemScheduleTypeCode | Indicates the type of schedule. Values are payment and billing. |
| LeasePaymentItemShipToSiteUseId | This is the ship-to customer site use identifier. |
| LeasePaymentItemStartDate | Indicates the start date of the payment item. |
| LeasePaymentItemSupplierInvoiceRefNumber | Indicates the supplier number reference for the invoice. |
| LeasePaymentItemTaxClassificationCode | Indicates the tax classification code for payment term. |
| LeasePaymentItemTaxIncludedFlag | Indicates whether tax is included on the payments created for leases in the business unit. |
| LeasePaymentItemTaxTransactionId | This is the reference of the tax transaction identifier. |
| LeasePaymentItemThirdPtyRegId | The bill-to customer tax registration number. |
| LeasePaymentItemTrxBusinessCategory | The transactions category assigned by user. |
| LeasePaymentItemUserDefinedFiscalClass | The fiscal classification. |
| LeasePaymentItemVendorId | The supplier's ID. it's used to send the information to payables during the payment process. |
| LeasePaymentItemVendorSiteId | The supplier's site ID. it's used to send the information to Payables during the payment process. |
| LeasePaymentItemVersionNum | Indicates the version number of the lease as captured in FLA_LEASE_DETAILS table. |
| LeasePaymentItemWithholdingTaxGroupId | The withholding tax group's identifier. |