Definition of table: MQ1WP - Work Queue

generated: 09.12.2016 10:28:08
by UC2010.accdb

AE Database 12.0 (Step 013)



Name Type Len Attributes Description
MQWP_PK Long Integer 4 UC: Null=False Typ=Auto Primary Key
MQWP_System Text 8 UC: Null=True UC4 System Name
MQWP_CAddr Text 32 UC: Null=True Call Address
MQWP_CSRName Text 8 UC: Null=True Call Routine Name
MQWP_CAcv Long Integer 4 UC: Null=True Call ACV
MQWP_BAddr Text 32 UC: Null=True Back Address
MQWP_BSRName Text 8 UC: Null=True Back Routine Name
MQWP_BAcv Long Integer 4 UC: Null=True Back ACV
MQWP_FAddr Text 32 UC: Null=True From Address
MQWP_LogAddr Text 32 UC: Null=True Logical Address
MQWP_PhysAddr Text 32 UC: Null=True Physical Address
MQWP_BTable Text 8 UC: Null=True Back Table (MQCP001, MQCP002...)
MQWP_SchedTime Date/Time 8 UC: Null=True Scheduling Time
MQWP_Status Long Integer 4 UC: Null=True Status (0=not sended, 1=sended)
MQWP_Priority Long Integer 4 UC: Null=True Priority (0=high, 255=low)
MQWP_DRole Text 32 UC: Null=True Destination Role (e.g. "*PRIMARY")
MQWP_LAddr Text 32 UC: Null=True Server processes this message now
MQWP_Len Long Integer 4 UC: Null=True Length
MQWP_Msg Memo 0 UC: Typ=blob L=0 Null=True inlinelength=30000 db2lobsize=128_M Message Content


Indexes:

Name Fields
NK_MQ1WP_Prio MQWP_Priority, MQWP_SchedTime, MQWP_PK
NK_MQ1WP_SchTime MQWP_SchedTime
PK_MQ1WP MQWP_PK


Return to the Index File