TRANS_TYPE_LNVW

(SQL View)
 Index Back

AM Transaction Types


SELECT %Substring(A.FIELDVALUE,1,3) ,A.LANGUAGE_CD , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A ,PSXLATITEM C WHERE A.FIELDNAME='TRANS_TYPE' AND A.FIELDVALUE = C.FIELDVALUE AND A.FIELDNAME = C.FIELDNAME AND C.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEMLANG B WHERE A.FIELDVALUE = B.FIELDVALUE AND A.FIELDNAME = B.FIELDNAME AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record for TRANS_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Types of Asset Management Transactions
    ACR=Accretion Expense
    ADD=Asset Addition
    ADJ=Asset Cost Adjustment
    BKS=Book Adjustment
    BUD=Budgeted Depreciation
    DPR=Depreciation
    INF=Inflation Adjustment
    LEX=Lease Expense
    LPB=Budgeted Lease Payments
    LPY=Lease Payment
    PDP=Prior Period Depreciation
    PLP=Prior Lease Payment
    RAD=Manual Reserve Adjustment
    RCT=Asset Recategorization
    REI=Asset Reinstatement
    RES=Resume Depreciation
    RET=Asset Retirement
    RRC=Retro rate change for grp ast
    SUS=Suspend Depreciation
    TRF=Asset Transfer
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TRANS_TYPE_VW.DESCR