DEPR_RT_DET_VW

(SQL View)
 Index Back

JPN Composite Depreciation


SELECT A.SETID ,A.METHOD ,A.LIFE ,A.RATE FROM PS_DEPR_RT_DET_TBL A WHERE EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_DEPR_RT_DET_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.METHOD = A_ED.METHOD AND A_ED.EFFDT <= %CurrentDateIn) AND SETID=( SELECT DISTINCT Y.SETID FROM PS_SET_CNTRL_GROUP Y , PS_ASSET_COMP_MCJP Z WHERE Y.SETCNTRLVALUE = Z.BUSINESS_UNIT AND Y.REC_GROUP_ID = 'AM_09')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
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
3 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
4 RATE Number(8,5) DECIMAL(7,5) NOT NULL Rate