OM_EDISTUCK_CTX

(SQL Table)
Index Back

EOEN context record

EOEN context record

# 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 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
13 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
14 EIP_REFERENCE Character(30) VARCHAR2(30) NOT NULL EIP Reference
15 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
16 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
17 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
18 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
19 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
20 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).