BOOK_H_DT_TMP

(SQL Table)
Index Back

Financial Book History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: SP_BU_BK_NONVW

4 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
5 BOOK_CHANGE_TYPE Character(3) VARCHAR2(3) NOT NULL Book Change Type
ADD=Add
LFE=Life Ext.
MTH=Method
MUL=Multi Chng
OTH=Other
RCL=Recalc
RES=Resume
RRC=Rate Change
SUS=Suspend
TRF=Transfer
6 TRANS_DT Date(10) DATE Transaction Date
7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
8 IN_SERVICE_DT Date(10) DATE In Service Date
9 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

Default Value: N

10 DEPR_CALC_SW Character(1) VARCHAR2(1) NOT NULL Depreciation Calculation Sw
11 CALCULATION_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Type
L=Life-to-Date
R=Remaining Value

Default Value: R

12 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable
13 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

Prompt Table: CONV_BOOK_VW

14 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
15 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent
16 DB_PERCENT Number(16,14) DECIMAL(15,14) NOT NULL Declining Balance Percent
17 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
18 DEPR_SCHED_CD Character(10) VARCHAR2(10) NOT NULL Schedule Code

Prompt Table: DEPR_SCHED_TBL

19 DEPR_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Depreciation Limit Code

Prompt Table: DEPR_LIM_TBL

20 LIFE_END_DT Date(10) DATE Useful Life End Date
21 DEPR_LOW_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Depr Low Limit Amount
22 SUSPEND_STATUS Character(1) VARCHAR2(1) NOT NULL Suspend Status
N=Depreciation Has Been Resumed
Y=Depreciation Is Suspended
23 SUSPEND_DT Date(10) DATE Suspend Date
24 RESUME_DT Date(10) DATE Resume Date
25 SUSPENDED_PERIODS Number(4,0) SMALLINT NOT NULL Number of Suspended Periods
26 COST_BASIS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Basis Limit
27 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging

Default Value: N

28 UOP_ID Character(10) VARCHAR2(10) NOT NULL Units of Production ID

Prompt Table: UOP_TBL

29 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

Prompt Table: BK_GRP_ASSET_VW

30 UD_METHOD_ID Character(5) VARCHAR2(5) NOT NULL Method ID

Prompt Table: UD_METHOD

31 PERIOD_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Depreciate By Period

Y/N Table Edit

Default Value: N

32 DEPR_PASS_LIFE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate Pass Life SW

Y/N Table Edit

33 DEPR_LIMIT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Depreciation Limit Percent
34 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.

Prompt Table: MULTI_SHIFT_TBL

35 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.
36 ACCOUNTING_MTHD Character(3) VARCHAR2(3) NOT NULL Accounting Method
ALL=Allowance
EXP=Expense
RES=Reserve
37 SPECIAL_TERMS Character(10) VARCHAR2(10) NOT NULL Special Terms

Prompt Table: DEPR_TERMS_TBL

38 ACCELERATED_TERMS Character(10) VARCHAR2(10) NOT NULL Accelerated Terms

Prompt Table: DEPR_TERMS_TBL

39 INITIAL_TERMS Character(10) VARCHAR2(10) NOT NULL Initial Terms

Prompt Table: DEPR_TERMS_TBL

40 INCREASE_RATE Signed Number(11,6) DECIMAL(9,6) NOT NULL Increased Rate
41 SPECIAL_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Special Depreciation

Y/N Table Edit

42 LIFE_IN_YRS Number(6,1) DECIMAL(5,1) NOT NULL Life in Years
43 RETIREMENT_DT Date(10) DATE Projected Retirement Date
44 YEAR_CHANGE Number(4,0) SMALLINT NOT NULL Year of change
45 LOW_VALUE_SW Character(1) VARCHAR2(1) NOT NULL Low Value Asset Only

Y/N Table Edit

Default Value: N

46 BUSINESS_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Business Tax

Default Value: N

47 BUSINESS_TAX_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Business Tax Basis
48 DEROGATORY_SW Character(1) VARCHAR2(1) NOT NULL Derogatory Depreciation

Y/N Table Edit

Default Value: N

49 CCA_50_FLG Character(1) VARCHAR2(1) NOT NULL g
50 FUTURE_DEPR_YEARS Number(3,0) SMALLINT NOT NULL No of Future Depreciation Year