RE_TRANS_PIV_VW

(SQL View)
Index Back

Pivot Grid View for Transition

Pivot Grid View for Transition Analytics

SELECT A.LS_KEY , A.LS_NBR , A.BUSINESS_UNIT , CASE WHEN B.PRINCIPAL_ID = ' ' THEN A.PRINCIPAL_ID ELSE B.PRINCIPAL_ID END , B.TERM_RENT_TYPE , B.PAYMENT_GROUP , A.LEASE_OBLG , A.LS_CLASSIFICATION , A.LEASE_STATUS , A.LEASE_NAME , A.LSE_TYPE_CD , A.REGION_CD , A.CURRENCY_CD , %Coalesce(B.SCHED_DATE, A.LEASE_END_DT) , B.AMOUNT , B.OBLIGATION_REDUCE , B.INTEREST_AMOUNT , C.OPRDEFNDESC , D.OPRDEFNDESC FROM PS_RE_LS A , PS_RE_TNST_PIV1_VW B , PS_RE_PTY_DESC C , PS_RE_PTY_DESC D WHERE A.LS_KEY = B.LS_KEY AND A.LS_ADMIN = C.PARTY_KEY AND A.PRTFL_MGR = D.PARTY_KEY AND A.RECOGNITION_EXEMPT = 'N'

# 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 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant
5 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
6 PAYMENT_GROUP Number(3,0) SMALLINT NOT NULL Field For Payment Group
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 LEASE_STATUS Character(1) VARCHAR2(1) NOT NULL Lease Status
1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred
10 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
11 LSE_TYPE_CD Character(10) VARCHAR2(10) NOT NULL This field contains the code for the Lease Types
12 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 SCHED_DATE Date(10) DATE Schedule Date
15 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
16 OBLIGATION_REDUCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction
17 INTEREST_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Amount
18 LS_ADMINDESC Character(30) VARCHAR2(30) NOT NULL Lease Administrator
19 PRTFL_MGRDESC Character(30) VARCHAR2(30) NOT NULL Portfolio Manager