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 |