RE_OPEX_RL_SRCH (SQL View)	Index Back
Lease Search for Opex Search Lease based on Lease Obligation and Lease Status.

RE_OPEX_RL_SRCH

(SQL View)

Lease Search for Opex

Search Lease based on Lease Obligation and Lease Status.

%Sql(RE_OPEX_LS_SQL_S, CUST_ID, %NumToChar(2))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
Prompt Table: RE_LS_SRCH

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: RE_BUS_UNIT

3 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

4 LEASE_END_DT Date(10) DATE Lease Termination Date

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

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

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

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

9 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number

10 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables

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

12 PRORATE_PCT Number(16,6) DECIMAL(15,6) NOT NULL Prorate Percentage

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

14 MIN_FEE Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Fee

15 MAX_FEE Signed Number(28,3) DECIMAL(26,3) NOT NULL Maximum Fee for Lease Category

16 TOT_RENT_AREA Number(18,3) DECIMAL(17,3) NOT NULL Rentable Area

17 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_BI_VW
Set Control Field: BUSINESS_UNIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key Prompt Table: RE_LS_SRCH
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: RE_BUS_UNIT
3	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
4	LEASE_END_DT	Date(10)	DATE	Lease Termination Date
5	LS_ADMIN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Lease Administrator Prompt Table: RE_LS_ADMIN
6	LS_ADMIN_DESC	Character(30)	VARCHAR2(30) NOT NULL	Lease Admin Description
7	PRTFL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Prompt Table: RE_PRTFL_MGR
8	PRTFL_MGR_DESC	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Description
9	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number
10	LEASE_OBLG	Character(1)	VARCHAR2(1) NOT NULL	Lease Obligation either Payables or Receivables Lease 1=Payables 2=Receivables
11	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name
12	PRORATE_PCT	Number(16,6)	DECIMAL(15,6) NOT NULL	Prorate Percentage
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	MIN_FEE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Minimum Fee
15	MAX_FEE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Maximum Fee for Lease Category
16	TOT_RENT_AREA	Number(18,3)	DECIMAL(17,3) NOT NULL	Rentable Area
17	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_BI_VW Set Control Field: BUSINESS_UNIT