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
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