PROCESS_INSTANCEBB=Blackberry
BUS=Business
D=Dispatch
HOME=Home
N=Notification
OTH=Other
WORK=Work
Default Value: D
RTV_EMAIL_Q_AET(SQL Table) |
Index Back |
|---|---|
RTV Dispatch E-Mail-AET* 07/15/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. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROCESS_INST_STG | Number(10,0) | DECIMAL(10) NOT NULL | Stage Record Process Instance |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 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 | 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 |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 11 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |