Table:
TRANSAC_TEMPLATE_DESC
|
Table Name
|
TRANSAC_TEMPLATE_DESC |
| Table Description |
The TRANSAC_TEMPLATE_DESC table contains the description of transaction templates. Transaction templates are used to filter
postpaid transaction details.
|
| Tablespace |
CATALOG_DATA |
| Database |
Core Database |
|
Columns
|
|
Columns of the Table
The TRANSAC_TEMPLATE_DESC database table is defined by the following columns.
Column: OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
Primary Key: PK_TRANSAC_TEMPLATE_DESC |
Foreign K.:
- Foreign table: CHARGE_CONDITION
- Foreign field(s): OID
|
| Index(es) |
IX_TTEM_CCON
|
| Column Description |
The identifier of the template. |
Column: DISPATCH1
| Value Type |
VARCHAR(256) |
|
| Column Description |
This field contains a property of the transaction selected by the user. |
Column: DISPATCH2
| Value Type |
VARCHAR(256) |
|
| Column Description |
This field contains a property of the transaction selected by the user. |
Column: DISPATCH3
| Value Type |
VARCHAR(256) |
|
| Column Description |
This field contains a property of the transaction selected by the user. |
Column: FILTERING
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
This field indicates if the filtering is activated. Possible values are:
- 0: filtering is not activated
- 1: filtering is activated
|
Column: FILTER_LABEL
| Value Type |
DECIMAL(1) |
|
| Column Description |
This field indicates if the name of the rate in the price plan is stored in the database. Possible values are:
- 0: the name is stored in the database
- 1: the name is not stored in the database
|
Column: FILTER_CHARGE_CODE
| Value Type |
DECIMAL(1) |
|
| Column Description |
This field indicates if the code of the charge is stored in the database. Possible values are:
- 0: the code is stored in the database
- 1: the code is not stored in the database
|
Column: FILTER_OFFER_CODE
| Value Type |
DECIMAL(1) |
|
| Column Description |
This field indicates if the code of the offer is stored in the database. Possible values are:
- 0: the code is stored in the database
- 1: the code is not stored in the database
|
Column: CCON_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: CHARGE_CONDITION
- Foreign field(s): OID
|
| Index(es) |
IX_TTEM_CCON
|
| Column Description |
The identifier of the charge condition. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.