ALLO
Allowances (Customer Master Data)
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 subscriber
data).
Each allowance refers to an allowance plan defined in the pricing catalog of the service provider.
Technical Data
| Schema Version |
4.5.13 |
| 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.
See the column details for more information.
Column Details
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 com.highdeal.allowance.tool.AllowanceBlob Java class.
See the SAP CC Core - Java/XML API Reference documentation for more information about
the development of this function in your client application during the implementation
project.
|
| Type |
BLOB, NOT NULL |
Primary Key Details
PK_ALLO
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 |
