[Home] [Help] [Dependency Information]
Object Name: | ECX_DOCLOGS# |
---|---|
Object Type: | VIEW |
Owner: | ECX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSGID | RAW | (16) | Yes | |
MESSAGE_TYPE | VARCHAR2 | (100) | ||
MESSAGE_STANDARD | VARCHAR2 | (100) | ||
TRANSACTION_TYPE | VARCHAR2 | (100) | ||
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | ||
DOCUMENT_NUMBER | VARCHAR2 | (256) | ||
PARTYID | VARCHAR2 | (256) | ||
PARTY_SITE_ID | VARCHAR2 | (256) | ||
PARTY_TYPE | VARCHAR2 | (30) | ||
PROTOCOL_TYPE | VARCHAR2 | (500) | ||
PROTOCOL_ADDRESS | VARCHAR2 | (2000) | ||
USERNAME | VARCHAR2 | (500) | ||
PASSWORD | VARCHAR2 | (500) | ||
ATTRIBUTE1 | VARCHAR2 | (500) | ||
ATTRIBUTE2 | VARCHAR2 | (500) | ||
ATTRIBUTE3 | VARCHAR2 | (500) | ||
ATTRIBUTE4 | VARCHAR2 | (500) | ||
ATTRIBUTE5 | VARCHAR2 | (500) | ||
PAYLOAD | CLOB | (4000) | ||
FIELD1 | VARCHAR2 | (2000) | ||
FIELD2 | VARCHAR2 | (2000) | ||
FIELD3 | VARCHAR2 | (2000) | ||
FIELD4 | VARCHAR2 | (2000) | ||
FIELD5 | VARCHAR2 | (2000) | ||
FIELD6 | VARCHAR2 | (2000) | ||
FIELD7 | VARCHAR2 | (2000) | ||
FIELD8 | VARCHAR2 | (2000) | ||
FIELD9 | VARCHAR2 | (2000) | ||
FIELD10 | VARCHAR2 | (2000) | ||
FIELD11 | VARCHAR2 | (2000) | ||
FIELD12 | VARCHAR2 | (2000) | ||
FIELD13 | VARCHAR2 | (2000) | ||
FIELD14 | VARCHAR2 | (2000) | ||
FIELD15 | VARCHAR2 | (2000) | ||
FIELD16 | VARCHAR2 | (2000) | ||
FIELD17 | VARCHAR2 | (2000) | ||
FIELD18 | VARCHAR2 | (2000) | ||
FIELD19 | VARCHAR2 | (2000) | ||
FIELD20 | VARCHAR2 | (2000) | ||
FIELD21 | VARCHAR2 | (2000) | ||
FIELD22 | VARCHAR2 | (2000) | ||
FIELD23 | VARCHAR2 | (2000) | ||
FIELD24 | VARCHAR2 | (2000) | ||
FIELD25 | VARCHAR2 | (2000) | ||
FIELD26 | VARCHAR2 | (2000) | ||
FIELD27 | VARCHAR2 | (2000) | ||
FIELD28 | VARCHAR2 | (2000) | ||
FIELD29 | VARCHAR2 | (2000) | ||
FIELD30 | VARCHAR2 | (2000) | ||
LOGFILE | VARCHAR2 | (80) | ||
INTERNAL_CONTROL_NUMBER | NUMBER | |||
STATUS | VARCHAR2 | (256) | ||
DIRECTION | VARCHAR2 | (240) | ||
TIME_STAMP | DATE | |||
OUT_MSGID | RAW | (16) | ||
ITEM_TYPE | VARCHAR2 | (8) | ||
ITEM_KEY | VARCHAR2 | (240) | ||
ACTIVITY_ID | NUMBER | |||
EVENT_NAME | VARCHAR2 | (240) | ||
EVENT_KEY | VARCHAR2 | (240) | ||
ORIG_REFERENCE_ID | VARCHAR2 | (240) | ||
CB_EVENT_NAME | VARCHAR2 | (240) | ||
CB_EVENT_KEY | VARCHAR2 | (240) | ||
BLOCK_MODE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT MSGID
, MESSAGE_TYPE
, MESSAGE_STANDARD
, TRANSACTION_TYPE
, TRANSACTION_SUBTYPE
, DOCUMENT_NUMBER
, PARTYID
, PARTY_SITE_ID
, PARTY_TYPE
, PROTOCOL_TYPE
, PROTOCOL_ADDRESS
, USERNAME
, PASSWORD
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, PAYLOAD
, FIELD1
, FIELD2
, FIELD3
, FIELD4
, FIELD5
, FIELD6
, FIELD7
, FIELD8
, FIELD9
, FIELD10
, FIELD11
, FIELD12
, FIELD13
, FIELD14
, FIELD15
, FIELD16
, FIELD17
, FIELD18
, FIELD19
, FIELD20
, FIELD21
, FIELD22
, FIELD23
, FIELD24
, FIELD25
, FIELD26
, FIELD27
, FIELD28
, FIELD29
, FIELD30
, LOGFILE
, INTERNAL_CONTROL_NUMBER
, STATUS
, DIRECTION
, TIME_STAMP
, OUT_MSGID
, ITEM_TYPE
, ITEM_KEY
, ACTIVITY_ID
, EVENT_NAME
, EVENT_KEY
, ORIG_REFERENCE_ID
, CB_EVENT_NAME
, CB_EVENT_KEY
, BLOCK_MODE
FROM ECX.ECX_DOCLOGS#;
|
|
|