Accounts

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for this record.
AccountOwner_Id	String	False	The Id of the account owner for the account.
AccountOwner_Name	String	True	The name of the account owner for the account.
Rating	String	False	The rating for the account.
AccountName	String	False	The name of the account.
Phone	String	False	The phone of the account.
AccountSite	String	False	The site for the account.
Fax	String	False	The fax of the account.
ParentAccount_Id	String	False	The Id of the parent account of the account.
ParentAccount_Name	String	True	The name of the parent account of the account.
Website	String	False	The website of the account.
AccountNumber	Long	False	The account number of the account.
TickerSymbol	String	False	The ticker symbol of the account
AccountType	String	False	The type of the account.
Ownership	String	False	The ownership of the account.
Industry	String	False	The industry of the account.
Employees	Int	False	The number of employess the account has.
AnnualRevenue	Double	False	The annual revenue of the account.
SICCode	Int	False	The SIC code of the account
Tag	String	False	The tag of the account.
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.
LastActivityTime	Datetime	False	The time of the last activity for the account.
BillingStreet	String	False	The billing street of the account.
ShippingStreet	String	False	The shipping street of the account.
BillingCity	String	False	The billing city of the account.
ShippingCity	String	False	The shipping city of the account.
BillingState	String	False	The billing state of the account.
ShippingState	String	False	The shipping state of the account.
BillingCode	String	False	The billing code of the account.
ShippingCode	String	False	The shipping code of the account.
BillingCountry	String	False	The billing country of the account.
ShippingCountry	String	False	The shipping country of the account.
Description	String	False	The description of the account.
History	String	False	The history of the account.

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.