| # |
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 |
CONSOLIDATION_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Consolidation Set
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
LEDGER_TEMPLATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Template
Prompt Table:
LED_TMPLT_TBL
|
| 7 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_SUMLED_NONVW
|
| 8 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Default Value: BUSINESS_UNIT
Prompt Table:
CFS_TMPLT_VW
|
| 9 |
LEDGER_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
Ledger Set
Prompt Table:
LEDGER_SET_CONS
|
| 10 |
JOURNAL_ID_MASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Journal ID Mask
Default Value: NEXT
|
| 11 |
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
|
| 12 |
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
|
| 13 |
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
|
| 14 |
ALL_ELIM_SETS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Elimination Sets Apply
Default Value: N
|
| 15 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 16 |
MINORITY_INT_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Minority Interest Set
Prompt Table:
MINOR_SET_TBL
|
| 17 |
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
|
| 18 |
TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
TimeSpan
Default Value: BAL
Prompt Table:
CONS_TIMESPN_VW
|
| 19 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|