EOEN_PRCS_NAMEEOEN_CATEGORYSEQ_NBR_EOENBUSINESS_UNIT_RTVRTV_ID0=Ship
1=Destroy
1=Manual
2=Express
3=Fulfill
4=Re-Send
RTV_INVEWN_CTX(SQL Table) |
Index Back |
|---|---|
RTV EWN Context RecordUsed by EWN |
| # | 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_RTV |
Character(5) | VARCHAR2(5) NOT NULL | RTV Business Unit |
| 5 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 6 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 7 | DISPOSITION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Disposition Type
0=Ship 1=Destroy |
| 8 | RTV_INV_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
RTV Inventory Option
1=Manual 2=Express 3=Fulfill 4=Re-Send |
| 9 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |