PROCESS_INSTANCESETIDPrompt Table: SP_SETID_NONVW
EOEP_RULE_IDEOEP_COND_SEQEOEP_VAL_SEQOMEP_CVAL_TMP(SQL Table) |
Index Back |
|---|---|
Condition ValuesTemporary usage record for Condition Values |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 3 | EOEP_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 4 | EOEP_COND_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Price Condition Sequence |
| 5 | EOEP_VAL_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Condition value sequence |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | EOEP_VAL_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Value field name |
| 8 | EOEP_CHAR_VAL | Character(128) | VARCHAR2(128) NOT NULL | Character value field |
| 9 | EOEP_NUM_VAL | Number(20,0) | DECIMAL(20) NOT NULL | Numeric value field |