RE_ACTV_HOLD_LS (SQL View)	Index Back
Active/Holdover Lease Prompt Active/Holdover Lease Prompt - SQL View: Used as prompt to display the list of Leases which are in "Active" or "Holdover" with Lease Obligation as an alternate search key.

RE_ACTV_HOLD_LS

(SQL View)

Active/Holdover Lease Prompt

Active/Holdover Lease Prompt - SQL View: Used as prompt to display the list of Leases which are in "Active" or "Holdover" with Lease Obligation as an alternate search key.

SELECT BUSINESS_UNIT , LS_NBR , LEASE_OBLG , LS_KEY , LEASE_NAME , REGION_CD , LEASE_STATUS , CUST_ID , LEASE_END_DT , LS_ADMIN , PRTFL_MGR , LS_ADMIN_OPRID , LS_ADMIN_DESC , PRTFL_MGR_OPRID ,PRTFL_MGR_DESC FROM PS_RE_LS_SRCH WHERE LEASE_STATUS IN ('2' , '6')

# 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 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 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 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator

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

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

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

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

15 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	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	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	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator
11	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager
12	LS_ADMIN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Lease Administrator Prompt Table: RE_LS_ADMIN
13	LS_ADMIN_DESC	Character(30)	VARCHAR2(30) NOT NULL	Lease Admin Description
14	PRTFL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Prompt Table: RE_PRTFL_MGR
15	PRTFL_MGR_DESC	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Description