| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CHARTFIELD_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value
|
| 3 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 4 |
LEDGER_PRIMARY |
Character(10) |
VARCHAR2(10) NOT NULL |
Primary Ledger for a Group
|
| 5 |
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. "
|
| 6 |
ELIM_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Elimination Node Number
|
| 7 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 8 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 9 |
INCLUDE_BAL_FRWD |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Balance Forward
|
| 10 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 11 |
ACCOUNTING_PERIOD2 |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 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 |
LEDGERS_SYNC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Ledgers in Sync
|
| 14 |
SECOND_LEDGERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Ledgers Exist
|
| 15 |
TRANSL_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Translation Ledger
|
| 16 |
COMMITMENT_CNTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Commitment Control
|