Table: CAPI

Table Name CAPI
Table Description The CAPI table contains charge plan items.
Tablespace CATALOG_DATA
Database Core Database
Columns
OID
CAPA_OID
ID
RELATIONSHIP_TYPE
OPERATION_TYPE

Columns of the Table

The CAPI database table is defined by the following columns.

Column: OID

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

Foreign K.:

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

Index(es) IX_CAPA_ITM
Column Description The unique identifier of the charge plan item. It is generated by the system.


Column: CAPA_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

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

Index(es) IX_CAPA_ITM
Column Description The identifier of the charge plan.


Column: ID

Value Type VARCHAR(256), NOT NULL
Key(s) Primary Key: PK_CAPI

Foreign K.:

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

Index(es) IX_CAPA_ITM
Column Description The identifier of the charge plan item in the charge plan.


Column: RELATIONSHIP_TYPE

Value Type DECIMAL(1), NOT NULL
Column Description The type of relationship with the service provider. Possible values are:
  • 0: client
  • 1: partner


Column: OPERATION_TYPE

Value Type DECIMAL(1), NOT NULL
Column Description The type of operation. This field indicates whether the account of the client or the partner involved will be credited or debited. Possible values are:
  • 0: debit
  • 1: credit


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

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