WM_ALMEWN_CTX

(SQL Table)
Index Back

WM ALM EWN 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
6 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
7 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
8 USER_ID Character(30) VARCHAR2(30) NOT NULL User ID
9 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
13 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
14 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
15 QTY_NEW Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
17 IN_EMAIL_GROUP Number(10,0) DECIMAL(10) NOT NULL Email group id for inventory audit / EWN purposes
18 IN_NOTIFY_TO Character(30) VARCHAR2(30) NOT NULL Notification receiver
19 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
20 EMAIL_ADDRESS Long Character CLOB Email Addresses