SUMT_MARO

Definition

The SUMT_MARO table contains the rows of the Subscriber Mapping Tables

Technical Data

Schema Version	2022.0.2
Filegroup	SUBSCRIBER_DATA
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	PK	FK	IX	Uses	Used by	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
IN_21						The value of the twenty-first input column
IN_22						The value of the twenty-second input column
IN_23						The value of the twenty-third input column
IN_24						The value of the twenty-fourth input column
IN_25						The value of the twenty-fifth input column
IN_26						The value of the twenty-sixth input column
IN_27						The value of the twenty-seventh input column
IN_28						The value of the twenty-eighth input column
IN_29						The value of the twenty-ninth input column
IN_30						The value of the thirtieth input column
IN_31						The value of the thirty-first input column
IN_32						The value of the thirty-second input column
IN_33						The value of the thirty-third input column
IN_34						The value of the thirty-fourth input column
IN_35						The value of the thirty-fifth input column
IN_36						The value of the thirty-sixth input column
IN_37						The value of the thirty-seventh input column
IN_38						The value of the thirty-eighth input column
IN_39						The value of the thirty-ninth input column
IN_40						The value of the fortieth 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

IN_21

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

IN_22

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

IN_23

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

IN_24

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

IN_25

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

IN_26

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

IN_27

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

IN_28

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

IN_29

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

IN_30

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

IN_31

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

IN_32

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

IN_33

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

IN_34

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

IN_35

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

IN_36

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

IN_37

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

IN_38

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

IN_39

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

IN_40

Definition	The value of the fortieth 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
Filegroup	SUBSCRIBER_INDX