Definition of table: AJPPO - Conditions/Actions Link

generated: 12.12.2016 18:33:11
by UC2010.accdb

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
AJPPO_AH_Idnr Long Integer 4 UC: Null=False reference to the archive header (AH) (RunID)
AJPPO_AJPP_Lnr Integer 2 UC: Null=False ascending number of the jobplan process (Task Lnr)
AJPPO_Location Integer 2 UC: Null=False 1=Pre, 2=Post
AJPPO_Lnr Integer 2 UC: Null=False ascending number of conditions in a workflow-task
AJPPO_CarName Text 32 UC: Null=True Name of the Condition/Action
AJPPO_Type Text 1 UC: Null=True Type Condition/Action or structure info (C=Condition, A=Action, E=ELSE, F=ENDIF)
AJPPO_Active Byte 1 UC: Null=True Typ=Boolean 0=inactive, 1=active
AJPPO_Once Byte 1 UC: Null=True Typ=Boolean 0=every, 1=ONCE
AJPPO_Status Integer 2 UC: Null=True Status of Condition/Action
AJPPO_Count Long Integer 4 UC: Null=True Counter how often the conditions was checked/actions was taken
AJPPO_UIInfo Memo 0 UC: L=0 Null=True Typ=CLOB User field for UI


Indexes:

Name Fields
PK_AJPPO AJPPO_AH_Idnr, AJPPO_AJPP_Lnr, AJPPO_Location, AJPPO_Lnr


Return to the Index File