GL_JP_RVRSL_AET(SQL Table) |
Index Back |
|---|---|
GL JP: Process state recordThe following state record is used in the GL Journal Post Process (GL_JP). This state record contains all of the high level information (Statuses, Number of Journals Processed...). |
| # | 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 | REVERSAL_DATE | Date(10) | DATE | Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date. |
| 5 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 6 | 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". |
| 7 | 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. |
| 8 | DOC_SEQ_DATE | Date(10) | DATE | Specifies the date that a document sequence number is assigned to a document or the date the document was created. |
| 9 | DOC_SEQ_NBR | Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
| 10 | DOC_SEQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status |
| 11 | COMMITMENT_CNTL_GL | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on GL |
| 12 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 13 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 14 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 15 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 16 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 17 | SQLROWS | Number(5,0) | INTEGER NOT NULL | SQL Rows |
| 18 | SQL_SET_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 19 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 20 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 21 | JOURNAL_LOCKED | Character(1) | VARCHAR2(1) NOT NULL | Journal Locked for Change |
| 22 | ADJUSTING_ENTRY | Character(1) | VARCHAR2(1) NOT NULL |
Adjusting Entry
C=Fiscal Year Close N=Non-Adjusting Entry Y=Adjusting Entry |