BOOK_CUR_VW

(SQL View)
 Index Back

Current Financial Book


SELECT BUSINESS_UNIT , ASSET_ID , BOOK , IN_SERVICE_DT , IN_SERVICE_pd , IN_SERVICE_fy , depr_in_service_sw , Begin_Depr_Dt , Begin_Depr_Pd , Begin_Depr_Fy , depr_calc_sw , Begin_Calc_Dt , Begin_Calc_Pd , Begin_CALC_FY , Calculation_type , Last_calc_type , Rsv_fraction , Recalc_rsv_sw , Sched_fraction , Year_Rem_Fraction , Depr_Status , Regulation , Recovery_life , Recovery_subtype , future_depr_years , Convention , Life , Life_Remaining , Tax_Class_AM , Depr_Percent , DB_Percent , Method , DEPR_SCHED_CD , DEPR_LIMIT_CD , Property_CD , Property_Type , SALVAGE_VAL , SALVAGE_PCT , Tax_credit_sw , Basis_red_total , Basis_red_recap , Sec179_taken_sw , Sec179_amt , Life_end_dt , Depr_low_limit , Suspend_status , Suspend_dt , Resume_dt , Suspended_periods , Cost_basis_limit , Depr_avg_option , Begin_Fraction , UOP_ID , Group_Asset_Id , Currency_cd , Include_Cap_Gains , UD_Method_ID , PERIOD_DEPR_SW , DEPR_PASS_LIFE_SW , LISTED_PROP , LISTED_PROP_TYPE , BUS_USE_PERCENT , CHILD_TK_PARENT_SW , ARCHIVE_ID , SEC_291 , DEPR_LIMIT_PCT , MULTI_SHIFT_CODE , MULTI_SHIFT_NBR , SPECIAL_TERMS , ACCOUNTING_MTHD , ACCELERATED_TERMS , INITIAL_TERMS , INCREASE_RATE , SPECIAL_DEPR_SW , LIFE_IN_YRS , RETIREMENT_DT , LOW_VALUE_SW , YEAR_CHANGE , BUSINESS_TAX_FLG , BUSINESS_TAX_BASIS , LAST_BK_DTTM_STAMP , AM_BK_UD_CHAR1 , AM_BK_UD_CHAR2 , AM_BK_UD_DATE1 , AM_BK_UD_NUM1 , AM_BK_UD_NUM2 , IUT_DEPR_STATUS , LAST_ACCOUNTING_DT , LAST_TRANS_DT , PS_BOOK.DEROGATORY_SW , CCA_50_FLG , SUS_DEPR_ACCUM , SUS_DEPR_YTD , SUS_DTTM_STAMP , CF_SEQNO_LAST , END_DEPR_DT , END_DEPR_FY , END_DEPR_PD , RETIRED_SW , RETIRE_CONVENTION , DEPR_BONUS_SW , DEPR_BONUS_PCT , TOT_OBLIGATION , IMPAIR_FLG , LAST_IMPAIR_DT , ADJUST_CONVENTION , LAST_REVALUE_DT , FULLY_DEPR_SW , BK_CAP_THRSHLD_ID , AM_CAP_STATUS_SW FROM PS_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 IN_SERVICE_DT Date(10) DATE In Service Date
5 IN_SERVICE_PD Number(3,0) SMALLINT NOT NULL In service Period
6 IN_SERVICE_FY Number(4,0) SMALLINT NOT NULL In Service Fiscal Year
7 DEPR_IN_SERVICE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate When In Service
N=No
X=Used to be set to 'Y'
Y=Yes
8 BEGIN_DEPR_DT Date(10) DATE Begin Depr Date
9 BEGIN_DEPR_PD Number(3,0) SMALLINT NOT NULL Begin Depreciation Period
10 BEGIN_DEPR_FY Number(4,0) SMALLINT NOT NULL Begin Depreciation Fiscal Year
11 DEPR_CALC_SW Character(1) VARCHAR2(1) NOT NULL Depreciation Calculation Sw
12 BEGIN_CALC_DT Date(10) DATE Begin Depreciation Calc Date
13 BEGIN_CALC_PD Number(3,0) SMALLINT NOT NULL Begin Calculation Period
14 BEGIN_CALC_FY Number(4,0) SMALLINT NOT NULL Begin Calculation Fiscal Yr
15 CALCULATION_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Type
L=Life-to-Date
R=Remaining Value
16 LAST_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Last Calculation Type
17 RSV_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Reserve Fraction (RSV/Cost)
18 RECALC_RSV_SW Character(1) VARCHAR2(1) NOT NULL Recalculate RSV Fraction (Y/N)
19 SCHED_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Fraction of Schedule Elapsed
20 YEAR_REM_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Year Remaining Fraction
21 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable
22 REGULATION Character(1) VARCHAR2(1) NOT NULL Depreciation Regulation
A=Accelerated Cost Recovery Sys
D=Asset Depreciation Range
F=Conventional/Facts& Circumstan
G=Guideline
M=Modified Accel Cost Recovery
23 RECOVERY_LIFE Number(4,1) DECIMAL(3,1) NOT NULL Recovery Life
24 RECOVERY_SUBTYPE Character(2) VARCHAR2(2) NOT NULL Recovery SubType
LI=Low-Income Housing
PU=Public Utility Property
25 FUTURE_DEPR_YEARS Number(3,0) SMALLINT NOT NULL No of Future Depreciation Year
26 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

Prompt Table: CONV_TBL

27 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
28 LIFE_REMAINING Signed Number(17,11) DECIMAL(15,11) NOT NULL Remaining Life
29 TAX_CLASS_AM Character(6) VARCHAR2(6) NOT NULL Guideline Tax Class
30 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent
31 DB_PERCENT Number(16,14) DECIMAL(15,14) NOT NULL Declining Balance Percent
32 METHOD Character(2) VARCHAR2(2) NOT NULL Method
DL=DB w/SL By Limit%
DX=Declining Balance w/SL
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Tangible/Declining Bal
J2=Japan- Tangible/Strt Line
J3=Japan- Intangible/Strt Line
J4=Japan - Lease Depreciation
J5=Japan-Changes DB to SL
J6=Japan - Changes DB to SL 250
J7=Japan-Tangible/Strt Line Rev
J8=Japan - Changes DB to SL 200
J9=JPN - Changes 200/250 DB to SL
JE=Japan - Extended/Strt Line
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SP=Straight Line Percent
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production
33 DEPR_SCHED_CD Character(10) VARCHAR2(10) NOT NULL Schedule Code
34 DEPR_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Depreciation Limit Code

Prompt Table: DEPR_LIM_TBL

35 PROPERTY_CD Character(1) VARCHAR2(1) NOT NULL Property Code
1=1245 Property
2=1250 Property
36 PROPERTY_TYPE Character(1) VARCHAR2(1) NOT NULL Property Type
P=Personal
R=Non-Residential Real
S=Residential Real
37 SALVAGE_VAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
38 SALVAGE_PCT Number(16,14) DECIMAL(15,14) NOT NULL Salvage Percentage
39 TAX_CREDIT_SW Character(1) VARCHAR2(1) NOT NULL Tax Credit Switch
40 BASIS_RED_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Basis Reduction Total
41 BASIS_RED_RECAP Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Reduction Recapture
42 SEC179_TAKEN_SW Character(1) VARCHAR2(1) NOT NULL Section 179 Taken switch
N=Section 179 Expense not taken
Y=Section 179 Expense Taken
43 SEC179_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Section 179 Taken Amount
44 LIFE_END_DT Date(10) DATE Useful Life End Date
45 DEPR_LOW_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Depr Low Limit Amount
46 SUSPEND_STATUS Character(1) VARCHAR2(1) NOT NULL Suspend Status
N=Depreciation Has Been Resumed
Y=Depreciation Is Suspended
47 SUSPEND_DT Date(10) DATE Suspend Date
48 RESUME_DT Date(10) DATE Resume Date
49 SUSPENDED_PERIODS Number(4,0) SMALLINT NOT NULL Number of Suspended Periods
50 COST_BASIS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Basis Limit
51 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging
52 BEGIN_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Begin Depr Period Fraction
53 UOP_ID Character(10) VARCHAR2(10) NOT NULL Units of Production ID
54 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
55 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
56 INCLUDE_CAP_GAINS Character(1) VARCHAR2(1) NOT NULL CGT Applicable
57 UD_METHOD_ID Character(5) VARCHAR2(5) NOT NULL Method ID

Prompt Table: UD_METHOD

58 PERIOD_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Depreciate By Period
59 DEPR_PASS_LIFE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate Pass Life SW
60 LISTED_PROP Character(1) VARCHAR2(1) NOT NULL Listed Property?
61 LISTED_PROP_TYPE Character(1) VARCHAR2(1) NOT NULL Listed Property Type
A=Automobiles
B=Other Passenger Vehicles
C=Computer and Periph Equipment
E=Entertain and Recr Equipment
O=Other Listed Property
T=Cellular Telephones
62 BUS_USE_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Business Use %
63 CHILD_TK_PARENT_SW Character(1) VARCHAR2(1) NOT NULL Child Inherits Parent's Life
64 ARCHIVE_ID Character(8) VARCHAR2(8) NOT NULL Archive ID
65 SEC_291 Character(1) VARCHAR2(1) NOT NULL Corporation Sec.291
N=Not Corporation Sec291
Y=Corporation Sec291
66 DEPR_LIMIT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Depreciation Limit Percent
67 MULTI_SHIFT_CODE Character(6) VARCHAR2(6) NOT NULL Multi_Shift Code is used to assign and specify the Multi_Shift factor. A Multi_Shift factor is used to indicate the % of increase of annual depreciation during a multi_shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.
68 MULTI_SHIFT_NBR Number(1,0) SMALLINT NOT NULL This field is used to indicate the number of shifts operated within a fiscal year during a multi-shift operation.
69 SPECIAL_TERMS Character(10) VARCHAR2(10) NOT NULL Special Terms
70 ACCOUNTING_MTHD Character(3) VARCHAR2(3) NOT NULL Accounting Method
ALL=Allowance
EXP=Expense
RES=Reserve
71 ACCELERATED_TERMS Character(10) VARCHAR2(10) NOT NULL Accelerated Terms
72 INITIAL_TERMS Character(10) VARCHAR2(10) NOT NULL Initial Terms
73 INCREASE_RATE Signed Number(11,6) DECIMAL(9,6) NOT NULL Increased Rate
74 SPECIAL_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Special Depreciation

Y/N Table Edit

75 LIFE_IN_YRS Number(6,1) DECIMAL(5,1) NOT NULL Life in Years
76 RETIREMENT_DT Date(10) DATE Projected Retirement Date
77 LOW_VALUE_SW Character(1) VARCHAR2(1) NOT NULL Low Value Asset Only
78 YEAR_CHANGE Number(4,0) SMALLINT NOT NULL Year of change
79 BUSINESS_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Business Tax
80 BUSINESS_TAX_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Tax Basis
81 LAST_BK_DTTM_STAMP DateTime(26) TIMESTAMP Last Book Dttm Stamp
82 AM_BK_UD_CHAR1 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field1
83 AM_BK_UD_CHAR2 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field2
84 AM_BK_UD_DATE1 Date(10) DATE User Defined Date Field1
85 AM_BK_UD_NUM1 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field1
86 AM_BK_UD_NUM2 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field2
87 IUT_DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL InterUnit Depreciation Status
H=Hold Depreciation
N=None
88 LAST_ACCOUNTING_DT Date(10) DATE Last Accounting Date
89 LAST_TRANS_DT Date(10) DATE Last Transaction Date
90 DEROGATORY_SW Character(1) VARCHAR2(1) NOT NULL Derogatory Depreciation

Y/N Table Edit

91 CCA_50_FLG Character(1) VARCHAR2(1) NOT NULL g
92 SUS_DEPR_ACCUM Signed Number(28,3) DECIMAL(26,3) NOT NULL Suspended Depreciation Accum
93 SUS_DEPR_YTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Suspend Depreciation YTD
94 SUS_DTTM_STAMP DateTime(26) TIMESTAMP Suspend DateTime Stamp
95 CF_SEQNO_LAST Number(6,0) INTEGER NOT NULL Last Chartfield Sequence Numbe
96 END_DEPR_DT Date(10) DATE End Depreciation Date
97 END_DEPR_FY Number(4,0) SMALLINT NOT NULL End Depreciation Year
98 END_DEPR_PD Number(3,0) SMALLINT NOT NULL End Depreciation Period
99 RETIRED_SW Character(1) VARCHAR2(1) NOT NULL Retired

Y/N Table Edit

100 RETIRE_CONVENTION Character(2) VARCHAR2(2) NOT NULL Retirement Convention
101 DEPR_BONUS_SW Character(3) VARCHAR2(3) NOT NULL Resolution Date Description -------------- ------- ------------------ 753343 03/13/08 New depreciation bonus:Stimulus Act is added.
0=None
1=Section 101 - Federal
2=New York Liberty Zone
3=Section 101 - Local
4=Gulf Opportunity Zone
5=Stimulus Act
6=American Recovery&Reinvestment

Prompt Table: AM_DEPR_BONUS

102 DEPR_BONUS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Depreciation Bonus Percent
103 TOT_OBLIGATION Signed Number(28,3) DECIMAL(26,3) NOT NULL Lease Total Obligation
104 IMPAIR_FLG Character(1) VARCHAR2(1) NOT NULL Impairment Process
105 LAST_IMPAIR_DT Date(10) DATE Last Impairment Date
106 ADJUST_CONVENTION Character(2) VARCHAR2(2) NOT NULL Adjustment Convention
107 LAST_REVALUE_DT Date(10) DATE Last Revaluation Date
108 FULLY_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Retire As Fully Depreciated SW
F=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense
109 BK_CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID
110 AM_CAP_STATUS_SW Character(1) VARCHAR2(1) NOT NULL Physical Book Cost

Y/N Table Edit

Default Value: Y