BUSINESS_UNITASSET_IDBOOKFISCAL_YEARDEPR_YEAR2_VW(SQL View) |
Index Back |
|---|---|
Operation Lease Amortizations |
| SELECT DISTINCT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , D.FISCAL_YEAR FROM PS_AM_OPAST_AMT_VW A , PS_BU_BOOK_TBL B , PS_SET_CNTRL_REC C , PS_CAL_DETP_TBL D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BOOK = A.BOOK AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'CAL_DETP_TBL' AND D.CALENDAR_ID = B.CAL_DEPR_PD AND D.SETID = C.SETID AND (D.FISCAL_YEAR = A.FISCAL_YEAR OR %CurrentDateIn BETWEEN D.BEGIN_DT AND D.END_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |