BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW
STNDRD_JOURNAL_IDSTNDRD_JOURNAL_DTSTNDRD_UNPOST_SEQPrompt Table: JOURNAL_VW
Prompt Table: JOURNAL_DATE_VW
Y/N Table Edit
SJE_STNDRD_JRNL(SQL Table) |
Index Back |
|---|---|
SJE Stndrd Jrnl associativ tblAssociative table between SJE_DETAIL and JRNL_HEADER. It defines which journals were generated by which SJE. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
| 2 | STNDRD_JOURNAL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Standard Journal ID |
| 3 | STNDRD_JOURNAL_DT |
Date(10) | DATE NOT NULL | Standard Journal Date |
| 4 | STNDRD_UNPOST_SEQ |
Number(2,0) | SMALLINT NOT NULL | Standard UnPost Sequence |
| 5 | BUSINESS_UNIT_IU | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Business Unit for which InterUnit activity is being generated. |
| 6 | SJE_ID | Character(10) | VARCHAR2(10) NOT NULL | Standard Journal |
| 7 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | MODEL_JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Model GL Journal ID
Prompt Table: JOURNAL_VW |
| 9 | MODEL_JOURNAL_DATE | Date(10) | DATE NOT NULL |
Model Journal Date
Prompt Table: JOURNAL_DATE_VW |
| 10 | MODEL_UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Model UnPost Sequence |
| 11 | ALLOW_CHNG_JRNL_LN | Character(1) | VARCHAR2(1) NOT NULL |
Allow Lines to be Modified
Y/N Table Edit |
| 12 | RUN_DT | Date(10) | DATE NOT NULL | Run Date |