SJ_JOURNAL_TYPEPrompt Table: SJ_JOURNAL_TYPE
SJ_TEMPLATE_IDPrompt Table: SP_BU_GL_NONVW
0=No Security
1=User ID
2=Role
3=Permission List
Default Value: 0
N=No
Y=Yes
Prompt Table: CF_DSP_TMPL_HDR
N=No
Y=Yes
SJ_JRNL_TMPLT(SQL Table) |
Index Back |
|---|---|
Simplified Journal HeaderRecord stores the Simplified Journal Template details including security setup. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SJ_JOURNAL_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Journal Type
Prompt Table: SJ_JOURNAL_TYPE |
| 2 | SJ_TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Simplified Journal Tempale |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 4 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 5 | CF_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Enable ChartField Securtity
0=No Security 1=User ID 2=Role 3=Permission List Default Value: 0 |
| 6 | APPROVAL_REQ_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field specifies whether the approval is required for the activity.
N=No Y=Yes |
| 7 | USE_ACCTG_TAG | Character(1) | VARCHAR2(1) NOT NULL | Use Accounting Tag |
| 8 | CF_DSP_TEMPLATE | Character(20) | VARCHAR2(20) NOT NULL |
ChartField Display Template name
Prompt Table: CF_DSP_TMPL_HDR |
| 9 | HIDE_JRNL_HEADER | Character(1) | VARCHAR2(1) NOT NULL |
Hide section on Journal Template
N=No Y=Yes |