| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 3 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 4 |
LEDGER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
|
| 5 |
BALANCED_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Balanced Ledger
|
| 6 |
JRNL_BALANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value
K=Reject Out of Balance Journals
R=Recycle Out of Bal. Journals
S=Suspend Out of Bal. Journals
W=Accept With Warning Message
|
| 7 |
JRNL_EDIT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Edit Errors Option
D=Default to Higher Level Value
K=Reject Journals w/ Edit Errors
R=Recycle Jrnls With Edit Errors
S=Suspend Errors/Accept Others
|
| 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=Defaut to a Higher Level Value
R=Recycle
S=Suspend
|
| 9 |
JRNL_DT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date < Open From
C=Change to Open From Date
D=Default to Higher Level Value
R=Recycle
|
| 10 |
JRNL_DT_ERR_OPTN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date > Open to
C=Change to Open to Date
D=Default to Higher Level Value
R=Recycle
|
| 11 |
CONTROL_TOTAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value
K=Reject Exception Journals
N=Don't Care (No Controls)
R=Recycle Exception Journals
W=Accept With Warning Message
|
| 12 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 13 |
UPD_OPENPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Open Periods
C=By Ledger Code
G=By Ledger Group
|
| 14 |
ADB_REPORTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Average Balances
|
| 15 |
ADB_STATUTORY_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain Regulatory Balances
|
| 16 |
ADB_FILTER_ACCNTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Filter Posted Activity
|
| 17 |
CALENDAR_ID_ADB |
Character(2) |
VARCHAR2(2) NOT NULL |
ADB Calendar
|
| 18 |
ALLOW_LEDG_LOAD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Ledger Load Update
|
| 19 |
ALLOW_WF_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Budgets Ledger Updates
|
| 20 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 21 |
DEFAULT_LEDGER_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Jrnl Generator Dflt Ledger Grp
|
| 22 |
SEPARATE_DRCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Separate Debit/Credit
|
| 23 |
SEPARATE_DRCR_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate DR/CR Amount Fields
|
| 24 |
ALTACCT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Alternate Account
|
| 25 |
ACCT_ALT_SUSPENSE |
Character(10) |
VARCHAR2(10) NOT NULL |
Acct->Alt Suspense
|
| 26 |
ALT_ACCT_SUSPENSE |
Character(10) |
VARCHAR2(10) NOT NULL |
Alt->Acct Suspense
|
| 27 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Type
L=Letter
N=Notice
O=Other
Q=Request
R=Report
|
| 28 |
POSITION_ACCOUNT |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Accounting
|