| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SJ_JOURNAL_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Journal Type
|
| 2 |
SJ_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Simplified Journal Tempale
|
| 3 |
SEQ_NBR_3 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 5 |
ADJUSTING_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry
Default Value: N
|
| 6 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_BULGRP_NONVW
|
| 7 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
LED_GRP_LED_TBL
|
| 8 |
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
|
| 9 |
AUTO_GEN_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) journal lines should be automatically generated for other ledgers in a ledger group. This option is automatically on if the Keep Ledgers in Sync option is on for the specified ledger group. You can select the Auto Generate Lines option for a multibook ledger group specified on a journal header.
Default Value: N
|
| 10 |
ADB_DATE |
Date(10) |
DATE |
Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE).
|
| 11 |
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
|
| 12 |
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.
|
| 13 |
REVERSAL_ADJ_PER |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Period
Prompt Table:
CAL_ADJP_TBL
|
| 14 |
REVERSAL_CD_ADB |
Character(1) |
VARCHAR2(1) NOT NULL |
ADB Reversal Code
D=On Date Specified By User
S=Same As Journal Reversal
Default Value: S
|
| 15 |
REVERSAL_DATE_ADB |
Date(10) |
DATE |
ADB Reversal Date
|
| 16 |
JOURNAL_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Class
Prompt Table:
JRNL_CLASS_TBL
|
| 17 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
Prompt Table:
IU_TRAN_MAP_VW
|
| 18 |
GL_ADJUST_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Adjustment Type
Prompt Table:
FIN_ADJ_TYPE_VW
|
| 19 |
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.
|
| 20 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 21 |
SCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
ID
|
| 22 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
Prompt Table:
FRGN_CURR_VW
|
| 23 |
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_TBL
|
| 24 |
CUR_EFFDT |
Date(10) |
DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
|
| 25 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 26 |
RT_RATE |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Market Rate
|
| 27 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 28 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 29 |
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_TBL
|
| 30 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 31 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 32 |
DATE_CODE_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines codes for Date field used in Journal lines record.
The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
|
| 33 |
VISUAL_RATE |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
The selected leg of a cross-currency rate designated to be displayed on a given application transaction p
|
| 34 |
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
Default Value: 1
|
| 35 |
KK_TRAN_BYPAS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass Budget Checking
|
| 36 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
|