CAPI_ACCOUNT_ASSIGNMENT_REF

Definition

The CAPI_ACCOUNT_ASSIGNMENT_REF table shows which account assignment of the charge plan is referenced by the account assignment of the charge plan item

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
CAPI_OID			IX_CAPA_ACASREF	CAPI (OID)
NAME
TARGET_NAME
ACCOUNT_TYPE

Column Details

CAPI_OID

Definition	The identifier of the charge plan item
Type	DECIMAL(28), NOT NULL
Available Index	IX_CAPA_ACASREF

NAME

Definition	The name of the account assignment of the charge plan item
Type	NVARCHAR(256), NOT NULL

TARGET_NAME

Definition	The name of the charge plan account assignment
Type	NVARCHAR(256), NOT NULL

ACCOUNT_TYPE

Definition	The type of account
Format	The possible values are: 0: postpaid 1: prepaid
Type	DECIMAL(1), NULL

Index Details

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

IX_CAPA_ACASREF

Indexed Column(s)	CAPI_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX