Choosing the correct data type

The choice of data type for a new attribute depends on the nature of the data itself, and how that data is used. Some choices are obvious – dates and times, for example – but others require some additional consideration.

The data type identifies the type of data stored by the attribute. The following data types are available:

Use the data type...

to represent...

Attachment

that you want to add attachments to this object. For example, you can attach a document to a business object. If you want to store more than one attachment in this attribute when you use Web Access, set the Attachment Type to Multiple Attachments.

For information about restricting the types of file that can be attached by using a whitelist, see Creating an instance.

Boolean

Yes/No, True/False, and On/Off values.

DateTime

Dates and times.

Decimal

decimal values between -9999999999.99999 and +9999999999.99999.

GUID

a unique identification number used by the Service Desk Framework. This is automatically generated and cannot be modified.

Int 16

signed integers with values ranging from negative 32768 through positive 32767.

Int 32

signed integers with values ranging from negative 2,147,483,648 through positive 2,147,483,647.

Object

the type of relationship. This does not apply when you create new attributes, only when you are linking business objects together.

String

sequences of characters, like sentences. 0 to approximately 2 000 000 000 characters (depending on your database platform).