SETIDJRNL_CODEPrompt Table: JRNL_TYPE_TBL
Prompt Table: SEQ_RANGE_DEFN
A=Automatic Numbering
M=Manually Entered
Default Value: N
JRNL_CODE_TBL(SQL Table) |
Index Back |
|---|---|
Journal Code Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | JRNL_CODE |
Character(8) | VARCHAR2(8) NOT NULL | Journal Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | JRNL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Journal Type
Prompt Table: JRNL_TYPE_TBL |
| 5 | SEQ_RANGE_ID | Character(2) | VARCHAR2(2) NOT NULL |
Sequence Range
Prompt Table: SEQ_RANGE_DEFN |
| 6 | SEQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Document Sequencing Type
A=Automatic Numbering M=Manually Entered |
| 7 | IN_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Row in use flag
Default Value: N |