AMDEPRTAX_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	OPEN_WDV_VAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Opening Balance
4	ASSET_BLOCK	Character(20)	VARCHAR2(20) NOT NULL	Block of Assets
5	CCA_RATE	Number(7,3)	DECIMAL(6,3) NOT NULL	CCA Rate %
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
8	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
9	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
10	PROCESSING_SEQ	Number(5,0)	INTEGER NOT NULL	Processing Sequence
11	ENTITY_BOOK	Character(10)	VARCHAR2(10) NOT NULL	India Assets Register
12	TAX_CLASS_AM	Character(6)	VARCHAR2(6) NOT NULL	Guideline Tax Class
13	TAX_RPT_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Tax/Reporting Entity
14	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
15	LAST_FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Last Fiscal Year
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	BEGIN_DT	Date(10)	DATE	Begin Date
18	END_DT	Date(10)	DATE	End Date
19	FIFTY_PERC_DT	Date(10)	DATE	Fifty Percent Rule Date
20	FIFTY_PERC_RULE	Signed Number(4,0)	DECIMAL(3) NOT NULL	50% rule, assets in service <
21	TOTAL_COSTS	Number(27,3)	DECIMAL(26,3) NOT NULL	Total Costs
22	TOTAL_PROCEEDS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Proceeds
23	DEPR_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Depreciation Amount
24	DEPR_AMT_50	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Depreciation Amt - 50%
25	CLOSING_WDV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Closing Balance
26	ADD_REG_TAX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Add/Adj (Regular)
27	ADD_50_RULE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Add/Adj (50% Rule)