ALLOWANCE_INTERFACE_PARAMETER

Definition


The ALLOWANCE_INTERFACE_PARAMETER table describes the parameters of the unique allowance interface of the SAP CC system

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


The ALLOWANCE_INTERFACE_PARAMETER table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
NAME          
DESCRIPTION          
VALUE_TYPE          
NUMBER_DEFAULT_VALUE          
STRING_DEFAULT_VALUE          
DATE_DEFAULT_VALUE          

Column Details


NAME

Definition The name of the parameter. It must be unique in the allowance interface.
Type VARCHAR(256), NOT NULL

DESCRIPTION

Definition The description of the parameter
Type VARCHAR(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 VARCHAR(64), NULL

DATE_DEFAULT_VALUE

Definition The default value of the parameter when it is a date
Type TIMESTAMP, NULL