RE_LS_NBR_VW

(SQL View)
Index Back

RE Lease Number View

RE Lease Number View

SELECT BUSINESS_UNIT , LS_NBR , LEASE_OBLG , LEASE_NAME FROM PS_RE_LS

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