JRNL_DRILL_VW

(SQL View)
Index Back

Journal Line DrillDown View


SELECT a.BUSINESS_UNIT , a.JOURNAL_ID , a.JOURNAL_DATE , a.UNPOST_SEQ , b.JOURNAL_LINE , b.LEDGER , a.JRNL_HDR_STATUS , a.FISCAL_YEAR , a.ACCOUNTING_PERIOD , b.ACCOUNT , b.ALTACCT , B.DEPTID , B.BOOK_CODE , %subrec(cf12_an_sbr, b) , b.project_id , b.CURRENCY_CD , b.STATISTICS_CODE , b.MONETARY_AMOUNT , b.MOVEMENT_FLAG , b.STATISTIC_AMOUNT , b.JRNL_LN_REF , ' ' , b.LINE_DESCR , b.JRNL_LINE_STATUS , b.JOURNAL_LINE_DATE , b.FOREIGN_CURRENCY , b.RT_TYPE , b.FOREIGN_AMOUNT , b.RATE_MULT , b.PROCESS_INSTANCE FROM PS_JRNL_HEADER A , PS_JRNL_LN b WHERE a.business_unit = b.business_unit AND a.journal_id = b.journal_id AND a.journal_date = b.journal_date AND a.unpost_seq = b.unpost_seq

  • 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

    Default Value: BU_LED_P_VW.LEDGER

    Prompt Table: SP_BULEDD_NONVW

    7 JRNL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the processing status of a journal entry.
    D=Deleted
    E=Journal Has Errors
    I=Posting Incomplete
    M=Valid SJE Model -- Do Not Post
    N=No Status - Needs to be Edited
    P=Posted to Ledger(s)
    T=Journal Entry Incomplete
    U=Unposted
    V=Valid Journal - Edits Complete
    X=Cancelled
    Z=Upgrade Journal - Can't Unpost
    8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    9 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    10 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    11 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    13 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
    14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
    15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
    16 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    17 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
    18 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
    19 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
    20 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
    21 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
    24 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    25 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    26 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    28 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_TBL

    29 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
    30 MOVEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
    N=Natural
    R=Reversal

    Default Value: N

    31 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
    32 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
    33 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
    C=Closed Item
    N=Not an Open Item Account
    O=Open Item

    Default Value: N

    34 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.

    Default Value: GL_ACCOUNT_TBL.DESCR

    35 JRNL_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the stage of processing of a journal entry.
    0=OK - No Errors
    1=Uncorrected Error(s)

    Default Value: 0

    36 JOURNAL_LINE_DATE Date(10) DATE Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.

    Default Value: JRNL_HEADER.TRANSACTION_DATE

    37 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

    Prompt Table: FRGN_CURR_VW

    38 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Prompt Table: CUR_RT_TYPE_TBL

    39 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
    40 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate
    41 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance