BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
ASSET_IDBOOKPrompt Table: BOOK
ACTIVITY_SWRETIRE_SWCOST_SUM_VW(SQL View) |
Index Back |
|---|---|
Asset Current Cost by Chartfld |
| SELECT DISTINCT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , SUM(A.COST) , SUM(A.ACTIVITY_SW) , SUM(A.RETIRE_SW) , SUM(A.QUANTITY) , SUM(A.SALVAGE_VALUE) , MIN(A.TRANS_DT) , MAX(A.IU_MAP_KEY) FROM PS_COST A WHERE A.TRANS_DT <= %CurrentDateIn GROUP BY A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK HAVING SUM(A.ACTIVITY_SW) = 0 AND SUM(A.RETIRE_SW) = 0 |
| # | 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 |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: BOOK |
| 4 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 5 | ACTIVITY_SW |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Activity Switch |
| 6 | RETIRE_SW |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Retirement Switch |
| 7 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 8 | SALVAGE_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Salvage Value |
| 9 | MIN_TRANS_DT | Date(10) | DATE | Minimum Trans Date |
| 10 | IU_MAP_KEY | Number(7,0) | INTEGER NOT NULL | InterUnit transfer map key |