RE_LS_OBLG_NBR

(SQL View)
 Index Back

Lease view by Number and name

View from PS_RE_LS containing lease Number and Name by Business unit and Obligation

SELECT DISTINCT BUSINESS_UNIT , LEASE_OBLG , LS_NBR , LEASE_NAME FROM PS_RE_LS WHERE LEASE_STATUS <> '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
3 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
4 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name