| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 6 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCOUNT_TBL
|
| 7 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
ALTACCT_TBL
|
| 8 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 9 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPER_UNIT_TBL
|
| 10 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_TBL
|
| 11 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_TBL
|
| 12 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_TBL
|
| 13 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_TBL
|
| 14 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_TBL
|
| 15 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 16 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 17 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 18 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CHARTFIELD1_TBL
|
| 19 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CHARTFIELD2_TBL
|
| 20 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CHARTFIELD3_TBL
|
| 21 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_ID_VW
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 23 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 24 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 25 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 26 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 27 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 28 |
PERIOD_FROM |
Number(3,0) |
SMALLINT NOT NULL |
From Period
|
| 29 |
PERIOD_TO |
Number(3,0) |
SMALLINT NOT NULL |
To Period
|
| 30 |
INC_CNTL_ACCTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Budgetary Accts
|
| 31 |
PROCESS_BEGIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Begin Process Instance
Prompt Table:
%EDITTABLE3
|
| 32 |
PROCESS_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
End Process Instance
Prompt Table:
%EDITTABLE3
|
| 33 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
PROCESS_VW
|
| 34 |
JOBID |
Character(10) |
VARCHAR2(10) NOT NULL |
Job ID
Prompt Table:
MESSAGE_LOG
|
| 35 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Default Value: OPR_DEF_TBL_FS.LEDGER
Prompt Table:
SP_LEDG_D_NONVW
|
| 36 |
LEDGER_SUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Summary Ledger
Prompt Table:
SP_LEDG_S_NONVW
|
| 37 |
LED_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger
S=Summary Ledger
|
| 38 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 39 |
OPERATOR |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
Prompt Table:
OPRID_VW
|
| 40 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Prompt Table:
SOURCE_TBL
|
| 41 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
Prompt Table:
JRNL_ALL_ID_VW
|
| 42 |
STNDRD_JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Journal ID
Prompt Table:
SJE_JRNL_VW
|
| 43 |
JOURNAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Status
E=Journal Has Errors
J=Posted (by journal dates)
N=No Status - Needs to be Edited
P=Posted (by posting dates)
U=Unposted
V=Valid Journal - Edits Complete
|
| 44 |
SJE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Journal
Prompt Table:
SJE_DEFN
|
| 45 |
SJE_TYPE_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Journal Entry Type
R=Recurring on a Schedule
T=Template to be Completed
|
| 46 |
CLOSING_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
Closing Rule
Prompt Table:
CLOSE_RPT_VW
|
| 47 |
TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
TimeSpan
Prompt Table:
TIME_SPANS
|
| 48 |
MINORITY_INT_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Minority Interest Set
Prompt Table:
MINOR_RPT_VW
|
| 49 |
ELIMINATION_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Elimination Set
Prompt Table:
ELIM_SET_RPT_VW
|
| 50 |
CONSOLIDATION_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Consolidation Set
Prompt Table:
CONSOL_RPT_VW
|
| 51 |
EQUITIZATION_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Equitization Rule
Prompt Table:
EQTZ_RULE_RPTVW
|
| 52 |
OWNERSHIP_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Ownership Set
Prompt Table:
OWNERSHIP_RPTVW
|
| 53 |
SPEEDTYPE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
SpeedType Key
Prompt Table:
SPEEDTYP_VW
|
| 54 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
%EDITTABLE
|
| 55 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table:
SCHED_RPT_VW
|
| 56 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table:
STAT_TBL
|
| 57 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 58 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
TREE_CFNOSET_VW
|
| 59 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
CF_PROMPT_VW
|
| 60 |
FIELDVALUE |
Character(4) |
VARCHAR2(4) NOT NULL |
Field Value
|
| 61 |
PROCESS_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Step
Prompt Table:
%EDITTABLE4
|
| 62 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
Prompt Table:
%EDITTABLE4
|
| 63 |
REPORT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Report Identifier
Prompt Table:
NVS_REPORT
|
| 64 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 65 |
REVALUATION_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Revaluation Step
Prompt Table:
CURR_STEPR_VW
|
| 66 |
TRANSL_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Translation Within Ledger Step
Prompt Table:
CURR_STEPM_VW
|
| 67 |
TRANSLATION_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Translation Step
Prompt Table:
CURR_STEPT_VW
|
| 68 |
ADB |
Character(10) |
VARCHAR2(10) NOT NULL |
Average Daily Balances
Prompt Table:
%EDITTABLE2
|
| 69 |
MASS_REPORT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Report ID
Prompt Table:
MASS_RPT_HDR
|
| 70 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
Prompt Table:
LEDGER_FILE_VW
|
| 71 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Default Value: OPR_DEF_TBL_FS.LEDGER_GROUP
Prompt Table:
SP_BULGRP_NONVW
|
| 72 |
SHOW_CFS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Report ChartFields Option
1=Show Account Only
2=Show All Chartfields
3=Show Some Chartfields
Default Value: 2
|
| 73 |
SHOW_DESCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Description on Report
Y/N Table Edit
Default Value: Y
|
| 74 |
DISPLAY_26_DIGITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Full Numeric Field
N=No
Y=Yes
Default Value: N
|
| 75 |
SORT_BY_CURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort By Currency
N=No
Y=Yes
Default Value: N
|
| 76 |
SOURCE_INSTANCE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier.
Prompt Table:
%EDITTABLE4
|
| 77 |
TMPLT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Type
A=All
C=Permission
O=User ID
|
| 78 |
OPRCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table:
OPRCLASS_VW
|
| 79 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 80 |
LEDGER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Code
Prompt Table:
LEDGER_CODE_TBL
|
| 81 |
LEDGER_GROUP_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_KKBULG_NONVW
|
| 82 |
LEDGER_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 83 |
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
|