| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RTBL_SCENARIO |
Character(18) |
VARCHAR2(18) NOT NULL |
Scenario Name
|
| 3 |
SCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
ID
|
| 4 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
|
| 5 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 6 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 7 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 8 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 10 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Default Value: OPR_DEF_TBL_FS.LEDGER
Prompt Table:
SP_BULEDD_NONVW
|
| 11 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 12 |
PERIOD_TO |
Number(3,0) |
SMALLINT NOT NULL |
To Period
|
| 13 |
SHOW_DR_CR |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Debit/Credit Columns
Y/N Table Edit
Default Value: N
|
| 14 |
INCLUDE_ADJ_PER |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Adjustment Period(s)
Y/N Table Edit
Default Value: N
|
| 15 |
CURRENCY_OPTION2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Option
B=Base
F=All Frgn
S=Selected Frgn
Default Value: B
|
| 16 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 17 |
SHOW_CFS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Report ChartFields Option
1=Show Account Only
2=Show All Chartfields
3=Show Some Chartfields
|
| 18 |
INC_CNTL_ACCTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Budgetary Accts
Y/N Table Edit
|
| 19 |
DISPLAY_26_DIGITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Full Numeric Field
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 20 |
TEXT_LABEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Text Label
|
| 21 |
LEDGER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Code
Prompt Table:
LEDGER_CODE_TBL
|
| 22 |
DATE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines codes for Date field used in Journal lines record.
The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
Default Value: 0
Prompt Table:
DATE_CD_VW
|
| 23 |
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. "
|
| 24 |
SETID_ACCOUNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Account Table Setid
|