RE_AM_PRO_LS_VW (SQL View)	Index Back
Lease Chart Temp View

RE_AM_PRO_LS_VW

(SQL View)

Lease Chart Temp View

SELECT BUSINESS_UNIT , ASSET_ID , LEASE_ID , VENDOR_ID , VENDOR_CONTACT , LEASE_DT , RESPONSIBILITY , MRP , EXECUTORY_COSTS , MLP , PV_MLP , CAP_LEASE_AMT , GUAR_RESIDUAL , ACTUAL_RESIDUAL , TSFR_OWNERSHIP_FLG , RENEWAL_OPTION , RENEWAL_PENALTY , BPO , BPO_PAYMENT , IMPLICIT_RATE , BORROW_RATE , ITC_AMT , ITC_TAKEN_YEAR , LEASE_TYPE , LEASE_TERM , FMV , EST_LIFE , PYMNT_SCHED_ID , LEASE_BOOK , CAL_DEPR_PD , CAL_SETID , FISCAL_YEAR , ACCOUNTING_PERIOD , PYMNT_DT , PERCENTAGE , CF_SEQNO , CF_SEQNO_EXP , INTEREST_EXPENSE , INTEREST_ACCRUAL , OBLIGATION_REDUCE , INTRST_EXPENSE_BSE , INTRST_ACCRUAL_BSE , OBLG_REDUCE_BSE , CURRENCY_CD , SCHED_PYMNT_TYPE , TXN_CURRENCY_CD , INT_WITH_AP_BI , FIRST_PYMNT_SW , ASSET_CLASSIFY , TERM_RENT_TYPE , TXN_KEY , LS_KEY , AMND_NBR , PRORATION_RATE , IDC_PRORATION_RATE , PRORATE_LS_EXP , PLPREC_SW , PLP_FLG , FISCAL_YEAR2 , ACCOUNTING_PERIOD2 , TRANS_DT , ACCOUNTING_DT , PAYMENT_ACTION FROM PS_RE_AM_PRO_LS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

3 LEASE_ID Character(30) VARCHAR2(30) NOT NULL Lease ID

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

5 VENDOR_CONTACT Character(30) VARCHAR2(30) NOT NULL Vendor Contact

6 LEASE_DT Date(10) DATE Lease Date

7 RESPONSIBILITY Character(30) VARCHAR2(30) NOT NULL Responsibility

8 MRP Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Rental Payment

9 EXECUTORY_COSTS Signed Number(28,3) DECIMAL(26,3) NOT NULL Executory Costs

10 MLP Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Lease Payment

11 PV_MLP Signed Number(28,3) DECIMAL(26,3) NOT NULL Present Value

12 CAP_LEASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Capitalized Lease Amount

13 GUAR_RESIDUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Guaranteed Residual Value

14 ACTUAL_RESIDUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Residual Value

15 TSFR_OWNERSHIP_FLG Character(1) VARCHAR2(1) NOT NULL Transfer Ownership

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

17 RENEWAL_PENALTY Signed Number(28,3) DECIMAL(26,3) NOT NULL Renewal Payment Penalty

18 BPO Character(1) VARCHAR2(1) NOT NULL Bargain Purchase Option

19 BPO_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bargain Purchase Option Paymnt

20 IMPLICIT_RATE Number(8,4) DECIMAL(7,4) NOT NULL Implicit Interest Rate

21 BORROW_RATE Number(8,4) DECIMAL(7,4) NOT NULL Incremental Borrowing Rate

22 ITC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Investment Tax Credit Amount

23 ITC_TAKEN_YEAR Number(4,0) SMALLINT NOT NULL ITC Taken Year

24 LEASE_TYPE Character(1) VARCHAR2(1) NOT NULL Lease Type
C=Capital
O=Operating

25 LEASE_TERM Number(6,0) INTEGER NOT NULL Lease Term (Periods)

26 FMV Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair (Market) Value Amount

27 EST_LIFE Number(6,0) INTEGER NOT NULL Estimated Life

28 PYMNT_SCHED_ID Character(2) VARCHAR2(2) NOT NULL Payment Schedule ID

29 LEASE_BOOK Character(10) VARCHAR2(10) NOT NULL Book used by Lease

30 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar

31 CAL_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

32 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

33 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

34 PYMNT_DT Date(10) DATE Payment Date

35 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

36 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number

37 CF_SEQNO_EXP Number(6,0) INTEGER NOT NULL Chartfield Sequence Number

38 INTEREST_EXPENSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense

39 INTEREST_ACCRUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest calculated

40 OBLIGATION_REDUCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction

41 INTRST_EXPENSE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense

42 INTRST_ACCRUAL_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest calculated

43 OBLG_REDUCE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction

44 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

45 SCHED_PYMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Lease Payment Type
C=Capital Interim Rent
I=Interim Rent
N=Normal Rent
R=Reversal Payment
S=Reversal Interim
T=Reversal Capital Interim
X=Payment Reverted
Y=Interim Reverted
Z=Capital Interim Reverted

46 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

47 INT_WITH_AP_BI Character(1) VARCHAR2(1) NOT NULL Integrate with Accounts Payable

48 FIRST_PYMNT_SW Character(1) VARCHAR2(1) NOT NULL First Payment Switch

49 ASSET_CLASSIFY Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating

50 TERM_RENT_TYPE Character(2) VARCHAR2(2) NOT NULL List of Rent Type for Transaction Group
00=Residual Value
01=Base Rent
02=Operating Expense
03=Miscellaneous Rent
04=Initial Direct Cost
05=Prepaid Rent
06=Purchase Option
07=Renewal Option
08=Penality Option
09=Lease Incentives
10=Prepaid Rent

51 TXN_KEY Number(30,0) DECIMAL(30) NOT NULL Transaction Key

52 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key

53 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number

54 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate

55 IDC_PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL IDC Proration Rate

56 PRORATE_LS_EXP Character(1) VARCHAR2(1) NOT NULL Recognize Monthly Expense

57 PLPREC_SW Character(1) VARCHAR2(1) NOT NULL From PLP Row

58 PLP_FLG Character(1) VARCHAR2(1) NOT NULL Prior Lease Period Flag
N=No
Y=Yes

59 FISCAL_YEAR2 Number(4,0) SMALLINT NOT NULL Fiscal Year

60 ACCOUNTING_PERIOD2 Number(3,0) SMALLINT NOT NULL Accounting Period

61 TRANS_DT Date(10) DATE Transaction Date

62 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

63 PAYMENT_ACTION Character(1) VARCHAR2(1) NOT NULL What do I do with payment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	LEASE_ID	Character(30)	VARCHAR2(30) NOT NULL	Lease ID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VENDOR_CONTACT	Character(30)	VARCHAR2(30) NOT NULL	Vendor Contact
6	LEASE_DT	Date(10)	DATE	Lease Date
7	RESPONSIBILITY	Character(30)	VARCHAR2(30) NOT NULL	Responsibility
8	MRP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Minimum Rental Payment
9	EXECUTORY_COSTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Executory Costs
10	MLP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Minimum Lease Payment
11	PV_MLP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Present Value
12	CAP_LEASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Capitalized Lease Amount
13	GUAR_RESIDUAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Guaranteed Residual Value
14	ACTUAL_RESIDUAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Residual Value
15	TSFR_OWNERSHIP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Transfer Ownership
16	RENEWAL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Bargain Renewal Option
17	RENEWAL_PENALTY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Renewal Payment Penalty
18	BPO	Character(1)	VARCHAR2(1) NOT NULL	Bargain Purchase Option
19	BPO_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bargain Purchase Option Paymnt
20	IMPLICIT_RATE	Number(8,4)	DECIMAL(7,4) NOT NULL	Implicit Interest Rate
21	BORROW_RATE	Number(8,4)	DECIMAL(7,4) NOT NULL	Incremental Borrowing Rate
22	ITC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Investment Tax Credit Amount
23	ITC_TAKEN_YEAR	Number(4,0)	SMALLINT NOT NULL	ITC Taken Year
24	LEASE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Lease Type C=Capital O=Operating
25	LEASE_TERM	Number(6,0)	INTEGER NOT NULL	Lease Term (Periods)
26	FMV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair (Market) Value Amount
27	EST_LIFE	Number(6,0)	INTEGER NOT NULL	Estimated Life
28	PYMNT_SCHED_ID	Character(2)	VARCHAR2(2) NOT NULL	Payment Schedule ID
29	LEASE_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Book used by Lease
30	CAL_DEPR_PD	Character(2)	VARCHAR2(2) NOT NULL	Calendar
31	CAL_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
32	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
33	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
34	PYMNT_DT	Date(10)	DATE	Payment Date
35	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
36	CF_SEQNO	Number(6,0)	INTEGER NOT NULL	Chartfield Sequence Number
37	CF_SEQNO_EXP	Number(6,0)	INTEGER NOT NULL	Chartfield Sequence Number
38	INTEREST_EXPENSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest Expense
39	INTEREST_ACCRUAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest calculated
40	OBLIGATION_REDUCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Obligation Reduction
41	INTRST_EXPENSE_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest Expense
42	INTRST_ACCRUAL_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest calculated
43	OBLG_REDUCE_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Obligation Reduction
44	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
45	SCHED_PYMNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Lease Payment Type C=Capital Interim Rent I=Interim Rent N=Normal Rent R=Reversal Payment S=Reversal Interim T=Reversal Capital Interim X=Payment Reverted Y=Interim Reverted Z=Capital Interim Reverted
46	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
47	INT_WITH_AP_BI	Character(1)	VARCHAR2(1) NOT NULL	Integrate with Accounts Payable
48	FIRST_PYMNT_SW	Character(1)	VARCHAR2(1) NOT NULL	First Payment Switch
49	ASSET_CLASSIFY	Character(1)	VARCHAR2(1) NOT NULL	Field for Lease Classification C=Finance O=Operating
50	TERM_RENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	List of Rent Type for Transaction Group 00=Residual Value 01=Base Rent 02=Operating Expense 03=Miscellaneous Rent 04=Initial Direct Cost 05=Prepaid Rent 06=Purchase Option 07=Renewal Option 08=Penality Option 09=Lease Incentives 10=Prepaid Rent
51	TXN_KEY	Number(30,0)	DECIMAL(30) NOT NULL	Transaction Key
52	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
53	AMND_NBR	Number(3,0)	SMALLINT NOT NULL	Amendment Number
54	PRORATION_RATE	Number(14,10)	DECIMAL(13,10) NOT NULL	Proration Rate
55	IDC_PRORATION_RATE	Number(14,10)	DECIMAL(13,10) NOT NULL	IDC Proration Rate
56	PRORATE_LS_EXP	Character(1)	VARCHAR2(1) NOT NULL	Recognize Monthly Expense
57	PLPREC_SW	Character(1)	VARCHAR2(1) NOT NULL	From PLP Row
58	PLP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prior Lease Period Flag N=No Y=Yes
59	FISCAL_YEAR2	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
60	ACCOUNTING_PERIOD2	Number(3,0)	SMALLINT NOT NULL	Accounting Period
61	TRANS_DT	Date(10)	DATE	Transaction Date
62	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
63	PAYMENT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	What do I do with payment