RE_LS_RECEVBLS (SQL View)	Index Back
Receivable Leases Prompt Receivable Leases Prompt - SQL View: Used as prompt to display the list of Receivable Leases in Sales Reports Search Page.

RE_LS_RECEVBLS

(SQL View)

Receivable Leases Prompt

Receivable Leases Prompt - SQL View: Used as prompt to display the list of Receivable Leases in Sales Reports Search Page.

SELECT A.BUSINESS_UNIT ,A.LEASE_OBLG , A.LS_NBR , A.LS_KEY , A.LEASE_NAME , A.REGION_CD , A.LEASE_STATUS , A.CUST_ID , A.LEASE_END_DT , B.CALENDAR_ID , A.LS_ADMIN , A.PRTFL_MGR , A.LS_ADMIN_OPRID , A.LS_ADMIN_DESC , A.PRTFL_MGR_OPRID ,A.PRTFL_MGR_DESC FROM PS_RE_LS_SRCH A , PS_RE_LS B WHERE B.LEASE_STATUS NOT IN ('1','3') AND A.LS_KEY = B.LS_KEY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_RE_NONVW

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 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key

5 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name

6 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: RE_REGION

7 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

8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_SLD_VW
Set Control Field: BUSINESS_UNIT

9 LEASE_END_DT Date(10) DATE Lease Termination Date

10 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

11 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator

12 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager

13 LS_ADMIN_OPRID Character(30) VARCHAR2(30) NOT NULL Lease Administrator
Prompt Table: RE_LS_ADMIN

14 LS_ADMIN_DESC Character(30) VARCHAR2(30) NOT NULL Lease Admin Description

15 PRTFL_MGR_OPRID Character(30) VARCHAR2(30) NOT NULL Portfolio Manager
Prompt Table: RE_PRTFL_MGR

16 PRTFL_MGR_DESC Character(30) VARCHAR2(30) NOT NULL Portfolio Manager Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_RE_NONVW
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	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
5	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name
6	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Prompt Table: RE_REGION
7	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
8	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_SLD_VW Set Control Field: BUSINESS_UNIT
9	LEASE_END_DT	Date(10)	DATE	Lease Termination Date
10	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
11	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator
12	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager
13	LS_ADMIN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Lease Administrator Prompt Table: RE_LS_ADMIN
14	LS_ADMIN_DESC	Character(30)	VARCHAR2(30) NOT NULL	Lease Admin Description
15	PRTFL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Prompt Table: RE_PRTFL_MGR
16	PRTFL_MGR_DESC	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Description