Table AV

Definition of table: AV - object values (archived)

generated: 09.12.2016 10:27:01
by UC2010.accdb

AE Database 12.0 (Step 013)

Name Type Len Attributes Description

AV_AH_Idnr Long Integer 4 UC: Null=False Reference to AH

AV_VName Text 32 UC: Null=False Value Name

AV_Value Memo 0 UC: Typ=clob L=0 Null=True inlinelength=30000 Value

AV_Source Integer 2 UC: Null=True Value's source (0 own, 1 parent, 2 modified during runtime)

AV_SortOrder Integer 2 UC: Null=True Sort order

AV_ERTUsage Integer 2 UC: Null=True Defines how this value is used in ERT calculation (0=No ERT usage, 1=Nominal, 2=Numeric, 3=Timestamp, 4=Date, 5=Time)

Name	Type	Len	Attributes	Description
AV_AH_Idnr	Long Integer	4	UC: Null=False	Reference to AH
AV_VName	Text	32	UC: Null=False	Value Name
AV_Value	Memo	0	UC: Typ=clob L=0 Null=True inlinelength=30000	Value
AV_Source	Integer	2	UC: Null=True	Value's source (0 own, 1 parent, 2 modified during runtime)
AV_SortOrder	Integer	2	UC: Null=True	Sort order
AV_ERTUsage	Integer	2	UC: Null=True	Defines how this value is used in ERT calculation (0=No ERT usage, 1=Nominal, 2=Numeric, 3=Timestamp, 4=Date, 5=Time)

Indexes:

Name Fields

PK_AV AV_AH_Idnr, AV_VName

Name	Fields
PK_AV	AV_AH_Idnr, AV_VName

Return to the Index File