|
|
Contact
Table Name:
|
Contact
|
Default Access:
|
Edit, Delete, Add, Read,
|
| Field Name |
Field Type |
Field Access |
| Address1Type |
|
Table Default |
| Address2Street1 |
|
Table Default |
| Address2Street2 |
|
Table Default |
| Address2Type |
|
Table Default |
| Address3Street1 |
|
Table Default |
| Address3Street2 |
|
Table Default |
| Address3Type |
|
Table Default |
| Anniversary |
Date |
Table Default |
| AssistantName |
|
Table Default |
| AssistantPhone |
|
Table Default |
| BillingInformation |
|
Table Default |
| Birthday |
Date |
Table Default |
| City |
|
Table Default |
| City2 |
|
Table Default |
| City3 |
|
Table Default |
| Company |
|
Table Default |
| AccountId |
Integer |
Table Default |
| CompanyID |
Integer |
Table Default |
| ContactNotes |
|
Table Default |
| ContactType |
|
Table Default |
| Country |
|
Table Default |
| Country2 |
|
Table Default |
| Country3 |
|
Table Default |
| CreatedBy |
Integer |
Edit, Delete, Add, Read, |
| DateCreated |
DateTime |
Edit, Delete, Add, Read, |
| Email |
|
Table Default |
| EmailAddress2 |
|
Table Default |
| EmailAddress3 |
|
Table Default |
| Fax1 |
|
Table Default |
| Fax1Type |
|
Table Default |
| Fax2 |
|
Table Default |
| Fax2Type |
|
Table Default |
| FirstName |
|
Table Default |
| Groups |
|
Edit, Delete, Add, Read, |
| Id |
Integer |
Edit, Delete, Add, Read, |
| JobTitle |
|
Table Default |
| LastName |
|
Table Default |
| LastUpdated |
DateTime |
Edit, Delete, Add, Read, |
| LastUpdatedBy |
Integer |
Edit, Delete, Add, Read, |
| Leadsource |
|
Edit, Delete, Add, Read, |
| LeadSourceId |
Integer |
Edit, Delete, Add, Read, |
| MiddleName |
|
Table Default |
| Nickname |
|
Table Default |
| OwnerID |
Integer |
Table Default |
| Password |
|
Table Default |
| Phone1 |
|
Table Default |
| Phone1Ext |
|
Table Default |
| Phone1Type |
|
Table Default |
| Phone2 |
|
Table Default |
| Phone2Ext |
|
Table Default |
| Phone2Type |
|
Table Default |
| Phone3 |
|
Table Default |
| Phone3Ext |
|
Table Default |
| Phone3Type |
|
Table Default |
| Phone4 |
|
Table Default |
| Phone4Ext |
|
Table Default |
| Phone4Type |
|
Table Default |
| Phone5 |
|
Table Default |
| Phone5Ext |
|
Table Default |
| Phone5Type |
|
Table Default |
| PostalCode |
|
Table Default |
| PostalCode2 |
|
Table Default |
| PostalCode3 |
|
Table Default |
| ReferralCode |
|
Table Default |
| SpouseName |
|
Table Default |
| State |
|
Table Default |
| State2 |
|
Table Default |
| State3 |
|
Table Default |
| StreetAddress1 |
|
Table Default |
| StreetAddress2 |
|
Table Default |
| Suffix |
|
Table Default |
| Title |
|
Table Default |
| Username |
|
Table Default |
| Website |
|
Table Default |
| ZipFour1 |
|
Table Default |
| ZipFour2 |
|
Table Default |
| ZipFour3 |
|
Table Default |
|
Call Us Now… 24 Hour Infusionsoft Support UK: 01992 289000USA: (480) 588 0858
 |
| |
|
|
|
 |
|