MS SQL Server Columns
The following column names are present in the database. The same column name can be used in different tables.
| column | type | table |
|---|---|---|
| CI_ID | DECIMAL(28) | CI_INFO |
| CI_NAME | NVARCHAR(256) | CI_INFO |
| PRODUCT_NAME | NVARCHAR(256) | CI_INFO |
| PROP_ID | DECIMAL(28) | PROP_INFO |
| PROP_NAME | NVARCHAR(256) | PROP_INFO |
| PROP_TYPE | DECIMAL(1) | PROP_INFO |
| CI_ID | DECIMAL(28) | PROP_INFO |
| XCI_ID | DECIMAL(28) | XCI_INFO |
| XCI_SRCID | NVARCHAR(256) | XCI_INFO |
| USER_LOGIN | NVARCHAR(256) | XCI_INFO |
| CONS_DATE | DATETIME | XCI_INFO |
| IMPORT_DATE | DATETIME | XCI_INFO |
| EXPORT_DATE | DATETIME | XCI_INFO |
| EXPORT_FLAG | DECIMAL(1) | XCI_INFO |
| XCI_COUNT | DECIMAL(16) | XCI_INFO |
| CI_ID | DECIMAL(28) | XCI_INFO |
| MAGIC_NUMBER | NVARCHAR(2000) | XCI_INFO |
| XCI_ID | DECIMAL(28) | XCI_VALUES |
| PROP_ID | DECIMAL(28) | XCI_VALUES |
| NUMBER_VALUE | DECIMAL(28,6) | XCI_VALUES |
| STRING_VALUE | NVARCHAR(2000) | XCI_VALUES |
| DATE_VALUE | DATETIME | XCI_VALUES |