RE_BASIC_LSR (SQL View)	Index Back
Receivable Lease Inquiry View for the Receivable Lease Inquiry report

RE_BASIC_LSR

(SQL View)

Receivable Lease Inquiry

View for the Receivable Lease Inquiry report

SELECT A.BUSINESS_UNIT , A.LS_NBR , A.LEASE_NAME , A.REGION_CD , A.LEASE_STATUS , A.LSE_TYPE_CD , A.PRINCIPAL_ID , L.CUST_ID , A.LEASE_START_DT , A.LEASE_END_DT , A.LEASE_TERM , A.LEASE_SIGNED_DT , A.LS_ADMIN , A.PRTFL_MGR , A.TOT_RENT_AREA , A.PRORATE_PCT , A.CURRENCY_CD , A.MAX_OPEX_INC_PCT , A.MAX_RENT_INC_PCT , L.LS_ADMIN_OPRID , P.PRTFL_MGR_OPRID FROM PS_RE_LS A , PS_RE_LS_SRCH_LA L , PS_RE_LS_SRCH_PM P WHERE A.LS_KEY = L.LS_KEY AND L.LS_KEY = P.LS_KEY AND A.LEASE_OBLG = '2'

# 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_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name

4 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_NAME

5 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

6 LSE_TYPE_CD Character(10) VARCHAR2(10) NOT NULL This field contains the code for the Lease Types
Prompt Table: RE_LS_TYPE_NAME
Set Control Field: LSE_TYPE_CD

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

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

9 LEASE_START_DT Date(10) DATE Lease Start Date

10 LEASE_END_DT Date(10) DATE Lease Termination Date

11 LEASE_TERM Number(6,0) INTEGER NOT NULL Lease Term (Periods)

12 LEASE_SIGNED_DT Date(10) DATE Lease Signed Date

13 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator
Prompt Table: RE_PARTY_LA

14 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager
Prompt Table: RE_PARTY_PM

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

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

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

18 MAX_OPEX_INC_PCT Number(6,2) DECIMAL(5,2) NOT NULL Max Op. Ex. Increase/Year

19 MAX_RENT_INC_PCT Number(6,2) DECIMAL(5,2) NOT NULL Max Lease Rent Escalation

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

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

#	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_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name
4	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_NAME
5	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
6	LSE_TYPE_CD	Character(10)	VARCHAR2(10) NOT NULL	This field contains the code for the Lease Types Prompt Table: RE_LS_TYPE_NAME Set Control Field: LSE_TYPE_CD
7	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant
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: RE_LESSEE_VW Set Control Field: BUSINESS_UNIT
9	LEASE_START_DT	Date(10)	DATE	Lease Start Date
10	LEASE_END_DT	Date(10)	DATE	Lease Termination Date
11	LEASE_TERM	Number(6,0)	INTEGER NOT NULL	Lease Term (Periods)
12	LEASE_SIGNED_DT	Date(10)	DATE	Lease Signed Date
13	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator Prompt Table: RE_PARTY_LA
14	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager Prompt Table: RE_PARTY_PM
15	TOT_RENT_AREA	Number(18,3)	DECIMAL(17,3) NOT NULL	Rentable Area
16	PRORATE_PCT	Number(16,6)	DECIMAL(15,6) NOT NULL	Prorate Percentage
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	MAX_OPEX_INC_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Max Op. Ex. Increase/Year
19	MAX_RENT_INC_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Max Lease Rent Escalation
20	LS_ADMIN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Lease Administrator Prompt Table: RE_LS_ADMIN
21	PRTFL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Prompt Table: RE_PRTFL_MGR