PRICING_MACRO

Description

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The PRICING_MACRO table is defined by the following columns. See the column details for more information.

Name	PK	FK	IX	Uses	Used by
OID	PK_PRICING_MACRO				RATE_COMPONENT_HOLDER (MACR_OID) OUT_MACRO_PROPERTY (MACR_OID) IN_MACRO_PROPERTY (MACR_OID) PMIN_ADDITIONAL_INFO (MACR_OID)
CODE			IX_PRICING_MACRO_CODE
DESCRIPTION
OWNER			IX_PRICING_MACRO_OWNER

Column Details

OID

Definition	The pricing macro unique ID
Description	The pricing macro unique ID. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_PRICING_MACRO

CODE

Definition	The code of the pricing macro
Type	NVARCHAR(256), NOT NULL
Available Index	IX_PRICING_MACRO_CODE

DESCRIPTION

Definition	The description of the pricing macro
Type	NVARCHAR(2000), NULL

OWNER

Definition	The owner of the pricing macro
Type	NVARCHAR(64), NOT NULL
Available Index	IX_PRICING_MACRO_OWNER

Primary Key Details

PK_PRICING_MACRO

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_PRICING_MACRO_OWNER

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

IX_PRICING_MACRO_CODE

Indexed Column(s)	CODE
Unique	Yes
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX