AM_WC_DPRRP2_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 , B.DESCR , B.ASSET_STATUS , 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 , PS_ASSET B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID

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