OtherName 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
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
IsActive	-7	BIT	2	True	True	True	False	1 0 true false		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
OtherNameAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
OtherNameAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
OtherNameAddress_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
OtherNameAddress_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
OtherNameAddress_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
OtherNameAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
OtherNameAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
OtherNameAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
OtherNameAddress_Country	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
OtherNameAddress_Note	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
OtherNameAddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		1.0	US, CA, UK
OtherNameAddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		1.0	US, CA, UK
OtherNameAddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		1.0	US, CA, UK
OtherNameAddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		1.0	US, CA, UK
OtherNameAddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		1.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
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
AccountNumber	12	VARCHAR	99	True	True	True	False	%s		1.0	US, CA, UK
Notes	12	VARCHAR	4095	True	True	True	False	%s		3.0	US, CA, UK
ExternalGUID	12	VARCHAR	40	True	False	True	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}		8.0	US, CA, UK

• 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.

• 
• 
•