TABLE DETAIL REFERENCE: OtherName
(USA VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 41 | True | True | True | True | %s | |
| IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| CompanyName | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| OtherNameAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| OtherNameAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| OtherNameAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| OtherNameAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| OtherNameAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| OtherNameAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| OtherNameAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| OtherNameAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| OtherNameAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| OtherNameAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| OtherNameAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| OtherNameAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| OtherNameAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| OtherNameAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| OtherNameAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| OtherNameAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| OtherNameAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| 12 | VARCHAR | 1023 | True | True | True | False | %s | ||
| Contact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| AltContact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
| BusinessNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
| Notes | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | |
| ExternalGUID | 12 | VARCHAR | 40 | True | False | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} |