OPRIDPrompt Table: OPRID_VW
Prompt Table: SP_BU_CA_NONVW
Prompt Table: CA_AUTONUM_VW
Prompt Table: CA_REGION_CD_VW
OPR_DEF_TBL_CA(SQL Table) |
Index Back |
|---|---|
Operator Defaults - CA4/23/99 Created: Operator defaults table for Contracts Administration. |
| # | 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: OPRID_VW |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 3 | BEG_SEQ | Character(3) | VARCHAR2(3) NOT NULL |
Beginning Sequence
Prompt Table: CA_AUTONUM_VW |
| 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: CA_REGION_CD_VW |