| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 3 |
JRNL_EDIT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Edit Errors Option
D=Default to Higher Level Value
R=Recycle
S=Suspend
|
| 4 |
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
|
| 5 |
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
|
| 6 |
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
|
| 7 |
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
|
| 8 |
ADJ_YEAR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Year Not Exist Option
O=Override
R=Recycle
|
| 9 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 10 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
|
| 11 |
VAT_NRCVR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Non-Recoverable VAT
|
| 12 |
JRNL_BALANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value
R=Recycle
S=Suspend
|
| 13 |
CONTROL_TOTAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value
N=N/A
R=Recycle
|
| 14 |
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
|
| 15 |
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
|
| 16 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
|