CustomerContacts Table

Back to list of tables.

Column	Data type	Data type name	Length	Can be queried?	Can be updated?	Can be inserted?	Mandatory when inserting?	Format	Refers To	Version introduced in	Edition available in
ID	12	VARCHAR	75
ListID	12	VARCHAR	36	True	False	False	False	%s	ListID	1.0	US, CA, UK
TimeCreated	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
TimeModified	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
EditSequence	12	VARCHAR	16	True	False	False	False	%s		1.0	US, CA, UK
Name	12	VARCHAR	41	True	True	True	True	%s		1.0	US, CA, UK
FullName	12	VARCHAR	209	True	False	False	False	%s		1.0	US, CA, UK
IsActive	-7	BIT	2	True	True	True	False	1 0 true false		1.0	US, CA, UK
ParentRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
ParentRef_FullName	12	VARCHAR	159	True	True	True	False	%s		1.0	US, CA, UK
ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	12.0	US, CA, UK
ClassRef_FullName	12	VARCHAR	209	True	True	True	False	%s	FullName	12.0	US, CA, UK
Sublevel	4	INTEGER	9	True	False	False	False	%11.0f		1.0	US, CA, UK
CompanyName	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
Salutation	12	VARCHAR	15	True	True	True	False	%s		1.0	US, CA, UK
FirstName	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
MiddleName	12	VARCHAR	5	True	True	True	False	%s		1.0	US, CA, UK
LastName	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
JobTitle	12	VARCHAR	14					%s		12.0	US, CA, UK
BillAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
BillAddress_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
BillAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Country	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
BillAddress_Note	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
BillAddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
ShipAddress_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
ShipAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Country	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Note	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
Phone	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
AltPhone	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
Fax	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
Email	12	VARCHAR	1023	True	True	True	False	%s		1.0	US, CA, UK
Cc	12	VARCHAR	1023	True	True	True	False	%s		1.0	US, CA, UK
Contact	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
AltContact	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
AdditionalContactRef_ContactName1	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue1	12	VARCHAR	255							12.0	US, CA, UK
AdditionalContactRef_ContactName2	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue2	12	VARCHAR	255							12.0	US, CA, UK
AdditionalContactRef_ContactName3	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue3	12	VARCHAR	255							12.0	US, CA, UK
AdditionalContactRef_ContactName4	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue4	12	VARCHAR	255							12.0	US, CA, UK
AdditionalContactRef_ContactName5	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue5	12	VARCHAR	255							12.0	US, CA, UK
AdditionalContactRef_ContactName6	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue6	12	VARCHAR	255							12.0	US, CA, UK
AdditionalContactRef_ContactName7	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue7	12	VARCHAR	255							12.0	US, CA, UK
AdditionalContactRef_ContactName8	12	VARCHAR	40							12.0	US, CA, UK
AdditionalContactRef_ContactValue8	12	VARCHAR	255							12.0	US, CA, UK
CustomerTypeRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
CustomerTypeRef_FullName	12	VARCHAR	159	True	True	True	False	%s	FullName	1.0	US, CA, UK
TermsRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
TermsRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
SalesRepRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
SalesRepRef_FullName	12	VARCHAR	5	True	True	True	False	%s	Initial	1.0	US, CA, UK
OpenBalance	2	NUMERIC	14	True	False	True	False	%10.2f		1.0	US, CA, UK
Balance	2	NUMERIC	14	True	False	False	False	%10.2f		1.0	US, CA, UK
TotalBalance	2	NUMERIC	14	True	False	False	False	%10.2f		1.0	US, CA, UK
OpenBalanceDate	91	DATE	10	True	False	True	False	CCCC-MM-DD		1.0	US, CA, UK
SalesTaxCodeRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
SalesTaxCodeRef_FullName	12	VARCHAR	3	True	True	True	False	%s	Name	1.0	US, CA, UK
ItemSalesTaxRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ItemSalesTaxRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
ResaleNumber	12	VARCHAR	15	True	True	True	False	%s		1.0	US, CA, UK
AccountNumber	12	VARCHAR	99	True	True	True	False	%s		1.0	US, CA, UK
CreditLimit	2	NUMERIC	14	True	True	True	False	%10.2f		1.0	US, CA, UK
PreferredPaymentMethodRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	3.0	US, CA, UK
PreferredPaymentMethodRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	3.0	US, CA, UK
CreditCardInfo_CreditCardNumber	12	VARCHAR	25	True	True	True	False	%s		3.0	US, CA, UK
CreditCardInfo_ExpirationMonth	4	INTEGER	9	True	True	True	False	%13.0f		3.0	US, CA, UK
CreditCardInfo_ExpirationYear	4	INTEGER	9	True	True	True	False	%13.0f		3.0	US, CA, UK
CreditCardInfo_NameOnCard	12	VARCHAR	41	True	True	True	False	%s		3.0	US, CA, UK
CreditCardInfo_CreditCardAddress	12	VARCHAR	41	True	True	True	False	%s		3.0	US, CA, UK
CreditCardInfo_CreditCardPostalCode	12	VARCHAR	41	True	True	True	False	%s		3.0	US, CA, UK
JobStatus	12	VARCHAR	10	True	True	True	False	None Pending Awarded InProgress Closed NotAwarded		3.0	US, CA, UK
JobStartDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
JobProjectedEndDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
JobEndDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
JobDesc	12	VARCHAR	99	True	True	True	False	%s		1.0	US, CA, UK
JobTypeRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
JobTypeRef_FullName	12	VARCHAR	159	True	True	True	False	%s	FullName	1.0	US, CA, UK
Notes	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
PreferredDeliveryMethod	12	VARCHAR	10	True	True	True	True	None Email Fax		12.0	US, CA, UK
PriceLevelRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	4.0	US, CA, UK
PriceLevelRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	4.0	US, CA, UK
ExternalGUID	12	VARCHAR	40	True	False	True	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}		8.0	US, CA, UK
CurrencyRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	8.0	US, CA, UK
CurrencyRef_FullName	12	VARCHAR	64	True	True	True	False	%s	Name	8.0	US, CA, UK
Contacts_ListID	12	VARCHAR	36	True	True	False	False	%s		1.0	US, CA, UK
Contacts_TimeCreated	11	TIMESTAMP	16	True	False	False	False	%s		1.0	US, CA, UK
Contacts_TimeModified	11	TIMESTAMP	16	True	False	False	False	%s		1.0	US, CA, UK
Contacts_EditSequence	12	VARCHAR	16	True	True	False	False	%s		1.0	US, CA, UK
Contacts_Salutation	12	VARCHAR	15	True	True	True	False	%s		1.0	US, CA, UK
Contacts_FirstName	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
Contacts_MiddleName	12	VARCHAR	5	True	True	True	False	%s		1.0	US, CA, UK
Contacts_LastName	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
Contacts_JobTitle	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactName1	12	VARCHAR	40	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactValue1	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactName2	12	VARCHAR	40	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactValue2	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactName3	12	VARCHAR	40	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactValue3	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactName4	12	VARCHAR	40	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactValue4	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactName5	12	VARCHAR	40	True	True	True	False	%s		1.0	US, CA, UK
Contacts_AdditionalContactRef_ContactValue5	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
CFBDay	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
CFContract	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
CFSpousesName	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK

Back to list of tables.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•