ContactSnapshot
A copy of the Bill To or Sold To contact information from a posted invoice.
Columns
Name | Type | Description |
taxregion | String | The 'taxregion' column for the 'contactsnapshot' table. |
otherphone | String | The 'otherphone' column for the 'contactsnapshot' table. |
accountid | String | The 'accountid' column for the 'contactsnapshot' table. |
description | String | The 'description' column for the 'contactsnapshot' table. |
updateddate | Datetime | The 'updateddate' column for the 'contactsnapshot' table. |
postalcode | String | The 'postalcode' column for the 'contactsnapshot' table. |
contactid | String | The 'contactid' column for the 'contactsnapshot' table. |
county | String | The 'county' column for the 'contactsnapshot' table. |
mobilephone | String | The 'mobilephone' column for the 'contactsnapshot' table. |
personalemail | String | The 'personalemail' column for the 'contactsnapshot' table. |
createdbyid | String | The 'createdbyid' column for the 'contactsnapshot' table. |
workphone | String | The 'workphone' column for the 'contactsnapshot' table. |
firstname | String | The 'firstname' column for the 'contactsnapshot' table. |
updatedbyid | String | The 'updatedbyid' column for the 'contactsnapshot' table. |
address2 | String | The 'address2' column for the 'contactsnapshot' table. |
address1 | String | The 'address1' column for the 'contactsnapshot' table. |
city | String | The 'city' column for the 'contactsnapshot' table. |
workemail | String | The 'workemail' column for the 'contactsnapshot' table. |
nickname | String | The 'nickname' column for the 'contactsnapshot' table. |
homephone | String | The 'homephone' column for the 'contactsnapshot' table. |
state | String | The 'state' column for the 'contactsnapshot' table. |
createddate | Datetime | The 'createddate' column for the 'contactsnapshot' table. |
country | String | The 'country' column for the 'contactsnapshot' table. |
id | String | The 'id' column for the 'contactsnapshot' table. |
lastname | String | The 'lastname' column for the 'contactsnapshot' table. |
fax | String | The 'fax' column for the 'contactsnapshot' table. |
otherphonetype | String | The 'otherphonetype' column for the 'contactsnapshot' table. |