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.