Home > Technical > Table Definitions > USERDEFFIELD

USERDEFFIELD

This table records any used defined fields that have been added to the system as part of User Defined Fields functionality.

Column

Type

Description

CTRCODE

INT

A unique number assigned by the system to identify the record.

STRFUNCTION

VARCHAR(10)

Indicates which function this user defined field is for. CUSTOMER, ITEM, LOCATION, SUPPLIER, USER.

STRNAME

VARCHAR(20)

The name of the field. This is the name assigned by the user so they can easily identify the control.

INTSEQUENCE

INT

The sequence in which the fields should be created (controls the tab order).

INTFIELDTYPE

INT

Indicates the type of control.

0  

Edit box

1  

Date entry

2  

Combo box

3  

Check box

4  

Memo

5  

Label

INTLEFT

INT

Position of left hand side of control (pixels).

INTTOP

INT

Position of top of control (pixels).

INTWIDTH

INT

The width (in pixels) of the control.

INTHEIGHT

INT

The height (in pixels) of the control.

STRLABEL

VARCHAR(255)

Descriptive label identifying the field to be shown.

INTDATATYPE

INT

Indicates the type of data (used when INTFIELDTYPE = 0)

0  

String value. If field type = 0 and data  type is not 0 then the data entered is stored in the DBLVALUE field else it’s stored in the STRVALUE field in USERDEFVALUE.

1  

Integer

2  

Number with 1 decimal place.

3  

Number with 2 decimal places.

INTMAXLENGTH

INT

The maximum length of data allowed for the value.

MEMCOMBOITEMS

TEXT

A list of the items to appear in the drop-down list. This represents a StringList.Text where each entry would be on a separate line in the StringList.

STRDEFAULT

VARCHAR(255)

The default value for this control.

YSNDELETED

VARCHAR(1)

True if the field has been deleted.

 

Primary Key: CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)