PeopleSoft 9
Asset Management

Table Name BOOK_TAX_CR

Table Description
BOOK_TAX_CR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
TAX_CREDIT_TYPE char(1) Yes No
TAX_CREDIT_CD char(6) Yes No
QUAL_INV_CD char(1) No No
BASIS_RED_OPT char(1) No No
QUAL_INV_RT decimal(9,8) No No
QUAL_INV_AMT decimal(26,3) No No
TAX_CR_RT decimal(9,8) No No
TAX_CR_AMT decimal(26,3) No No
BASIS_RED_RT decimal(9,8) No No
BASIS_RED_AMT decimal(26,3) No No
CREDIT_RECAP_AMT decimal(26,3) No No
BASIS_RED_RECAP decimal(26,3) No No
CURRENCY_CD char(3) No No
TAX_CR_STATUS char(1) No No
Index
Name Type Unique Member
PS_BOOK_TAX_CR PK Yes
Member(s) of "PS_BOOK_TAX_CR" Index
BUSINESS_UNIT
ASSET_ID
BOOK
TAX_CREDIT_TYPE
TAX_CREDIT_CD

Published December 16, 2006