Lease Payment Headers
These are the lease payment headers.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeasePaymentHeadersExtractPVO
Primary Keys : LeasePaymentHeaderPaymentHeaderId
Initial Extract Date : LeasePaymentHeaderCreationDate
Incremental Extract Date : LeasePaymentHeaderLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeasePaymentHeaderAdjustedContractionAmount | Indicates the payment contraction line amount being sent by user through FDBI. |
| LeasePaymentHeaderAmortizeExemptPaymentFlag | Indicates if the exempt payment should be amortized over the term of the payment. |
| LeasePaymentHeaderApplyUpfrontTaxFlag | Indicates whether upfront tax is applicable or not. |
| LeasePaymentHeaderArPaymentTermId | This is the payment term identifier sent to Receivables for calculation of the due date. |
| LeasePaymentHeaderArrearsFlag | Indicates if the payment is in arrears. |
| LeasePaymentHeaderAssetNumber | This is the lease asset identifier from the FLA_LEASE_ASSETS table. It's valid only if asset is associated to the payment term. |
| LeasePaymentHeaderAttributeCategory | The structure definition of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar1 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar10 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar11 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar12 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar13 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar14 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar15 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar2 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar3 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar4 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar5 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar6 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar7 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar8 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeChar9 | A segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeDate1 | A date segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeDate2 | A date segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeDate3 | A date segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeDate4 | A date segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeDate5 | A date segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeNumber1 | A number segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeNumber2 | A number segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeNumber3 | A number segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeNumber4 | A number segment of the user descriptive flexfield. |
| LeasePaymentHeaderAttributeNumber5 | A number segment of the user descriptive flexfield. |
| LeasePaymentHeaderBillToCustomerId | The bill-to customer identifier for the billing. |
| LeasePaymentHeaderBillToSiteUseId | The bill-to customer site use identifier. |
| LeasePaymentHeaderChangeTypeCode | Indicates the type of change to the record, whether insert or update or delete. |
| LeasePaymentHeaderChangedInVersionNum | Specifies the LeasePaymentHeaderChanged version number in which there was a change, either an Addition or Update, or Delete. |
| LeasePaymentHeaderClosedFlag | Indicates if the payment or option is closed. |
| LeasePaymentHeaderContingentOnlyImpactFlag | Indicates if the contingent amount is impacted. |
| LeasePaymentHeaderConversionRate | This is the currency conversion rate used to derive the payment amount when the payment currency is different from functional currency. |
| LeasePaymentHeaderConversionTypeCode | This is the currency conversion type when the currency is different from the functional currency. |
| LeasePaymentHeaderCreatedBy | Indicates the user who created the row. |
| LeasePaymentHeaderCreationDate | Indicates the date and time of the creation of the row. |
| LeasePaymentHeaderCurrencyCode | Indicates the payment currency code. This is entered by the user. |
| LeasePaymentHeaderCustomerTrxTypeId | The transaction type's unique identifier to be sent to receivables. |
| LeasePaymentHeaderDataSourceCode | Indicates the feeder system from which lease data was created. |
| LeasePaymentHeaderDistributionSetId | The distribution set ID. It's passed into Payables. |
| LeasePaymentHeaderDocumentSubType | This is the classification used by a tax authority to categorize a document associated with a transaction for a tax. |
| LeasePaymentHeaderFinRouGrossBalanceAmount | The finance right-of-use gross balance amount for migrated leases. |
| LeasePaymentHeaderFinanceAccumAmortAmount | The finance right-of-use accumulated amortization amount for migrated leases. |
| LeasePaymentHeaderFinanceRouBalanceAmount | The finance right-of-use balance for migrated leases. |
| LeasePaymentHeaderFirstPtyRegId | Specifies the deploying company's tax registration number. |
| LeasePaymentHeaderFuncFinRouBalanceAmount | The finance right-of-use balance for migrated leases in functional currency. |
| LeasePaymentHeaderFuncOperRouBalanceAmount | The operating right-of-use balance for migrated leases in functional currency. |
| LeasePaymentHeaderGenerateInvoiceFlag | Indicates if the payment should be interfaced with Payables or Receivables during invoice creation. |
| LeasePaymentHeaderImpairmentImpactFlag | Indicates if the payment is impacted because of an impairment. |
| LeasePaymentHeaderIncreaseImpactFlag | Indicates if the payment is impacted by a payment increase agreement. |
| LeasePaymentHeaderIntercompanyFlag | The intercompany flag with possible values as Y or N. This is mainly used for reporting purposes. |
| LeasePaymentHeaderLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeasePaymentHeaderLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeasePaymentHeaderLastUpdatedBy | Indicates the user who last updated the row. |
| LeasePaymentHeaderLeaseDetailId | The lease detail's identifier which is referenced. |
| LeasePaymentHeaderLeaseId | This is the lease identifier. It references the primary key of the FLA_LEASES_ALL table. |
| LeasePaymentHeaderLiabilityFlag | Indicates if liability schedule for respective payment term should be generated or not. |
| LeasePaymentHeaderMigratedFlag | Indicates if the payment is migrated or imported from an external system. |
| LeasePaymentHeaderMigrationConversionRate | Indicates the migration currency conversion rate used to derive the payment amount when the payment currency is different from functional currency. |
| LeasePaymentHeaderMigrationDate | Indicates the date when the payment was migrated in. |
| LeasePaymentHeaderObjectVersionNumber | 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. |
| LeasePaymentHeaderOperRouGrossBalanceAmount | The operating right-of-use gross balance amount for migrated leases. |
| LeasePaymentHeaderOperatingAccumAmortAmount | The operating right-of-use accumulated amortization amount for migrated leases. |
| LeasePaymentHeaderOperatingRouBalanceAmount | The operating right-of-use balance for migrated leases. |
| LeasePaymentHeaderOptionExecutionDate | Indicates the date when the option was exercised or canceled. |
| LeasePaymentHeaderOptionFlag | Indicates if this is a payment or an option. |
| LeasePaymentHeaderOptionStatusCode | This is the option status code. Possible values are exercised, closed, expired, and terminated. |
| LeasePaymentHeaderOptionTypeCode | This is the option type code. Possible values are renewal, residual, and purchase. |
| LeasePaymentHeaderParentPaymentId | Indicates the payment header ID for the parent payment or option. |
| LeasePaymentHeaderParentRecordId | The parent record's unique identifier. This identifies the parent record for this record. |
| LeasePaymentHeaderPaymentEndDate | Indicates the date on which the payment ends. |
| LeasePaymentHeaderPaymentFrequencyCode | Indicates the payment frequency code. Possible values are daily, monthly, quarterly, or annually. |
| LeasePaymentHeaderPaymentHeaderId | The payment header's unique identifier. It's the primary key of the table. |
| LeasePaymentHeaderPaymentItemsImpactFlag | Indicates if there are any payment items impacted because of changes to the payment. |
| LeasePaymentHeaderPaymentNumber | This is the payment number which is either automatically generated or entered by the user. |
| LeasePaymentHeaderPaymentPurposeCode | This is the payment purpose. Values are populated from lookup FND_LOOKUPS where lookup type is FLA_PAYMENT_PURPOSE. |
| LeasePaymentHeaderPaymentStartDate | This is the date from which the first payment starts. |
| LeasePaymentHeaderPaymentStatusCode | This is the status of payment. Possible values are canceled and active. |
| LeasePaymentHeaderPaymentTemplateId | The payment template ID. References the template from which the payment term is copied. |
| LeasePaymentHeaderPaymentTermId | The payment term ID for calculation of due date. |
| LeasePaymentHeaderPaymentTypeCode | Indicates the payment type. Values are populated from lookup FND_LOOKUPS where the lookup type is FLA_PAYMENT_TYPE. |
| LeasePaymentHeaderPercentageOfReduction | Specifies if there is a reduction in right-of-use or liability at the payment or option level. |
| LeasePaymentHeaderPoHeaderId | The purchase order's unique identifier. It references the PO_HEADER_ID column from the PO_HEADERS_ALL table. |
| LeasePaymentHeaderPoLineId | The purchase order line's unique identifier referenced from PO_LINES_ALL table. |
| LeasePaymentHeaderPrimRegimeAdderRate | Indicates the adder rate used for the primary regime. |
| LeasePaymentHeaderPrimRegimeDiscRateIndexId | Indicates the discount rate index used for the primary regime. |
| LeasePaymentHeaderPrimRegimeInterestRate | Indicates the discount rate index value used for the primary regime. |
| LeasePaymentHeaderPrimaryIntendedUse | This dictates the purpose for which a product may be used. The actual use is stored at the distribution level. |
| LeasePaymentHeaderProductCategory | Identifies the taxable nature of a noninventory based item for tax determination or tax reporting. |
| LeasePaymentHeaderProductFiscalClassification | Indicates the product fiscal classification. |
| LeasePaymentHeaderProductType | Specifies the type of product. Possible values are goods and services. This value defaults from inventory item attributes or is entered by the user. |
| LeasePaymentHeaderRefPurchaseOrderNumber | This is the purchase order number for reference purpose. |
| LeasePaymentHeaderReportFromInceptionFlag | Indicates whether schedules are generated from the inception of the lease or not. |
| LeasePaymentHeaderRevenueMethodCode | Indicates the method for the spread of generated revenue. |
| LeasePaymentHeaderRouAssetFlag | Indicates whether to generate the right-of-use schedule for respective payment term or not. |
| LeasePaymentHeaderScheduleTypeCode | Indicates the type of schedule. Values are payment and billing. |
| LeasePaymentHeaderSchedulesImpactFlag | Indicates if the schedules are impacted and need to be regenerated. |
| LeasePaymentHeaderSecdRegimeAdderRate | Indicates the adder rate used for the secondary regime. |
| LeasePaymentHeaderSecdRegimeDiscRateIndexId | Indicates the discount rate index used for the secondary regime. |
| LeasePaymentHeaderSecdRegimeInterestRate | Indicates the discount rate index value used for the secondary regime. |
| LeasePaymentHeaderShipToSiteUseId | This is the ship-to customer site use identifier. |
| LeasePaymentHeaderSystemOriginReference1 | This is the source system first reference number from which the lease is being imported. |
| LeasePaymentHeaderSystemOriginReference2 | This is the source system second reference number from which the lease is being imported. |
| LeasePaymentHeaderTaxClassificationCode | This is the tax classification code for payment term. |
| LeasePaymentHeaderTaxDeterminantsSourceCode | Specifies the source of the tax determinants when the payment is invoiced. Valid values are setup and payment. |
| LeasePaymentHeaderTaxIncludedFlag | Indicates whether tax is included on the payments created for leases in the business unit. |
| LeasePaymentHeaderTerminationAdjustmentAmount | Indicates the estimated termination adjustment amount as calculated by system. |
| LeasePaymentHeaderTerminationDate | Indicates the date when the payment is terminated. |
| LeasePaymentHeaderThirdPtyRegId | The bill-to customer tax registration number. |
| LeasePaymentHeaderTrxBusinessCategory | This is the transactions category assigned by user. |
| LeasePaymentHeaderUserDefinedFiscalClass | This is the fiscal classification. |
| LeasePaymentHeaderVendorId | The supplier's unique identifier. It's referenced from POZ_VENDORS table. |
| LeasePaymentHeaderVendorSiteId | This is the supplier site's unique identifier. It's used to send the information to Payables during the payment process. |
| LeasePaymentHeaderWithholdingTaxGroupId | This is the withholding tax group's identifier. |