Table:
CHARGE_ACTIVATION
|
Table Name
|
CHARGE_ACTIVATION |
| Table Description |
The CHARGE_ACTIVATION table contains information about the charge activation.
A charge activation is contained in a subscription and gives the possibility to subscribe to an
existing charge condition.
|
| Tablespace |
SUBSCRIBER_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The CHARGE_ACTIVATION database table is defined by the following columns.
Column: OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
Primary Key: PK_CHARGE_ACTIVATION |
Foreign K.:
- Foreign table: SUBSCRIPTION
- Foreign field(s): OID
|
| Index(es) |
IX_CA_CCON
IX_CA_ROOT_SUBS_OID
IX_CA_SUBSCRIPTION
|
| Column Description |
The identifier of the charge activation. |
Column: SUB_CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Index(es) |
IX_CA_CODE
|
| Column Description |
The code of the charge activation. |
Column: DESCRIPTION
| Value Type |
VARCHAR(2000) |
|
| Column Description |
The description of the charge activation. |
Column: CURRENCY_CODE
| Value Type |
VARCHAR(5) |
|
| Column Description |
The currency code of the charge activation. |
Column: EFFECTIVE_DATE
| Value Type |
DATE |
|
| Column Description |
The effective date of the charge activation. |
Column: EXPIRATION_DATE
| Value Type |
DATE |
|
| Column Description |
The expiration date of the charge activation. |
Column: CANCELLATION_DATE
| Value Type |
DATE |
|
| Column Description |
The cancellation date of the charge activation. |
Column: CCON_OID
| Value Type |
BIGINT, NOT NULL |
|
| Index(es) |
IX_CA_CCON
|
| Column Description |
The identifier of the charge condition corresponding to the charge activation. |
Column: SUBS_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: SUBSCRIPTION
- Foreign field(s): OID
|
| Index(es) |
IX_CA_ROOT_SUBS_OID
IX_CA_SUBSCRIPTION
|
| Column Description |
The identifier of the subscription containing the charge activation. |
Column: ROOT_SUBS_OID
| Value Type |
BIGINT, NOT NULL |
|
| Index(es) |
IX_CA_ROOT_SUBS_OID
|
| Column Description |
The identifier of the root subscription containing the charge activation. |
Column: PARTITION_ID
| Value Type |
SMALLINT, NOT NULL |
|
| Column Description |
The identifier of the partition associated to the subscription which contains 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.