PROCESS_INSTANCEBUSINESS_UNITRTV_IDEMAIL_TYPEBB=Blackberry
BUS=Business
D=Dispatch
HOME=Home
N=Notification
OTH=Other
WORK=Work
Default Value: D
RTV_EMAIL_QUEUE(SQL Table) |
Index Back |
|---|---|
RTV Dispatch E-Mail Queue*** 07/07/00 *** 1. Added DESCR to store Return Reason description. 2. Added DESCR1 to store Disposition Type description. 3. Added DESCR2 to store Return Action description. *** 08/09/02**** Made EMAIL_TYPE as Key for the Ice report # 514958000 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 4 | EMAIL_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Email Type
BB=Blackberry BUS=Business D=Dispatch HOME=Home N=Notification OTH=Other WORK=Work Default Value: D |
| 5 | EMAIL_SERVER_DIR | Character(80) | VARCHAR2(80) NOT NULL | E-Mail Server Directory |
| 6 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 7 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 10 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |