PeopleSoft 9
Asset Management

Table Name INTFC_LEASE

Table Description
INTFC_LEASE
Columns
Name Datatype Is PK Is FK
INTFC_ID int Yes No
INTFC_LINE_NUM int Yes No
BUSINESS_UNIT char(5) Yes No
ASSET_ID char(12) Yes No
PYMNT_DT PSDATE Yes No
DTTM_STAMP PSDATETIME Yes No
TRANS_DT PSDATE Yes No
SYSTEM_SOURCE char(3) No No
LOAD_STATUS char(3) No No
INTFC_TYPE char(3) No No
APPROVAL_SW char(1) No No
LEASE_ID char(30) No No
VENDOR_ID char(10) No No
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
INTEREST_EXPENSE decimal(26,3) No No
OBLIGATION_REDUCE decimal(26,3) No No
PYMNT_FREQUENCY char(1) No No
CURRENCY_CD char(3) No No
SCHED_PYMNT_TYPE char(1) No No
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
PROJECT_ID char(15) No No
DEPTID char(10) No No
CATEGORY char(5) No No
COST_TYPE char(1) No No
TRANS_CODE char(5) No No
COMMENTS50 char(50) No No
LEASE_END_DT PSDATE No No
LEASE_RECEIPT_DT PSDATE No No
LEASE_COMMENCE_DT PSDATE No No
EXPIRATION_DT PSDATE No No
ACCEPTANCE_DT PSDATE No No
LEASE_PYMT_TYPE char(1) No No
INTERIM_RENT decimal(26,3) No No
PROCESS_INSTANCE decimal(10) No No
Index
Name Type Unique Member
PS_INTFC_LEASE PK Yes
PSAINTFC_LEASE IE1 No
Member(s) of "PS_INTFC_LEASE" Index
INTFC_ID
INTFC_LINE_NUM
BUSINESS_UNIT
ASSET_ID
PYMNT_DT
DTTM_STAMP
TRANS_DT
Member(s) of "PSAINTFC_LEASE" Index
PROCESS_INSTANCE

Published December 16, 2006