Table 2: Data types - HxGN EAM - 12.0 - Customization & Programming - Hexagon

HxGN EAM Connector Grid Services

Language
English
Product
HxGN EAM
Search by Category
Customization & Programming
HxGN EAM Version
12

Name

SQL type

Description

VARCHAR

VARCHAR

All values are in upper case, e.g., all codes are in upper case in the system

MIXVARCHAR

VARCHAR

Value could be in mixed case, e.g., Description

NUMBER

NUMBER

Value is a number

LONG

NUMBER

Value is a java long number

CURRENCY

NUMBER

Value is a currency

DECIMAL

NUMBER

Value is a java double. Can have decimals

DURATION

NUMBER

Value is duration in minutes since an event

DATE, DATETIME

DATE

Date / datetime