Custom object field types

Custom objects have one or more fields that store data associated with a custom object record. There is a maximum of 1024 fields allowed for a single custom object.

Custom object record fields can be one of the following types:

Field type	Description
Custom	Custom fields created and defined by your organization. These are fields that are not standard contact or account fields. Custom fields can be used to store the data required by your business needs. For example, on a purchase history custom object, there would be custom fields used to store information about the product (such as the product, purchase date, or serial number).
Contact or account	Standard contact or account fields. Adding these fields to a custom object allows you to draw a more complete profile of your liked contacts or accounts, and keep relevant data visible and consistent. For example, you could add the email address to your record making it easier to identify the custom object record and allowing you to update it whenever the custom object record is updated.
Form	Fields from a specified form.

Field type

Description

Custom

Custom fields created and defined by your organization. These are fields that are not standard contact or account fields.

Custom fields can be used to store the data required by your business needs. For example, on a purchase history custom object, there would be custom fields used to store information about the product (such as the product, purchase date, or serial number).

Contact or account

Standard contact or account fields.

Adding these fields to a custom object allows you to draw a more complete profile of your liked contacts or accounts, and keep relevant data visible and consistent. For example, you could add the email address to your record making it easier to identify the custom object record and allowing you to update it whenever the custom object record is updated.

Form

Fields from a specified form.

Data types

Every custom fields has a data type that identifies the kind of data that the field stores.

The following data types are supported:

Data type	Support input field types	Description
Text	Textbox Text area Single select picklist Check box	Supports strings up to a maximum of 250 characters
Large text	Text area	Supports strings up to a maximum of 32,000 characters. Note that Insight does not support reporting of Large text data.
Date / Time	Textbox Text area Single select picklist Check box	Date and time field. You can specify the format for the data type.
Number	Textbox Text area Single select picklist Check box	Positive integer. Decimals and negative numbers are not allowed. You can specify the format for the data type.
Numeric	Textbox Text area Single select picklist Check box	Decimal numbers (up to 4 digits). You can specify the format for the data type.

Note: For a custom object record field, the default value can be a maximum of 100 characters.

Supported date formats

Format	Example
d/M/yyyy	21/2/2018
dd/MM/yy	21/02/18
dd/MM/yyyy	21/02/2018
dddd	Wednesday
dddd MMMM d, yyyy	Wednesday February 21, 2018
h.mm.ss	3.11.05
h:mm:ss tt	3:11:05 PM
HH tt	15 PM
HH.mm.ss	15.11.05
HH:mm	15:11
HH:mm:ss	15:11:05
M.d.yyyy	2.21.2018
M/d/yyyy	2/21/2018
MM/dd/yyyy	02/21/18
MM/dd/yyyy HH:mm:ss	02/21/2018 15:11:05
MM/dd/yyyy	02/21/2018
MMM d, yyyy	Feb 21, 2018
MMMM d, yyyy	February 21, 2018
MMM d, yyyy	Feb 21, 2018
MMMM, yyyy	February, 2018
yyyy-MM-dd HH:mm:ss.fff	2018-02-21 15:11:05.568

Learn more

Events

Oracle University: Integrating Custom Objects with Campaign Canvas

Oracle University: Effective Marketing with Custom Objects

Knowledge Base: How to Find the ID of a Custom Object (Formerly "Custom Data Object" and "CDO")