IN_SDWC_PUT_CTX(SQL Table) |
Index Back |
---|---|
EOEN Putaway context recordPutaways 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 |