osobjfields

The column list comes from the schema dump; the column meanings were derived from the <field> structure of the object definition XML. A few columns remain marked as unknown here.

Part of the DMS object definition (see DMSObjDef, element <field>). Holds one entry per index field of an object type with the internal field name, data type, flags, layout position and the mapping to the corresponding column of the stammX/registerX/objectX table.

1. Columns

Name Type Length Description

osguid

nvarchar

32

External GUID of the field (os_guid attribute in the XML).

object_id

int

—

Reference to the object type (osobjdef.object_id) the field belongs to.

process_id

int

—

Process ID of the parent object type (matches osobjdef.process_id).

vertix_id

int

—

Vertix ID of the parent object type (matches osobjdef.vertix_id).

name

nvarchar

255

Display field name in the default language (name attribute in the XML).

fieldname

nvarchar

100

Column name in the corresponding database table (e.g. feld1, zahl1, datum1, list1). Empty for container controls (e.g. pagecontrol).

type

nvarchar

1

Data type code of the field (dt attribute in the XML, see field data types). Examples: A, X = text; D = date; I, 9 = integer; # = decimal; W = table field.

init

nvarchar

100

Initialisation expression or value (init attribute in the XML).

prnalias

nvarchar

100

Print label / report alias (prnalias attribute in the XML).

flags

int

—

Field flags (bitmask; flags attribute in <flags> of the XML).

flags1

int

—

Extended field flags 1 (flags1 attribute in <flags>).

flags2

int

—

Extended field flags 2 (flags2 attribute in <flags>).

inp_left

int

—

Position of the input field in the mask: left edge (<input_pos left>).

inp_top

int

—

Position of the input field in the mask: top edge (<input_pos top>).

inp_right

int

—

Position of the input field in the mask: right edge (<input_pos right>).

inp_bottom

int

—

Position of the input field in the mask: bottom edge (<input_pos bottom>).

inp_len

int

—

Maximum input length in characters (input_length in <flags>).

field_left

int

—

Position of the field label in the mask: left edge (<field_pos left>).

field_top

int

—

Position of the field label in the mask: top edge (<field_pos top>).

field_right

int

—

Position of the field label in the mask: right edge (<field_pos right>).

field_bottom

int

—

Position of the field label in the mask: bottom edge (<field_pos bottom>).

tab_order

int

—

Tab order in the input mask (taborder attribute in the XML).

osconfid

int

—

Unknown.

multifield

smallint

—

1 = multi-parameter field (multifield attribute in <flags>).

internalname

nvarchar

100

Internal field name (internal attribute in the XML). Used in the DMS API as internal_name.

tooltip

nvarchar

248

Tooltip text (tooltip attribute in the XML).

classstring

nvarchar

128

CSS class identifier for UI control (classstring attribute in the XML).

pageid

nvarchar

32

GUID of the tab page on which the field is placed — empty if the field sits directly on the main mask.

searchgroupname

nvarchar

255

Name of a search group the field belongs to (searchgroupname attribute).

regexp

nvarchar

max

Regular expression for input validation (regularexpression attribute).

2. Related Tables

  • osobjdef — object types object_id refers to.

  • osctrlpages — tab pages pageid refers to.

  • oslistctrl — column definitions for table fields (type = W).