RE_LS_AM_SRC_VW

(SQL View)
 Index Back

View for Lease Payment Entries

View for creating Lease Payment Entries by Depr Close Process

SELECT REC_SOURCE , TXN_KEY , BUSINESS_UNIT , ASSET_ID , ASSET_SEQ_NBR , LS_KEY , LEASE_OBLG , LS_CLASSIFICATION , RECOGNITION_EXEMPT , ASSET_CLASSIFY , ROUNDING_APPLIED , AMND_NBR , TRANS_DT , ACCOUNTING_DT , CATEGORY , TERM_ID , TERM_RENT_TYPE , TXN_GRP , CAPITALIZE_SW , INT_WITH_AP_BI , PRORATE_LS_EXP , FIRST_PYMNT_SW , SCHED_DATE , SCHED_TYPE , PRORATION_RATE , IDC_PRORATION_RATE , DST_ALLOC_METHOD , PERCENTAGE , CF_SEQNO , CF_SEQNO_EXP , CURRENCY_CD , OBLIGATION_REDUCE , INTEREST_AMOUNT , %Sql(RE_BASE_AMT_CONV, DECIMAL_POSITIONS2, OBLIGATION_REDUCE, RATE_MULT_2, RATE_DIV_2) , %Sql(RE_BASE_AMT_CONV, DECIMAL_POSITIONS2, INTEREST_AMOUNT, RATE_MULT, RATE_DIV) , %Sql(RE_BASE_AMT_CONV, DECIMAL_POSITIONS2, OBLIGATION_REDUCE, RATE_MULT, RATE_DIV) , %Sql(RE_BASE_AMT_CONV, DECIMAL_POSITIONS2, INTEREST_AMOUNT, RATE_MULT_2, RATE_DIV_2) , LS_TXN_SRC_ID , START_DT , END_DT FROM PS_RE_LS_AM_SRC UNION ALL SELECT 'T' , A.LS_TXN_ID , B.BUSINESS_UNIT_AM , B.ASSET_ID , B.ASSET_SEQ_NBR , A.LS_KEY , A.LEASE_OBLG , C.LS_CLASSIFICATION , C.RECOGNITION_EXEMPT , B.ASSET_CLASSIFY , B.ROUNDING_APPLIED , 0 , A.SCHED_DATE , A.SCHED_DATE , B.CATEGORY , 0 , ' ' , A.TXN_GRP , 'N' , 'Y' , 'N' , 'N' , A.SCHED_DATE , 'N' , B.PRORATION_RATE , B.IDC_PRORATION_RATE , '4' , 100 , -1 , -1 , C.CURRENCY_CD , 1 , 0 , 1 , 0 , 1 , 0 , A.LS_TXN_SRC_ID , A.SCHED_DATE , A.SCHED_DATE FROM PS_RE_LS_TXN A , PS_RE_LSA_PPTY B , PS_RE_LS C , PS_RE_BUS_UNIT D WHERE A.TXN_GRP NOT IN ('1', '4', '6') AND A.LS_KEY = B.LS_KEY AND A.LEASE_OBLG = '1' AND A.LS_KEY = C.LS_KEY AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND D.USE_AM_AET = 'Y' AND A.LS_TXN_STATUS IN ('1','2','5','7') AND B.AMND_NBR = ( SELECT MAX(E.AMND_NBR) FROM PS_RE_LSA E WHERE E.LS_KEY = C.LS_KEY AND E.AMND_STATUS <> '1')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REC_SOURCE Character(1) VARCHAR2(1) NOT NULL Record Source
S=Schedule
T=Transaction
2 TXN_KEY Number(30,0) DECIMAL(30) NOT NULL Transaction Key
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
6 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
7 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
8 LS_CLASSIFICATION Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
9 RECOGNITION_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from Recognition Flag
10 ASSET_CLASSIFY Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
11 ROUNDING_APPLIED Character(1) VARCHAR2(1) NOT NULL Rounding Applied
N=No
Y=Yes
12 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
13 TRANS_DT Date(10) DATE Transaction Date
14 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
15 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
16 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID
17 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
18 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
1=Base Rent
2=Security Deposit
3=Straightline Accounting
4=Operating Expense
5=Percent Rent
6=Miscellaneous Rent
7=Manual Fee
8=Lease Obligation
9=Lease Interest Expense
A=Prior Period Lease Obligation
B=Prior Period Lease Interest
C=Rent Expense
D=Lease Incentive
19 CAPITALIZE_SW Character(1) VARCHAR2(1) NOT NULL Capitalized
20 INT_WITH_AP_BI Character(1) VARCHAR2(1) NOT NULL Integrate with Accounts Payable
21 PRORATE_LS_EXP Character(1) VARCHAR2(1) NOT NULL Recognize Monthly Expense
22 FIRST_PYMNT_SW Character(1) VARCHAR2(1) NOT NULL First Payment Switch
23 SCHED_DATE Date(10) DATE Schedule Date
24 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
25 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate
26 IDC_PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL IDC Proration Rate
27 DST_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
5=Quantity
28 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
29 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
30 CF_SEQNO_EXP Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
32 OBLIGATION_REDUCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction
33 INTEREST_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Amount
34 OBLG_REDUCE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction
35 INTRST_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Amount
36 AMORTIZ_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amortization Amount
37 LO_INTRST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Amount for LO
38 LS_TXN_SRC_ID Number(30,0) DECIMAL(30) NOT NULL Lease Transaction Source ID
39 START_DT Date(10) DATE Start Date
40 END_DT Date(10) DATE End Date