CCA_YR_END_TBL

#	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	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: SP_BU_BK_NONVW
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	CCA_TAX_CLASS	Character(6)	VARCHAR2(6) NOT NULL	CCA Tax Class Prompt Table: TAX_CLASS_AM
5	CCA_50_FLG	Character(1)	VARCHAR2(1) NOT NULL	g Y/N Table Edit Default Value: Y
6	CCA_INCENTIVE	Character(4)	VARCHAR2(4) NOT NULL	CCA Measure ACCA=Accelerated CCA FEM=Full Expensing Measure NONE=None
7	CCA_ADD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CCA Addition Amount
8	CCA_ADJ_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CCA Adjustment Amount
9	CCA_TRF_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CCA Transfer Amount
10	CCA_CAP_GAINS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CCA Capital Gains
11	CCA_NET_PROCEEDS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CCA Net Proceeds
12	CCA_UCC_BEGIN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	UCC Begin of Year
13	CCA_UCC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Undepreciated Capital Cost
14	CCA_50_RULE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CCA 50% Rule
15	CCA_REDUCED_UCC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reduced Undepr Captial Cost
16	CCA_RATE	Number(7,3)	DECIMAL(6,3) NOT NULL	CCA Rate %
17	CCA_RECAPTURE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Recapture of CCA
18	CCA_TERMINAL_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CCA Terminal Loss
19	CCA_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Capital Cost Allowance
20	CCA_UCC_END	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	UCC End of Year
21	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CURR_CD_AM_VW.CURRENCY_CD