XCI_INFO
Definition
The XCI_INFO table contains all the extended chargeable items (XCIs) exported by an IEC application
Description
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.
Technical Data
| Schema Version | 4.5.0 | |
| Segment | ||
| Partitioned | No | |
Summary
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 |
|---|---|---|---|---|---|
| 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.
|
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
XCI_ID
| Definition | The unique identifier of the extended chargeable item (XCI) |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_XCI_INFO |
XCI_SRCID
| 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 |
USER_LOGIN
| Definition | The extended chargeable item user login |
| Type | NVARCHAR(256), NULL |
CONS_DATE
| Definition | The service consumption date recorded in the extended chargeable item (XCI) |
| Type | DATETIME, NULL |
IMPORT_DATE
| Definition | The date of the import |
| Type | DATETIME, NULL |
EXPORT_DATE
| Definition | The date of the export to the database |
| Type | DATETIME, NULL |
EXPORT_FLAG
| Definition | The extended chargeable item export flag |
| Type | DECIMAL(1), NULL |
XCI_COUNT
| Definition | The number of duplicated XCIs. They have the same magic number. |
| Type | DECIMAL(16), NULL |
CI_ID
| Definition | The ID of the chargeable item class |
| Type | DECIMAL(28), NULL |
MAGIC_NUMBER
| 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 |
Primary Key Details
See the primary key information:
PK_XCI_INFO
| Column(s) | XCI_ID |
| Segment |