CHARGE_CONDITION

Definition

The CHARGE_CONDITION table describes the relationships between charge components and offer conditions

Technical Data

Schema Version	2022.0.2
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The CHARGE_CONDITION table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	IX	Uses	Used by	Definition
OID	PK_CHARGE_CONDITION			TRANSAC_TEMPLATE_DESC (CCON_OID) CHARGED_ITEM_MAPPING (CCON_OID) PREPAID_TRANSAC_MAPPING (CCON_OID) TAX_PARAMETER_SET (CCON_OID) CCON_TRANSLATION_INSTANCE (CCON_OID) CCON_TIER_TABLE_INSTANCE (CCON_OID) CCON_PARAMETER (CCON_OID) CCON_COUNTER_DESC (CCON_OID)	The identifier of the charge condition
SUB_CODE					The code of the charge condition
DESCRIPTION					The description of the charge condition
CURRENCY_CODE			CURRENCY (CODE)		The currency code of the charge condition
MULTI_CURRENCIES					Specifies whether the charge condition is multicurrencies or not
RELATIONSHIP_TYPE					The type of relation between charge components and offer conditions More...
OPERATION_TYPE					The type of operation More...
ADJUSTMENT_MODE					This field indicates if a new transaction is created for the dependent charge and if the transaction corresponding to the master charge is modified (or adjusted) according to the dependent charge More...
MANUAL_ACTIVABLE					This field indicates if the charge condition is mandatory More...
USE_PREVIOUS_DISCOUNTED_AMOUNT					This field indicates if a discount must be applied to the amount of the master charge from which the previous discounts have already been subtracted More...
DEPENDENT_ROLE					The role for a dependent charge More...
CHRG_OID		IX_CCON_CHRG			The identifier of the charge component related to the charge condition
CCON_OID					The identifier of the charge condition contained in the offer associated to the CCON_OFFE_OID field and related to this charge condition
CCON_OFFE_OID					The identifier of the offer related to the offer condition containing the charge condition (see the CCON_OID field)
OFFE_OID		IX_CCON_OFFE	OFFER (OID)		The identifier of the offer containing the charge condition
OCON_OID		IX_CCON_OCON	OFFER_CONDITION (OID)		The identifier of the offer condition containing the charge condition

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The identifier of the charge condition
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CHARGE_CONDITION

SUB_CODE

Definition	The code of the charge condition
Type	NVARCHAR(256), NULL

DESCRIPTION

Definition	The description of the charge condition
Type	NVARCHAR(2000), NULL

CURRENCY_CODE

Definition	The currency code of the charge condition
Type	NVARCHAR(5), NULL

MULTI_CURRENCIES

Definition	Specifies whether the charge condition is multicurrencies or not
Type	DECIMAL(1), NOT NULL
Default	0

RELATIONSHIP_TYPE

Definition The type of relation between charge components and offer conditions

Format

The possible values are:

0: client
1: partner

Type DECIMAL(1), NOT NULL

OPERATION_TYPE

Definition The type of operation

Format

The possible values are:

0: debit
1: credit

Type DECIMAL(1), NOT NULL

ADJUSTMENT_MODE

Definition	This field indicates if a new transaction is created for the dependent charge and if the transaction corresponding to the master charge is modified (or adjusted) according to the dependent charge
Description	This field indicates if a new transaction is created for the dependent charge and if the transaction corresponding to the master charge is modified (or adjusted) according to the dependent charge. Used only if the charge is a dependent charge.
Format	This field indicates if a new transaction is created for the dependent charge and if the transaction corresponding to the master charge is modified (or adjusted) according to the dependent charge. Used only if the charge is a dependent charge. The possible values are: `0`: no adjustment. A transaction is created for the dependent charge and the master transaction is not modified. `1`: merging. No transaction is created for the dependent charge but the master transaction is modified to take the dependent amount into account. `2`: splitting. The master transaction is split into two transactions: one corresponding to the dependent charge and another master one modified according to the dependent charge. Note Transaction adjustment depends on the role of the dependent charge (see the DEPENDENT_ROLE field). The 3 modes are not always available.
Type	DECIMAL(1), NOT NULL

MANUAL_ACTIVABLE

Definition This field indicates if the charge condition is mandatory

Format

The possible values are:

0: mandatory
1: optional

Type DECIMAL(1), NOT NULL

USE_PREVIOUS_DISCOUNTED_AMOUNT

Definition This field indicates if a discount must be applied to the amount of the master charge from which the previous discounts have already been subtracted

Format

The possible values are:

0: Apply the discount on the initial amount of the master charge.
1: Apply the discount on the previously discounted amount.

Type DECIMAL(1), NULL

DEPENDENT_ROLE

Definition

The role for a dependent charge

Format

The possible values are:

partnerCommission (corresponding to the Commission role in the SAP CC Core Tool user interface)
commission (corresponding to the Third party billed commission role in SAP CC Core Tool)
sponsorship
discount
other

Type

NVARCHAR(256), NULL

CHRG_OID

Definition	The identifier of the charge component related to the charge condition
Type	DECIMAL(28), NULL
Available Index	IX_CCON_CHRG

CCON_OID

Definition	The identifier of the charge condition contained in the offer associated to the CCON_OFFE_OID field and related to this charge condition
Type	DECIMAL(28), NULL

CCON_OFFE_OID

Definition	The identifier of the offer related to the offer condition containing the charge condition (see the CCON_OID field)
Type	DECIMAL(28), NULL

OFFE_OID

Definition	The identifier of the offer containing the charge condition
Type	DECIMAL(28), NULL
Available Index	IX_CCON_OFFE

OCON_OID

Definition	The identifier of the offer condition containing the charge condition
Type	DECIMAL(28), NULL
Available Index	IX_CCON_OCON

Primary Key Details

See the primary key information:

PK_CHARGE_CONDITION

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_CCON_CHRG

Indexed Column(s)	CHRG_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_CCON_OCON

Indexed Column(s)	OCON_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_CCON_OFFE

Indexed Column(s)	OFFE_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX