GL_AUD_JRNL

(SQL Table)
 Index Back

Journal Audit Logging Table

# 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.
3 JOURNAL_DATE Date(10) DATE NOT NULL Specifies the date the journal was created.
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 JRNL_PROC_NAME Character(2) VARCHAR2(2) NOT NULL Journal process name for audit trail.
01=Journal Entry
02=Mark Journal for Posting
03=Mark Journal for Unposting
04=Journal Suspense Correction
05=Copy Journal
06=Create Standard Entry
07=External Flat File
08=Spreadsheet Import Batch
09=Edit Journal
10=Spreadsheet Import Online
11=Generate Journals
12=Allocation
13=Post Journal
14=Request Ledger Close
15=Process Multi-Currency
16=Consolidation
17=Equitization
18=Reversal Journals
19=BookCode Journals
20=Unpost Journals
21=Amortization Generate Journals
22=Mass Delete Journals
6 FS_EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code
7 AUDLOG_DTTM DateTime(26) TIMESTAMP Date and time that the event occurred.
8 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
12 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text
13 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
14 BATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Batch Action
15 PURGE_OPTN Character(1) VARCHAR2(1) NOT NULL Purge History without Archive