OPRIDPrompt Table: PSOPRDEFN
Prompt Table: RE_BUS_UNIT
Prompt Table: RE_REGION_DMSN
Prompt Table: UNITS_TBL
0=Sub-Lease
1=Payable Lease
2=Receivable Lease
RE_MYLEASES_F(SQL Table) |
Index Back |
|---|---|
My Leases filtersREM Pagelet: My Leases 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 | 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 |
| 5 | LS_STATUS_LIST | Number(5,0) | INTEGER NOT NULL | Lease Status List |
| 6 | SPACE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table: UNITS_TBL |
| 7 | LSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Lease Obligation Types
0=Sub-Lease 1=Payable Lease 2=Receivable Lease |