| # |
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
Default Value: 1
|
| 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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 12 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table:
SP_BOOKB3_NONVW
|
| 13 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 14 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 15 |
ASSET_ID_FROM |
Character(12) |
VARCHAR2(12) NOT NULL |
From Asset ID
Prompt Table:
ASSET
|
| 16 |
ASSET_ID_TO |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset ID to
Prompt Table:
ASSET
|
| 17 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 18 |
RERUN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Rerun depreciation close
Y/N Table Edit
Default Value: N
|
| 19 |
REVERSAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal SW
|
| 20 |
BUDGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Create budgeted depreciation
Y/N Table Edit
Default Value: N
|
| 21 |
PARTIAL_RANGE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Process a range of assets
N=Do not process a partial range
Y=Process a partial range
Y/N Table Edit
Default Value: N
|
| 22 |
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. "
|
| 23 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 24 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 25 |
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
|
| 26 |
AM_PROCESS_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
AM Process Jgen field
Y/N Table Edit
Default Value: N
|
| 27 |
AM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Setid
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 28 |
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
|