CHARGE_CONDITION

Table: CHARGE_CONDITION

Table Name

CHARGE_CONDITION

Table Description

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

Tablespace

CATALOG_DATA

Database

Core Database

Columns

OID
SUB_CODE
DESCRIPTION
CURRENCY_CODE
MULTI_CURRENCIES
RELATIONSHIP_TYPE
OPERATION_TYPE
ADJUSTMENT_MODE
MANUAL_ACTIVABLE
USE_PREVIOUS_DISCOUNTED_AMOUNT
DEPENDENT_ROLE
CHRG_OID
CCON_OID
CCON_OFFE_OID
OFFE_OID
OCON_OID

Columns of the Table

The CHARGE_CONDITION database table is defined by the following columns.

Column: OID

Value Type	BIGINT, NOT NULL
Key(s)	Primary Key: PK_CHARGE_CONDITION	Foreign K.: Foreign table: OFFER_CONDITION OFFER Foreign field(s): OID OID
Index(es)	IX_CCON_CHRG IX_CCON_OCON IX_CCON_OFFE
Column Description	The identifier of the charge condition.

Column: SUB_CODE

Value Type	VARCHAR(256)
Column Description	The code of the charge condition.

Column: DESCRIPTION

Value Type	VARCHAR(2000)
Column Description	The description of the charge condition.

Column: CURRENCY_CODE

Value Type	VARCHAR(5)
Column Description	The currency code of the charge condition.

Column: MULTI_CURRENCIES

Value Type	DECIMAL(1), NOT NULL
Default Value	0
Column Description	Specifies whether the charge condition is multicurrencies or not.

Column: RELATIONSHIP_TYPE

Value Type	DECIMAL(1), NOT NULL
Column Description	The type of relation between charge components and offer conditions. Possible values are: 0: client 1: partner

Column: OPERATION_TYPE

Value Type	DECIMAL(1), NOT NULL
Column Description	The type of operation. Possible values are: 0: debit 1: credit

Column: ADJUSTMENT_MODE

Value Type	DECIMAL(1), NOT NULL
Column 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 depedent charge. 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.

Value Type

DECIMAL(1), NOT NULL

Column 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 depedent charge. 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.

Column: MANUAL_ACTIVABLE

Value Type	DECIMAL(1), NOT NULL
Column Description	This field indicates if the charge condition is mandatory. Possible values are: 0: mandatory 1: optional

Column: USE_PREVIOUS_DISCOUNTED_AMOUNT

Value Type	DECIMAL(1)
Column Description	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. Possible values are: 0: Apply the discount on the initial amount of the master charge. 1: Apply the discount on the previously discounted amount.

Column: DEPENDENT_ROLE

Value Type	VARCHAR(256)
Column Description	The role for a dependent charge. Possible values are: partnerCommission (corresponding to the Commission role in the Core Tool) commission (corresponding to the Third party billed comission role in the Core Tool) sponsorship discount other

Column: CHRG_OID

Value Type	BIGINT
Index(es)	IX_CCON_CHRG
Column Description	The identifier of the charge component related to the charge condition.

Column: CCON_OID

Value Type	BIGINT
Column Description	The identifier of the charge condition contained in the offer associated to the CCON_OFFE_OID field and related to this charge condition.

Column: CCON_OFFE_OID

Value Type	BIGINT
Column Description	The identifier of the offer related to the offer condition containing the charge condition (see the CCON_OID field).

Column: OFFE_OID

Value Type	BIGINT
Key(s)	-	Foreign K.: Foreign table: OFFER Foreign field(s): OID
Index(es)	IX_CCON_OFFE
Column Description	The identifier of the offer containing the charge condition.

Column: OCON_OID

Value Type	BIGINT
Key(s)	-	Foreign K.: Foreign table: OFFER_CONDITION Foreign field(s): OID
Index(es)	IX_CCON_OCON
Column Description	The identifier of the offer condition containing the charge condition.

Top of the list

SAP Convergent Charging 3.0

Document Version: SP04 and later