| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
CURR_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Step
|
| 3 |
VERSION_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Version Number
Default Value: 0
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
FROM_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
From Ledger Group
Prompt Table:
SP_LGRP_A_NONVW
|
| 8 |
FROM_LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
From Ledger
Default Value: LED_GRP_LEDP_VW.LEDGER
Prompt Table:
%EDITTABLE4
|
| 9 |
FROM_CURRENCY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
From Currency Type
L=Ledger Base Currency
S=Specify
Default Value: L
|
| 10 |
FROM_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
TARGET_LEDGER_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Target Ledger Group
Prompt Table:
SP_LGRP_T_NONVW
|
| 12 |
TARGET_LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Target Ledger
|
| 13 |
BAL_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Balance of Step
Y/N Table Edit
Default Value: Y
|
| 14 |
GEN_ADJUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Adjustment
Y/N Table Edit
Default Value: Y
|
| 15 |
JOURNAL_ID_MASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Journal ID Mask
Default Value: NEXT
|
| 16 |
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
|
| 17 |
TO_ADJ_PER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
If = 'Y', the result juornal of the process will be in an adjusting period, specificed in the process rule defintion.
Y/N Table Edit
Default Value: N
|
| 18 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
Prompt Table:
GL_ALLADJP_VW
|
| 19 |
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
|
| 20 |
REVERSAL_ADJ_PER |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Period
|
| 21 |
REVERSAL_DATE |
Date(10) |
DATE |
Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
|
| 22 |
RVR_NEXT_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Reverse even if cross years
Y/N Table Edit
Default Value: Y
|
| 23 |
CREATE_JRNL_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Journal Entries
Y/N Table Edit
Default Value: N
|
| 24 |
JRNL_EDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Journal(s)
Y/N Table Edit
Default Value: N
|
| 25 |
EDIT_CHARTFIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit ChartField Values
Y/N Table Edit
Default Value: N
|
| 26 |
JRNL_BGTCHK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid.
Y/N Table Edit
Default Value: N
|
| 27 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
Y/N Table Edit
Default Value: N
|
| 28 |
GL_ADJUST_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Adjustment Type
|
| 29 |
SAVE_INC_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
|
| 30 |
STEP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Processing Step Type
FIN=Final
FST=First
INT=Intermediate
M=Translate Within Ledger
R=Currency Revaluation
T=Currency Translation
|
| 31 |
TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
TimeSpan
Prompt Table:
TIME_SPANS
|
| 32 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_VW
|
| 33 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 34 |
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
|
| 35 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 36 |
UNDO_PREV_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Undo Previous Process
Y/N Table Edit
Default Value: N
|
| 37 |
DONOT_DELETE_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Undo - Do Not Delete Journals
N=Physical Delete
X=Retain/Do Not Delete
Y=Mark as Deleted
Default Value: N
|
| 38 |
DEPLOYED |
Character(1) |
VARCHAR2(1) NOT NULL |
Identify whether an element has been deployed or not.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|