RE_LS_TXN_NOTE

(SQL Table)
 Index Back

Lease Transaction Notes

Lease Transaction Notes information

  • 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_NOTE_SEQ Number(15,0) DECIMAL(15) NOT NULL Lease Transaction Note ID
    3 LS_TXN_RSN_TYPE Character(1) VARCHAR2(1) NOT NULL Lease transaction Actions (Hold, Unhold, Cancel)
    1=Generated
    2=Hold
    3=Unhold
    4=Cancelled
    5=Approved
    6=Posted
    7=Rejected
    8=Processed
    4 REASONDESCR Character(200) VARCHAR2(200) NOT NULL Rejection Reason
    5 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    6 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.