CI_INFO

Chargeable Item Classes

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
Partitioned No

Summary


The CI_INFO table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
CI_ID PK_CI_INFO        PROP_INFO (CI_ID)
XCI_INFO (CI_ID)
 
CI_NAME          
PRODUCT_NAME          

Column Details


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


PK_CI_INFO

Column(s) CI_ID
Tablespace