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