| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 JOB_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 2 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
SF_RPL_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Replenishment Vendor ID
|
| 5 |
SF_RPL_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Replinshment Vendor
|
| 6 |
SF_KANBAN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Kanban ID
|
| 7 |
EMAIL_SERVER_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
E-Mail Server Directory
|
| 8 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 9 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 10 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 11 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 12 |
URL_STRING |
Character(250) |
VARCHAR2(250) NOT NULL |
URL String
|
| 13 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 14 |
FP_EMAILS_SENT |
Number(5,0) |
INTEGER NOT NULL |
E-Mails Successfully Sent
|
| 15 |
FP_EMAILS_FAIL |
Number(5,0) |
INTEGER NOT NULL |
E-Mails Failed To Be Sent
|