Database Items

최근 업데이트 : Nov 21, 2024 |

Database Items applies to items in the Database Items (dbitems) table. The table contains definitions for:

  • Dictionary standard and custom database items

  • Constants

  • Calculations

Database item

Description

Data type

Column type

Length

DESCR

The description of the database calculation, constant, or database item.

A

char(150) - ASCII text string

(Only first 50 are significant)

150 bytes

ITEM_TYPE (index)

The type of data for the row. Valid values are: dbase = database item

calc = calculation

constant = constant

cust_def = customer-defined database item

A

char(8) - ASCII text string

8 bytes

ITEM_NAME (index)

The name of the data item. There can be many ITEM_NAMEs for a specific ITEM_TYPE.

A

char(60) - ASCII text string

(Only first 20 are significant)

60 bytes

FORMULA

The formula for the database constant or calculation.

A

char(70) - ASCII text string

70 bytes

STANDARD

This item indicates if the item is a standard or custom database item. Values are:

1 = standard, not 1 (null) = custom.

A

smallint

2 bytes