Table: CACI

Table Name CACI
Table Description The CACI table contains the charging contract items.
Tablespace SUBSCRIBER_DATA
Database Core Database
Partitioned Yes
Columns
OID
CACO_OID
PARTITION_ID
EXT_ID
EXT_ID_2
CAPA_OID
TYPE

Columns of the Table

The CACI database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Key(s) Primary Key: PK_CACI

Foreign K.:

  • Foreign table: CACO
  • Foreign field(s): OID

Index(es) IX_CACO_ITM
Column Description The unique identifier of the charging contract item. It is generated by the system.


Column: CACO_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: CACO
  • Foreign field(s): OID

Index(es) IX_CACO_ITM
Column Description The identifier of the charging contract.


Column: PARTITION_ID

Value Type SMALLINT, NOT NULL
Key(s) Primary Key: PK_CACI
Column Description The partition of the subscriber account.


Column: EXT_ID

Value Type VARCHAR(256), NOT NULL
Column Description The identifier of the charging contract item inside the charging contract.


Column: EXT_ID_2

Value Type VARCHAR(256)
Column Description The optional non unique identifier of the charging contract item inside the charging contract.


Column: CAPA_OID

Value Type BIGINT
Column Description The unique identifier of the charge plan.


Column: TYPE

Value Type DECIMAL(1), NOT NULL
Column Description

The type of the charge plan.

Possible values are:

  • 0: charge plan
  • 1: refill plan



Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.