RE_MFT_DTL_ERR

(SQL View)
 Index Back

Lease transaction Error View

Lease Transaction error information from the Interfaces

SELECT A.TXN_GRP_ID , B.LS_TXN_ID , B.LS_TXN_DTL_SEQ , B.SEQ_NBR , B.MESSAGE_SET_NBR , B.MESSAGE_NBR , B.MESSAGE_PARM1 , B.MESSAGE_PARM2 , B.MESSAGE_PARM3 , B.MESSAGE_PARM4 , B.MESSAGE_PARM5 , B.MESSAGE_PARM6 , C.TXN_GRP , C.TXN_ITEM , C.CHG_GRP_CD , C.AMOUNT , C.CURRENCY_CD FROM PS_RE_MFT_TXN A JOIN PS_RE_LS_TXN_ERROR B ON A.LS_TXN_ID = B.LS_TXN_ID JOIN PS_RE_LS_TXN_DTL C ON B.LS_TXN_ID = C.LS_TXN_ID AND B.LS_TXN_DTL_SEQ = C.LS_TXN_DTL_SEQ

  • Parent record: RE_LS_TXN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TXN_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Row Key for Transaction Group
    2 LS_TXN_ID Number(25,0) DECIMAL(25) NOT NULL Lease Transaction ID
    3 LS_TXN_DTL_SEQ Number(15,0) DECIMAL(15) NOT NULL Lease Transaction Detail ID
    4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    7 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
    8 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
    9 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
    10 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
    11 MESSAGE_PARM5 Character(30) VARCHAR2(30) NOT NULL Message Parameter 5
    12 MESSAGE_PARM6 Character(30) VARCHAR2(30) NOT NULL Message Parameter
    13 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
    14 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
    15 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.
    16 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code