| # |
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 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Default Value: OPR_DEF_TBL_FS.LEDGER
Prompt Table:
SP_LEDG_D_NONVW
|
| 7 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCOUNT_TBL
|
| 8 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
ALTACCT_TBL
|
| 9 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 10 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_NB_VW
|
| 11 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_NB_VW
|
| 12 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_NB_VW
|
| 13 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_NB_VW
|
| 14 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_NB_VW
|
| 15 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_NB_VW
|
| 16 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 17 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 18 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 19 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_NB_VW
|
| 20 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_NB_VW
|
| 21 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_NB_VW
|
| 22 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_ID_VW
|
| 23 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 24 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
PROCESS_VW
|
| 25 |
PROCESS_BEGIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Begin Process Instance
Prompt Table:
MESSAGE_VW
|
| 26 |
PROCESS_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
End Process Instance
Prompt Table:
MESSAGE_VW
|
| 27 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 28 |
OPERATOR |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
Prompt Table:
OPR_DEFAULT_VW
|
| 29 |
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
|
| 30 |
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.
|
| 31 |
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
|
| 32 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 33 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 34 |
TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
TimeSpan
Prompt Table:
TIME_SPANS
|
| 35 |
SPEEDTYPE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
SpeedType Key
Prompt Table:
SPEEDTYP_VW
|
| 36 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
%EDITTABLE
|
| 37 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table:
STAT_TBL
|
| 38 |
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
|
| 39 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
SET_FIELDNAMEVW
|
| 40 |
SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
Prompt Table:
SET_CNTRL_TBL
|
| 41 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
|
| 42 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 43 |
ARCH_ID_PYMNT_HST |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment History Archive ID
Prompt Table:
%EDITTABLE2
|
| 44 |
ARCH_DT_PYMNT_HST |
Date(10) |
DATE |
Payment History Archive Date
Prompt Table:
%EDITTABLE3
|
| 45 |
ARCH_ID_VCHR_HST |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher History Archive ID
Prompt Table:
%EDITTABLE4
|
| 46 |
ARCH_DT_VCHR_HST |
Date(10) |
DATE |
Voucher History Archive Date
Prompt Table:
%EDITTABLE5
|
| 47 |
BANK_SETID_HST |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment History Bank SetID
Prompt Table:
%EDITTABLE6
|
| 48 |
BANK_CD_HST |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment History Bank Code
Prompt Table:
%EDITTABLE7
|
| 49 |
BANK_ACCT_HST |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment History Bank Account
Prompt Table:
%EDITTABLE8
|
| 50 |
BUS_UNIT_HST_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
Voucher History Business Unit
Prompt Table:
%EDITTABLE9
|
| 51 |
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
|
| 52 |
SHOW_DESCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Description on Report
Y/N Table Edit
Default Value: Y
|
| 53 |
DISPLAY_26_DIGITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Full Numeric Field
N=No
Y=Yes
Default Value: N
|
| 54 |
LEDGER_TEMPLATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Template
Prompt Table:
LED_TMPLT_TBL
|
| 55 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Default Value: OPR_DEF_TBL_FS.LEDGER_GROUP
Prompt Table:
SP_BULGRP_NONVW
|
| 56 |
COMBINATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Combination Rule
Prompt Table:
COMBO_RPT_VW
|
| 57 |
INV_ITEM_LIST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item List Option
A=All Items
C=Category
F=Item Family
G=Item Group
R=Range of Items
S=Single Item
|
| 58 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
MASTER_ITEM_VW
|
| 59 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 60 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
Prompt Table:
INV_ITEM_FAM
|
| 61 |
FROM_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table:
MASTER_ITEM_VW
|
| 62 |
TO_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
To Item ID
Prompt Table:
MASTER_ITEM_VW
|
| 63 |
JRNL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Journal Type
Prompt Table:
JRNL_TYPE_TBL
|
| 64 |
JRNL_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Journal Code
Prompt Table:
JRNL_CODE_TBL
|
| 65 |
SEQ_RANGE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Sequence Range
Prompt Table:
SEQ_RANGE_DEFN
|
| 66 |
LANGUAGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Language Option
O=Specified Language
R=Recipient's Language
Default Value: O
|
| 67 |
PRCSINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 68 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
Prompt Table:
EFT_LAYOUT_TBL
|
| 69 |
ITM_STATUS_CURRENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status Current
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization
|
| 70 |
ITM_STATUS_FUTURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive
|
| 71 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table:
DOC_TYPE_TBL
|
| 72 |
ONLY_GAPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Only Gaps for Journal Checklist
Y/N Table Edit
Default Value: N
|
| 73 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|