DEPR_MTH_JPN_VW

(SQL View)
 Index Back

Depreciation Method View

Depreciation Method View from XLats for National Tax Report Prompt

SELECT DISTINCT %Substring(A.FIELDVALUE,1, 2) , A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'METHOD' AND A.EFF_STATUS = 'A' AND A.FIELDVALUE IN ('J1','J2')

  • Related Language Record: DEPR_MTHJPN_LVW

    • # 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 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name