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.
Note: If you have migrated your Asset Management lease data into Lease Administration (per PeopleSoft’s compliance with ASC 842 and IFRS 16 lease accounting standards), this topic does not apply.
Page Name |
Definition Name |
Usage |
---|---|---|
Load Preview-Lease |
INTFC_LEASE |
Review and, if necessary, correct lease data before uploading it to PeopleSoft Asset Management tables. |
Load Approval - Lease |
INTFC_LEASE_APPR |
Approve lease data before uploading to PeopleSoft Asset Management tables. |
Use the Load Preview - Lease page (INTFC_LEASE) to review and, if necessary, correct lease data before uploading it to PeopleSoft Asset Management tables.
Navigation:
Use the Load Approval - Lease page (INTFC_LEASE_APPR) to approve lease data before uploading to PeopleSoft Asset Management tables.
Navigation: