| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
EQUITIZATION_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Equitization Group
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
LEDGER_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
Ledger Set
Prompt Table:
LEDGER_SET_CONS
|
| 5 |
JOURNAL_ID_MASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Journal ID Mask
Default Value: NEXT
|
| 6 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Default Value: OPR_DEF_TBL_FS.SOURCE
Prompt Table:
SOURCE_TBL
|
| 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.
Prompt Table:
DOC_TYPE_A_VW
|
| 8 |
REVERSAL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.
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
Default Value: B
|
| 9 |
OWNERSHIP_SET_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Ownership Set effective-dated rows by:
1 - Process Request As of Date
2 - Accounting Perio(s)
1=by Process Request As Of Date
2=by Period End Date(s)
Default Value: 1
|
| 10 |
TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
TimeSpan
Default Value: YTD
Prompt Table:
CONS_TIMESPN_VW
|
| 11 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|