ca_link_company_location

Contains links between companies and their locations or locations and their companies. UAPM supports multiple associations between locations and companies as this is useful to track companies with worldwide offices. A record is added to this table when a location is linked to a company and vice versa.

Column Name Column Datatype Column Null Option Column Comment
company_uuid byte(16) not null Company ID. Foreign key to the ca_company table.
location_uuid byte(16) not null Location ID. Foreign key to the ca_location table.
last_update_date integer not null Date the record was last updated.
version_number integer with null Version number for transaction integrity.

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.