TAX_DEPR_VW

(SQL View)
Index Back

Advanced Depreciation

Depreciation Amount View for Tax Book

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , A.FISCAL_YEAR , A.CF_SEQNO , %subrec(CF12_AN_SBR, A) , A.PROJECT_ID , A.DEPTID , A.CATEGORY , SUM(A.DEPR) , A.CURRENCY_CD FROM PS_DEPRECIATION A , PS_BUS_UNIT_TBL_AM B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.BOOK = ( SELECT B.JPN_TAX_BOOK FROM PS_BUS_UNIT_TBL_AM B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT) GROUP BY A.BUSINESS_UNIT, A.ASSET_ID, A.BOOK , A.FISCAL_YEAR, A.CF_SEQNO , %subrec(CF12_AN_SBR, A) , A.PROJECT_ID , A.DEPTID, A.CATEGORY , A.CURRENCY_CD

# 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
5 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
6 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
7 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
8 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
9 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
10 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
11 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
12 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
13 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
14 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
15 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
16 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
17 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
18 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
20 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
21 DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Depreciation Amt
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code