Table UC_SVALM

Definition of table: UC_SVALM - System Value: Map Attribute name to DB Field

generated: 09.12.2016 10:29:06
by UC2010.accdb

AE Database 12.0 (Step 013)

Name Type Len Attributes Description

SVALM_SVAL_VName Text 32 UC: Null=False Variable name of the system value. The prefix has to be '&$'

SVALM_OType Text 8 UC: Null=False Object type for which the system value is valid.

SVALM_HostAttrType Text 8 UC: Null=False For Chooser, Different Platforms have different System Values/Attributes

SVALM_SubType Text 2 UC: Null=False Sub Type R3-Job and EVNT

SVALM_AttName Text 64 UC: Null=False Attribute name (PUT/GET_ATT)

SVALM_SecureLevel Integer 2 UC: Null=True Level for security check (SQL)

SVALM_AttType Text 2 UC: Null=True Attribute Type describes how the field has to be processed (GET_ATT) (B: Boolean,I: Integer, L: Lookup in UC_SVALV, P: Hardcoded in program, S: String,0: GET_ATT not allowed)

SVALM_Evaluation Text 2 UC: Null=True Describes how the input for PUT_ATT has to be evaluated. (B: Boolean, I: Integer, L/LI/LS: Lookup in UC_SVALV, P: Hardoced in program, S: String, 0: PUT_ATT not allowed)

SVALM_DefVal Text 8 UC: Null=True Default Values if RestId-Key not found in RestId field

SVALM_MinVal Long Integer 4 UC: Null=True Allowed min-value for PUT_ATT

SVALM_MaxVal Long Integer 4 UC: Null=True Allowed Max-value for PUT_ATT

SVALM_CorrMinMax Byte 1 UC: Typ=Boolean Null=True Adjust value to Min/Max if it's out of bounds (PUT_ATT)

SVALM_UCase Byte 1 UC: Typ=Boolean Null=True Store value case-insensitive in UpperCase (PUT_ATT)

SVALM_AttDBFName Text 18 UC: Null=True Database Reference of the Attribute

SVALM_RestID Text 1 UC: Null=True Restfeld ID in case of Attribute in EH_REST

SVALM_DisplayMsgNr Long Integer 4 UC: Null=True MsgNr for Display name (text without format)

SVALM_DescrMsgNr Long Integer 4 UC: Null=True MsgNr for description text

SVALM_VarChange Byte 1 UC: Typ=Boolean Null=True Do varchange for this attribute

SVALM_Rev Byte 1 UC: Typ=Boolean Null=True Add this attribute to revision log

Name	Type	Len	Attributes	Description
SVALM_SVAL_VName	Text	32	UC: Null=False	Variable name of the system value. The prefix has to be '&$'
SVALM_OType	Text	8	UC: Null=False	Object type for which the system value is valid.
SVALM_HostAttrType	Text	8	UC: Null=False	For Chooser, Different Platforms have different System Values/Attributes
SVALM_SubType	Text	2	UC: Null=False	Sub Type R3-Job and EVNT
SVALM_AttName	Text	64	UC: Null=False	Attribute name (PUT/GET_ATT)
SVALM_SecureLevel	Integer	2	UC: Null=True	Level for security check (SQL)
SVALM_AttType	Text	2	UC: Null=True	Attribute Type describes how the field has to be processed (GET_ATT) (B: Boolean,I: Integer, L: Lookup in UC_SVALV, P: Hardcoded in program, S: String,0: GET_ATT not allowed)
SVALM_Evaluation	Text	2	UC: Null=True	Describes how the input for PUT_ATT has to be evaluated. (B: Boolean, I: Integer, L/LI/LS: Lookup in UC_SVALV, P: Hardoced in program, S: String, 0: PUT_ATT not allowed)
SVALM_DefVal	Text	8	UC: Null=True	Default Values if RestId-Key not found in RestId field
SVALM_MinVal	Long Integer	4	UC: Null=True	Allowed min-value for PUT_ATT
SVALM_MaxVal	Long Integer	4	UC: Null=True	Allowed Max-value for PUT_ATT
SVALM_CorrMinMax	Byte	1	UC: Typ=Boolean Null=True	Adjust value to Min/Max if it's out of bounds (PUT_ATT)
SVALM_UCase	Byte	1	UC: Typ=Boolean Null=True	Store value case-insensitive in UpperCase (PUT_ATT)
SVALM_AttDBFName	Text	18	UC: Null=True	Database Reference of the Attribute
SVALM_RestID	Text	1	UC: Null=True	Restfeld ID in case of Attribute in EH_REST
SVALM_DisplayMsgNr	Long Integer	4	UC: Null=True	MsgNr for Display name (text without format)
SVALM_DescrMsgNr	Long Integer	4	UC: Null=True	MsgNr for description text
SVALM_VarChange	Byte	1	UC: Typ=Boolean Null=True	Do varchange for this attribute
SVALM_Rev	Byte	1	UC: Typ=Boolean Null=True	Add this attribute to revision log

Indexes:

Name Fields

PK_SVALM SVALM_SVAL_VName, SVALM_OType, SVALM_HostAttrType, SVALM_SubType, SVALM_AttName

Name	Fields
PK_SVALM	SVALM_SVAL_VName, SVALM_OType, SVALM_HostAttrType, SVALM_SubType, SVALM_AttName

Return to the Index File