RE_AM_CR_SL1_VW

(SQL View)
 Index Back

Lease Chart Temp View


SELECT C.Ls_Key , b.Business_Unit , b.Asset_ID , b.Lease_ID , b.Vendor_ID , b.Vendor_Contact , b.Lease_Dt , b.Responsibility , b.MRP , b.Executory_Costs , b.MLP , b.PV_MLP , b.CAP_Lease_Amt , b.Guar_Residual , b.Actual_Residual , b.Tsfr_Ownership_Flg , b.Renewal_Option , b.Renewal_penalty , b.BPO , b.BPO_Payment , b.Implicit_Rate , b.Borrow_Rate , b.ITC_Amt , b.ITC_Taken_Year , 'Y' , b.Lease_Term , b.FMV , b.Est_Life , b.Pymnt_Sched_ID , b.Lease_Book , b.Cal_depr_pd , b.Cal_SetID , a.Fiscal_Year , a.Accounting_Period , c.End_Dt , c.Percentage , c.cf_seqno , 0 , C.ACCR_DEFR_AMT , 0 , C.ACR_DFR_AMT_BS , b.Currency_Cd , ' ' , C.Currency_Cd , ' ' , ' ' , C.Asset_Classify , C.AMND_NBR , C.Term_Rent_Type , C.Prorate_Ls_Exp , 'N' , a.Fiscal_Year , a.Accounting_Period , C.TRANS_DT , C.ACCOUNTING_DT FROM ps_Cal_Detp_Tbl a , PS_LEASE_CHART1_VW b , PS_RE_LS_STLINE_VW c WHERE a.SetID = b.Cal_SetID AND a.Calendar_ID = b.Cal_Depr_Pd AND b.Business_Unit = c.Business_Unit AND b.Asset_ID = c.Asset_ID AND c.End_Dt BETWEEN a.Begin_Dt AND a.End_Dt UNION ALL SELECT C.Ls_Key , b.Business_Unit , b.Asset_ID , b.Lease_ID , b.Vendor_ID , b.Vendor_Contact , b.Lease_Dt , b.Responsibility , b.MRP , b.Executory_Costs , b.MLP , b.PV_MLP , b.CAP_Lease_Amt , b.Guar_Residual , b.Actual_Residual , b.Tsfr_Ownership_Flg , b.Renewal_Option , b.Renewal_penalty , b.BPO , b.BPO_Payment , b.Implicit_Rate , b.Borrow_Rate , b.ITC_Amt , b.ITC_Taken_Year , 'Y' , b.Lease_Term , b.FMV , b.Est_Life , b.Pymnt_Sched_ID , b.Lease_Book , b.Cal_depr_pd , b.Cal_SetID , a.Fiscal_Year , a.Accounting_Period , c.End_Dt , c.Percentage , c.cf_seqno , 0 , C.ACCR_DEFR_AMT , 0 , C.ACR_DFR_AMT_BS , b.Currency_Cd , ' ' , C.Currency_Cd , ' ' , ' ' , C.Asset_Classify , C.AMND_NBR , C.Term_Rent_Type , C.Prorate_Ls_Exp , 'N' , a.Fiscal_Year , a.Accounting_Period , C.TRANS_DT , C.ACCOUNTING_DT FROM ps_Cal_Detp_Tbl a , PS_LEASE_CHART1_VW b , PS_RE_LS_SL_RND_VW c WHERE a.SetID = b.Cal_SetID AND a.Calendar_ID = b.Cal_Depr_Pd AND b.Business_Unit = c.Business_Unit AND b.Asset_ID = c.Asset_ID AND c.End_Dt BETWEEN a.Begin_Dt AND a.End_Dt

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

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
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
17 RENEWAL_OPTION Character(1) VARCHAR2(1) NOT NULL Bargain Renewal Option
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
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 LEASE_BOOK Character(10) VARCHAR2(10) NOT NULL Book used by Lease
31 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar
32 CAL_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
33 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
34 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.
35 PYMNT_DT Date(10) DATE Payment Date
36 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
37 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
38 INTEREST_EXPENSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense
39 OBLIGATION_REDUCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction
40 INTRST_EXPENSE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense
41 OBLG_REDUCE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction
42 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
43 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
44 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
45 INT_WITH_AP_BI Character(1) VARCHAR2(1) NOT NULL Integrate with Accounts Payable
46 FIRST_PYMNT_SW Character(1) VARCHAR2(1) NOT NULL First Payment Switch
47 ASSET_CLASSIFY Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
48 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
49 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
50 PRORATE_LS_EXP Character(1) VARCHAR2(1) NOT NULL Recognize Monthly Expense
51 PLP_FLG Character(1) VARCHAR2(1) NOT NULL Prior Lease Period Flag
N=No
Y=Yes
52 FISCAL_YEAR2 Number(4,0) SMALLINT NOT NULL Fiscal Year
53 ACCOUNTING_PERIOD2 Number(3,0) SMALLINT NOT NULL Accounting Period
54 TRANS_DT Date(10) DATE Transaction Date
55 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple