| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
LEDGER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
|
| 3 |
ASSOCIATED_LED_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Associated Actual Ledger Group
|
| 4 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 5 |
DAILY_CALENDAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Daily Calendar
|
| 6 |
UPD_OPENPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Open Periods options - By Ledger Group or By Ledger Code
C=By Ledger Code
G=By Ledger Group
|
| 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
|
| 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
|
| 9 |
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
|
| 10 |
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
|
| 11 |
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
|
| 12 |
ALTACCT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Alternate Account
|
| 13 |
BALANCED_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Balanced Ledger
|
| 14 |
JRNL_BALANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value
R=Recycle
S=Suspend
|
| 15 |
CONTROL_TOTAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value
N=N/A
R=Recycle
|
| 16 |
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
|
| 17 |
CALENDAR_ID_ADB |
Character(2) |
VARCHAR2(2) NOT NULL |
ADB Calendar
|
| 18 |
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
|
| 19 |
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
|
| 20 |
SEPARATE_DRCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Separate Debit/Credit
|
| 21 |
ACCT_ALT_SUSPENSE |
Character(10) |
VARCHAR2(10) NOT NULL |
Acct->Alt Suspense
|
| 22 |
ALT_ACCT_SUSPENSE |
Character(10) |
VARCHAR2(10) NOT NULL |
Alt->Acct Suspense
|
| 23 |
COMMITMENT_CNTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Commitment Control
|
| 24 |
POSITION_ACCOUNT |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Accounting
|