RE_LS_NUMBER

(SQL View)
Index Back

Leases Numbers by Key


SELECT %subrec(RE_LS_NUMBER, A) FROM PS_RE_LS A WHERE A.LEASE_STATUS <> '3'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
2 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
3 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 LEASE_STATUS Character(1) VARCHAR2(1) NOT NULL Lease Status
1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred