# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
EOEN_PRCS_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
EOEN Process Name
|
2 |
EOEN_CATEGORY |
Character(30) |
VARCHAR2(30) NOT NULL |
EOEN Category
|
3 |
SEQ_NBR_EOEN |
Number(15,0) |
DECIMAL(15) NOT NULL |
EOEN Sequence Nbr
|
4 |
EOEN_EMAIL_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
Email group id
|
5 |
EOEN_NOTIFY_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Notification receiver
|
6 |
EMAIL_ADDRESS |
Long Character |
CLOB |
Email Addresses
|
7 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
|
8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
9 |
EOEN_LAST_DTTIME |
DateTime(26) |
TIMESTAMP |
Last Date Time
|
10 |
EOEN_EMAIL_SUBJECT |
Character(100) |
VARCHAR2(100) NOT NULL |
EOEN Email subject field
|
11 |
EOEC_UL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the approval process.
|
12 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
13 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
14 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
15 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
16 |
COUNT_LINES |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Lines
|