RE_LS_DTL_OBLG

(SQL View)
 Index Back

Lease Details by OBLG,BU,CCY

Lease Details prompt by Obligation, BU, Ccy, and Lease Key

SELECT A.LEASE_OBLG , A.BUSINESS_UNIT , A.CURRENCY_CD , A.LS_KEY , A.LS_NBR , A.LEASE_NAME , A.LEASE_STATUS , A.LEASE_START_DT , A.LEASE_END_DT , A.LSE_TYPE_CD , A.REGION_CD FROM PS_RE_LS A WHERE A.LEASE_STATUS IN ('2', '5', '6')

# 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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

4 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
5 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
6 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
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 LEASE_START_DT Date(10) DATE Lease Start Date
9 LEASE_END_DT Date(10) DATE Lease End Date
10 LSE_TYPE_CD Character(10) VARCHAR2(10) NOT NULL This field contains the code for the Lease Types
11 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