TIER_TABLE_ROW
Definition
The TIER_TABLE_ROW table contains the rows of tier table instances
Technical Data
Summary
The TIER_TABLE_ROW table is defined by the
following columns.
See the column details for more information.
Column Details
INDEX_IN_TINS
| Definition |
The ordinal number of the row in the tier table instance |
| Type |
DECIMAL(6), NOT NULL |
TINS_OID
| Definition |
The identifier of the tier table instance |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_TIERTR_TINS_OID |
GROUP_NAME
| Definition |
The group name of the row |
| Type |
NVARCHAR(256), NULL |
LOW_RANGE
| Definition |
The lower range |
| Type |
DECIMAL(28,6), NULL |
LOW_RANGE_INC
| Definition |
Is the lower range inclusive |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
UP_RANGE
| Definition |
The upper range |
| Type |
DECIMAL(28,6), NULL |
UP_RANGE_INC
| Definition |
Is the upper range inclusive |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
OUT_BD_01
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_02
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_03
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_04
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_05
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_S_01
| Definition |
A string output value of the row |
| Type |
NVARCHAR(256), NULL |
OUT_S_02
| Definition |
A string output value of the row |
| Type |
NVARCHAR(256), NULL |
OUT_S_03
| Definition |
A string output value of the row |
| Type |
NVARCHAR(256), NULL |
OUT_S_04
| Definition |
A string output value of the row |
| Type |
NVARCHAR(256), NULL |
OUT_S_05
| Definition |
A string output value of the row |
| Type |
NVARCHAR(256), NULL |
Index Details
The following database indexes are available in the
TIER_TABLE_ROW database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_TIERTR_TINS_OID
| Indexed Column(s) |
TINS_OID |
| Unique |
No |
| Partitioned |
No |
| Clustered |
No |
| Segment |
CATALOG_INDX |
