udcontactSmall table - SuperOffice

udcontactSmall Table (35)

User-defined fields for contact

Fields

Name	Description	Type	Nullable
udcontactSmall_id	Primary key	PK	No
long01	long value 1, indexed	Id	Yes
long02	long value 2, indexed	Id	Yes
long03	long value 3, indexed	Id	Yes
long04	long value 4, indexed	Id	Yes
long05	long value 5, not indexed	Id	Yes
long06	long value 6, not indexed	Id	Yes
long07	long value 7, not indexed	Id	Yes
long08	long value 8, not indexed	Id	Yes
long09	long value 9, not indexed	Id	Yes
long10	long value 10, not indexed	Id	Yes
long11	long value 11, not indexed	Id	Yes
long12	long value 12, not indexed	Id	Yes
long13	long value 13, not indexed	Id	Yes
long14	long value 14, not indexed	Id	Yes
long15	long value 15, not indexed	Id	Yes
long16	long value 16, not indexed	Id	Yes
long17	long value 17, not indexed	Id	Yes
long18	long value 18, not indexed	Id	Yes
long19	long value 19, not indexed	Id	Yes
long20	long value 20, not indexed	Id	Yes
long21	long value 21, not indexed	Id	Yes
long22	long value 22, not indexed	Id	Yes
long23	long value 23, not indexed	Id	Yes
long24	long value 24, not indexed	Id	Yes
long25	long value 25, not indexed	Id	Yes
long26	long value 26, not indexed	Id	Yes
long27	long value 27, not indexed	Id	Yes
long28	long value 28, not indexed	Id	Yes
long29	long value 29, not indexed	Id	Yes
long30	long value 30, not indexed	Id	Yes
long31	long value 31, not indexed	Id	Yes
long32	long value 32, not indexed	Id	Yes
long33	long value 33, not indexed	Id	Yes
long34	long value 34, not indexed	Id	Yes
long35	long value 35, not indexed	Id	Yes
long36	long value 36, not indexed	Id	Yes
long37	long value 37, not indexed	Id	Yes
long38	long value 38, not indexed	Id	Yes
long39	long value 39, not indexed	Id	Yes
long40	long value 40, not indexed	Id	Yes
long41	long value 41, not indexed	Id	Yes
long42	long value 42, not indexed	Id	Yes
long43	long value 43, not indexed	Id	Yes
long44	long value 44, not indexed	Id	Yes
long45	long value 45, not indexed	Id	Yes
long46	long value 46, not indexed	Id	Yes
long47	long value 47, not indexed	Id	Yes
long48	long value 48, not indexed	Id	Yes
long49	long value 49, not indexed	Id	Yes
long50	long value 50, not indexed	Id	Yes
long51	long value 51, not indexed	Id	Yes
long52	long value 52, not indexed	Id	Yes
long53	long value 53, not indexed	Id	Yes
long54	long value 54, not indexed	Id	Yes
long55	long value 55, not indexed	Id	Yes
long56	long value 56, not indexed	Id	Yes
long57	long value 57, not indexed	Id	Yes
long58	long value 58, not indexed	Id	Yes
long59	long value 59, not indexed	Id	Yes
long60	long value 60, not indexed	Id	Yes
string01	string value 1, indexed	String(39)	Yes
string02	string value 2, indexed	String(39)	Yes
string03	string value 3, indexed	String(39)	Yes
string04	string value 4, indexed	String(39)	Yes
string05	string value 5, not indexed	String(39)	Yes
string06	string value 6, not indexed	String(39)	Yes
string07	string value 7, not indexed	String(39)	Yes
string08	string value 8, not indexed	String(39)	Yes
string09	string value 9, not indexed	String(39)	Yes
string10	string value 10, not indexed	String(39)	Yes
string11	string value 11, not indexed	String(39)	Yes
string12	string value 12, not indexed	String(39)	Yes
string13	string value 13, not indexed	String(39)	Yes
string14	string value 14, not indexed	String(39)	Yes
string15	string value 15, not indexed	String(39)	Yes
string16	string value 16, not indexed	String(39)	Yes
string17	string value 17, not indexed	String(39)	Yes
string18	string value 18, not indexed	String(39)	Yes
string19	string value 19, not indexed	String(39)	Yes
string20	string value 20, not indexed	String(39)	Yes
string21	string value 21, not indexed	String(39)	Yes
string22	string value 22, not indexed	String(39)	Yes
string23	string value 23, not indexed	String(39)	Yes
string24	string value 24, not indexed	String(39)	Yes
string25	string value 25, not indexed	String(39)	Yes
string26	string value 26, not indexed	String(39)	Yes
string27	string value 27, not indexed	String(39)	Yes
string28	string value 28, not indexed	String(39)	Yes
string29	string value 29, not indexed	String(39)	Yes
string30	string value 30, not indexed	String(39)	Yes
string31	string value 31, not indexed	String(39)	Yes
string32	string value 32, not indexed	String(39)	Yes
string33	string value 33, not indexed	String(39)	Yes
string34	string value 34, not indexed	String(39)	Yes
string35	string value 35, not indexed	String(39)	Yes
string36	string value 36, not indexed	String(39)	Yes
string37	string value 37, not indexed	String(39)	Yes
string38	string value 38, not indexed	String(39)	Yes
string39	string value 39, not indexed	String(39)	Yes
string40	string value 40, not indexed	String(39)	Yes
double01	double value 1, indexed	Double	Yes
double02	double value 2, indexed	Double	Yes
double03	double value 3, indexed	Double	Yes
double04	double value 4, indexed	Double	Yes
double05	double value 5, not indexed	Double	Yes
double06	double value 6, not indexed	Double	Yes
double07	double value 7, not indexed	Double	Yes
double08	double value 8, not indexed	Double	Yes
double09	double value 9, not indexed	Double	Yes
double10	double value 10, not indexed	Double	Yes

Indexes

Fields	Types	Description
long01	Id	Index
long02	Id	Index
long03	Id	Index
long04	Id	Index
string01	String(39)	Index
string02	String(39)	Index
string03	String(39)	Index
string04	String(39)	Index
double01	Double	Index
double02	Double	Index
double03	Double	Index
double04	Double	Index

Relationships

Table	Description
contact	Companies and Organizations.

Replication Flags

Area Management controlled table. Contents replicated to satellites and traveller databases.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

Sentry controls access to items in this table using user’s Role and data rights matrix on the table’s parent.

Related topics

Working with custom objects and fields in API udcontactLarge table contact table udtempSmall table udpersonSmall table udprojectSmall table

⌘I