RE_LS_AM_PIE_VW

(SQL View)
 Index Back

Lease Interest for Depr Close

View to get the Lease Interest expense for the depreciation close process

SELECT TERM_SCHED_ID , PIE.SEQ_NUM , PIE.SCHED_TYPE , PIE.ASSET_SEQ_NBR , PIE.ASSET_CLASSIFY , PIE.BUSINESS_UNIT , PIE.ASSET_ID , PIE.LS_KEY , PIE.LS_CLASSIFICATION , PIE.AMND_NBR , PIE.TRANS_DT , PIE.ACCOUNTING_DT , PIE.SCHED_DATE , PIE.PYMNT_DT , PIE.FIRST_PYMNT_SW , PIE.INT_WITH_AP_BI , PIE.LEASE_EXPIRED_FLG , PIE.PRORATE_LS_EXP , PIE.DST_ALLOC_METHOD , PIE.PERCENTAGE , PIE.CF_SEQNO , PIE.CF_SEQNO_EXP , PIE.CURRENCY_CD , PIE.INTEREST_EXPENSE , PIE.INTEREST_ACCRUAL , PIE.AMORTIZATION_AMT , %Sql(RE_BASE_AMT_CONV, PIE.DECIMAL_POSITIONS2, PIE.INTEREST_EXPENSE, PIE.RATE_MULT, PIE.RATE_DIV) , %Sql(RE_BASE_AMT_CONV, PIE.DECIMAL_POSITIONS2, PIE.INTEREST_ACCRUAL, PIE.RATE_MULT, PIE.RATE_DIV) , %Sql(RE_BASE_AMT_CONV, PIE.DECIMAL_POSITIONS2, PIE.AMORTIZATION_AMT, PIE.RATE_MULT, PIE.RATE_DIV) , %Sql(RE_BASE_AMT_CONV, PIE.DECIMAL_POSITIONS2, PIE.INTEREST_EXPENSE, PIE.RATE_MULT_2, PIE.RATE_DIV_2) , %Sql(RE_BASE_AMT_CONV, PIE.DECIMAL_POSITIONS2, PIE.INTEREST_ACCRUAL, PIE.RATE_MULT_2, PIE.RATE_DIV_2) , PIE.ACCOUNTING_DATE , PIE.TRANS_DATE FROM PS_RE_LS_AM_PIE PIE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TERM_SCHED_ID Number(30,0) DECIMAL(30) NOT NULL Lease Term Schedule ID
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
3 SCHED_TYPE Character(1) VARCHAR2(1) NOT NULL Schedule Type
C=Capital Interim Rent
I=Interim Rent
N=Normal Rent
R=Reversal Normal Rent
S=Reversal Interim Rent
T=Reversal Capital Interim
X=Normal Rent Reverted
Y=Interim Reverted
Z=Capital Interim Reverted

Default Value: N

4 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
5 ASSET_CLASSIFY Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
8 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
9 LS_CLASSIFICATION Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
10 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
11 TRANS_DT Date(10) DATE Transaction Date
12 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
13 SCHED_DATE Date(10) DATE Schedule Date
14 PYMNT_DT Date(10) DATE Payment Date
15 FIRST_PYMNT_SW Character(1) VARCHAR2(1) NOT NULL First Payment Switch
16 INT_WITH_AP_BI Character(1) VARCHAR2(1) NOT NULL Integrate with Accounts Payable
17 LEASE_EXPIRED_FLG Character(1) VARCHAR2(1) NOT NULL Lease Expire Flag
18 PRORATE_LS_EXP Character(1) VARCHAR2(1) NOT NULL Recognize Monthly Expense
19 DST_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
5=Quantity
20 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
21 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
22 CF_SEQNO_EXP Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
24 INTEREST_EXPENSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense
25 INTEREST_ACCRUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest calculated
26 AMORTIZATION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amortization Amount
27 INTRST_EXPENSE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense
28 INTRST_ACCRUAL_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest calculated
29 AMORTIZ_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amortization Amount
30 LO_INTRST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Amount for LO
31 LO_INTRST_ACCR_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Amount for LO
32 ACCOUNTING_DATE Date(10) DATE ACCOUNTING_DATE
33 TRANS_DATE Date(10) DATE Transaction Date