Definition of table: MQ2PWP - Work Queue

generated: 12.12.2016 18:34:10
by UC2010.accdb

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
MQPWP_PK Long Integer 4 UC: Null=False Typ=Auto Primary Key
MQPWP_System Text 8 UC: Null=True UC4 System Name
MQPWP_CAddr Text 32 UC: Null=True Call Address
MQPWP_CSRName Text 8 UC: Null=True Call Routine Name
MQPWP_CAcv Long Integer 4 UC: Null=True Call ACV
MQPWP_BAddr Text 32 UC: Null=True Back Address
MQPWP_BSRName Text 8 UC: Null=True Back Routine Name
MQPWP_BAcv Long Integer 4 UC: Null=True Back ACV
MQPWP_FAddr Text 32 UC: Null=True From Address
MQPWP_LogAddr Text 32 UC: Null=True Logical Address
MQPWP_PhysAddr Text 32 UC: Null=True Physical Address
MQPWP_BTable Text 8 UC: Null=True Back Table (MQCP001, MQCP002...)
MQPWP_SchedTime Date/Time 8 UC: Null=True Scheduling Time
MQPWP_Status Long Integer 4 UC: Null=True Status (0=not sended, 1=sended)
MQPWP_Priority Long Integer 4 UC: Null=True Priority (0=high, 255=low)
MQPWP_DRole Text 32 UC: Null=True Destination Role (e.g. "*PRIMARY")
MQPWP_LAddr Text 32 UC: Null=True Server processes this message now
MQPWP_Len Long Integer 4 UC: Null=True Length
MQPWP_Msg Memo 0 UC: Typ=blob L=0 Null=True inlinelength=30000 db2lobsize=128_M Message Content


Indexes:

Name Fields
NK_MQ2PWP_Prio MQPWP_Priority, MQPWP_SchedTime, MQPWP_PK
NK_MQ2PWP_SchTime MQPWP_SchedTime
PK_MQ2PWP MQPWP_PK


Return to the Index File