All the configurable values for Accounting and the catalog are set in this table. Primary keys are: domain, group_name, name
| Column Name | Column Datatype | Column Null Option | Column Comment |
| group_name | nvarchar(50) | not null | Configuration is split into the following groups: billingprofile=the default values for any new billing profiles created, statementengine=values that control how billing runs behave, scheduler=will soon be removed and replaced by billing groups, system=configuations defined at the system level (ex: posting events) these are only visible to the SP, invoicemethods=supported invoicing send methods, paymentmethods=supported payment types, billingcycles=supported billing cycles, general=general configuration (ex: default post payment method) that are visible to all SP and ST. |
| name | nvarchar(50) | not null | The name of the configuration parameter |
| domain | varchar(50) | with null | This is the tenant id of the business unit |
| data_type | integer | not null | 0=integer, 1=float, 2=boolean, 3=string, 4=object, 5=time stamp, 6=date stamp, 7=date/time stamp |
| is_visible | integer | not null | 1=show in configuration gui, 0=hide |
| value | nvarchar(1024) | with null | The value of the configuration parameter |
| component_id | integer | with null | What component uses this configuration. ex: iCanBill, catalog, etc. Used only for maintenance as of now. |
| aclinfo | varchar(128) | with null | Currently not used |
| product_code | nvarchar(64) | with null | |
| widget_type | integer | with null | |
| value_list | long varchar | with null |
Product Name: Unicenter Service Management
Table Type: Table