BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW
ASSET_IDBOOKPrompt Table: CATEGORY_TBL
D=Depreciable
N=Non Depreciable
Default Value: D
ASSET_PRFLBK_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , B.BOOK , B.CATEGORY , B.DEPR_STATUS FROM PS_ASSET A , PS_PROFILE_DET_TBL B , PS_BU_BOOK_TBL F , PS_SET_CNTRL_REC D WHERE F.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.SETCNTRLVALUE = F.BUSINESS_UNIT AND D.RECNAME = 'BOOK_DEFN_TBL' AND B.SETID = D.SETID AND B.PROFILE_ID = A.PROFILE_ID AND B.BOOK = F.BOOK AND B.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_PROFILE_DET_TBL I WHERE I.SETID = B.SETID AND I.PROFILE_ID = B.PROFILE_ID AND I.BOOK = B.BOOK AND I.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 4 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table: CATEGORY_TBL |
| 5 | DEPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Depreciation Status
D=Depreciable N=Non Depreciable Default Value: D |