IN_SDWC_PAR_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 EOEN_LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
9 EOEN_EMAIL_SUBJECT Character(100) VARCHAR2(100) NOT NULL EOEN Email subject field
10 EOEC_UL_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
11 IN_SDWC_DOC_TYPE Character(2) VARCHAR2(2) NOT NULL Document Type
00=MSR
10=Requisition
20=Purchase Order
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

13 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
14 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

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_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
17 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
18 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
19 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
20 IN_PROCESS_DATE Date(10) DATE Process Date
21 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash