LEASE_TEO2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	LEASE_ID	Character(30)	VARCHAR2(30) NOT NULL	Lease ID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VNDR_FS
6	VENDOR_CONTACT	Character(30)	VARCHAR2(30) NOT NULL	Vendor Contact
7	LEASE_DT	Date(10)	DATE	Lease Date Default Value: %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 Default Value: N
17	RENEWAL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Bargain Renewal Option Y/N Table Edit Default Value: N
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 Default Value: N
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 Default Value: C
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 Prompt Table: LEASE_SCH_ID
30	COMMENTS	Long Character	CLOB	Comment
31	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CURR_CD_AM_VW.CURRENCY_CD
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)
40	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
41	DAYS_TO_ALERT	Number(3,0)	SMALLINT NOT NULL	Display Alert Days
42	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
43	FV_TEMPLATE_ID	Character(12)	VARCHAR2(12) NOT NULL	Fair Value Template ID
44	FV_GROUP_ID	Character(20)	VARCHAR2(20) NOT NULL	FV Group ID used to group related FV Assets
45	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.