| # |
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:
OPERATOR_VW
|
| 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
|
| 6 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 7 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AM_NONVW
|
| 9 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table:
SP_BOOKB3_NONVW
|
| 10 |
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. "
|
| 11 |
FROM_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
From Asset ID
Prompt Table:
SP_AMCLRC_NONVW
|
| 12 |
TO_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
To Asset ID
Prompt Table:
SP_AMCLRC_NONVW
|
| 13 |
DOCUMENT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Document Type
123=Lotus 1-2-3
AVI=Video for Windows
CAD=AutoCad Document
DOC=Microsoft Winword
MPP=MicroSoft Project
NON=No Document Type
PST=PeopleSoft PeopleTools
SCR=Lotus ScreenCam
TLP=TimeLine for Windows
TXT=Notepad for ASCII Text
XLS=Microsoft Excel
|
| 14 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 15 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 16 |
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.
|
| 17 |
RATE_EFFDT |
Date(10) |
DATE |
Rate Effective Date
|