AM_WC_DPRRPT_VW

(SQL View)
 Index Back

Depreciation Report View

Used in WorkCenter Pivot Grid. Note: Keep in Synch with ARO_DEPR_RPT record.

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.CF_SEQNO , A.GROUP_ASSET_FLAG , %subrec(CF12_AN_SBR, A) , %subrec(AM_CF1_N_SBR, A) , A.PROJECT_ID , A.DEPTID , A.CATEGORY , A.COST_TYPE , A.ACTIVITY_SW , A.RETIRE_SW , A.DEPR , A.DEPR_YTD , A.DEPR_LTD , A.CURRENCY_CD , A.MANUAL_DEPR_TYPE , A.SPEC_DEPR , A.INITIAL_DEPR , A.ACCEL_DEPR , A.INCREASE_DEPR , A.STANDARD_DEPR , A.COST , A.SALVAGE_VALUE , A.GRP_COST , A.GRP_SALVAGE_VALUE , A.ACCUM_DEPR_ADD , A.ACCUM_DEPR_TRF , A.ACCUM_DEPR_RCT , A.ACCUM_DEPR_REI , A.ACCUM_DEPR_RET , A.COST_ADD , A.COST_ADJ , A.COST_TRF , A.COST_RCT , A.COST_REI , A.COST_RET , A.DEPR_PDP , A.ACCOUNT_AD , A.ACCOUNT_FA , A.LOCATION , A.PROFILE_ID , A.ALTACCT_AD , A.ALTACCT_FA FROM PS_DEPR_RPT A WHERE (EXISTS ( SELECT B.BOOK FROM PS_BU_BOOK_TBL B , PS_LED_GRP_LED_TBL C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BOOK = B.BOOK AND B.DISTRIBUTION_SW = 'Y' AND B.BUSINESS_UNIT = D.SETCNTRLVALUE AND D.RECNAME = 'LED_GRP_LED_TBL' AND D.SETID = C.SETID AND B.LEDGER_GROUP = C.LEDGER_GROUP AND B.LEDGER = C.LEDGER AND C.PRIMARY_LEDGER = 'Y' AND ((B.BKC_DIST_GRP = ' ') OR (B.BKC_DIST_GRP <> ' ' AND B.BKC_DIST_GRP = ( SELECT MIN(B2.BKC_DIST_GRP) FROM PS_BU_BOOK_TBL B2 WHERE B2.BUSINESS_UNIT = B.BUSINESS_UNIT))) ) OR EXISTS ( SELECT F.DEFAULT_BOOK FROM PS_BUS_UNIT_TBL_AM F WHERE A.BUSINESS_UNIT = F.BUSINESS_UNIT AND A.BOOK = F.DEFAULT_BOOK AND F.DEFAULT_BOOK <> ' '))

# 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 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 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
7 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
G=Group Asset
M=Group Member
N=None
8 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
9 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
10 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
11 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
12 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
13 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
14 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
15 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
16 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
17 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
18 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
19 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
20 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
21 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
22 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
23 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
24 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
25 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
26 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
27 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
28 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
29 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
30 ACTIVITY_SW Signed Number(2,0) DECIMAL(1) NOT NULL Activity Switch
31 RETIRE_SW Signed Number(2,0) DECIMAL(1) NOT NULL Retirement Switch
32 DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Depreciation Amt
33 DEPR_YTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Year to Date Depreciation
34 DEPR_LTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Life to Date Depreciation
35 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
36 MANUAL_DEPR_TYPE Character(1) VARCHAR2(1) NOT NULL Manual Depreciation Type
A=Appreciation
F=Write-off for Extraord. Fading
M=Manual Depreciation
N=Non-scheduled Depreciation
P=Partial Value Write-off
37 SPEC_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Special Depreciation
38 INITIAL_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Initial Depreciation
39 ACCEL_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Accelerated Depreciation
40 INCREASE_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Increased Depreciation
41 STANDARD_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Standard Depreciation
42 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
43 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
44 GRP_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Group Asset Total Cost
45 GRP_SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Group Asset Salvage Value
46 ACCUM_DEPR_ADD Signed Number(28,3) DECIMAL(26,3) NOT NULL Addition Accum Depreciation
47 ACCUM_DEPR_TRF Signed Number(28,3) DECIMAL(26,3) NOT NULL Transfer Accum Depreciation
48 ACCUM_DEPR_RCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Recat Accum Depreciation
49 ACCUM_DEPR_REI Signed Number(28,3) DECIMAL(26,3) NOT NULL Reinstate Accum Depreciation
50 ACCUM_DEPR_RET Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Accum Depreciation
51 COST_ADD Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Addition
52 COST_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Adjustment
53 COST_TRF Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Transfer
54 COST_RCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Recategorization
55 COST_REI Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Reinstatement
56 COST_RET Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Retirement
57 DEPR_PDP Signed Number(28,3) DECIMAL(26,3) NOT NULL Prior Period Depreciation
58 ACCOUNT_AD Character(10) VARCHAR2(10) NOT NULL Account - Accum Depr
59 ACCOUNT_FA Character(10) VARCHAR2(10) NOT NULL Account - Fixed Asset
60 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
61 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
62 ALTACCT_AD Character(10) VARCHAR2(10) NOT NULL Accum depr Alternate Account
63 ALTACCT_FA Character(10) VARCHAR2(10) NOT NULL Fixed Asset - Alternate Account