Table:
CACI_ACCOUNT_ASSIGNMENT
|
Table Name
|
CACI_ACCOUNT_ASSIGNMENT |
| Table Description |
The CACI_ACCOUNT_ASSIGNMENT table contains the account assignment of the charging contract items. |
| Tablespace |
SUBSCRIBER_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The CACI_ACCOUNT_ASSIGNMENT database table is defined by the following columns.
Column: CACI_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: CACI
- Foreign field(s): PARTITION_ID,OID
|
| Index(es) |
IX_CACI_AA
|
| Column Description |
The identifier of the charging contract item. |
Column: CACO_OID
| Value Type |
BIGINT, NOT NULL |
|
| Column Description |
The identifier of the charging contract. |
Column: PARTITION_ID
| Value Type |
SMALLINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: CACI
- Foreign field(s): PARTITION_ID,OID
|
| Column Description |
The partition of the subscriber account. |
Column: NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name of the account assignment. |
Column: ACCOUNT_TYPE
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
The type of account. Possible values are:
|
Column: ACCOUNT_ID
| Value Type |
VARCHAR(256) |
|
| Column Description |
The account id of the account assignment. |
Column: START_DATE
| Value Type |
DATE |
|
| Column Description |
The effective date of the account assignment. |
Column: END_DATE
| Value Type |
DATE |
|
| Column Description |
The expiration date of the account assignment. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.