Overview | Core Database Schema | All Tables All Columns

Table: RATE_COMPONENT_HOLDER

Table Name RATE_COMPONENT_HOLDER
Table Description The RATE_COMPONENT_HOLDER table implements the links between a rating or a charging component and the object which contains the component. For a rating component, the container can be a usage rate, a recurring rate, a one-shot rate or a pricing macro. For a charging component, the container is a charging plan.
Tablespace CATALOG_DATA
Database Core Database
Columns
OID
USRA_OID
RERA_OID
OSRA_OID
MACR_OID
CHPL_OID
VALIDATION_DATE

Columns of the Table

The RATE_COMPONENT_HOLDER database table is defined by the following columns.

Column: OID

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

Foreign K.:

  • Foreign table: USAGE_RATE RECURRING_RATE CHARGING_PLAN PRICING_MACRO ONE_SHOT_RATE
  • Foreign field(s): OID OID OID OID OID
Index(es) IX_RCOH_OSRA
IX_RCOH_RERA
IX_RCOH_USRA
IX_RCOH_MACR
Column Description The component unique identifier.


Column: USRA_OID

Value Type BIGINT
Key(s) -

Foreign K.:

  • Foreign table: USAGE_RATE
  • Foreign field(s): OID
Index(es) IX_RCOH_USRA
Column Description The identifier of the usage rate if it the container is a usage rate.


Column: RERA_OID

Value Type BIGINT
Key(s) -

Foreign K.:

  • Foreign table: RECURRING_RATE
  • Foreign field(s): OID
Index(es) IX_RCOH_RERA
Column Description The identifier of the recurring rate if it the container is a recurring rate.


Column: OSRA_OID

Value Type BIGINT
Key(s) -

Foreign K.:

  • Foreign table: ONE_SHOT_RATE
  • Foreign field(s): OID
Index(es) IX_RCOH_OSRA
Column Description The identifier of the one-shot rate if it the container is a one-shot rate.


Column: MACR_OID

Value Type BIGINT
Key(s) -

Foreign K.:

  • Foreign table: PRICING_MACRO
  • Foreign field(s): OID
Index(es) IX_RCOH_MACR
Column Description The identifier of the pricing macro if it the container is a pricing macro.


Column: CHPL_OID

Value Type BIGINT
Key(s) -

Foreign K.:

  • Foreign table: CHARGING_PLAN
  • Foreign field(s): OID
Column Description The identifier of the charging plan if it the component is a charging one.


Column: VALIDATION_DATE

Value Type DATE
Column Description The date when the component becomes valid.


Top of the list


SAP Convergent Charging 3.0

Document Version: SP04 and later

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