MCF_EMAIL_IDPrompt Table: RB_EM_STATUS_VW
RB_IBEM_PRMT_VW(SQL View) |
Index Back |
|---|---|
Inbound Email viewInbound Email View - used as prompt table for parent email ID on outbound email page. |
| SELECT A.MCF_EMAIL_ID , A.EMAIL_STATUS , A.MCF_WL_SUBJECT , A. BO_ID_CUST , A.BO_ID_CONTACT , A.REPLY_TO_ADDRESS , A.ASSIGNED_TO , A.MB_DUE_DTTM , A.ROW_ADDED_DTTM FROM PS_RB_IN_EMAIL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | EMAIL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
ERMS Inbound Email Status
Prompt Table: RB_EM_STATUS_VW |
| 3 | EMAIL_SUBJECT254 | Character(254) | VARCHAR2(254) NOT NULL | Email Subject |
| 4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 5 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 6 | REPLY_TO_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | Email Address associated with the Reply To Person |
| 7 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 8 | MB_DUE_DTTM | DateTime(26) | TIMESTAMP | Mailbox level (or external) due date/time |
| 9 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |