PREPAID_TRANSAC_MAPPING

Definition

The PREPAID_TRANSAC_MAPPING table defines the mapping between prepaid details coming from the rating context and specific fields in the prepaid transaction files

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The PREPAID_TRANSAC_MAPPING 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
CCON_OID			IX_PPTM_CCON	CHARGE_CONDITION (OID)		The ID of the charge condition
INDEX_IN_PPTM						The index of the mapping
TRANSACTION_FIELD						The name of the field where the detail is stored in the prepaid transaction files
PROPERTY_NAME						The name of the detail to map
STRING_VALUE						The value of the detail when it is a string
NUMBER_VALUE						The value of the detail when it is a number
DATE_VALUE						The value of the detail when it is a date

Column Details

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

CCON_OID

Definition	The ID of the charge condition
Type	DECIMAL(28), NULL
Available Index	IX_PPTM_CCON

INDEX_IN_PPTM

Definition	The index of the mapping
Type	DECIMAL(5), NOT NULL

TRANSACTION_FIELD

Definition	The name of the field where the detail is stored in the prepaid transaction files
Type	NVARCHAR(4), NOT NULL

PROPERTY_NAME

Definition	The name of the detail to map
Type	NVARCHAR(256), NULL

STRING_VALUE

Definition	The value of the detail when it is a string
Type	NVARCHAR(64), NULL

NUMBER_VALUE

Definition	The value of the detail when it is a number
Type	DECIMAL(28,6), NULL

DATE_VALUE

Definition	The value of the detail when it is a date
Type	DATETIME, NULL

Index Details

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

IX_PPTM_CCON

Indexed Column(s)	CCON_OID
Unique	No
Partitioned	No
Clustered	No