Difference between revisions of "IX.ORDERS QUEUETABLE (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 200: Line 200:
 
| SYS_C005059
 
| SYS_C005059
 
| MSGID
 
| MSGID
|}
 
 
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Dependency Type
 
| '''Object Type
 
| '''Referenced Object
 
 
|- valign="top"
 
| Data Type
 
| Type
 
| [[IX.ORDER_EVENT_TYP_(type)|IX.ORDER_EVENT_TYP]]
 
 
 
|}
 
|}

Latest revision as of 10:34, 27 August 2011

wikibot[edit]

Table IX.ORDERS_QUEUETABLE

Columns[edit]

Column Data Type Nullable Default Description
Q_NAME VARCHAR2(30) null
MSGID RAW(16) not null
CORRID VARCHAR2(128) null
PRIORITY NUMBER null
STATE NUMBER null
DELAY TIMESTAMP(6) null
EXPIRATION NUMBER null
TIME_MANAGER_INFO TIMESTAMP(6) null
LOCAL_ORDER_NO NUMBER null
CHAIN_NO NUMBER null
CSCN NUMBER null
DSCN NUMBER null
ENQ_TIME TIMESTAMP(6) null
ENQ_UID VARCHAR2(30) null
ENQ_TID VARCHAR2(30) null
DEQ_TIME TIMESTAMP(6) null
DEQ_UID VARCHAR2(30) null
DEQ_TID VARCHAR2(30) null
RETRY_COUNT NUMBER null
EXCEPTION_QSCHEMA VARCHAR2(30) null
EXCEPTION_QUEUE VARCHAR2(30) null
STEP_NO NUMBER null
RECIPIENT_KEY NUMBER null
DEQUEUE_MSGID RAW(16) null
SENDER_NAME VARCHAR2(30) null
SENDER_ADDRESS VARCHAR2(1024) null
SENDER_PROTOCOL NUMBER null
USER_DATA IX.ORDER_EVENT_TYP null
USER_PROP SYS.ANYDATA null

Primary Key[edit]

Primary Key Columns
SYS_C005059 MSGID