PeopleSoft 9
Asset Management

Table Name BU_BOOK_TBL

Table Description
BU_BOOK_TBL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
BOOK char(10) Yes Yes
REQUIRED_SW char(1) No No
BOOK_TYPE char(1) No No
CURRENCY_CD char(3) No Yes
CAPITALIZATION_MIN decimal(26,3) No No
LEASE_CAP_MIN decimal(26,3) No No
DISTRIBUTION_SW char(1) No No
DISPOSAL_DIST_SW char(1) No No
BUSINESS_UNIT_GL char(5) No No
LEDGER_GROUP char(10) No Yes
LEDGER char(10) No No
BUD_LEDGER_GROUP char(10) No No
BUDGET_LEDGER char(10) No No
ACCT_ENT_TMPL_ID char(10) No Yes
CAL_DEPR_PD char(2) No No
RT_TYPE char(5) No No
GROUP_PROC_SW char(1) No No
CHILD_TK_PARENT_SW char(1) No No
INFL_ADJ_SW char(1) No No
CALC_TYPE_INFL char(1) No No
DAY_CALC char(1) No No
COST_LIMIT_CD char(10) No No
DEROGATORY_SW char(1) No No
BOOK_STATUTORY char(10) No No
ROUND_TYPE char(1) No No
ROUND_RULE_AM char(1) No No
ROUND_PRECISION smallint No No
ROUND_FACTOR decimal(14,7) No No
TRUNCATE_FLAG char(1) No No
STORE_DEPR_BY_PD char(1) No No
ALLOW_AUTO_RET_SW char(1) No No
LOW_VALUE_SW char(1) No No
ONLINE_RPT_SW char(1) No No
TRANSLATE_GL_SW char(1) No No
TRANSLATE_ACCOUNT char(10) No No
BKC_DIST_GRP char(10) No Yes
IMPAIR_FLG char(1) No No
IMP_REVERSE_FLG char(1) No No
IMP_COST_TYPE char(1) No No
REVERSE_COST_TYPE char(1) No No
NEG_DEPR_SW CHAR(1) No No
REVALUE_FLG CHAR(1) No No
REVAL_WRT_OFF_FLG CHAR(1) No No
REVAL_REVERSAL_FLG CHAR(1) No No
REVAL_COST_TYPE CHAR(1) No No
REVAL_WRTOFF_CS_TY CHAR(1) No No
IMP_REVER_CST_TY CHAR(1) No No
REVALUE_METHOD CHAR(1) No No
REVAL_TRANS_CODE CHAR(5) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_BU_BOOK_TBL PK Yes
Member(s) of "PS_BU_BOOK_TBL" Index
BUSINESS_UNIT
BOOK

Published December 16, 2006