SETIDDOC_TYPEPrompt Table: DOC_TYPE_TBL
Prompt Table: JRNL_CODE_TBL
Prompt Table: SEQ_RANGE_DEFN
A=Automatic Numbering
M=Manually Entered
Default Value: N
DOC_TYPE_TBL(SQL Table) |
Index Back |
|---|---|
Document Type Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DOC_TYPE |
Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | JRNL_CODE | Character(8) | VARCHAR2(8) NOT NULL |
Journal Code
Prompt Table: JRNL_CODE_TBL |
| 5 | JRNL_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Journal Type |
| 6 | SEQ_RANGE_ID | Character(2) | VARCHAR2(2) NOT NULL |
Sequence Range
Prompt Table: SEQ_RANGE_DEFN |
| 7 | SEQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Document Sequencing Type
A=Automatic Numbering M=Manually Entered |
| 8 | IN_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Row in use flag
Default Value: N |