LS_KEY_RELATEDPrompt Table: RE_LS_NUMBER
1=Payables
2=Receivables
1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred
RE_RELTD_LS_VW(SQL View) |
Index Back |
|---|---|
Related Lease ViewRelated Lease View |
| SELECT A.LS_KEY ,A.BUSINESS_UNIT , A.LS_NBR ,A.LEASE_NAME ,A.LEASE_OBLG ,A.LEASE_STATUS ,CASE WHEN C.ADDRESS1 != ' ' THEN C.ADDRESS1 %Concat ',' %Concat C.CITY END ,A.LEASE_START_DT ,A.LEASE_END_DT FROM PS_RE_LS A LEFT OUTER JOIN PS_RE_LS_PPTY B ON A.LS_KEY = B.LS_KEY LEFT OUTER JOIN PS_RE_PPTY_ADDRESS C ON B.PROPERTY_ID = C.PROPERTY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY_RELATED |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key Related |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Prompt Table: RE_LS_NUMBER |
| 4 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 5 | LEASE_OBLG | Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 6 | 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 |
| 7 | ADDRESS_150 | Character(150) | VARCHAR2(150) NOT NULL | Address |
| 8 | LEASE_START_DT | Date(10) | DATE | Lease Start Date |
| 9 | LEASE_END_DT | Date(10) | DATE | Lease End Date |