DEPR_METHOD_VW

(SQL View)
 Index Back

Depreciation Method View

Depreciation Method View from XLats for Mass Change prompt

SELECT DISTINCT %Substring(a.fieldvalue, 1, 2) , a.xlatlongname FROM PSXLATITEM a WHERE A.FIELDNAME = 'METHOD' AND A.EFF_STATUS = 'A' AND a.effdt = ( SELECT MAX(b.effdt) FROM PSXLATITEM b WHERE a.fieldvalue = b.fieldvalue AND a.fieldname = b.fieldname )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description