ALLOWANCE_INTERFACE_PARAMETER

Parameters of the Allowance Interface (in Business and Custom Data)

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 5.0.6
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 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

        More...

        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 legible name of the parameter. It must be unique in the allowance interface.
              Type NVARCHAR(256), NOT NULL

              DESCRIPTION

              Definition The textual and understandable description of the parameter
              Type NVARCHAR(256), NOT NULL

              VALUE_TYPE

              Definition The type of the parameter
              Format

              The possible values are:

              • 0: number
              • 1: string
              • 2: date

              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