AM_NBVDT_PD_VW

(SQL View)
Index Back

Cost Detail by FY/PD


SELECT BUSINESS_UNIT , BOOK , CATEGORY , FISCAL_YEAR , ACCOUNTING_PERIOD , SUM(COST) , SUM(DEPR) , SUM(DEPR_YTD) , SUM(DEPR_LTD) , SUM(NBV) , SUM(COST_ADD ) , SUM(COST_ADJ ) , SUM(COST_TRF ) , SUM(COST_RCT ) , SUM(COST_REI ) , SUM(COST_RET ) , SUM(COST1) , CURRENCY_CD FROM PS_AM_NBVDT_PDI_VW GROUP BY BUSINESS_UNIT , BOOK , CATEGORY ,FISCAL_YEAR ,ACCOUNTING_PERIOD , CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
3 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
5 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.
6 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
7 DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Depreciation Amt
8 DEPR_YTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Year to Date Depreciation
9 DEPR_LTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Life to Date Depreciation
10 NBV Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value
11 COST_ADD Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Addition
12 COST_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Adjustment
13 COST_TRF Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Transfer
14 COST_RCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Recategorization
15 COST_REI Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Reinstatement
16 COST_RET Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Retirement
17 COST1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code