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
Tablespace CATALOG_DATA
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 VARCHAR(256), NOT NULL

          TARGET_NAME

          Definition The name of the charge plan account assignment
          Type VARCHAR(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
          Tablespace CATALOG_INDX