Skip to content

Data types and constants

All attribute (dt_<Type>) types are of type CONSTANT VARCHAR2. The attribute types corresponds to IFS Application Server attribute types.

The record state types are of type CONSTANT VARCHAR2. The states corresponds to the IFS Application Server record states.

Type Description/use
type_record_ Foundation1 record.
type_value_ Attribute value data type.
type_name_ Attribute name data type.
type_type_ Attribute type data type.
type_status_ Attribute status data type.
type_domain_ Domain data type..
type_trace_file_ Trace file data type.
Record State Value
New_Record_ Create
Modified_Record_ Modify
Removed_Record_ Remove
Queried_Record_ NULL
Attribute type Value
dt_Text  T
dt_Text_Key  TK
dt_Text_Reference TR
dt_Long_Text LT
dt_Integer I
dt_Decimal  DEC
dt_Money  DEC
dt_Float  N
dt_Date  D
dt_Time DT
dt_TimeStamp  DTS
dt_Alpha A
dt_Binary R.B64
dt_Long_Binary  R.B64
dt_Enumeration  ENUM
dt_Aggregate  AGGREGATE
dt_Array  ARRAY
dt_Reference  REFERENCE
dt_Picture  Picture Object