PeopleSoft 9
Asset Management

Table Name BOOK_HIST

Table Description
BOOK_HIST
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes No
BOOK_CHANGE_TYPE char(3) No No
TRANS_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
IN_SERVICE_DT PSDATE No No
DEPR_IN_SERVICE_SW char(1) No No
DEPR_CALC_SW char(1) No No
CALCULATION_TYPE char(1) No No
DEPR_STATUS char(1) No No
CONVENTION char(2) No No
LIFE smallint No No
DEPR_PERCENT decimal(9,8) No No
DB_PERCENT decimal(15,14) No No
METHOD char(2) No No
DEPR_SCHED_CD char(10) No No
DEPR_LIMIT_CD char(10) No No
LIFE_END_DT PSDATE No No
DEPR_LOW_LIMIT decimal(26,3) No No
SUSPEND_STATUS char(1) No No
SUSPEND_DT PSDATE No No
RESUME_DT PSDATE No No
SUSPENDED_PERIODS smallint No No
COST_BASIS_LIMIT decimal(26,3) No No
DEPR_AVG_OPTION char(1) No No
UOP_ID char(10) No No
GROUP_ASSET_ID char(12) No No
UD_METHOD_ID char(5) No No
PERIOD_DEPR_SW char(1) No No
DEPR_PASS_LIFE_SW char(1) No No
DEPR_LIMIT_PCT decimal(5,2) No No
MULTI_SHIFT_CODE char(6) No No
MULTI_SHIFT_NBR smallint No No
ACCOUNTING_MTHD char(3) No No
SPECIAL_TERMS char(10) No No
ACCELERATED_TERMS char(10) No No
INITIAL_TERMS char(10) No No
INCREASE_RATE decimal(9,6) No No
SPECIAL_DEPR_SW char(1) No No
LIFE_IN_YRS decimal(5,1) No No
RETIREMENT_DT PSDATE No No
YEAR_CHANGE smallint No No
LOW_VALUE_SW char(1) No No
BUSINESS_TAX_FLG char(1) No No
BUSINESS_TAX_BASIS decimal(26,3) No No
DEROGATORY_SW char(1) No No
CCA_50_FLG char(1) No No
FUTURE_DEPR_YEARS smallint No No
Index
Name Type Unique Member
PS_BOOK_HIST PK Yes
Member(s) of "PS_BOOK_HIST" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP

Published December 16, 2006