TRANS_TYPE2_VW

(SQL View)
 Index Back

AM Cost Panel Trans Types


SELECT %Substring(A.FIELDVALUE,1,3) , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A , PS_INSTALLATION_AM b WHERE A.FIELDNAME = 'TRANS_TYPE' AND A.EFF_STATUS = 'A' AND (a.fieldvalue = b.type_add OR a.fieldvalue = b.type_adjustment OR a.fieldvalue = b.type_recategorize OR a.fieldvalue = b.type_transfer) AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE A.FIELDNAME = C.FIELDNAME AND C.EFFDT <= %CurrentDateIn)

# 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_TYPE2_VW.DESCR