PROCESS_INSTANCEB=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
D=On Date Specified By User
S=Same As Journal Reversal
GL_JRCP_AET(SQL Table) |
Index Back |
|---|---|
Journal Copy & SJE State Rec. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | 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. |
| 4 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 6 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 7 | NEW_JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | For SJE. The ID to be assigned to new standard journals generated by the SJE. |
| 8 | NEW_JOURNAL_DATE | Date(10) | DATE | New Journal Date |
| 9 | NEW_ADB_DATE | Date(10) | DATE | New ADB Date |
| 10 | NEW_REVERSAL_CD | Character(1) | VARCHAR2(1) NOT NULL |
New Reversal Code
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 |
| 11 | NEW_REVERSAL_DATE | Date(10) | DATE | New Reversal Date |
| 12 | REVERSAL_CD_ADB | Character(1) | VARCHAR2(1) NOT NULL |
ADB Reversal Code
D=On Date Specified By User S=Same As Journal Reversal |
| 13 | REVERSAL_DATE_ADB | Date(10) | DATE | ADB Reversal Date |
| 14 | 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". |
| 15 | NEW_LEDGER | Character(10) | VARCHAR2(10) NOT NULL | New Ledger |
| 16 | CUR_EFFDT | Date(10) | DATE | Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header. |
| 17 | REVERSE_SIGNS_SW | Character(1) | VARCHAR2(1) NOT NULL | Reverse Signs |
| 18 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
| 19 | RECALC_BUDGET_DT | Character(1) | VARCHAR2(1) NOT NULL | Recalculate Budget Date |
| 20 | SAVE_INC_JRNL | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |