JLN_IU_ANCH_VW(SQL View) |
Index Back |
---|---|
Journal Line Data |
SELECT BUSINESS_UNIT , JOURNAL_ID , JOURNAL_DATE , UNPOST_SEQ , MIN(JOURNAL_LINE) , LEDGER , IU_TRAN_GRP_NBR FROM PS_JRNL_LN WHERE IU_ANCHOR_FLG='Y' AND IU_TRAN_GRP_NBR>0 GROUP BY BUSINESS_UNIT , JOURNAL_ID , JOURNAL_DATE , UNPOST_SEQ, LEDGER ,IU_TRAN_GRP_NBR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
2 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
Default Value: JRNL_HEADER.JOURNAL_ID |
3 | JOURNAL_DATE | Date(10) | DATE NOT NULL |
Specifies the date the journal was created.
Default Value: JRNL_HEADER.JOURNAL_DATE |
4 | UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
5 | JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
6 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: LED_GRP_LED_TBL |
7 | IU_TRAN_GRP_NBR | Number(4,0) | SMALLINT NOT NULL | To support multiple InterUnit or IntraUnit groups in a single journal. |