company table - SuperOffice

company Table (1)

Information on license and owner of this SuperOffice database. This table should only have 1 row. This table contains encrypted license information. Changing it will disable login for all users and require you to restore the database from backup.

Fields

Name	Description	Type	Nullable
company_id	Primary key	PK	No
version	Database version, must match dictionary (conceptualdatabase)	Int	No
revision	Database revision, must match dictionary	UShort	No
ownerContactName	Name of contact who owns the license - exact match required	String(219)	No
ownerDepartmentName	Department of contact who owns the license - exact match required	String(219)	No
ownerContactId	ID of contact who owns the license	Id	No
dbContactName	Name of contact who owns this database (<> license owner for satellite etc)	String(219)	No
dbDepartmentName	Department of contact who owns this database	String(219)	No
dbContactId	ID of contact who owns this database	Id	No
serialNo	Serial number of license; this is THE master item… which will be checked against SuperOffice AS license database by SoAdmin!	String(219)	No
extraInfo	Spare field	String(254)	Yes
encryptedCheck	Encrypted hash checksum	String(254)	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

Working with companies in API company_domain table Company ext_table table Companies

⌘I