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