Search Results fa_lease_payment_items




Overview
Explore in AI Chat

Overview

FA_LEASE_PAYMENT_ITEMS is a transaction-level table in the Oracle Assets (OFA) module that stores the individual payment items associated with lease schedules. Where FA_LEASES captures the master lease agreement, FA_LEASE_PAYMENT_ITEMS decomposes that agreement into discrete, dated payment obligations, each tied to an amortization line on a scheduled payment stream. The table is therefore central to lease expense recognition, payment scheduling, and the reconciliation of lease obligations against supplier invoices, which the application posts through Payables.

From a data-modeling perspective, the object has a satellite-leaning Data Vault classification, as inferred heuristically from its foreign-key structure. It is a satellite of the lease hub because it records descriptive and derived attributes—payment amounts, invoice references, and distribution accounting—rather than serving purely as a keyed link between two hubs. Each row represents one amortization line on one payment schedule belonging to one lease.

Key Information Stored

The table contains seventeen documented columns. The most significant are summarized below.

The documented unique index FA_LEASE_PAYMENT_ITEMS_U1, defined on LEASE_ID, PAYMENT_SCHEDULE_ID, and SCHEDULE_AMORT_LINE_NUM, establishes the business key. No separate surrogate primary key column is enumerated in the metadata; the composite business key effectively governs row identity, confirming the table's satellite character.

Common Use Cases and Queries

Typical usage focuses on extracting lease payment schedules, reconciling payments to invoices, and reviewing accounting distributions. A common pattern joins the table back to FA_LEASES to enrich the lease context:

  • Listing all payment items for a lease and schedule, ordered by amortization line number, to reconstruct the full payment stream.
  • Reconciling lease payments against Payables invoices using INVOICE_ID, INVOICE_LINE_ID, and INVOICE_NUMBER, including the join to FTE_INVOICE_LINES.
  • Reviewing distribution accounting by linking DIST_CODE_COMBINATION_ID to GL code combinations, useful for lease expense reporting.
  • Auditing supplier detail via LESSOR_ID and LESSOR_SITE_ID for lessor-level and site-level spend analysis.
  • Monitoring EXPORT_STATUS to identify unexported items and REQUEST_ID to trace the concurrent process that created them.

A representative query selects payment items for a schedule and orders them by line number, with a correlated lookup to FA_LEASES for lease identification.

Related Objects

The most significant related objects are described below.

  • FA_LEASES — The parent lease table; joined on LEASE_ID via the documented foreign key.
  • FTE_INVOICE_LINES — Referenced through INVOICE_LINE_ID; provides invoice line detail for matched payments.
  • FA_LEASE_PAYMENT_ITEMS_U1 — The unique index enforcing the business key, useful in query plans and lookups.
  • Payables invoice objects (AP_INVOICES, AP_INVOICE_LINES) — Logical counterparts referenced through INVOICE_ID and INVOICE_LINE_ID.
  • GL_CODE_COMBINATIONS — Resolves DIST_CODE_COMBINATION_ID for accounting analysis.
  • AP_TERMS — Resolves TERMS_ID for payment terms detail.
  • PO_VENDORS / PO_VENDOR_SITES — Supplier and site detail for LESSOR_ID and LESSOR_SITE_ID.

Together, these relationships position FA_LEASE_PAYMENT_ITEMS as the operational bridge between lease scheduling in Assets and payment execution in Payables.