BUSINESS_UNITJOURNAL_IDJOURNAL_DATEB=Beginning of Next Period
D=On Date Specified By User
E=End of Next Period
N=Do Not Generate Reversal
R=Created by Reversal Process
U=Adjustment Period
X=Next Day
JRNL_COPY_VW(SQL View) |
Index Back |
|---|---|
Journal Copy View |
| SELECT BUSINESS_UNIT , JOURNAL_ID , JOURNAL_DATE , ADB_DATE , LEDGER_GROUP , LEDGER , REVERSAL_CD FROM PS_JRNL_HEADER |
| # | 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 NOT NULL | Specifies the date the journal was created. |
| 4 | ADB_DATE | Date(10) | DATE | Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE). |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 6 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 7 | REVERSAL_CD | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.
B=Beginning of Next Period D=On Date Specified By User E=End of Next Period N=Do Not Generate Reversal R=Created by Reversal Process U=Adjustment Period X=Next Day |