SCP_EMAIL_SEQ_IDSCP_CNTEMAIL_FL(SQL Table) |
Index Back |
|---|---|
Contact Emails |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCP_EMAIL_SEQ_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Email Contact Seq ID |
| 2 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 3 | CONTACT_EMAIL | Character(70) | VARCHAR2(70) NOT NULL | Recepient Email Id |
| 4 | MESSAGE_TEXT_LONG | Long Character | CLOB | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 5 | SCP_EMAIL_SUBJECT | Character(30) | VARCHAR2(30) NOT NULL | Email Subject |
| 6 | SCP_EMAIL_PURPOSE | Character(100) | VARCHAR2(100) NOT NULL | Subject Line Text |