BUSINESS_UNITLEASE_OBLG1=Payables
2=Receivables
Prompt Table: RE_REGION
Prompt Table: RE_OPEX_PL_SRCH
Prompt Table: RE_LS_ADMIN
Prompt Table: RE_PRTFL_MGR
RE_OPEX_LS_SRCH(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.LEASE_OBLG , S.REGION_CD , S.LS_NBR , S.LEASE_NAME , S.LS_ADMIN_OPRID , S.PRTFL_MGR_OPRID FROM PS_RE_LS A , PS_RE_LS_SRCH S WHERE A.LS_KEY = S.LS_KEY AND A.LEASE_STATUS <> %NumToChar(1) AND A.LEASE_STATUS <> %NumToChar(3) AND A.LEASE_STATUS <> %NumToChar(7) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 3 | 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 |
| 4 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Prompt Table: RE_OPEX_PL_SRCH |
| 5 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 6 | LS_ADMIN_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Lease Administrator
Prompt Table: RE_LS_ADMIN |
| 7 | PRTFL_MGR_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Portfolio Manager
Prompt Table: RE_PRTFL_MGR |