Main source of information for a company and its attributes. A Company is an organization that buys, sells, services, manages, or uses your IT assets. A record is added to this table when a new company is created.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| company_uuid | byte(16) | not null | Primary key. Unique identifier. |
| parent_company_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table for the company's parent company. |
| company_name | nvarchar(100) | with null | Company name. |
| inactive | integer | with null | Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive) |
| description | nvarchar(400) | with null | Description. |
| company_type | integer | with null | Foreign key to the id field of the ca_company_type table for company type (i.e. manufacturer, vendor, publisher, internal, external). |
| alias | nvarchar(30) | with null | Company alias or "a.k.a." name. (e.g. "CA") |
| month_fiscal_year_ends | integer | with null | Integer value (1-12) representing the month the company's fiscal year ends. |
| web_address | nvarchar(50) | with null | Company web address. |
| bbs | nvarchar(30) | with null | Bulletin board system information. |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Date the record was created. |
| last_update_user | nvarchar(64) | with null | User or process that last updated the record. |
| location_uuid | byte(16) | with null | Foreign key to the ca_location table for the company's default location. |
| primary_contact_uuid | byte(16) | with null | Foreign key to the contact_uuid field of the ca_contact table for the company's primary contact. |
| version_number | integer | with null | Version number for transaction integrity. |
| last_update_date | integer | with null | Date the record was last updated. |
| exclude_registration | integer | with null | Exclude Registration |
| delete_time | integer | with null | Delete Time |
| authentication_user_name | nvarchar(64) | with null | Authentication user name |
| authentication_password | nvarchar(20) | with null | Authentication password |
| source_type_id | integer | not null | Source type id. Foreign key to the ca_source_type table. |
Product Name: Asset
Table Type: Table