RE_LS_DTL_ERROR

(SQL View)
 Index Back

Lease transaction Error View

Lease Transaction error information from the Interfaces

SELECT A.LS_TXN_ID , A.LS_TXN_DTL_SEQ , A.SEQ_NBR , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.MESSAGE_PARM1 , A.MESSAGE_PARM2 , A.MESSAGE_PARM3 , A.MESSAGE_PARM4 , A.MESSAGE_PARM5 , A.MESSAGE_PARM6 , B.TXN_GRP , B.TXN_ITEM , B.CHG_GRP_CD , B.AMOUNT , B.CURRENCY_CD FROM PS_RE_LS_TXN_ERROR A , PS_RE_LS_TXN_DTL B WHERE %Join(COMMON_KEYS, RE_LS_TXN_ERROR A, RE_LS_TXN_DTL B )

  • Parent record: RE_LS_TXN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LS_TXN_ID Number(25,0) DECIMAL(25) NOT NULL Lease Transaction ID
    2 LS_TXN_DTL_SEQ Number(15,0) DECIMAL(15) NOT NULL Lease Transaction Detail ID
    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    6 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
    7 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
    8 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
    9 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
    10 MESSAGE_PARM5 Character(30) VARCHAR2(30) NOT NULL Message Parameter 5
    11 MESSAGE_PARM6 Character(30) VARCHAR2(30) NOT NULL Message Parameter
    12 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
    13 TXN_ITEM Character(2) VARCHAR2(2) NOT NULL Transaction Item
    01=Base Rent
    02=Security Deposit Issue
    03=Security Deposit Deductions
    04=Security Deposit Interest
    05=Security Deposit Refund
    06=Receivables St. Line Accrual
    07=Receivables St. Line Deferral
    08=Receivables St.Line Adjustment
    09=Operating Expense
    10=Percent Rent
    11=Miscellaneous Rent
    12=Manual Fee
    13=Payables St. Line Accrual
    14=Payables St. Line Deferral
    15=Payables St. Line Adjustment
    16=Lease Obligation
    17=Interest Expense
    18=Prior Period Obligation
    19=Prior Period Interest Expense
    20=Rent Expense
    21=Lease Incentive
    14 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.
    15 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code