Previous Topic: ca_company TableNext Topic: ca_contact Table


ca_company_type Table

Company type information (CA-MDB).

Field

Data Type

Reference

Remarks

creation_date

INTEGER

 

Specifies the date this record was created.

creation_user

nvarchar(64)

 

Identifies the user or process that created the record.

description

nvarchar(255)

 

Provides the textual company type description of this entry.

id

INTEGER

 

Specifies the Primary key, this also identifies the unique company type numeric ID.

inactive

INTEGER

Active_Boolean_
Table::enum

Specifies Active flag, as follows:
0—False (Active)
1—True (Inactive)

last_update_
date

INTEGER

 

Specifies the date when this record was last updated.

last_update_
user

nvarchar(64)

 

Specifies the user or process that updated the record.

name

nvarchar(100)

 

Identifies the unique, company type name.

version_ number

INTEGER

 

Specifies the version number for transaction integrity