LEASE_CC_TMP

(SQL Table)
Index Back

Asset Lease

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 LEASE_ID Character(30) VARCHAR2(30) NOT NULL Lease ID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VENDOR_CONTACT Character(30) VARCHAR2(30) NOT NULL Vendor Contact
7 LEASE_DT Date(10) DATE Lease Date
8 RESPONSIBILITY Character(30) VARCHAR2(30) NOT NULL Responsibility
9 MRP Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Rental Payment
10 EXECUTORY_COSTS Signed Number(28,3) DECIMAL(26,3) NOT NULL Executory Costs
11 MLP Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Lease Payment
12 PV_MLP Signed Number(28,3) DECIMAL(26,3) NOT NULL Present Value
13 CAP_LEASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Capitalized Lease Amount
14 GUAR_RESIDUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Guaranteed Residual Value
15 ACTUAL_RESIDUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Residual Value
16 TSFR_OWNERSHIP_FLG Character(1) VARCHAR2(1) NOT NULL Transfer Ownership

Y/N Table Edit

17 RENEWAL_OPTION Character(1) VARCHAR2(1) NOT NULL Bargain Renewal Option

Y/N Table Edit

18 RENEWAL_PENALTY Signed Number(28,3) DECIMAL(26,3) NOT NULL Renewal Payment Penalty
19 BPO Character(1) VARCHAR2(1) NOT NULL Bargain Purchase Option

Y/N Table Edit

20 BPO_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bargain Purchase Option Paymnt
21 IMPLICIT_RATE Number(8,4) DECIMAL(7,4) NOT NULL Implicit Interest Rate
22 BORROW_RATE Number(8,4) DECIMAL(7,4) NOT NULL Incremental Borrowing Rate
23 ITC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Investment Tax Credit Amount
24 ITC_TAKEN_YEAR Number(4,0) SMALLINT NOT NULL ITC Taken Year
25 LEASE_TYPE Character(1) VARCHAR2(1) NOT NULL Lease Type
C=Capital
O=Operating
26 LEASE_TERM Number(6,0) INTEGER NOT NULL Lease Term (Periods)
27 FMV Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair (Market) Value Amount
28 EST_LIFE Number(6,0) INTEGER NOT NULL Estimated Life
29 PYMNT_SCHED_ID Character(2) VARCHAR2(2) NOT NULL Payment Schedule ID
30 COMMENTS Long Character CLOB Comment
31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
32 STEP_LEASE_FLAG Character(1) VARCHAR2(1) NOT NULL Step Lease

Y/N Table Edit

33 ACCEPTANCE_DT Date(10) DATE Acceptance Date
34 LEASE_PYMT_TYPE Character(1) VARCHAR2(1) NOT NULL Lease Payment Type
A=Advance
O=One Time
R=Arrears
35 EXPIRATION_DT Date(10) DATE Expiration Date
36 LEASE_COMMENCE_DT Date(10) DATE Commencement Date
37 LEASE_END_DT Date(10) DATE Lease End Date
38 LEASE_RECEIPT_DT Date(10) DATE Receipt Date
39 INTERIM_RENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Interim Rent (Monthly)