DEPR_RPT_PD_SUM

(SQL Table)
Index Back

Depreciation Transactions

# 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 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
G=Group Asset
M=Group Member
N=None
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 DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Depreciation Amt
7 DEPR_YTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Year to Date Depreciation
8 DEPR_LTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Life to Date Depreciation
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 SPEC_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Special Depreciation
11 INITIAL_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Initial Depreciation
12 ACCEL_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Accelerated Depreciation
13 INCREASE_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Increased Depreciation
14 STANDARD_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Standard Depreciation
15 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
16 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
17 GRP_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Group Asset Total Cost
18 GRP_SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Group Asset Salvage Value
19 ACCUM_DEPR_ADD Signed Number(28,3) DECIMAL(26,3) NOT NULL Addition Accum Depreciation
20 ACCUM_DEPR_TRF Signed Number(28,3) DECIMAL(26,3) NOT NULL Transfer Accum Depreciation
21 ACCUM_DEPR_RCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Recat Accum Depreciation
22 ACCUM_DEPR_REI Signed Number(28,3) DECIMAL(26,3) NOT NULL Reinstate Accum Depreciation
23 ACCUM_DEPR_RET Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Accum Depreciation
24 COST_ADD Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Addition
25 COST_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Adjustment
26 COST_TRF Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Transfer
27 COST_RCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Recategorization
28 COST_REI Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Reinstatement
29 COST_RET Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Retirement
30 DEPR_PDP Signed Number(28,3) DECIMAL(26,3) NOT NULL Prior Period Depreciation