RE_LS_SL_RND_VW(SQL View) |
Index Back |
|---|
| SELECT A.LS_KEY , AMND.AMND_NBR , AMND.TRANS_DT , AMND.ACCOUNTING_DT , B.BUSINESS_UNIT_AM , B.ASSET_ID , B.ASSET_CLASSIFY , A.LEASE_END_DT , %Coalesce(C.PERCENTAGE, 100) , CASE WHEN STL.TERM_RENT_TYPE = '09' THEN %Coalesce(C.CF_SEQNO_INC, B.CF_SEQNO_INC) ELSE %Coalesce(C.CF_SEQNO_EXP, B.CF_SEQNO_EXP) END , A.CURRENCY_CD , CASE WHEN STL.TERM_RENT_TYPE = '09' THEN %Coalesce(C.ADJ_AMOUNT_LN, B.ADJ_AMOUNT_LN) ELSE %Coalesce(C.ADJ_AMOUNT_RE, B.ADJ_AMOUNT_RE) END , CASE WHEN STL.TERM_RENT_TYPE = '09' THEN %Coalesce(C.ADJ_AMOUNT_LN_BSE, B.ADJ_AMOUNT_LN_BSE) ELSE %Coalesce(C.ADJ_AMOUNT_RE_BSE, B.ADJ_AMOUNT_RE_BSE) END , STL.TERM_RENT_TYPE , A.PRORATE_LS_EXP , A.RECOGNITION_EXEMPT FROM PS_RE_LSA AMND INNER JOIN PS_RE_LS A ON (A.LS_KEY = AMND.LS_KEY) INNER JOIN PS_RE_STLINE STL ON (STL.LS_KEY = A.LS_KEY) INNER JOIN PS_RE_LS_PPTY B ON (B.LS_KEY = A.LS_KEY) LEFT OUTER JOIN PS_RE_LS_AST_DST C ON (C.LS_KEY = B.LS_KEY AND C.ASSET_SEQ_NBR = B.ASSET_SEQ_NBR) WHERE A.LEASE_OBLG = '1' AND A.LS_CLASSIFICATION = 'C' AND STL.REGENERATE = 'N' AND STL.TERM_RENT_TYPE IN ('04','09','10') AND AMND.AMND_NBR = ( SELECT MAX(LSA.AMND_NBR) FROM PS_RE_LSA LSA WHERE LSA.LS_KEY = A.LS_KEY AND AMND_STATUS <> '1') |
| # | 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 | AMND_NBR | Number(3,0) | SMALLINT NOT NULL | Amendment Number |
| 3 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 4 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 7 | ASSET_CLASSIFY | Character(1) | VARCHAR2(1) NOT NULL |
Field for Lease Classification
C=Finance O=Operating |
| 8 | END_DT | Date(10) | DATE | End Date |
| 9 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 10 | CF_SEQNO | Number(6,0) | INTEGER NOT NULL | Chartfield Sequence Number |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | ACCR_DEFR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Accrual/ Deferral Amount |
| 13 | ACR_DFR_AMT_BS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Accrual/ Deferral Amount |
| 14 | 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 |
| 15 | PRORATE_LS_EXP | Character(1) | VARCHAR2(1) NOT NULL | Recognize Monthly Expense |
| 16 | RECOGNITION_EXEMPT | Character(1) | VARCHAR2(1) NOT NULL | Exempt from Recognition Flag |