ContactField
Retrieve Contact Fields.
Table Specific Information
The EmailAddress column is required to INSERT INTO or to update the Contact table. For example,
UPDATE [Contact] SET emailAddress = '[email protected]', firstName = 'test' WHERE ID = ?
Columns
Name | Type | Description |
ID [KEY] | Long | The unique identifier for the contact field. |
Name | String | The name of the contact field. |
UpdateType | String | The update rule for when to update this field. |
CheckedValue | String | The checked value of the contact field. |
DataType | String | The data type of the contact field. |
DefaultValue | String | The default value for the contact field. |
Description | String | The description of the contact field. |
DisplayType | String | The display type of the contact field. |
FolderId | Long | The folder Id of the contact field. |
InternalName | String | The country of the contact field. |
IsReadOnly | Boolean | Identifies whether the contact field is read-only. |
IsRequired | Boolean | Identifies whether the contact field is required. |
IsStandard | Boolean | Identifies whether the contact field is standard. |
OptionListId | Long | The Id of the option list for the contact field. |
OutputFormatId | Long | The Id of the output format for the contact field. |
ScheduledFor | String | The date and time scheduled for the contact field. |
SourceTemplatedId | Long | The Id of the source template for the contact field |
UncheckedValue | String | The unchecked value of the contact field. |
Permissions | String | The permissions of the contact field. |
CreatedAt | Datetime | Date the contact field was created. |
CreatedBy | String | The Id of the user who created the contact field. |
AccessedAt | Datetime | Date the contact field was accessed. |
CurrentStatus | String | The current status of the contact field. |
Depth | String | The depth of the contact field. |
UpdatedAt | Datetime | Date the contact field was updated. |
UpdatedBy | String | The Id of the user who last updated the contact field. |