The XCI_INFO table contains all the extended chargeable items (XCIs) exported by
an Import/Export Connector (IEC) application.
Note The property values are not stored in this table but they are stored
in the XCI_VALUES table.
The list of the properties that are available in an XCI is defined in a chargeable
item class stored in
the CI_INFOtable.
| Schema Version | 4.5.0 | |
| Filegroup | ||
| Partitioned | No | |
The XCI_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 |
|---|---|---|---|---|---|---|
| XCI_ID | PK_XCI_INFO |
|
The unique identifier of the extended chargeable item (XCI) | |||
| XCI_SRCID |
|
The source ID from which the XCI has been extracted by the IEC application. It is mainly a filename. | ||||
| USER_LOGIN |
|
The extended chargeable item user login | ||||
| CONS_DATE |
|
The service consumption date recorded in the extended chargeable item (XCI) | ||||
| IMPORT_DATE |
|
The date of the import | ||||
| EXPORT_DATE |
|
The date of the export to the database | ||||
| EXPORT_FLAG |
|
The extended chargeable item export flag | ||||
| XCI_COUNT |
|
The number of duplicated XCIs. They have the same magic number. | ||||
| CI_ID | CI_INFO (CI_ID)
|
|
The ID of the chargeable item class | |||
| MAGIC_NUMBER |
|
The business identifier of the extended chargeable item. It is generated by the IEC application. |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the extended chargeable item (XCI) |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_XCI_INFO |
| Definition | The source ID from which the XCI has been extracted by the IEC application. It is mainly a filename. |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The extended chargeable item user login |
| Type | NVARCHAR(256), NULL |
| Definition | The service consumption date recorded in the extended chargeable item (XCI) |
| Type | DATETIME, NULL |
| Definition | The date of the import |
| Type | DATETIME, NULL |
| Definition | The date of the export to the database |
| Type | DATETIME, NULL |
| Definition | The extended chargeable item export flag |
| Type | DECIMAL(1), NULL |
| Definition | The number of duplicated XCIs. They have the same magic number. |
| Type | DECIMAL(16), NULL |
| Definition | The ID of the chargeable item class |
| Type | DECIMAL(28), NULL |
| Definition | The business identifier of the extended chargeable item. It is generated by the IEC application. |
| Description |
The IEC application determines this number during the export operation when the duplicate
detection subfunction is enabled.
|
| Type | NVARCHAR(2000), NULL |
See the primary key information:
| Column(s) | XCI_ID |
| Filegroup |
