OPRIDRUN_CNTL_IDSEQ_NUMSEQ_NUMBERC=Character
D=Date
N=Numeric
REALTIME_JOBSQL(SQL Table) |
Index Back |
|---|---|
Real Time Job Detail |
| # | 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 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | SEQ_NUMBER |
Number(3,0) | SMALLINT NOT NULL | Expense Sequence Number |
| 5 | FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type
C=Character D=Date N=Numeric |
| 6 | FIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 7 | FIELD_VALUE_DATE | Date(10) | DATE | An accounting template field designated to support the substitution of desired dates during accounting b |
| 8 | FIELD_VALUE_NBR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An accounting template field designated to support the substitution of desired monetary amounts during a |