Logo OfficeClip Web Services
Schema: Account

Name Type Comment
sidstringThe serial id of this service type
isLockbooleanDetermines if the column can be edited
tagstringUsed by OfficeClip to pass specific information
accountIdintThe unique id of the account in the OfficeClip database
accountNumberstringThe account number of the account, it is advised that this needs to be unique
orgIdintThe unique id of the organization in the OfficeClip database where the contact belongs
accountNamestringThe name of the account
shortNamestringThe short name of the account
parentAccountSidstringThe sid of the parent account
primaryContactstringThe name of the primary contact
relationshipTypestringThe relationType for the account
webSitestringThe website for the account
emailAddressstringThe email address of the account
mainPhonestringThe primary phone number for the account
otherPhonestringThe other phone number for the account
faxstringThe fax number of the account
isArchivebooleanShows if the account is archived
address1stringThe first address line for the account
address2stringThe second address line for the account
citystringThe city of the account address
statestringThe state of the account address
zipstringThe zip code of the account address
countrystringThe country of the account address
descriptionstringThe description of the account
createdUserstringThe name of the user that created the account
createdDatedateTimeThe created date for the account
ownerstringThe name of the user who is assigned the current account
modifiedUserstringThe name of the user that modified the account
modifiedDatedateTimeThe modified date for the account
currencystringThe currency of the account
industrystringThe industry of the account
annualRevenuedoubleThe annual revenue of the account
numEmployeesintThe number of employees
sicCodestringThe sic code for the account
ownershipstringThe ownership for the account
tickerSymbolstringThe ticker symbol for the account
accountSourcestringThe account source
udf1stringThe first user defined field
udf2stringThe second user defined field
udf3stringThe third user defined field
udf4stringThe fourth user defined field
udf5stringThe fifth user defined field
udf6stringThe sixth user defined field
udf7stringThe seventh user defined field
udf8stringThe eighth user defined field
udf9stringThe nineth user defined field
udf10stringThe tenth user defined field