PeopleSoft 9
Asset Management

Table Name BOOK

Table Description
BOOK
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
IN_SERVICE_DT PSDATE No No
IN_SERVICE_PD smallint No No
IN_SERVICE_FY smallint No No
DEPR_IN_SERVICE_SW char(1) No No
BEGIN_DEPR_DT PSDATE No No
BEGIN_DEPR_PD smallint No No
BEGIN_DEPR_FY smallint No No
BEGIN_FRACTION decimal(15,13) No No
DEPR_CALC_SW char(1) No No
BEGIN_CALC_DT PSDATE No No
BEGIN_CALC_PD smallint No No
BEGIN_CALC_FY smallint No No
CALCULATION_TYPE char(1) No No
LAST_CALC_TYPE char(1) No No
RSV_FRACTION decimal(15,13) No No
RECALC_RSV_SW char(1) No No
SCHED_FRACTION decimal(15,13) No No
YEAR_REM_FRACTION decimal(15,13) No No
DEPR_STATUS char(1) No No
REGULATION char(1) No No
RECOVERY_LIFE decimal(3,1) No No
RECOVERY_SUBTYPE char(2) No No
FUTURE_DEPR_YEARS smallint No No
CONVENTION char(2) No No
LIFE smallint No No
LIFE_REMAINING decimal(15,11) No No
TAX_CLASS_AM char(6) No Yes
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
PROPERTY_CD char(1) No No
PROPERTY_TYPE char(1) No No
SALVAGE_VAL decimal(26,3) No No
SALVAGE_PCT decimal(15,14) No No
TAX_CREDIT_SW char(1) No No
BASIS_RED_TOTAL decimal(26,3) No No
BASIS_RED_RECAP decimal(26,3) No No
SEC179_TAKEN_SW char(1) No No
SEC179_AMT decimal(26,3) 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
GROUP_ASSET_ID char(12) No Yes
UOP_ID char(10) No No
CURRENCY_CD char(3) No No
INCLUDE_CAP_GAINS char(1) No No
UD_METHOD_ID char(5) No No
PERIOD_DEPR_SW char(1) No No
ACCOUNTING_MTHD char(3) No No
DEPR_PASS_LIFE_SW char(1) No No
LISTED_PROP char(1) No No
LISTED_PROP_TYPE char(1) No No
BUS_USE_PERCENT decimal(9,8) No No
CHILD_TK_PARENT_SW char(1) No No
ARCHIVE_ID char(8) No No
SEC_291 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
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
LAST_BK_DTTM_STAMP PSDATETIME No No
LAST_TRANS_DT PSDATE No No
LAST_ACCOUNTING_DT PSDATE No No
IUT_DEPR_STATUS char(1) No No
SUS_DEPR_ACCUM decimal(26,3) No No
SUS_DEPR_YTD decimal(26,3) No No
SUS_DTTM_STAMP PSDATETIME No No
AM_BK_UD_CHAR1 char(10) No No
AM_BK_UD_CHAR2 char(10) No No
AM_BK_UD_DATE1 PSDATE No No
AM_BK_UD_NUM1 decimal(18,3) No No
AM_BK_UD_NUM2 decimal(18,3) No No
DEROGATORY_SW char(1) No No
CCA_50_FLG char(1) No No
CF_SEQNO_LAST int No No
END_DEPR_DT PSDATE No No
END_DEPR_FY smallint No No
END_DEPR_PD smallint No No
RETIRED_SW char(1) No No
RETIRE_CONVENTION char(2) No No
DEPR_BONUS_SW char(1) No No
DEPR_BONUS_PCT decimal(5,2) No No
TOT_OBLIGATION decimal(26,3) No No
IMPAIR_FLG char(1) No No
LAST_IMPAIR_DT PSDATE No No
ADJUST_CONVENTION CHAR(2) No No
LAST_REVALUE_DT PSDATE No No
Index
Name Type Unique Member
PS_BOOK PK Yes
PSABOOK IE1 No
Member(s) of "PS_BOOK" Index
BUSINESS_UNIT
ASSET_ID
BOOK
Member(s) of "PSABOOK" Index
ASSET_ID
BUSINESS_UNIT
BOOK

Published December 16, 2006