| # |
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 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 5 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 6 |
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. "
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
|
| 8 |
CALC_LOG_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Calculations Log
C=Create Calc Log and Output
N=No Calc Log - Create Output
O=Create Calc Log - No Output
Default Value: N
|
| 9 |
DATE_REQ_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Date Option
A=As-Of Date
P=Process Date
S=SYSDATE
Default Value: P
|
| 10 |
DELETE_LIMIT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Used in GL AE batch processes to perform deletes rather than truncate.
|
| 11 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 12 |
FIRST_PASS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
First Pass Switch
Default Value: Y
|
| 13 |
LAST_SEQ_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 14 |
LAST_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Last Step Completed
|
| 15 |
LEDGER_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Number of Ledgers
|
| 16 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
Default Value: 9999
|
| 17 |
POST_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Process Date Option
C=Current Date
P=Process Date
|
| 18 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 19 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 20 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
|
| 21 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
Default Value: N
|
| 22 |
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
|
| 23 |
PROCESS_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Step
|
| 24 |
RTBL_COMBO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Combination Edit Flag
Default Value: N
|
| 25 |
RTBL_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Mode
Default Value: N
|
| 26 |
SCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
ID
|
| 27 |
SELECT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Flag
N=No
Y=Yes
|
| 28 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 29 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 30 |
START_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Step to Start Processing Group
F=First Step in Group
L=Last Step Completed
Default Value: F
|
| 31 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 32 |
STOP_SEQ_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 33 |
STOP_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Break Point Step
|
| 34 |
SUCCESS_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error Count
|
| 35 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
|
| 36 |
USE_GTT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Global Temp Table Flag
Default Value: N
|
| 37 |
VERSION_GRP |
Number(3,0) |
SMALLINT NOT NULL |
Group Version
|
| 38 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 39 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|