| Name |
Type |
Comment |
| sid | string | The serial id of this service type |
| isLock | boolean | Determines if the column can be edited |
| tag | string | Used by OfficeClip to pass specific information |
| accountId | int | The unique id of the account in the OfficeClip database |
| accountNumber | string | The account number of the account, it is advised that this needs to be unique |
| orgId | int | The unique id of the organization in the OfficeClip database where the contact belongs |
| accountName | string | The name of the account |
| shortName | string | The short name of the account |
| parentAccountSid | string | The sid of the parent account |
| primaryContact | string | The name of the primary contact |
| relationshipType | string | The relationType for the account |
| webSite | string | The website for the account |
| emailAddress | string | The email address of the account |
| mainPhone | string | The primary phone number for the account |
| otherPhone | string | The other phone number for the account |
| fax | string | The fax number of the account |
| isArchive | boolean | Shows if the account is archived |
| address1 | string | The first address line for the account |
| address2 | string | The second address line for the account |
| city | string | The city of the account address |
| state | string | The state of the account address |
| zip | string | The zip code of the account address |
| country | string | The country of the account address |
| description | string | The description of the account |
| createdUser | string | The name of the user that created the account |
| createdDate | dateTime | The created date for the account |
| owner | string | The name of the user who is assigned the current account |
| modifiedUser | string | The name of the user that modified the account |
| modifiedDate | dateTime | The modified date for the account |
| currency | string | The currency of the account |
| industry | string | The industry of the account |
| annualRevenue | double | The annual revenue of the account |
| numEmployees | int | The number of employees |
| sicCode | string | The sic code for the account |
| ownership | string | The ownership for the account |
| tickerSymbol | string | The ticker symbol for the account |
| accountSource | string | The account source |
| udf1 | string | The first user defined field |
| udf2 | string | The second user defined field |
| udf3 | string | The third user defined field |
| udf4 | string | The fourth user defined field |
| udf5 | string | The fifth user defined field |
| udf6 | string | The sixth user defined field |
| udf7 | string | The seventh user defined field |
| udf8 | string | The eighth user defined field |
| udf9 | string | The nineth user defined field |
| udf10 | string | The tenth user defined field |
