BOOK_TAX_CR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: BU_BOOK_VW2
4	TAX_CREDIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tax Credit Type E=Energy Tax Credit I=Regular Investment Tax Credit R=Rehabilitation Tax Credit U=User-Defined
5	TAX_CREDIT_CD	Character(6)	VARCHAR2(6) NOT NULL	Tax Credit Code Prompt Table: TAX_CR_VW
6	QUAL_INV_CD	Character(1)	VARCHAR2(1) NOT NULL	Qualified Investment Code A=Accelerated Cost Recovery Sys D=Asset Depreciation Range F=Conventional/Facts& Circumstan G=Guideline M=Modified Accel Cost Recovery
7	BASIS_RED_OPT	Character(1)	VARCHAR2(1) NOT NULL	Basis Reduction Option B=Basis Reduction N=None - No Basis Reduction P=Percentage Rate Reduction Prompt Table: TAX_CR_RED_VW
8	QUAL_INV_RT	Signed Number(11,8)	DECIMAL(9,8) NOT NULL	Qualified Investment Percent
9	QUAL_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Qualified Investment Amount
10	TAX_CR_RT	Signed Number(11,8)	DECIMAL(9,8) NOT NULL	Tax Credit Rate
11	TAX_CR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Credit Amount
12	BASIS_RED_RT	Signed Number(11,8)	DECIMAL(9,8) NOT NULL	Basis Reduction Percentage
13	BASIS_RED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Basis Reduction Amount
14	CREDIT_RECAP_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Credit Recapture Amount
15	BASIS_RED_RECAP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Basis Reduction Recapture
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	TAX_CR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Tax Credit Status Prompt Table: TAX_CR_STAT_VW