IN_SDWC_PUT_CTX

(SQL Table)
Index Back

EOEN Putaway context record

Putaways not Complete

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID
13 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
14 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
17 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
18 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
19 STAGED_NUM Number(3,0) SMALLINT NOT NULL Staged Number
20 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
21 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
22 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
23 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
24 PUTAWAY_STATE Character(1) VARCHAR2(1) NOT NULL Putaway State
1=Not Interfaced
2=Interfaced, Not Staged
3=Staged, Not Putaway
4=Putaway Complete
25 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash