Expiring Leases Inquiry program (P154030)

Use the Expiring Leases Inquiry program (P154030) to review the expiration dates, building statistics, and rent information for leases as of a specific date. You can review leases that expire within selected date ranges in 30-day increments from the as of date. For example, you can select leases that expire within 1–30 days, 31–60 days, or over 181 days as of a certain date.

Use this criteria to search for lease expiration dates on the Expiring Leases Inquiry form:

  • Building/Business Unit (Release 9.2 Update)

  • Unit

  • Asset Number (Release 9.2 Update)

  • Tenant

  • Lease/Version

  • Lease Type

The P154030 program retrieves information from the Lease Master Header (F1501B) and Lease Master Detail (F15017) tables, as well as rent information from the Recurring Billings Master table (F1502B).

(Release 9.2 Update) If you are working with lessee leases, you can view expiring leases using the Work With Amortization Schedules program (P15171). See Processing Lease Commencement for Balance Sheet Lessee Accounting for additional information.