ALLOWANCE_INTERFACE_PARAMETER
Definition
The ALLOWANCE_INTERFACE_PARAMETER table contains the parameters of the unique allowance interface in the SAP CC system
Description
The ALLOWANCE_INTERFACE_PARAMETER table contains all the parameters of the unique allowance interface configured in the SAP CC Core Server system.
The allowance interface defines the common parameters and counters of
all the allowances configured in provider contracts of a service provider and its customer service.
The SAP CC system uses this data configuration when creating a new allowance.
See also: ALLOWANCE_INTERFACE_COUNTER
Technical Data
| Schema Version | 4.6.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
Summary
The ALLOWANCE_INTERFACE_PARAMETER 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 |
|---|---|---|---|---|---|---|
| NAME |
|
The name of the parameter. It must be unique in the allowance interface. | ||||
| DESCRIPTION |
|
The comprehensive description of the parameter | ||||
| VALUE_TYPE |
|
The type of the parameter | ||||
| NUMBER_DEFAULT_VALUE |
|
The default value of the parameter when it is a number | ||||
| STRING_DEFAULT_VALUE |
|
The default value of the parameter when it is a string | ||||
| DATE_DEFAULT_VALUE |
|
The default value of the parameter when it is a date |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
NAME
| Definition | The name of the parameter. It must be unique in the allowance interface. |
| Type | NVARCHAR(256), NOT NULL |
DESCRIPTION
| Definition | The comprehensive description of the parameter |
| Type | NVARCHAR(256), NOT NULL |
VALUE_TYPE
| Definition | The type of the parameter |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
NUMBER_DEFAULT_VALUE
| Definition | The default value of the parameter when it is a number |
| Type | DECIMAL(28,6), NULL |
STRING_DEFAULT_VALUE
| Definition | The default value of the parameter when it is a string |
| Type | NVARCHAR(64), NULL |
DATE_DEFAULT_VALUE
| Definition | The default value of the parameter when it is a date |
| Type | DATETIME, NULL |