SHAL

Shared Allowances (in Customer Master Data)

Definition

The SHAL table contains the list of shared allowances

Description

The SHAL table contains the list of allowances that are shared among multiple subscriber accounts.

Technical Data

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

Summary

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

Name	PK	IX	Uses	Definition
SHARE_ID				Sharing identifier, specified at shared allowance creation time
SUAC_OID			SUBSCRIBER_ACCOUNT (OID)	The identifier of the subscriber account related to the shared allowance
CACO_OID			CACO (OID)	The identifier of the contract related to the shared allowance
ALLO_OID	PK_SHAL	IX_SHAL_VERSION_ID	ALLO (OID)	The identifier of the shared allowance
PARTITION_ID	PK_SHAL	IX_SHAL_VERSION_ID		The identifier of the database partition that contains the shared allowance
VERSION_ID		IX_SHAL_VERSION_ID		The identifier of the version of the shared allowance
PURGE_DATE				The date and time the shared allowance has been purged
OP_STATUS				The operational status of the charging contract related to the shared allowance More...

Column Details

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

SHARE_ID

Definition	Sharing identifier, specified at shared allowance creation time
Type	NVARCHAR(256), NOT NULL

SUAC_OID

Definition	The identifier of the subscriber account related to the shared allowance
Type	DECIMAL(28), NOT NULL

CACO_OID

Definition	The identifier of the contract related to the shared allowance
Type	DECIMAL(28), NOT NULL

ALLO_OID

Definition	The identifier of the shared allowance
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SHAL
Available Index	IX_SHAL_VERSION_ID

PARTITION_ID

Definition	The identifier of the database partition that contains the shared allowance
Type	DECIMAL(4), NOT NULL
Primary Key	PK_SHAL
Available Index	IX_SHAL_VERSION_ID

VERSION_ID

Definition	The identifier of the version of the shared allowance
Type	DECIMAL(28), NOT NULL
Available Index	IX_SHAL_VERSION_ID

PURGE_DATE

Definition	The date and time the shared allowance has been purged
Type	DATETIME, NULL

OP_STATUS

Definition	The operational status of the charging contract related to the shared allowance
Description	The operational status indicates if you can modify a charging contract and its linked contracts and use them in the SAP CC processes. The value of the operational status for the linked charging contracts is always set to `0` but this value is not used. The linked charging contracts inherit from the operational status of their parent charging contract.
Format	The possible values are: `0` : active. You can modify the contract and use it in the SAP CC standard processes. `1` : locked. The contract is temporarily suspended. You cannot modify this contract. Processes can no longer use this contract. `2` : closed. The contract is permanently locked. You cannot modify this contract or its operational status. Processes can no longer use this contract.
Type	DECIMAL(1), NOT NULL

Primary Key Details

See the primary key information:

PK_SHAL

Column(s)	PARTITION_ID,ALLO_OID
Filegroup	ALLOWANCE_DATA

Index Details

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

IX_SHAL_VERSION_ID

Indexed Column(s)	PARTITION_ID,VERSION_ID,ALLO_OID
Unique	Yes
Partitioned	Yes
Clustered	No
Filegroup	ALLOWANCE_INDX