JDBC Driver for Highrise

Build 22.0.8462

DealCategories

Create, update, delete, and query Deal Categories.

Table Specific Information

Insert

To insert a new Deal Category, at least a Category Name and a Color must be provided.

INSERT INTO DealCategories (Name, Color) VALUES ('A unique deal category', '5df4b5')  

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

The unique identifier for the category.

Name String False

The name of the category.

Color String False

The color as a hex value.

AccountId Integer True

A reference to the account.

ElementsCount Integer True

The number of elements in the category.

CreatedAt Datetime True

The date and time when this record was created.

UpdatedAt Datetime True

The date and time when this record was last updated.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462