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

  • Parent record: JRNL_HEADER
  • # 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.