RE_LS_PEN_REP(SQL View) |
Index Back |
|---|---|
Pending Rec./Payables ReportPending Receivables/Payables Leases Prompt - SQL View: Used as Lease Number prompt of Pending Receivables and Payables Lease Reports. |
| SELECT BUSINESS_UNIT , LEASE_OBLG , LS_NBR , LEASE_NAME , REGION_CD , LEASE_STATUS , LEASE_END_DT , LS_ADMIN , PRTFL_MGR , LS_ADMIN_OPRID , LS_ADMIN_DESC , PRTFL_MGR_OPRID ,PRTFL_MGR_DESC FROM PS_RE_LS_SRCH WHERE LEASE_STATUS NOT IN('1','3') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_RE_NONVW |
| 2 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 3 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 4 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 5 | 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 |
| 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 | LEASE_END_DT | Date(10) | DATE | Lease Termination Date |
| 8 | LS_ADMIN | Number(10,0) | DECIMAL(10) NOT NULL | Lease Administrator |
| 9 | PRTFL_MGR | Number(10,0) | DECIMAL(10) NOT NULL | Portfolio Manager |
| 10 | LS_ADMIN_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Lease Administrator
Prompt Table: RE_LS_ADMIN |
| 11 | LS_ADMIN_DESC | Character(30) | VARCHAR2(30) NOT NULL | Lease Admin Description |
| 12 | PRTFL_MGR_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Portfolio Manager
Prompt Table: RE_PRTFL_MGR |
| 13 | PRTFL_MGR_DESC | Character(30) | VARCHAR2(30) NOT NULL | Portfolio Manager Description |