CAPI_USER_TECH_ID_REF

Definition


The CAPI_USER_TECH_ID_REF table shows which user technical identifier of the charge plan is referenced by the user technical identifier of the charge plan item

Technical Data


Schema Version 5.0.6
Partitioned No

Summary


The CAPI_USER_TECH_ID_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_UITREF  CAPI (OID)
 

    The identifier of the charge plan item
    SERVICE        

      The service of the user technical identifier in the charge plan item
      TARGET_NAME        

        The name of the charge plan user technical identifier

        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_UITREF

        SERVICE

        Definition The service of the user technical identifier in the charge plan item
        Type NVARCHAR(256), NOT NULL

        TARGET_NAME

        Definition The name of the charge plan user technical identifier
        Type NVARCHAR(256), NOT NULL

        Index Details

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

        IX_CAPA_UITREF

        Indexed Column(s) CAPI_OID
        Unique No
        Partitioned No