RE_TXN_GRP_R_VW

(SQL View)
 Index Back

Transaction Group view

LA/Contracts Transaction Type view created from translate values of field TXN_GRP.

SELECT X.FIELDVALUE , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'TXN_GRP' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A' AND X.FIELDVALUE NOT IN ('3', '8', '9', 'A', 'B', 'C', 'D')

  • Related Language Record: RE_TXN_GRP_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
    1=Base Rent
    2=Security Deposit
    3=Straightline Accounting
    4=Operating Expense
    5=Percent Rent
    6=Miscellaneous Rent
    7=Manual Fee
    8=Lease Obligation
    9=Lease Interest Expense
    A=Prior Period Lease Obligation
    B=Prior Period Lease Interest
    C=Rent Expense
    D=Lease Incentive
    2 DESCRIPTION Character(35) VARCHAR2(35) NOT NULL DESCRIPTION