Home > Technical > Table Definitions > USERDEFVALUE

USERDEFVALUE

This table stores the actual values entered by users for user defined fields.

Column

Type

Description

STRFUNCTION

VARCHAR(10)

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

STRKEY

VARCHAR(20)

The identifying value – item number for ITEM entries, trade code for LOCATION entries and so on.

INTCODE

INT

Maps to the CTRCODE in USERDEFFIELD.
USERDEFFIELD.ctrCode

STRVALUE

VARCHAR(2048)

Specific value of this field as a string (may be null depend-ing on data type). If the data type was actually a date or a number, the value will be stored in DTMVALUE or DBLVALUE.

DTMVALUE

DATETIME

Specific value of this field as a date time (may be null de-pending on data type).

DBLVALUE

DECIMAL(19,4)

Specific value of this field as a number (may be 0 depend-ing on data type).

 

Primary Key: STRFUNCTION + STRKEY + INTCODE

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