Table:
ACCESS_ACTI_CHRONOLOGY
|
Table Name
|
ACCESS_ACTI_CHRONOLOGY |
| Table Description |
The ACCESS_ACTI_CHRONOLOGY table contains the chronology of access for a charge activation. |
| Tablespace |
ACCESS_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The ACCESS_ACTI_CHRONOLOGY database table is defined by the following columns.
Column: ACTI_OID
| Value Type |
BIGINT |
|
| Index(es) |
IX_ACCESS_ACTIVATION
|
| Column Description |
The OID of the charge activation. |
Column: ACCE_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: ACCESS_TABLE
- Foreign field(s): PARTITION_ID,OID
|
| Index(es) |
IX_ACCESS_OWNER
IX_ACTI_ID
|
| Column Description |
The OID of the access. |
Column: ACCE_PARTITION_ID
| Value Type |
SMALLINT |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: ACCESS_TABLE
- Foreign field(s): PARTITION_ID,OID
|
| Index(es) |
IX_ACTI_ID
|
| Column Description |
The partition of the access. |
Column: START_DATE
| Value Type |
DATE |
|
| Column Description |
The start date for the chronology. |
Column: ACCE_TYPE
| Value Type |
DECIMAL(1) |
|
| Column Description |
The type of the target.
Possible values are:
- 0: Subscription
- 1: Charging Contract
|
Column: SUBS_OID
| Value Type |
BIGINT |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: SUBSCRIPTION
- Foreign field(s): OID
|
| Index(es) |
IX_ACTI_CHRO_SUBS
|
| Column Description |
The identifier of the subscription which contains the charge activation. |
Column: CACO_OID
| Value Type |
BIGINT |
|
| Index(es) |
IX_ACTI_CHRO_CACO
|
| Column Description |
The identifier of the charging contract which contains the charge activation. |
Column: PARTITION_ID
| Value Type |
SMALLINT |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: ACCESS_TABLE
- Foreign field(s): PARTITION_ID,OID
|
| Index(es) |
IX_ACTI_ID
|
| Column Description |
The partition of the subscriber account containing the charge activation. |
Column: BGRP_OID
| Value Type |
DECIMAL(2), NOT NULL |
|
| Column Description |
The ID of the batch rating group. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.