| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 4 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Default Value: OPR_DEF_TBL_FS.LEDGER
Prompt Table:
SP_BUL_SD_NONVW
|
| 5 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 6 |
ACCOUNTING_PD_FROM |
Number(3,0) |
SMALLINT NOT NULL |
From Accounting Period
Default Value: 1
|
| 7 |
ACCOUNTING_PD_TO |
Number(3,0) |
SMALLINT NOT NULL |
To Accounting Period
Default Value: 12
|
| 8 |
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
|
| 9 |
ADJUST_PERIOD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Adjustment Period
Y/N Table Edit
Default Value: N
|
| 10 |
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.
Prompt Table:
JRNL_ALL_ID_VW
|
| 11 |
ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
Prompt Table:
JRNLGEN_DEFN
|
| 12 |
LEDGER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Code
Prompt Table:
LEDGER_CODE_TBL
|