PeopleSoft 9
Asset Management

Table Name LEASE

Table Description
LEASE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
LEASE_ID char(30) No No
VENDOR_ID char(10) No Yes
VENDOR_CONTACT char(30) No No
LEASE_DT PSDATE No No
RESPONSIBILITY char(30) No No
MRP decimal(26,3) No No
EXECUTORY_COSTS decimal(26,3) No No
MLP decimal(26,3) No No
PV_MLP decimal(26,3) No No
CAP_LEASE_AMT decimal(26,3) No No
GUAR_RESIDUAL decimal(26,3) No No
ACTUAL_RESIDUAL decimal(26,3) No No
TSFR_OWNERSHIP_FLG char(1) No No
RENEWAL_OPTION char(1) No No
RENEWAL_PENALTY decimal(26,3) No No
BPO char(1) No No
BPO_PAYMENT decimal(26,3) No No
IMPLICIT_RATE decimal(6,3) No No
BORROW_RATE decimal(6,3) No No
ITC_AMT decimal(26,3) No No
ITC_TAKEN_YEAR smallint No No
LEASE_TYPE char(1) No No
LEASE_TERM int No No
FMV decimal(26,3) No No
EST_LIFE int No No
PYMNT_SCHED_ID char(2) No No
CURRENCY_CD char(3) No No
STEP_LEASE_FLAG char(1) No No
ACCEPTANCE_DT PSDATE No No
LEASE_PYMT_TYPE char(1) No No
EXPIRATION_DT PSDATE No No
LEASE_COMMENCE_DT PSDATE No No
LEASE_END_DT PSDATE No No
LEASE_RECEIPT_DT PSDATE No No
INTERIM_RENT decimal(26,3) No No
DESCR char(30) No No
DAYS_TO_ALERT smallint No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_LEASE PK Yes
PS0LEASE IE1 No
PSALEASE IE1 No
Member(s) of "PS_LEASE" Index
BUSINESS_UNIT
ASSET_ID
Member(s) of "PS0LEASE" Index
LEASE_ID
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSALEASE" Index
ASSET_ID

Published December 16, 2006