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
Tablespace	CATALOG_DATA
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	VARCHAR(4), NOT NULL

PROPERTY_NAME

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

STRING_VALUE

Definition	The value of the detail when it is a string
Type	VARCHAR(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	TIMESTAMP, 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
Tablespace	CATALOG_INDX