DEPR_RT_DET_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	METHOD	Character(2)	VARCHAR2(2) NOT NULL	Method DL=DB w/SL By Limit% DX=Declining Balance w/SL F1=France Derogatory Balance FL=Flat Rate % G1=Germany Staffel Method J1=Japan- Tangible/Declining Bal J2=Japan- Tangible/Strt Line J3=Japan- Intangible/Strt Line J4=Japan - Lease Depreciation J5=Japan-Changes DB to SL J6=Japan - Changes DB to SL 250 J7=Japan-Tangible/Strt Line Rev J8=Japan - Changes DB to SL 200 J9=JPN - Changes 200/250 DB to SL JE=Japan - Extended/Strt Line MN=Manual Depreciation PC=Declining Balance SC=Depreciation Schedule SL=Straight Line SP=Straight Line Percent SY=Sum of the Years UD=User Defined Method UP=Units of Production Prompt Table: DEPR_METHOD_VW
3	EFFDT	Date(10)	DATE	Effective Date
4	LIFE	Number(4,0)	SMALLINT NOT NULL	Useful Life
5	RATE	Number(8,5)	DECIMAL(7,5) NOT NULL	Rate
6	GUAR_RATE	Number(8,5)	DECIMAL(7,5) NOT NULL	Date Incident Initials Description ------- ---------- -------- ------ 07/11/07 1623410001 CGW Added this field for Japan Enhancements for J6 and J7
7	REVISED_RATE	Number(8,5)	DECIMAL(7,5) NOT NULL	Date Incident Initials Description ------- ---------- -------- ------ 07/11/07 1623410001 CGW Added this field for Japan Enhancements for J6 and J7