RE_TNST_PIV1_VW(SQL View) |
Index Back |
|---|---|
Pivot Grid ViewTransition Analytics Pivot Grid View |
| SELECT A.LS_KEY , B.TERM_RENT_TYPE , B.PAYMENT_GROUP , A.PRINCIPAL_ID , A.SCHED_DATE , A.AMOUNT , A.OBLIGATION_REDUCE , A.INTEREST_AMOUNT FROM PS_RE_LS_TRM_SCHED A , PS_RE_LS_TRM B WHERE A.LS_KEY = B.LS_KEY AND A.TERM_ID = B.TERM_ID UNION ALL SELECT C.LS_KEY , '00' , 1 , ' ' , %DateNull , 0 , C.GUAR_RESIDUAL , 0 FROM PS_RE_LS_PPTY C WHERE GUAR_RESIDUAL <> 0 AND NOT EXISTS ( SELECT 1 FROM PS_RE_LS_TRM D WHERE D.LS_KEY = C.LS_KEY AND D.TERM_RENT_TYPE = '06' AND D.CAPITALIZE_SW = 'Y') |
| # | 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 | 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 |
| 3 | PAYMENT_GROUP | Number(3,0) | SMALLINT NOT NULL | Field For Payment Group |
| 4 | PRINCIPAL_ID | Character(15) | VARCHAR2(15) NOT NULL | Landlord/Tenant |
| 5 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 6 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 7 | OBLIGATION_REDUCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Obligation Reduction |
| 8 | INTEREST_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Interest Amount |