CAPA_ACCOUNT_ASSIGNMENT

Definition


The CAPA_ACCOUNT_ASSIGNMENT table contains the account assignments of the charge plan

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
CAPA_OID     IX_CAPA_ACAS  CAPA (OID)
 
 
NAME          
DESCRIPTION          
ACCOUNT_TYPE          

Column Details


CAPA_OID

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

NAME

Definition The name of the assignment
Type VARCHAR(256), NOT NULL

DESCRIPTION

Definition The description of the assignment
Type VARCHAR(2000), NULL

ACCOUNT_TYPE

Definition The type of account
Format

The possible values are:

  • 0: postpaid
  • 1: prepaid

Type DECIMAL(1), NOT NULL

Index Details


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

IX_CAPA_ACAS

Indexed Column(s) CAPA_OID
Unique No
Partitioned No
Tablespace CATALOG_INDX