Table AJPPA

Definition of table: AJPPA - jobplan after (archived)

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

AE Database 11.2 (Step 018)

Name Type Len Attributes Description

AJPPA_AH_Idnr Long Integer 4 UC: Null=False reference to the archive header (AH)

AJPPA_AJPP_Lnr Integer 2 UC: Null=False reference to the jobplan process (AJPP)

AJPPA_Lnr Integer 2 UC: Null=False ascending number of the jobplan after

AJPPA_PreLnr Integer 2 UC: Null=False ascending number of the precondition

AJPPA_LineDef Text 255 UC: Null=True desctiption of the line: aaa/bbb/c/d;.... aaa=row bbb=column c=position in the job d=option (line width)

AJPPA_When Text 30 UC: Null=True when precondition

AJPPA_Status Long Integer 4 UC: Null=True state of the precondition

AJPPA_Name Text 32 UC: Null=True Name of the line

AJPPA_BranchType Integer 2 UC: Null=True position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath

Name	Type	Len	Attributes	Description
AJPPA_AH_Idnr	Long Integer	4	UC: Null=False	reference to the archive header (AH)
AJPPA_AJPP_Lnr	Integer	2	UC: Null=False	reference to the jobplan process (AJPP)
AJPPA_Lnr	Integer	2	UC: Null=False	ascending number of the jobplan after
AJPPA_PreLnr	Integer	2	UC: Null=False	ascending number of the precondition
AJPPA_LineDef	Text	255	UC: Null=True	desctiption of the line: aaa/bbb/c/d;.... aaa=row bbb=column c=position in the job d=option (line width)
AJPPA_When	Text	30	UC: Null=True	when precondition
AJPPA_Status	Long Integer	4	UC: Null=True	state of the precondition
AJPPA_Name	Text	32	UC: Null=True	Name of the line
AJPPA_BranchType	Integer	2	UC: Null=True	position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath

Indexes:

Name Fields

PK_AJPPA AJPPA_AH_Idnr, AJPPA_AJPP_Lnr, AJPPA_Lnr

Name	Fields
PK_AJPPA	AJPPA_AH_Idnr, AJPPA_AJPP_Lnr, AJPPA_Lnr

Return to the Index File