ODBC Driver for Highrise

Build 24.0.9062

Deals

Create, update, delete, and query Highrise Deals. This table is dynamic.

テーブル固有の情報

Select

Datetime カラムでは、WHERE 句にて'>'、および'>=' の演算子だけがサポートされています。次のクエリは、指定された日の後に更新されたDeal を取得します。

SELECT * FROM Deals WHERE UpdatedAt > '2012-01-12'

Insert

新しいDeal の作成には、Name、CategoryId、Background、Currency、Price、PriceType、Duration、およびPartyId が必須です。

INSERT INTO Deals (Name, CategoryId, Background, Currency, Price, PriceType, Duration, PartyId) VALUES ('deal with someone', 4195389, 'black', 'usd', 500, 'fixed', 123545, 149760370)  

Columns

Name Type ReadOnly References Description
Id [KEY] Integer False

The Id column for the table Deals.

Name String False

The Name column for the table Deals.

AccountId Integer False

The AccountId column for the table Deals.

AuthorId Integer False

The AuthorId column for the table Deals.

Background String False

The Background column for the table Deals.

CategoryId Integer False

The CategoryId column for the table Deals.

Currency String False

The Currency column for the table Deals.

Duration Integer False

The Duration column for the table Deals.

VisibleTo String False

The VisibleTo column for the table Deals.

GroupId String False

The GroupId column for the table Deals.

OwnerId Integer False

The OwnerId column for the table Deals.

PartyId Integer False

The PartyId column for the table Deals.

Price Long False

The Price column for the table Deals.

PriceType String False

The PriceType column for the table Deals.

ResponsiblePartyId Integer False

The ResponsiblePartyId column for the table Deals.

Status String False

The Status column for the table Deals.

StatusChangedOn String True

The StatusChangedOn column for the table Deals.

CreatedAt Datetime True

The CreatedAt column for the table Deals.

UpdatedAt Datetime True

The UpdatedAt column for the table Deals.

DealCustomField1 String False

A Custom Field of type deal.

DealCustomField2 String False

A Custom Field of type deal.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062