AE_PROPERTY_DESCRIPTION

Definition


The AE_PROPERTY_DESCRIPTION table describes the properties of an allowance event class

Technical Data


Schema Version 4.5.13
Partitioned No

Summary


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

Name PK FK IX Uses Used by
NAME          
INDEX_IN_EVENT          
VALUE_TYPE          
DESCRIPTION          
EVENT_OID     IX_AE_PROPERTY_DESCRIPTION  AE_CLASS (OID)
 
 

Column Details


NAME

Definition The name of the property. It must be unique for an allowance event class.
Type NVARCHAR(256), NOT NULL

INDEX_IN_EVENT

Definition The position of the property in the allowance event class
Type DECIMAL(3), NOT NULL

VALUE_TYPE

Definition The type of the property
Format

The possible values are:

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

Type DECIMAL(1), NOT NULL

DESCRIPTION

Definition The comprehensive description of the property
Type NVARCHAR(2000), NULL

EVENT_OID

Definition The OID of the allowance event class having this property
Type DECIMAL(28), NOT NULL
Available Index IX_AE_PROPERTY_DESCRIPTION

Index Details


The following database indexes are available in the AE_PROPERTY_DESCRIPTION database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_AE_PROPERTY_DESCRIPTION

Indexed Column(s) EVENT_OID
Unique Yes
Partitioned No