RE_LS_SRCH3 (SQL View)	Index Back
Lease (ADEHCls) Search by BU Lease Search by BU - Leases in Active, Disputed, Expired, Holdover and Closed states. (Excluding Pending and Canceled Leases)

RE_LS_SRCH3

(SQL View)

Lease (ADEHCls) Search by BU

Lease Search by BU - Leases in Active, Disputed, Expired, Holdover and Closed states. (Excluding Pending and Canceled Leases)

SELECT %subrec(RE_LS_SRCH3,A) FROM PS_RE_LS_SRCH A WHERE A.LEASE_STATUS IN ('2','4','5','6','7')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR
Set Control Field: BUSINESS_UNIT

9 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

10 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant

11 LEASE_END_DT Date(10) DATE Lease Termination Date

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

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

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

15 LS_ADMIN_DESC Character(30) VARCHAR2(30) NOT NULL Lease Admin Description
Prompt Table: RE_LS_AD_NAME

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

17 PRTFL_MGR_DESC Character(30) VARCHAR2(30) NOT NULL Portfolio Manager Description
Prompt Table: RE_PRTFL_NAME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR Set Control Field: BUSINESS_UNIT
9	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
10	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant
11	LEASE_END_DT	Date(10)	DATE	Lease Termination Date
12	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator
13	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager
14	LS_ADMIN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Lease Administrator Prompt Table: RE_LS_ADMIN
15	LS_ADMIN_DESC	Character(30)	VARCHAR2(30) NOT NULL	Lease Admin Description Prompt Table: RE_LS_AD_NAME
16	PRTFL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Prompt Table: RE_PRTFL_MGR
17	PRTFL_MGR_DESC	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Description Prompt Table: RE_PRTFL_NAME