BUSINESS_UNITPrompt Table: SP_BU_AM_NONVW
BOOKPrompt Table: SP_BU_BK_NONVW
AM_WC_NBV_CK_VW(SQL View) |
Index Back |
|---|---|
Asset NBV Pending ViewAsset NBV Pending View |
| SELECT DISTINCT D.BUSINESS_UNIT , D.BOOK , D.FISCAL_YEAR , D.ACCOUNTING_PERIOD , C.BEGIN_DT , C.END_DT , E.DESCR FROM PS_BU_BOOK_TBL A , PS_SET_CNTRL_REC B , PS_CAL_DETP_TBL C , PS_DEPR_RPT D , PS_BUS_UNIT_TBL_FS E WHERE B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RECNAME = 'CAL_DETP_TBL' AND B.SETID = C.SETID AND A.CAL_DEPR_PD = C.CALENDAR_ID AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BOOK = A.BOOK AND D.FISCAL_YEAR = C.FISCAL_YEAR AND D.ACCOUNTING_PERIOD = C.ACCOUNTING_PERIOD AND D.FISCAL_YEAR = ( SELECT MAX(D1.FISCAL_YEAR) FROM PS_AM_WC_BKCLSE_VW D1 WHERE D1.BUSINESS_UNIT = D.BUSINESS_UNIT ) AND D.ACCOUNTING_PERIOD = ( SELECT MAX(D1.ACCOUNTING_PERIOD) FROM PS_AM_WC_BKCLSE_VW D1 WHERE D1.BUSINESS_UNIT = D.BUSINESS_UNIT AND D1.FISCAL_YEAR = D.FISCAL_YEAR ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: SP_BU_BK_NONVW |
| 3 | CUR_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Current Fiscal Year |
| 4 | 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. |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |