XCI_INFO
Extended Chargeable Items (XCI)
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 |
| Tablespace |
|
| Partitioned |
No |
Summary
The XCI_INFO table is defined by the
following columns.
See the column details for more information.
Column Details
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 |
VARCHAR(256), NOT NULL |
USER_LOGIN
| Definition |
The extended chargeable item user login |
| Type |
VARCHAR(256), NULL |
CONS_DATE
| Definition |
The service consumption date recorded in the extended chargeable item (XCI) |
| Type |
TIMESTAMP, NULL |
IMPORT_DATE
| Definition |
The date of the import |
| Type |
TIMESTAMP, NULL |
EXPORT_DATE
| Definition |
The date of the export to the database |
| Type |
TIMESTAMP, 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 |
VARCHAR(2000), NULL |
Primary Key Details
PK_XCI_INFO
| Column(s) |
XCI_ID |
| Tablespace |
|
