ALLO
Definition
The ALLO table contains the allowances of the provider contracts as part of the master data related to the end customers of a service provider
Description
The ALLO table contains all the current allowances of the provider contracts as part of
the master data related to the end customers of a service provider (see customer master
data or subscriber data).
Each allowance refers to an allowance plan defined in the pricing catalog of the service provider to monetize its customer service.
Technical Data
| Schema Version | 4.6.2 | |
| Tablespace | ALLOWANCE_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
Summary
The ALLO 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 |
|---|---|---|---|---|---|---|
| OID | PK_ALLO |
|
The unique identifier of the allowance. It is generated by the SAP CC system. | |||
| CACO_OID | IX_ALLO_ITM | CACO (OID)
|
|
The unique identifier of the related charging contract | ||
| CAPA_OID | CAPA (OID)
|
|
The unique identifier of the related allowance plan | |||
| PARTITION_ID | PK_ALLO |
|
The database partition ID assigned to the subscriber account of the related charging contract | |||
| START_DATE |
|
The validity start date of the allowance | ||||
| END_DATE |
|
The validity end date of the allowance | ||||
| ALLO_DATA |
|
The data of the allowance |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
OID
| Definition | The unique identifier of the allowance. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_ALLO |
CACO_OID
| Definition | The unique identifier of the related charging contract |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_ALLO_ITM |
CAPA_OID
| Definition | The unique identifier of the related allowance plan |
| Type | DECIMAL(28), NOT NULL |
PARTITION_ID
| Definition | The database partition ID assigned to the subscriber account of the related charging contract |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_ALLO |
START_DATE
| Definition | The validity start date of the allowance |
| Type | TIMESTAMP, NOT NULL |
END_DATE
| Definition | The validity end date of the allowance |
| Type | TIMESTAMP, NULL |
ALLO_DATA
| Definition | The data of the allowance |
| Description |
The value of this field can be read using the |
| Type | BLOB, NOT NULL |
Primary Key Details
See the primary key information:
PK_ALLO
| Column(s) | PARTITION_ID,OID |
| Tablespace | ALLOWANCE_INDX |
Index Details
The following database indexes are available in the ALLO database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
IX_ALLO_ITM
| Indexed Column(s) | CACO_OID |
| Unique | Yes |
| Partitioned | Yes |
| Tablespace | ALLOWANCE_INDX |