VIEW: IEM.IEM_POST_MDTS#

Source

View Text - Preformatted

select MESSAGE_ID MESSAGE_ID, EMAIL_ACCOUNT_ID EMAIL_ACCOUNT_ID, RT_CLASSIFICATION_ID RT_CLASSIFICATION_ID, AGENT_ID AGENT_ID, GROUP_ID GROUP_ID, MESSAGE_SIZE MESSAGE_SIZE, SENDER_NAME SENDER_NAME, USER_NAME USER_NAME, DOMAIN_NAME DOMAIN_NAME, PRIORITY PRIORITY, MSG_STATUS MSG_STATUS, SUBJECT SUBJECT, SENT_DATE SENT_DATE, CUSTOMER_ID CUSTOMER_ID, PRODUCT_ID PRODUCT_ID, EMAIL_CLASSIFICATION EMAIL_CLASSIFICATION, SCORE_PERCENT SCORE_PERCENT, ICENTER_MAP_ID ICENTER_MAP_ID, IH_MEDIA_ITEM_ID IH_MEDIA_ITEM_ID, RFC822_MESSAGE_ID RFC822_MESSAGE_ID, MESSAGE_UID MESSAGE_UID, LANGUAGE LANGUAGE, CONTENT_TYPE CONTENT_TYPE, MAILER MAILER, ORGANIZATION ORGANIZATION, DFLT_AGT_ID DFLT_AGT_ID, MESSAGE_TYPE MESSAGE_TYPE, RECEIVED_DATE RECEIVED_DATE, END_DATE END_DATE, MAIL_ITEM_STATUS MAIL_ITEM_STATUS, SOURCE_MESSAGE_ID SOURCE_MESSAGE_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FROM_AGENT_ID FROM_AGENT_ID, QUEUE_STATUS QUEUE_STATUS, IH_INTERACTION_ID IH_INTERACTION_ID, MESSAGE_FLAG MESSAGE_FLAG, TO_ADDRESS TO_ADDRESS, CATEGORY_MAP_ID CATEGORY_MAP_ID from "IEM"."IEM_POST_MDTS"

View Text - HTML Formatted

SELECT MESSAGE_ID MESSAGE_ID
, EMAIL_ACCOUNT_ID EMAIL_ACCOUNT_ID
, RT_CLASSIFICATION_ID RT_CLASSIFICATION_ID
, AGENT_ID AGENT_ID
, GROUP_ID GROUP_ID
, MESSAGE_SIZE MESSAGE_SIZE
, SENDER_NAME SENDER_NAME
, USER_NAME USER_NAME
, DOMAIN_NAME DOMAIN_NAME
, PRIORITY PRIORITY
, MSG_STATUS MSG_STATUS
, SUBJECT SUBJECT
, SENT_DATE SENT_DATE
, CUSTOMER_ID CUSTOMER_ID
, PRODUCT_ID PRODUCT_ID
, EMAIL_CLASSIFICATION EMAIL_CLASSIFICATION
, SCORE_PERCENT SCORE_PERCENT
, ICENTER_MAP_ID ICENTER_MAP_ID
, IH_MEDIA_ITEM_ID IH_MEDIA_ITEM_ID
, RFC822_MESSAGE_ID RFC822_MESSAGE_ID
, MESSAGE_UID MESSAGE_UID
, LANGUAGE LANGUAGE
, CONTENT_TYPE CONTENT_TYPE
, MAILER MAILER
, ORGANIZATION ORGANIZATION
, DFLT_AGT_ID DFLT_AGT_ID
, MESSAGE_TYPE MESSAGE_TYPE
, RECEIVED_DATE RECEIVED_DATE
, END_DATE END_DATE
, MAIL_ITEM_STATUS MAIL_ITEM_STATUS
, SOURCE_MESSAGE_ID SOURCE_MESSAGE_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FROM_AGENT_ID FROM_AGENT_ID
, QUEUE_STATUS QUEUE_STATUS
, IH_INTERACTION_ID IH_INTERACTION_ID
, MESSAGE_FLAG MESSAGE_FLAG
, TO_ADDRESS TO_ADDRESS
, CATEGORY_MAP_ID CATEGORY_MAP_ID
FROM "IEM"."IEM_POST_MDTS"