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 |