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. |
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 |
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")