TRANSAC_TEMPLATE_DESC
Description
The TRANSAC_TEMPLATE_DESC table contains the description of transaction templates.
Transaction templates are used to filter postpaid transaction details.
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
CATALOG_DATA |
| Partitioned |
No |
Summary
The TRANSAC_TEMPLATE_DESC table is defined by the
following columns.
See the column details for more information.
Column Details
OID
DISPATCH1
| Definition |
This field contains a property of the transaction selected by the SAP CC user |
| Type |
VARCHAR2(256 CHAR), NULL |
DISPATCH2
| Definition |
This field contains a property of the transaction selected by the SAP CC user |
| Type |
VARCHAR2(256 CHAR), NULL |
DISPATCH3
| Definition |
This field contains a property of the transaction selected by the SAP CC user |
| Type |
VARCHAR2(256 CHAR), NULL |
FILTERING
| Definition |
This field indicates if the filtering is activated |
| Format |
The possible values are:
0: Filtering is not activated
1: Filtering is activated
|
| Type |
DECIMAL(1), NOT NULL |
FILTER_LABEL
| Definition |
This field indicates if the name of the rate in the price plan is stored in the database |
| Format |
The possible values are:
0: the name is stored in the database
1: the name is not stored in the database
|
| Type |
DECIMAL(1), NULL |
FILTER_CHARGE_CODE
| Definition |
This field indicates if the code of the charge is stored in the database |
| Format |
The possible values are:
0: The code is stored in the database
1: The code is not stored in the database
|
| Type |
DECIMAL(1), NULL |
FILTER_OFFER_CODE
| Definition |
This field indicates if the code of the offer is stored in the database |
| Format |
The possible values are:
0: the code is stored in the database
1: the code is not stored in the database
|
| Type |
DECIMAL(1), NULL |
CCON_OID
| Definition |
The identifier of the charge condition |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_TTEM_CCON |
Primary Key Details
PK_TRANSAC_TEMPLATE_DESC
Index Details
The following database indexes are available in the
TRANSAC_TEMPLATE_DESC database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_TTEM_CCON
| Indexed Column(s) |
CCON_OID |
| Unique |
No |
| Partitioned |
No |
| Tablespace |
CATALOG_INDX |
