CHARGE_CONDITION
Definition
The CHARGE_CONDITION table describes the relationships between charge components and
offer conditions
Technical Data
| Schema Version |
4.5.13 |
|
| Partitioned |
No |
Summary
The CHARGE_CONDITION table is defined by the
following columns.
See the column details for more information.
Column Details
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:
|
| Type |
DECIMAL(1), NOT NULL |
OPERATION_TYPE
| Definition |
The type of operation |
| Format |
The possible values are:
|
| 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:
|
| 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
PK_CHARGE_CONDITION
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 |
IX_CCON_OCON
| Indexed Column(s) |
OCON_OID |
| Unique |
No |
| Partitioned |
No |
IX_CCON_OFFE
| Indexed Column(s) |
OFFE_OID |
| Unique |
No |
| Partitioned |
No |
