RE_TRANS_PIV_VW(SQL View) |
Index Back |
---|---|
Pivot Grid View for TransitionPivot 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 |