abbreviation

nvarchar(30)

Specifies the model abbreviation.

capacity

float

Defines the capacity.

capacity_unit

INTEGER

Defines the capacity unit.
Note: This is the Foreign key to the id field of the ca_capacity_unit table.

class_id

INTEGER

ca_resource_ class::id

Foreign key to the id field of the ca_resource_class table for the class to which this model belongs.

creation_date

INTEGER

Specifies the date of when this record was created.

creation_user

nvarchar(64)

Identifies the user or process that created the record.

current_as_of_ date

INTEGER

Specifies the date which represents the point at which the model information is considered current.

delete_time

INTEGER

Indicates the time of deletion.

description

nvarchar
(255)

Identifies the model description.

exclude_registration

INTEGER

Indicates to exclude registration.

family_id

INTEGER

Foreign key to the id field of the ca_resource_family table for the family to which this model belongs.

gl_code

INTEGER

Specifies the GL code.
Note: This is the Foreign key to the id field of the ca_resource_gl_code table.

inactive

INTEGER

Active_Boolean_
Table::enum

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

last_update_date

INTEGER

Specifies the date of when this record was last updated.

last_update_user

nvarchar(64)

Specifies the user or process that last updated this record.

manufacturer_uuid

byte(16)

ca_company
::company_uuid

Foreign key to the company_uuid field of the ca_company table for the record that represents the manufacturer.

model_uuid

byte(16)

Specifies the model ID.
Note: This is a Primary key.

name

nvarchar(100)

Identifies the unique Model name.

operating_system

INTEGER

Operating system.
Note: It is a Foreign key to the id field of the ca_resource_operating_system table.

preferred_seller_ uuid

byte(16)

Foreign key to the company_uuid field of the ca_company table for the record that represents the preferred seller company of this model.

subclass_id

INTEGER

Foreign key to the id field of the ca_resource_class table for the subclass to which this model belongs.

version_number

INTEGER

Indicates the version number for transaction integrity.