RE_LS_SRCH

(SQL View)
 Index Back

Maintain Lease Update Search

Maintain Lease Update Search

SELECT L.LEASE_OBLG , L.BUSINESS_UNIT , L.LS_NBR , L.LS_KEY , L.LEASE_NAME , L.REGION_CD , L.LEASE_STATUS , L.VENDOR_ID , L.CUST_ID , L.PRINCIPAL_ID , L.LEASE_END_DT , L.LS_ADMIN , L.PRTFL_MGR , L.LS_ADMIN_OPRID , L.LS_ADMIN_DESC , P.PRTFL_MGR_OPRID , P.PRTFL_MGR_DESC , V.ASSET_ID , V.ASSET_TYPE , CASE WHEN A.LS_NBR IS NULL THEN 'R' ELSE 'A' END , L.LS_CLASSIFICATION , L.RECOGNITION_EXEMPT , V.ASSET_CLASSIFY FROM PS_RE_LS_ASST_VW V RIGHT OUTER JOIN PS_RE_LS_LA_DESC L ON L.BUSINESS_UNIT = V.BUSINESS_UNIT AND L.LS_KEY = V.LS_KEY LEFT OUTER JOIN PS_AM_RE_LEASE A ON L.BUSINESS_UNIT = A.BUSINESS_UNIT AND L.LS_KEY = A.LS_KEY AND L.LS_NBR = A.LS_NBR , PS_RE_LS_PM_DESC P WHERE L.LS_KEY = P.LS_KEY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RE_NONVW

3 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
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: RE_LANDLORD_VW
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: RE_LESSEE_VW
Set Control Field: BUSINESS_UNIT

10 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Lessor/Lessee
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

18 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
19 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
20 LEASE_KIND Character(1) VARCHAR2(1) NOT NULL This field tells whether Asset Lease or RE Lease
21 LS_CLASSIFICATION Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
22 RECOGNITION_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from Recognition Flag

Y/N Table Edit

23 ASSET_CLASSIFY Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating