| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 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.
Default Value: NEXT
|
| 3 |
JOURNAL_DATE |
Date(10) |
DATE NOT NULL |
Specifies the date the journal was created.
Default Value: %date
|
| 4 |
SJ_JOURNAL_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Journal Type
Prompt Table:
SJ_JOURNAL_TYPE
|
| 5 |
SJ_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Simplified Journal Tempale
Prompt Table:
SJ_TEMPLATE_DVW
|
| 6 |
JRNL_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost
Default Value: N
|