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
| Schema Version | 2025.0.0 | |
| Partitioned | No | |
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 |
|---|---|---|---|---|---|---|
| CLIENT_NUMBER |
|
The client number associated to the parameter | ||||
| NAME |
|
The legible name of the parameter. It must be unique in the allowance interface. | ||||
| DESCRIPTION |
|
The textual and understandable 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 |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The client number associated to the parameter |
| Type | DECIMAL(3), NOT NULL |
| Definition | The legible name of the parameter. It must be unique in the allowance interface. |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The textual and understandable description of the parameter |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The type of the parameter |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The default value of the parameter when it is a number |
| Type | DECIMAL(28,6), NULL |
| Definition | The default value of the parameter when it is a string |
| Type | NVARCHAR(64), NULL |
| Definition | The default value of the parameter when it is a date |
| Type | SECONDDATE, NULL |
