| # |
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 |
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
|
| 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 |
JRNL_BALANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value
R=Recycle
S=Suspend
Default Value: D
|
| 7 |
JRNL_EDIT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Edit Errors Option
D=Default to Higher Level Value
R=Recycle
S=Suspend
Default Value: D
|
| 8 |
JRNL_AMT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
A Journal Edit option to decide if accept, error or suspense a journal line when foreign amount and monetary amount are different sign (i.e. one positive and the other negative).
A=Accept
D=Default to Higher Level Value
R=Recycle
S=Suspend
Default Value: D
|
| 9 |
JRNL_DT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date < Open From Date
C=Change to Open From Date
D=Default to Higher Level Value
R=Recycle
Default Value: D
|
| 10 |
JRNL_DT_ERR_OPTN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date > Open To Date
C=Change To Open To Date
D=Default to Higher Level Value
R=Recycle
Default Value: D
|
| 11 |
CONTROL_TOTAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value
N=N/A
R=Recycle
Default Value: D
|
| 12 |
CURRENCY_BAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Balancing Option
A=Balance by All Currencies
B=Balance by Base Currency Only
D=Default to Higher Level Value
Default Value: D
|
| 13 |
ROUND_ADJ_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Adjustment Option
A=Add Adjusting Journal Line
D=Default to Higher Level Value
L=Adjust Last Journal Line
S=Skip Rounding Adjustment
Default Value: D
|
| 14 |
EXCHANGE_RATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Translate Ledger Exchange Rate
D=Default to Higher Level Value
N=Retain Exchange Rate
Y=Inherit from Primary Ledger
Default Value: D
|
| 15 |
BASE_CUR_ADJ_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Base Currency Adjust Option
D=Default to Higher Level Value
N=Disallow Base Curr Adjustments
Y=Allow Base Curr Adjustments
Default Value: D
|
| 16 |
JRNL_FOREIGN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Currencies per Journal
D=Default to Higher Level Value
M=Multiple Foreign Currencies
N=No Foreign Currencies
O=Only One Foreign Currency
Default Value: D
|
| 17 |
POST_ZERO_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Zero Amount Journal Lines
Y/N Table Edit
Default Value: N
|
| 18 |
JRNL_APPRVL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Approval Option
D=Default to Higher Level
P=Pre-Approved
S=Require Approval
Default Value: D
|
| 19 |
JRNL_APP_UP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Unpost Approval Option
Y/N Table Edit
Default Value: N
|
| 20 |
BD_JRNL_APPR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Journal Approval Optn
D=Default to Higher Level
P=Pre-Approved
S=Require Approval
Default Value: D
|
| 21 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
BUSPROCNAME_VW
|
| 22 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
APPR_RULE_BP_VW
|
| 23 |
BUSPROCNAME_BD |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name - Budget
Prompt Table:
BUSPROC_BD_VW
|
| 24 |
APPR_RULE_SET_BD |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set - Budgets
Prompt Table:
APPR_RULE_BD_VW
|
| 25 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 26 |
DOC_TYPE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type Option
D=Default to Higher Level Value
S=Specify
Default Value: D
|
| 27 |
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
|