Database Items applies to items in the Database Items (dbitems) table. The table contains definitions for:
|
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
|
