VIEW: ECX.ECX_DOCLOGS#

Source

View Text - Preformatted

select MSGID MSGID, MESSAGE_TYPE MESSAGE_TYPE, MESSAGE_STANDARD MESSAGE_STANDARD, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE, DOCUMENT_NUMBER DOCUMENT_NUMBER, PARTYID PARTYID, PARTY_SITE_ID PARTY_SITE_ID, PARTY_TYPE PARTY_TYPE, PROTOCOL_TYPE PROTOCOL_TYPE, PROTOCOL_ADDRESS PROTOCOL_ADDRESS, USERNAME USERNAME, PASSWORD PASSWORD, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, PAYLOAD PAYLOAD, FIELD1 FIELD1, FIELD2 FIELD2, FIELD3 FIELD3, FIELD4 FIELD4, FIELD5 FIELD5, FIELD6 FIELD6, FIELD7 FIELD7, FIELD8 FIELD8, FIELD9 FIELD9, FIELD10 FIELD10, FIELD11 FIELD11, FIELD12 FIELD12, FIELD13 FIELD13, FIELD14 FIELD14, FIELD15 FIELD15, FIELD16 FIELD16, FIELD17 FIELD17, FIELD18 FIELD18, FIELD19 FIELD19, FIELD20 FIELD20, FIELD21 FIELD21, FIELD22 FIELD22, FIELD23 FIELD23, FIELD24 FIELD24, FIELD25 FIELD25, FIELD26 FIELD26, FIELD27 FIELD27, FIELD28 FIELD28, FIELD29 FIELD29, FIELD30 FIELD30, LOGFILE LOGFILE, INTERNAL_CONTROL_NUMBER INTERNAL_CONTROL_NUMBER, STATUS STATUS, DIRECTION DIRECTION, TIME_STAMP TIME_STAMP, OUT_MSGID OUT_MSGID, ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY, ACTIVITY_ID ACTIVITY_ID, EVENT_NAME EVENT_NAME, EVENT_KEY EVENT_KEY, ORIG_REFERENCE_ID ORIG_REFERENCE_ID, CB_EVENT_NAME CB_EVENT_NAME, CB_EVENT_KEY CB_EVENT_KEY, BLOCK_MODE BLOCK_MODE from "ECX"."ECX_DOCLOGS"

View Text - HTML Formatted

SELECT MSGID MSGID
, MESSAGE_TYPE MESSAGE_TYPE
, MESSAGE_STANDARD MESSAGE_STANDARD
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, PARTYID PARTYID
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_TYPE PARTY_TYPE
, PROTOCOL_TYPE PROTOCOL_TYPE
, PROTOCOL_ADDRESS PROTOCOL_ADDRESS
, USERNAME USERNAME
, PASSWORD PASSWORD
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, PAYLOAD PAYLOAD
, FIELD1 FIELD1
, FIELD2 FIELD2
, FIELD3 FIELD3
, FIELD4 FIELD4
, FIELD5 FIELD5
, FIELD6 FIELD6
, FIELD7 FIELD7
, FIELD8 FIELD8
, FIELD9 FIELD9
, FIELD10 FIELD10
, FIELD11 FIELD11
, FIELD12 FIELD12
, FIELD13 FIELD13
, FIELD14 FIELD14
, FIELD15 FIELD15
, FIELD16 FIELD16
, FIELD17 FIELD17
, FIELD18 FIELD18
, FIELD19 FIELD19
, FIELD20 FIELD20
, FIELD21 FIELD21
, FIELD22 FIELD22
, FIELD23 FIELD23
, FIELD24 FIELD24
, FIELD25 FIELD25
, FIELD26 FIELD26
, FIELD27 FIELD27
, FIELD28 FIELD28
, FIELD29 FIELD29
, FIELD30 FIELD30
, LOGFILE LOGFILE
, INTERNAL_CONTROL_NUMBER INTERNAL_CONTROL_NUMBER
, STATUS STATUS
, DIRECTION DIRECTION
, TIME_STAMP TIME_STAMP
, OUT_MSGID OUT_MSGID
, ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
, ACTIVITY_ID ACTIVITY_ID
, EVENT_NAME EVENT_NAME
, EVENT_KEY EVENT_KEY
, ORIG_REFERENCE_ID ORIG_REFERENCE_ID
, CB_EVENT_NAME CB_EVENT_NAME
, CB_EVENT_KEY CB_EVENT_KEY
, BLOCK_MODE BLOCK_MODE
FROM "ECX"."ECX_DOCLOGS"