CATALOG

Pricing Catalogs (Master Data)

Definition

The CATALOG table contains the pricing catalogs

Technical Data

Schema Version	2023.0.2
Filegroup	COCKPIT_DATA
Partitioned	No

Summary

The CATALOG 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_CATALOG					The unique identifier of the pricing catalog
NAME			IX_CATALOG_NAME		ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION (CATALOG) ALLOWANCE_PLAN (CATALOG) CHARGEABLE_ITEM (CATALOG) CHARGEABLE_ITEM_CLASS (CATALOG) CHARGED_ITEM_CLASS (CATALOG) CHARGED_ITEM_DEFINITION (CATALOG) CHARGE_TREE (CATALOG) MAPPING_TABLE (CATALOG) MAPPING_TABLE_CLASS (CATALOG) RANGE_TABLE (CATALOG) RANGE_TABLE_CLASS (CATALOG) RATE_PLAN (CATALOG) PRICING_FUNCTION (CATALOG)	The name of the pricing catalog

Column Details

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

OID

Definition	The unique identifier of the pricing catalog
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CATALOG

NAME

Definition	The name of the pricing catalog
Type	NVARCHAR(64), NULL
Available Index	IX_CATALOG_NAME

Primary Key Details

See the primary key information:

PK_CATALOG

Column(s)	OID
Filegroup	COCKPIT_DATA

Index Details

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

IX_CATALOG_NAME

Indexed Column(s)	NAME
Unique	Yes
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX