| # |
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 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 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 |
JOURNAL_ID_MASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Journal ID Mask
Default Value: NEXT
|
| 7 |
JRNL_DT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Journal Date Option
A=Accounting Date on Transaction
BF=Begin Date - From Period
BT=Begin Date - To Period
C=Current Date
EF=End Date - From Period
ET=End Date - To Period
PR=Process Date
PT=Period End - Accounting Date
S=Specify Date
Default Value: C
|
| 8 |
JRNL_DT_ALT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Alternate Journal Date Option
BF=Begin Date - From Period
BT=Begin Date - To Period
EF=End Date - From Period
ET=End Date - To Period
RD=Retain Primary Journal Date
Default Value: RD
|
| 9 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 10 |
STAY_IN_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Stay in Period Date
Y/N Table Edit
Default Value: N
|
| 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.
Prompt Table:
SOURCE_TBL
|
| 12 |
CURR_EFFDT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Effective Date
A=ADB Date
J=Journal Date
Default Value: J
|
| 13 |
JRNL_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Journal Description
|
| 14 |
LINE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
|
| 15 |
TRANS_REF_NUM |
Character(8) |
VARCHAR2(8) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal entry. The journal reference is helpful if you need to trace back to the source of the transaction.
|
| 16 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
|
| 17 |
HOW_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Specified Option
A=Summarize to Account, AltAcct
C=Summarize to All ChartFields
D=Retain Detail
S=Summarize by Selected CF's
Default Value: C
|
| 18 |
ACCOUNT_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Account Specified
1=All Account Values
2=Selected Account Values
3=Selected Tree Nodes
Default Value: 1
|
| 19 |
DEFAULT_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Default Specified
A=Summarize to Account, AltAcct
C=Summarize to All ChartFields
D=Retain Detail
S=Summarize by Selected CF's
Default Value: D
|
| 20 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
TREESETID_VW
|
| 21 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table:
TREE_LEVEL_VW
|
| 22 |
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: N
|
| 23 |
ENTRY_SYNC |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Entry In Sync
Y/N Table Edit
Default Value: N
|
| 24 |
BUS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Generator Group By option
A=Application Business Unit
G=General Ledger Business Unit
Default Value: A
|
| 25 |
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
|