LTAX_INFO1_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	ACQUISITION_DT	Date(10)	DATE	Acquisition Date
5	IN_SERVICE_DT	Date(10)	DATE	In Service Date
6	NEW_USED_CODE	Character(1)	VARCHAR2(1) NOT NULL	New or Used N=New U=Used
7	LTAX_OFFICE_CODE	Character(5)	VARCHAR2(5) NOT NULL	Local Tax Office
8	ASSET_RETURN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Asset Return Type 1=Structure 2=Machinery 3=Ship 4=Airplane 5=Vehicle 6=Tool
9	EXCEPTION_RATE1	Number(2,0)	SMALLINT NOT NULL	Exception Rate
10	EXCEPTION_RATE2	Number(2,0)	SMALLINT NOT NULL	Exception Rate
11	QUANTITY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Interface
12	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
13	THEORETICAL_NBV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Theoretical Net Book Value
14	ASSESSMENT_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Assessment Value
15	APPLIED_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Applied Amount
16	TAXABLE_STD_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Taxable Standard Amount
17	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
18	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code