TRANS_TYPE_VW

(SQL View)
 Index Back

AM Transaction Types


SELECT %Substring(A.FIELDVALUE,1,3) , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME='TRANS_TYPE' 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 AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: TRANS_TYPE_LNVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TRANS_TYPE_VW.DESCR