JRNL_LN_FED_STG(SQL Table) |
Index Back |
|---|---|
Journal Line Fed |
| # | 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.
Default Value: JRNL_LN.JOURNAL_LINE |
| 6 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Default Value: JRNL_LN.LEDGER Prompt Table: LED_GRP_LED_TBL |
| 7 | FAIN | Character(30) | VARCHAR2(30) NOT NULL | FAIN |
| 8 | PIID | Character(50) | VARCHAR2(50) NOT NULL | PIID |
| 9 | PIID_PARENT | Character(50) | VARCHAR2(50) NOT NULL | PIID_PARENT |
| 10 | URI | Character(70) | VARCHAR2(70) NOT NULL | URI |
| 11 | EXCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Exclude
N=No Y=Yes |
| 12 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |