| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 5 |
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
Default Value: N
|
| 6 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 7 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
Default Value: P
|
| 8 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 9 |
PARALLEL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Process in Parallel
N=Synchronous Processing
Y=Parallel Processing
Y/N Table Edit
Default Value: N
|
| 10 |
PROCESSING_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Processing Sequence
|
| 11 |
OPEN_TRANS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Trans Processing Options
1=Range of Open Trans for
2=All Open Trans for Operator
3=All Open Trans for all
Default Value: 1
|
| 12 |
OPEN_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Open Transaction ID
|
| 13 |
TO_OPEN_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
To Open Transaction ID
|
| 14 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 15 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table:
SP_BOOKB3_NONVW
|
| 16 |
ASSET_ID_FROM |
Character(12) |
VARCHAR2(12) NOT NULL |
From Asset ID
Prompt Table:
OPEN_TRANS3_VW
|
| 17 |
ASSET_ID_TO |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset ID to
Prompt Table:
OPEN_TRANS3_VW
|
| 18 |
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. "
|
| 19 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 20 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 21 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: CUR_RT_TYPE_VW.RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 22 |
RATE_EFFDT |
Date(10) |
DATE NOT NULL |
Rate Effective Date
Default Value: %date
|
| 23 |
COST_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Summarization switch
Y/N Table Edit
Default Value: N
|
| 24 |
MULTI_SEL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Select Option
|
| 25 |
AM_PROCESS_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
AM Process Jgen field
Y/N Table Edit
Default Value: N
|
| 26 |
AM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Setid
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 27 |
AM_ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
Prompt Table:
JRNLGEN_DEFN
Set Control Field: SETID
|