Fields

Defines the data elements used in entity sets, relationships, and structured documents.

A field is a data object representing one data element from a record in the associated data object (entity set, relationship, or structured document). The Fields entity set describes the attributes of the individual data elements that make up a record in the associated data object. The EntitySets, Relationships, and Documents entity sets describe the data objects themselves.

Establishing a Field

Since Fields are data elements belonging either to an entity set, a relationship or a structured document, refer to the procedures used to establish these objects.

Fields of the Fields Entity Set

Attributes

Description

SN

Identification number for the field

FieldName

Name of the field

OwnerName

Name of the object that "owns" the field

Type

Data type of the field's value

Length

Maximum length of the field's value

Decimals

Number of decimals in a numeric field's value

Reqd

Required status of the field

Index   

Index status of the field

Virtual

Virtual status of the field

ListWidth

Width of the field on output

FieldHeading

Heading for the field on output

FieldMask

Output mask for the field

Default

Default value for the field

BWSel, EQSel, LGSel

Index selectivity factors for the field

DirName

Application directory location of field

RemoteName

Name of the field in the remote location

ModTime

A time stamp indicating when it was created

ObjectKey

A unique identifier assigned by the Development Center