GL_JRNL_DEL

(SQL Table)
Index Back

Deleted Journals

Deleted Journals for PTSF index update

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 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 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.
6 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time