| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_LGNOKK_NONVW
|
| 4 |
BALANCED_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Balanced Ledger
Y/N Table Edit
Default Value: Y
|
| 5 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
%EDITTABLE
|
| 6 |
ADB_REPORTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Average Balances
Y/N Table Edit
Default Value: N
|
| 7 |
CALENDAR_ID_ADB |
Character(2) |
VARCHAR2(2) NOT NULL |
ADB Calendar
Prompt Table:
CAL_DAILY_VW
|
| 8 |
SEPARATE_DRCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Separate Debit/Credit
Y/N Table Edit
Default Value: N
|
| 9 |
NO_POST_FUTURE_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: N
|
| 10 |
POST_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Process Date Option
C=Current Date
P=Process Date
Default Value: C
|
| 11 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 12 |
ENABLE_UNPOST_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Different Unpost Date
Y/N Table Edit
Default Value: N
|
| 13 |
POST_REVERSAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator - Automatic Post Reversals
Y/N Table Edit
Default Value: N
|
| 14 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
Y/N Table Edit
Default Value: N
|
| 15 |
UNPOST_DOCTYPE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator - Option for unposting journal's document type
N=Specify a New Document Type
S=Same as the Original Journal
Default Value: S
|
| 16 |
DOC_TYPE_UNPOST |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Type for Unposted Journals
Prompt Table:
DOC_TYPE_TBL
|
| 17 |
UNPOST_INTERUNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: Y
|
| 18 |
UNPOST_REVERSALS |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: Y
|
| 19 |
ALLOW_LEDG_LOAD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No indicator - Allow Ledger Load Updates
Y/N Table Edit
Default Value: N
|
| 20 |
ENABLE_INC_SLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Enable Incremental Summary Ledger update
Y/N Table Edit
Default Value: N
|
| 21 |
ENABLE_INC_LLOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Incremental Ledger Load
Y/N Table Edit
Default Value: N
|
| 22 |
COMMITMENT_CNTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Commitment Control
Y/N Table Edit
Default Value: N
|
| 23 |
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
Default Value: G
|
| 24 |
COMMITMENT_CNTL_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on GL
|
| 25 |
DOC_SEQ_INSTALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 26 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 27 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 28 |
SETID_ACCOUNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Account Table Setid
|
| 29 |
SETID_CALENDAR |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar Setid
|
| 30 |
ADB_FILTER_ACCNTS |
Character(1) |
VARCHAR2(1) NOT NULL |
ADB Filter indicator
|
| 31 |
ADB_STATUTORY_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain Balances by Date Code
|
| 32 |
SETID_DOCTYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Doc TypeSetid
|
| 33 |
SETID_LEDGER_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Ledger Group SetID
|
| 34 |
RECNAME_LED_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger Tmp
|
| 35 |
ADB_POSTADJ_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
ADB Post Adjustment Period Option: this option determines whether to post the adjustment accouting period or the regular ADB accouting period to the ADB Ledger.
Y/N Table Edit
Default Value: Y
|
| 36 |
RECNAME_LED_TMP2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger Tmp2
|
| 37 |
ENABLE_DATE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Enable Incremental Summary Ledger update
|
| 38 |
SETTLEMENT_DT |
Date(10) |
DATE |
The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
|
| 39 |
FISCAL_YEAR2 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 40 |
FISCAL_YEAR3 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 41 |
ACCOUNTING_PERIOD2 |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 42 |
ACCOUNTING_PERIOD3 |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 43 |
DTTM_FROM |
DateTime(26) |
TIMESTAMP |
From Date/Time
|
| 44 |
DTTM_TO |
DateTime(26) |
TIMESTAMP |
To Date/Time
|