CHARGED_ITEM

Charged Item

Definition

The CHARGED_ITEM table contains the charged items of the processing result obtained when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

Technical Data

Schema Version	2023.0.2
Filegroup	COCKPIT_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by	Definition
OID	PK_CHARGED_ITEM				CHARGED_ITEM (MASTERCHARGEDITEM_OID) CHARGING_NOTIFICATION (RELATEDCHARGEDITEM_OID) CHARGING_PROPERTY (CHARGEDITEM_OID)	The unique identifier of the charged item. It is generated by the SAP CC Cockpit application.
CHARGED_ITEM_KEY						The identifier of the charged item among other charged items in the charging result
ACCOUNT						The name of the account which is charged
CHARGED_ITEM_CLASS				CHARGED_ITEM_CLASS (OID)		The name of the related charged item class
AMOUNT_VALUE						The amount of the charged item
AMOUNT_CURRENCY						The currency of the amount of the charged item
OPERATION_TYPE						The operation type of the charged item More...
ACCOUNT_OPERATION_KEY						The identifier of the account operation linked to the charged item
MASTER_ACCOUNT_OPERATION_KEY						The identifier of the account operation linked to the master charged item if the charged item is dependent
MASTERCHARGEDITEM_OID				CHARGED_ITEM (OID)		The unique identifier of the master charged item if the charged item is dependent
CHARGINGRESULT_OID				CHARGING_RESULT (OID)		The unique identifier of the charging result that owns the charged item

Column Details

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

OID

Definition	The unique identifier of the charged item. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CHARGED_ITEM

CHARGED_ITEM_KEY

Definition	The identifier of the charged item among other charged items in the charging result
Type	NVARCHAR(255), NULL

ACCOUNT

Definition	The name of the account which is charged
Type	NVARCHAR(256), NULL

CHARGED_ITEM_CLASS

Definition	The name of the related charged item class
Type	NVARCHAR(256), NULL

AMOUNT_VALUE

Definition	The amount of the charged item
Type	DECIMAL(28,6), NULL

AMOUNT_CURRENCY

Definition	The currency of the amount of the charged item
Type	NVARCHAR(255), NULL

OPERATION_TYPE

Definition	The operation type of the charged item
Format	The possible values are: 0: Debit 1: Credit
Type	DECIMAL(10), NULL

ACCOUNT_OPERATION_KEY

Definition	The identifier of the account operation linked to the charged item
Type	NVARCHAR(255), NULL

MASTER_ACCOUNT_OPERATION_KEY

Definition	The identifier of the account operation linked to the master charged item if the charged item is dependent
Type	NVARCHAR(255), NULL

MASTERCHARGEDITEM_OID

Definition	The unique identifier of the master charged item if the charged item is dependent
Type	DECIMAL(28), NULL

CHARGINGRESULT_OID

Definition	The unique identifier of the charging result that owns the charged item
Type	DECIMAL(28), NULL

Primary Key Details

See the primary key information:

PK_CHARGED_ITEM

Column(s)	OID
Filegroup	COCKPIT_DATA