Quotes

Columns

Name

Type

ReadOnly

Description

Id [KEY]

String

False

The unique identifier for this record.

QuoteOwner_Id

String

False

The Id of the owner of the quote.

QuoteOwner_Name

String

True

The name of the owner of the quote.

QuoteNumber

String

False

The number of the quote.

Subject

String

False

The subject of the quote.

DealName_Id

String

False

The Id of the deal related to this quote.

DealName_Name

String

True

The name of the deal related to this quote.

QuoteStage

String

False

The stage in which this quote is currently at.

ValidUntil

Date

False

The time until this quote is valid.

Team

String

False

The team who is related to this quote.

ContactName_Id

String

False

The Id of the contact of the quote.

ContactName_Name

String

True

The nate of the contact of the quote.

Carrier

String

False

The carrier of this quote.

AccountName_Id

String

False

The Id of the account related to this quote.

AccountName_Name

String

True

The name of the account related to this quote.

CreatedBy_Id

String

False

The Id of the User who created the record.

CreatedBy_Name

String

True

The name of the user who created the record.

ModifiedBy_Id

String

False

The Id of the User who modified the record.

ModifiedBy_Name

String

True

The name of the User who modified the record.

CreatedTime

Datetime

False

The time when the record was created.

ModifiedTime

Datetime

False

The time when the record was modified.

Tag

String

False

A list of tags related to this quote.

BillingStreet

String

False

The billing street of the record.

ShippingStreet

String

False

The shipping street of the record.

BillingCity

String

False

The billing city of the record.

ShippingCity

String

False

The shipping city of the record.

BillingState

String

False

The billing state of the record.

ShippingState

String

False

The shipping state of the record.

BillingCode

String

False

The billing code of the record.

ShippingCode

String

False

The shipping code of the record.

BillingCountry

String

False

The billing country of the record.

ShippingCountry

String

False

The shipping country of the record.

ProductDetails

String

False

A json aggregate of the product details related to this quote.

SubTotal

Double

True

The sub total price of this quote.

Discount

Double

False

The disocunt applied to this quote.

Tax

Double

True

The amount of tax applied to this quote.

Adjustment

Double

False

The amount of adjusted price applied to this quote.

GrandTotal

Double

True

The gradn total of the quote.

TermsandConditions

String

False

The terms and conditions of this quote.

Description

String

False

The description of this quote.

Pseudo-Columns

Name

Type

Description

Word

String

Used to search for a specific word in records.

DuplicateCheckFields

String

The field/s to be used for checking in an upsert.

Converted

Boolean

Set to true to return only converted records.

Approved

Boolean

Set to true to return only approved records.

CustomViewId

String

The custom view Id to be used for filtering this record.

Last updated