alias

nvarchar(30)

Identifies the Company alias or "also known as" name. For example, CA.

authentication_ password

nvarchar(20)

Specifies the authentication password.

authentication_ user_name

nvarchar(64)

Specifies the authentication user name.

bbs

nvarchar(30)

Identifies bulletin board system information.

company_name

nvarchar(100)

Identifies the company name.

company_type

INTEGER

ca_company_ type::id

Identifies the Company Type or Vendor Provider.
Note: This is the Foreign key to the id field of the ca_company_type table.

company_uuid

Byte(16)

The Primary key of this table.

creation_date

INTEGER

Indicates the date this record was created.

creation_user

nvarchar(64)

Identifies the user or process that created the record.

delete_time

INTEGER

Specifies the delete time.

description

nvarchar
(400)

Shows the textual description of this entry.

exclude_registration

INTEGER

Indicates to exclude registration.

inactive

INTEGER

Active_Boolean_
Table::enum

Flag representing whether this record is active or inactive.
0—False (Active)
1—True (Inactive)

last_update_date

INTEGER

Indicates the date that this record was last updated.

last_update_user

nvarchar(64)

Identifies the user or process that last updated the record.

location_uuid

Byte(16)

ca_location
::location
_uuid

Identifies the location.
Note: This is the Foreign key to the ca_location table entry.

month_fiscal_year_ends

INTEGER

Specifies the Integer value (1-12) representing the month the company's fiscal year ends.

parent_company_ uuid

Byte(16)

ca_company
::company
_uuid

This is the Foreign key to the company_uuid field of the ca_company table for the company's parent company.

primary_contact_ uuid

Byte(16)

ca_contact::uuid

Specifies the Primary contact.
Note: This is the Primary foreign key to the ca_contact table.

source_type_id

INTEGER

Represents the Source type id.
Note: This is the Foreign key to the ca_source_type table.

version_number

INTEGER

Specifies the version number for transaction integrity.

web_address

nvarchar(50)

Identifies the company web address.