RE_OPEX_PL_SRCH

(SQL View)
 Index Back

Lease Search for Opex

Search Lease based on Lease Obligation and Lease Status.

%Sql(RE_OPEX_LS_SQL_S, VENDOR_ID, %NumToChar(1))

# 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR
Set Control Field: BUSINESS_UNIT