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.

TypeDescription/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 StateValue
New_Record_Create
Modified_Record_Modify
Removed_Record_Remove
Queried_Record_NULL
Attribute typeValue
dt_Text T
dt_Text_Key TK
dt_Text_ReferenceTR
dt_Long_TextLT
dt_IntegerI
dt_Decimal DEC
dt_Money DEC
dt_Float N
dt_Date D
dt_TimeDT
dt_TimeStamp DTS
dt_AlphaA
dt_BinaryR.B64
dt_Long_Binary R.B64
dt_Enumeration ENUM
dt_Aggregate AGGREGATE
dt_Array ARRAY
dt_Reference REFERENCE
dt_Picture Picture Object