GL_JP_BKCD_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 | BOOK_CODE | Character(4) | VARCHAR2(4) NOT NULL | Book Code |
| 8 | LEDGER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Ledger Code |
| 9 | GL_ADJUST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Adjustment Type |
| 10 | 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. |
| 11 | 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. |
| 12 | 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. |
| 13 | 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 |
| 14 | JOURNAL_NUM_ASSIGN | Number(10,0) | DECIMAL(10) NOT NULL | Journal Number - Auto Assigned |
| 15 | NEW_JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | For SJE. The ID to be assigned to new standard journals generated by the SJE. |
| 16 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 17 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 18 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 19 | SQL_SET_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 20 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |