OPRIDPrompt Table: OPRID_VW
RUN_CNTL_IDJRNL_TYPEJRNL_CODEDOC_TYPEPrompt Table: DOC_TYPE_VW3
RUN_GL_DOC_TP(SQL Table) |
Index Back |
|---|---|
PS/Financials Process Run CtrlPS/Financials Process Run Ctrl |
| # | 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 | JRNL_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Journal Type |
| 4 | JRNL_CODE |
Character(8) | VARCHAR2(8) NOT NULL | Journal Code |
| 5 | 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_VW3 |