| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
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
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
P=Period End - Transaction Date
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 |
Alt. Journal Date
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
|
| 9 |
JOURNAL_DATE |
Date(10) |
DATE |
Journal Date
|
| 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 |
Source
|
| 12 |
JRNL_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Journal Header Description
|
| 13 |
LINE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Journal Line Description
|
| 14 |
TRANS_REF_NUM |
Character(8) |
VARCHAR2(8) NOT NULL |
Reference Number
|
| 15 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Line Reference
|
| 16 |
HOW_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Specified Option
A=Summarize to Account Level
C=Summarize to ChartField Level
D=Retain Detail
S=Summarize by Selected CF's
Default Value: C
|
| 17 |
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
|
| 18 |
DEFAULT_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Default Specified
A=Summarize to Account Level
C=Summarize to ChartField Level
D=Retain Detail
S=Summarize by Selected CF's
Default Value: D
|
| 19 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 20 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
|
| 21 |
REVERSAL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Code
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
Default Value: N
|
| 22 |
ENTRY_SYNC |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Entry In Sync
Y/N Table Edit
Default Value: N
|
| 23 |
BUS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Business_Unit_Option
A=Application Business Unit
G=General Ledger Business Unit
|
| 24 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Type
L=Letter
N=Notice
O=Other
Q=Request
R=Report
|