DEPR_MTHJPN_LVW

(SQL View)
 Index Back

Depreciation Method View

Depreciation Method View from XLats for National Tax Report Prompt

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

  • Related Language Record for DEPR_MTH_JPN_VW

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