Converting Lease Information

The interface load table INTFC_LEASE contains leased asset information for lease schedules that were already calculated. This lease interface table is used to add leases to PeopleSoft Asset Management tables using the Transaction Loader interface type LAD (Leased Asset Addition). The lease payment schedule information should be populated in the INTFC_LEASE table; it is not calculated by the Transaction Loader.

Before running the Transaction Loader, the INTFC_LEASE, INTFC_FIN and INTFC_PHY_A tables must be loaded with leased asset information. The new ASSET_IDs are calculated if the interface table ASSET_ID fields are set to NEXT. If NEXT ASSET_ID is used, each INTFC_LINE_NUM should represent one ASSET_ID, and the same INTFC_LINE_NUM should be used for all three interface tables.

These fields are required in INTFC_LEASE:

• PYMNT_DT

• PYMNT_SCHED_ID (Do not populate this field with NEXT; it will not be assigned automatically.)

• LEASE_TERM

• LEASE_TYPE

• IMPLICIT_RATE

• PV_MLP

• CAP_LEASE_AMT

• LEASE_DT

• MRP

• INTEREST_EXPENSE

• OBLIGATION_REDUCE

• EST_LIFE

These fields can have values of zero or N, or the default value from the profile (if you are using default profile switch = "Yes"):

• FV

• BPO

• BPO_PAYMENT

• BORROW_RATE

• ACTUAL_RESIDUAL

• GUAR_RESIDUAL

• TSFR_OWNERSHIP_FLAG

• RENEWAL_OPTION

• ITC_AMT

• EXECUTORY_COSTS

If LEASE_TYPE = O (Operating Lease), then DEFAULT_PROFILE_SW must equal N. If it is an operating lease asset, then the BOOK field in the LEASE_OPER record will be populated with the DEFAULT_BOOK in the BUS_UNIT_TBL_AM record.

All of the preceding fields affect the LEASE_BOOK. The INTFC_FIN.LIFE on the LEASE_BOOK should be calculated as FREQUENCY × LEASE_TERM. For example, if the PYMNT_SCHED_ID is monthly and LEASE_TERM = 24, then LIFE = 24 and ESTIMATED LIFE = 24. The preceding data is needed for lease adjustments in Asset Management.

When the INTFC_LEASE table is populated, you can use the Load Preview-Lease page to review and correct lease data before uploading to the PeopleSoft Asset Management tables.