Table: ACTI_PARAMETER

Table Name ACTI_PARAMETER
Table Description The ACTI_PARAMETER table contains information about parameters in charge activations. These parameters are first created in the price plan of the charge component corresponding to the charge activation. Then they are redefined in the charge activation.
Tablespace SUBSCRIBER_DATA
Database Core Database
Partitioned Yes
Columns
INDEX_IN_ACTI
PARA_KEY
DESCRIPTION
VALUE_TYPE
NUMBER_VALUE
STRING_VALUE
DATE_VALUE
ACTI_OID
VALIDATION_DATE
ROOT_SUBS_OID
PARTITION_ID

Columns of the Table

The ACTI_PARAMETER database table is defined by the following columns.

Column: INDEX_IN_ACTI

Value Type DECIMAL(5), NOT NULL
Column Description The index of the parameter in the charge activation.


Column: PARA_KEY

Value Type DECIMAL(6), NOT NULL
Column Description The identifier of the parameter.


Column: DESCRIPTION

Value Type VARCHAR(2000)
Column Description The description of the parameter.


Column: VALUE_TYPE

Value Type DECIMAL(1), NOT NULL
Column Description The type of the parameter. Possible values are:
  • 0: number
  • 1: string
  • 2: date


Column: NUMBER_VALUE

Value Type DECIMAL(28,6)
Column Description The value of the parameter when it is a number.


Column: STRING_VALUE

Value Type VARCHAR(2000)
Column Description The value of the parameter when it is a string.


Column: DATE_VALUE

Value Type DATE
Column Description The value of the parameter when it is a date.


Column: ACTI_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: CHARGE_ACTIVATION
  • Foreign field(s): OID

Index(es) IX_ACPA_ACTI
Column Description The identifier of the charge activation owning the parameter.


Column: VALIDATION_DATE

Value Type DATE
Column Description The date when the parameter becomes valid.


Column: ROOT_SUBS_OID

Value Type BIGINT, NOT NULL
Index(es) IX_AP_ROOT_SUBS_OID
Column Description The root subscription for the charge activation.


Column: PARTITION_ID

Value Type SMALLINT, NOT NULL
Column Description The partition of the subscriber account containing the charge activation.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.