CI_INFO

Chargeable Item Classes

Definition

The list of the chargeable item classes that define the data structure of the XCIs

Description

The CI_INFO table contains the list of the chargeable item classes that define the data structure of the XCIs. For each class, the list of customized properties is defined in the PROP_INFO table.

Each stored XCI refers to a chargeable item class that defines its data structure (list of properties).

Technical Data

Schema Version	4.5.0
Filegroup
Partitioned	No

Summary

The CI_INFO table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
CI_ID	PK_CI_INFO				PROP_INFO (CI_ID) XCI_INFO (CI_ID)	The unique identifier of the chargeable item class
CI_NAME						The code name of the chargeable item class
PRODUCT_NAME						The product name (DEPRECATED)

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

CI_ID

Definition	The unique identifier of the chargeable item class
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CI_INFO

CI_NAME

Definition	The code name of the chargeable item class
Type	NVARCHAR(256), NULL

PRODUCT_NAME

Definition	The product name (DEPRECATED)
Type	NVARCHAR(256), NULL

Primary Key Details

See the primary key information:

PK_CI_INFO

Column(s)	CI_ID
Filegroup