Table: PREPAID_TRANSAC_MAPPING

Table Name PREPAID_TRANSAC_MAPPING
Table Description The PREPAID_TRANSAC_MAPPING table defines the mapping between prepaid details coming from the rating context and specific fields in the prepaid transaction files.
Tablespace CATALOG_DATA
Database Core Database
Columns
CCON_OID
INDEX_IN_PPTM
TRANSACTION_FIELD
PROPERTY_NAME
STRING_VALUE
NUMBER_VALUE
DATE_VALUE

Columns of the Table

The PREPAID_TRANSAC_MAPPING database table is defined by the following columns.

Column: CCON_OID

Value Type BIGINT
Key(s) -

Foreign K.:

  • Foreign table: CHARGE_CONDITION
  • Foreign field(s): OID

Index(es) IX_PPTM_CCON
Column Description The ID of the charge condition.


Column: INDEX_IN_PPTM

Value Type DECIMAL(5), NOT NULL
Column Description The index of the mapping.


Column: TRANSACTION_FIELD

Value Type VARCHAR(4), NOT NULL
Column Description The name of the field where the detail is stored in the prepaid transaction files.


Column: PROPERTY_NAME

Value Type VARCHAR(256)
Column Description The name of the detail to map.


Column: STRING_VALUE

Value Type VARCHAR(64)
Column Description The value of the detail when it is a string.


Column: NUMBER_VALUE

Value Type DECIMAL(28,6)
Column Description The value of the detail when it is a number.


Column: DATE_VALUE

Value Type DATE
Column Description The value of the detail when it is a date.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.