OPRIDPrompt Table: PSOPRDEFN
Prompt Table: RE_BUS_UNIT
Prompt Table: UNITS_TBL
Prompt Table: RE_REGION_DMSN
1=Payables
2=Receivables
Default Value: 1
Prompt Table: RE_LSETYPE_SRCH
Prompt Table: RE_LS_ADMIN
Prompt Table: RE_PRTFL_MGR
RE_LEASEOPT_F(SQL Table) |
Index Back |
|---|---|
Lease Optimization filtersREM Pagelet: Lease Optimization Personalization settings. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 2 | DEFAULTROW | Character(1) | VARCHAR2(1) NOT NULL | Default Row |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: RE_BUS_UNIT |
| 4 | LS_STATUS_LIST | Number(5,0) | INTEGER NOT NULL | Lease Status List |
| 5 | SPACE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table: UNITS_TBL |
| 6 | 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_DMSN |
| 7 | LEASE_OBLG | Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables Default Value: 1 |
| 8 | LSE_TYPE_CD | Character(10) | VARCHAR2(10) NOT NULL |
This field contains the code for the Lease Types
Prompt Table: RE_LSETYPE_SRCH |
| 9 | LS_ADMIN_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Lease Administrator
Prompt Table: RE_LS_ADMIN |
| 10 | PRTFL_MGR_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Portfolio Manager
Prompt Table: RE_PRTFL_MGR |