IN_PUTAWAY_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 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
13 PUTAWAY_STATUS Character(1) VARCHAR2(1) NOT NULL Item Putaway Status
1=Not Assigned
2=Putaway Complete
3=In Error
14 STAGE_ID Number(15,0) DECIMAL(15) NOT NULL Unique stage identifier
15 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
16 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
17 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
18 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
19 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
20 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
21 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
22 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
23 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
24 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
25 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
26 STAGED_DATE Date(10) DATE Staged Date
27 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).