RE_REFUND_LS (SQL View)	Index Back
Receivables Lease View Receivable Leases with Active or Expired Status.

RE_REFUND_LS

(SQL View)

Receivables Lease View

Receivable Leases with Active or Expired Status.

SELECT DISTINCT BUSINESS_UNIT , LS_NBR , LEASE_NAME FROM PS_RE_LS , PS_RE_REFUND WHERE PS_RE_LS.LS_KEY = PS_RE_REFUND.LS_KEY

# 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_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name

#	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_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name