OPRIDPrompt Table: OPRID_VW
RUN_CNTL_IDREQUEST_NBRDefault Value: 9999
FIELD_GROUPFIELDNAMEC=Character
D=Date
N=Numeric
JRNLGEN_ADD_COL(SQL Table) |
Index Back |
|---|---|
Journal Generator Request |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | REQUEST_NBR |
Number(4,0) | SMALLINT NOT NULL |
Request Number
Default Value: 9999 |
| 4 | FIELD_GROUP |
Number(3,0) | SMALLINT NOT NULL | Field Group |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type
C=Character D=Date N=Numeric |
| 7 | DETAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Detail Flag |
| 8 | FLDCHAR_FROM | Character(40) | VARCHAR2(40) NOT NULL | Field from value |
| 9 | FLDCHAR_TO | Character(40) | VARCHAR2(40) NOT NULL | Field to value |
| 10 | FLDNBR_FROM | Number(20,0) | DECIMAL(20) NOT NULL | Field from value |
| 11 | FLDNBR_TO | Number(20,0) | DECIMAL(20) NOT NULL | Field to value |
| 12 | DATE_FROM | Date(10) | DATE | Date From |
| 13 | DATE_TO | Date(10) | DATE | Date To |