| # |
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 |
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.
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
RECDEFN_VW
|
| 5 |
RECNAME_UPDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Record to Update
Prompt Table:
RECDEFN_VW
|
| 6 |
RECNAME_REFREC_KEY |
Character(15) |
VARCHAR2(15) NOT NULL |
Referenced Record Key Record
Prompt Table:
RECDEFN_VW
|
| 7 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
Default Value: ACCOUNTING_DT
Prompt Table:
RECFLDDB_VW
|
| 8 |
FIELDNAME_MON_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Monetary Amount
Prompt Table:
RECFLDDB_VW
|
| 9 |
FIELDNAME_FRN_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Foreign Amount
Prompt Table:
RECFLDDB_VW
|
| 10 |
FIELDNAME_STAT_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Statistical Amount
Prompt Table:
RECFLDDB_VW
|
| 11 |
FIELDNAME_DESCR |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Journal Line Descr
Prompt Table:
RECFLDDB_VW
|
| 12 |
FIELDNAME_JRNL_REF |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Journal Reference
Prompt Table:
RECFLDDB_VW
|
| 13 |
FIELDNAME_OPEN_KEY |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Open Item Key
Prompt Table:
RECFLDDB_VW
|
| 14 |
FIELDNAME_STLMT_DT |
Character(18) |
VARCHAR2(18) NOT NULL |
Settlement Date
Default Value: SETTLEMENT_DT
Prompt Table:
RECFLDDB_VW
|
| 15 |
FIELDNAME_DT_STAMP |
Character(18) |
VARCHAR2(18) NOT NULL |
Last Update DateTime
Prompt Table:
RECFLDDB_VW
|
| 16 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 17 |
BUDGET_AMT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Budget Amount Type
EN=Encumbrance
OT=Other
PR=Pre-Encumbrance
Default Value: OT
|
| 18 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table:
PAGE_NAME_VW
|
| 19 |
DRILL_DOWN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Product Drill Down
N=No Drill Down
Y=Drill Down
Y/N Table Edit
Default Value: Y
|
| 20 |
KK_SKIP |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used in Journal Header record. If its value is '1', the journal will skip commitment control budget checking. Usually, the journal created from Journal Generator for accounting entries which have been budget checked already will have '1' populated in this field.
0=Commitment Control in GL
1=Skip Commitment Control in GL
Default Value: 1
|
| 21 |
JGEN_KK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Type Option
A=All Amount Type
V=Specific Amount Type
Default Value: A
|
| 22 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
|
| 23 |
APPL_JRNL_ID_DFLT |
Character(10) |
VARCHAR2(10) NOT NULL |
Default Journal Template
|