OPRIDRUN_CNTL_IDCOMP_INSTNC_NBRC=Character
D=Date
A=All
B=Between
E=Equal
Default Value: A
RUN_CNTL_CC1_EO(SQL Table) |
Index Back |
|---|---|
Currency Conversion Run Cntrl1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COMP_INSTNC_NBR |
Number(3,0) | SMALLINT NOT NULL | Selection Component Number |
| 4 | COMP_DATA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Data Type
C=Character D=Date |
| 5 | SELECT_OPER | Character(1) | VARCHAR2(1) NOT NULL |
Select Operator
A=All B=Between E=Equal Default Value: A |
| 6 | CHAR_FROM | Character(35) | VARCHAR2(35) NOT NULL | Character Field - From |
| 7 | CHAR_TO | Character(35) | VARCHAR2(35) NOT NULL | Character Field - To |
| 8 | DATE_FROM | Date(10) | DATE | Date From |
| 9 | DATE_TO | Date(10) | DATE | Previous Period Date To |