OPRIDPrompt Table: PSOPRDEFN
Prompt Table: RE_BUS_UNIT
Prompt Table: RE_CAL_SRCH
Prompt Table: UNITS_TBL
Prompt Table: RE_REGION_DMSN
Prompt Table: RE_LSETYPE_SRCH
Prompt Table: CURR_CD_EFF_VW
RE_LEASEREV_F(SQL Table) |
Index Back |
|---|---|
Lease Costs filtersREM Pagelet: Leases Costs 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 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table: RE_CAL_SRCH |
| 5 | SPACE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table: UNITS_TBL |
| 6 | PERIOD | Number(3,0) | SMALLINT NOT NULL | Previous Period |
| 7 | TXN_GRP_LIST | Number(5,0) | INTEGER NOT NULL | Charge Group List |
| 8 | 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 |
| 9 | LSE_TYPE_CD | Character(10) | VARCHAR2(10) NOT NULL |
This field contains the code for the Lease Types
Prompt Table: RE_LSETYPE_SRCH |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURR_CD_EFF_VW |