SUMT_MARO

Definition

The SUMT_MARO table contains the rows of the Subscriber Mapping Tables

Technical Data

Schema Version	5.0.6
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The SUMT_MARO table is defined by the following columns in your back-end database. See the column details for more information.

Name	IX	Uses	Definition
ID			The identifier of the row. It must be unique in the Subscriber Mapping Table containing the row
IN_01			The value of the first input column
IN_02			The value of the second input column
IN_03			The value of the third input column
IN_04			The value of the fourth input column
IN_05			The value of the fifth input column
IN_06			The value of the sixth input column
IN_07			The value of the seventh input column
IN_08			The value of the eighth input column
IN_09			The value of the ninth input column
IN_10			The value of the tenth input column
IN_11			The value of the eleventh input column
IN_12			The value of the twelfth input column
IN_13			The value of the thirteenth input column
IN_14			The value of the fourteenth input column
IN_15			The value of the fifteenth input column
IN_16			The value of the sixteenth input column
IN_17			The value of the seventeenth input column
IN_18			The value of the eighteenth input column
IN_19			The value of the nineteenth input column
IN_20			The value of the twentieth input column
START_DATE			The start date for the row
END_DATE			The end date of the row
OUT_S_01			The value of an output column (String or currency type)
OUT_S_02			The value of an output column (String or currency type)
OUT_S_03			The value of an output column (String or currency type)
OUT_S_04			The value of an output column (String or currency type)
OUT_S_05			The value of an output column (String or currency type)
OUT_S_06			The value of an output column (String or currency type)
OUT_S_07			The value of an output column (String or currency type)
OUT_S_08			The value of an output column (String or currency type)
OUT_S_09			The value of an output column (String or currency type)
OUT_S_10			The value of an output column (String or currency type)
OUT_S_11			The value of an output column (String or currency type)
OUT_S_12			The value of an output column (String or currency type)
OUT_S_13			The value of an output column (String or currency type)
OUT_S_14			The value of an output column (String or currency type)
OUT_S_15			The value of an output column (String or currency type)
OUT_S_16			The value of an output column (String or currency type)
OUT_S_17			The value of an output column (String or currency type)
OUT_S_18			The value of an output column (String or currency type)
OUT_S_19			The value of an output column (String or currency type)
OUT_S_20			The value of an output column (String or currency type)
OUT_S_21			The value of an output column (String or currency type)
OUT_S_22			The value of an output column (String or currency type)
OUT_S_23			The value of an output column (String or currency type)
OUT_S_24			The value of an output column (String or currency type)
OUT_S_25			The value of an output column (String or currency type)
OUT_S_26			The value of an output column (String or currency type)
OUT_S_27			The value of an output column (String or currency type)
OUT_S_28			The value of an output column (String or currency type)
OUT_S_29			The value of an output column (String or currency type)
OUT_S_30			The value of an output column (String or currency type)
OUT_N_01			The value of an output column (Number type)
OUT_N_02			The value of an output column (Number type)
OUT_N_03			The value of an output column (Number type)
OUT_N_04			The value of an output column (Number type)
OUT_N_05			The value of an output column (Number type)
OUT_N_06			The value of an output column (Number type)
OUT_N_07			The value of an output column (Number type)
OUT_N_08			The value of an output column (Number type)
OUT_N_09			The value of an output column (Number type)
OUT_N_10			The value of an output column (Number type)
OUT_N_11			The value of an output column (Number type)
OUT_N_12			The value of an output column (Number type)
OUT_N_13			The value of an output column (Number type)
OUT_N_14			The value of an output column (Number type)
OUT_N_15			The value of an output column (Number type)
OUT_N_16			The value of an output column (Number type)
OUT_N_17			The value of an output column (Number type)
OUT_N_18			The value of an output column (Number type)
OUT_N_19			The value of an output column (Number type)
OUT_N_20			The value of an output column (Number type)
OUT_N_21			The value of an output column (Number type)
OUT_N_22			The value of an output column (Number type)
OUT_N_23			The value of an output column (Number type)
OUT_N_24			The value of an output column (Number type)
OUT_N_25			The value of an output column (Number type)
OUT_N_26			The value of an output column (Number type)
OUT_N_27			The value of an output column (Number type)
OUT_N_28			The value of an output column (Number type)
OUT_N_29			The value of an output column (Number type)
OUT_N_30			The value of an output column (Number type)
SUMT_OID	IX_SUMT_MARO	SUMT (OID)	The identifier of the Subscriber Mapping Table containing the row
PARTITION_ID			The partition of the Subscriber Account the row belongs to

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

ID

Definition	The identifier of the row. It must be unique in the Subscriber Mapping Table containing the row
Type	NVARCHAR(256), NOT NULL

IN_01

Definition	The value of the first input column
Type	NVARCHAR(256), NULL

IN_02

Definition	The value of the second input column
Type	NVARCHAR(256), NULL

IN_03

Definition	The value of the third input column
Type	NVARCHAR(256), NULL

IN_04

Definition	The value of the fourth input column
Type	NVARCHAR(256), NULL

IN_05

Definition	The value of the fifth input column
Type	NVARCHAR(256), NULL

IN_06

Definition	The value of the sixth input column
Type	NVARCHAR(256), NULL

IN_07

Definition	The value of the seventh input column
Type	NVARCHAR(256), NULL

IN_08

Definition	The value of the eighth input column
Type	NVARCHAR(256), NULL

IN_09

Definition	The value of the ninth input column
Type	NVARCHAR(256), NULL

IN_10

Definition	The value of the tenth input column
Type	NVARCHAR(256), NULL

IN_11

Definition	The value of the eleventh input column
Type	NVARCHAR(256), NULL

IN_12

Definition	The value of the twelfth input column
Type	NVARCHAR(256), NULL

IN_13

Definition	The value of the thirteenth input column
Type	NVARCHAR(256), NULL

IN_14

Definition	The value of the fourteenth input column
Type	NVARCHAR(256), NULL

IN_15

Definition	The value of the fifteenth input column
Type	NVARCHAR(256), NULL

IN_16

Definition	The value of the sixteenth input column
Type	NVARCHAR(256), NULL

IN_17

Definition	The value of the seventeenth input column
Type	NVARCHAR(256), NULL

IN_18

Definition	The value of the eighteenth input column
Type	NVARCHAR(256), NULL

IN_19

Definition	The value of the nineteenth input column
Type	NVARCHAR(256), NULL

IN_20

Definition	The value of the twentieth input column
Type	NVARCHAR(256), NULL

START_DATE

Definition	The start date for the row
Type	DATETIME, NOT NULL

END_DATE

Definition	The end date of the row
Type	DATETIME, NOT NULL

OUT_S_01

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_02

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_03

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_04

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_05

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_06

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_07

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_08

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_09

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_10

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_11

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_12

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_13

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_14

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_15

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_16

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_17

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_18

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_19

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_20

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_21

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_22

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_23

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_24

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_25

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_26

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_27

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_28

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_29

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_30

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_N_01

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_02

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_03

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_04

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_05

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_06

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_07

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_08

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_09

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_10

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_11

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_12

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_13

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_14

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_15

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_16

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_17

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_18

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_19

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_20

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_21

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_22

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_23

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_24

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_25

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_26

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_27

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_28

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_29

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_30

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

SUMT_OID

Definition	The identifier of the Subscriber Mapping Table containing the row
Type	DECIMAL(28), NOT NULL
Available Index	IX_SUMT_MARO

PARTITION_ID

Definition	The partition of the Subscriber Account the row belongs to
Type	DECIMAL(4), NOT NULL

Index Details

The following database indexes are available in the SUMT_MARO database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_SUMT_MARO

Indexed Column(s)	SUMT_OID
Unique	No
Partitioned	No
Clustered	No