RE_AM_LS_VW

(SQL View)
 Index Back

Asset Lease

Asset Lease and Lease Administration Lease

SELECT RL.BUSINESS_UNIT ,RL.LS_NBR ,RL.LS_KEY ,CASE WHEN AL.LS_NBR IS NULL THEN RL.LEASE_NAME ELSE AL.LEASE_NAME END ,RL.LEASE_STATUS ,RL.LEASE_OBLG ,CASE WHEN AL.LS_NBR IS NULL THEN RL.LEASE_START_DT ELSE AL.LEASE_START_DT END ,CASE WHEN AL.LS_NBR IS NULL THEN RL.LEASE_END_DT ELSE AL.LEASE_END_DT END ,CASE WHEN AL.LS_NBR IS NULL THEN 'R' ELSE 'A' END ,RL.RECOGNITION_EXEMPT FROM PS_RE_LS RL LEFT OUTER JOIN PS_AM_RE_LS_VW AL ON RL.BUSINESS_UNIT = AL.BUSINESS_UNIT AND RL.LS_NBR = AL.LS_NBR AND RL.LS_KEY = AL.LS_KEY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
3 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
4 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease 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 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
7 LEASE_START_DT Date(10) DATE Lease Start Date
8 LEASE_END_DT Date(10) DATE Lease End Date
9 LEASE_KIND Character(1) VARCHAR2(1) NOT NULL This field tells whether Asset Lease or RE Lease
10 RECOGNITION_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from Recognition Flag