RE_VAR_ASSET_VW(SQL View) |
Index Back |
|---|---|
Variable Lease expense |
| SELECT A.LS_KEY ,A.PROPERTY_ID ,A.ASSET_SEQ_NBR ,A.BUSINESS_UNIT_AM ,A.ASSET_ID ,A.PRORATION_RATE ,B.TERM_SCHED_ID ,B.AMND_NBR ,B.TERM_ID ,B.SCHED_DATE ,B.CURRENCY_CD ,B.START_DT ,B.END_DT ,%DecMult(A.PRORATION_RATE,B.AMOUNT) ,E.FISCAL_YEAR , E.ACCOUNTING_PERIOD FROM %Table(RE_LS_PPTY) A , %Table(RE_LSTRMSCHD_VW) B , %Table(BUS_UNIT_TBL_AM) C , %Table(BU_BOOK_TBL) D , %Table(CAL_DETP_TBL) E , %Table(SET_CNTRL_REC) F WHERE A.LS_KEY = B.LS_KEY AND C.BUSINESS_UNIT = A.BUSINESS_UNIT_AM AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.LEASE_BOOK = D.BOOK AND E.CALENDAR_ID = D.CAL_DEPR_PD AND E.SETID = F.SETID AND F.RECNAME = 'CAL_DETP_TBL' AND F.SETCNTRLVALUE = C.BUSINESS_UNIT AND B.SCHED_DATE BETWEEN E.BEGIN_DT AND E.END_DT AND EXISTS (SELECT 'X' FROM %TABLE(RE_LSA_TRM) ESC WHERE ESC.LS_KEY = B.LS_KEY AND ESC.AMND_NBR = B.AMND_NBR AND ESC.TERM_ID = B.TERM_ID AND ESC.ESC_TYPE = '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 | PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Property ID |
| 3 | ASSET_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Asset Sequence Number |
| 4 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 5 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 6 | PRORATION_RATE | Number(14,10) | DECIMAL(13,10) NOT NULL | Proration Rate |
| 7 | TERM_SCHED_ID | Number(30,0) | DECIMAL(30) NOT NULL | Lease Term Schedule ID |
| 8 | AMND_NBR | Number(3,0) | SMALLINT NOT NULL | Amendment Number |
| 9 | TERM_ID | Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID |
| 10 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | START_DT | Date(10) | DATE | Start Date |
| 13 | END_DT | Date(10) | DATE | End Date |
| 14 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 15 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 16 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |