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 5.0.6
Partitioned No

Summary


The CAPI_ACCOUNT_ASSIGNMENT_REF table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
CAPI_OID     IX_CAPA_ACASREF  CAPI (OID)
 

    The identifier of the charge plan item
    NAME        

      The name of the account assignment of the charge plan item
      TARGET_NAME        

        The name of the charge plan account assignment
        ACCOUNT_TYPE        

          The type of account

          More...

          Column Details

          The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

          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