| Schema Version | 5.0.6 | |
| Partitioned | No | |
The ACTI_CHARGING_MAPPING 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 |
|---|---|---|---|---|---|---|
| ACTI_OID | IX_CA_MAPPING | CHARGE_ACTIVATION (OID)
|
|
The identifier of the charge activation | ||
| SUAC_OID |
|
The identifier of the subscriber account | ||||
| REFERENCE_CODE |
|
The code of the charging reference | ||||
| EXTERNAL_ACCOUNT_CODE |
|
The code of the external account if the account to be charged is external | ||||
| PREPAID_ACCOUNT_CODE |
|
The identifier code of the prepaid account if the account to be charged is prepaid | ||||
| CREDIT_LIMIT1_CODE |
|
The code of the first credit limit balance | ||||
| CREDIT_LIMIT2_CODE |
|
The code of the second credit limit balance | ||||
| CREDIT_LIMIT3_CODE |
|
The code of the third credit limit balance | ||||
| ROOT_SUBS_OID | IX_ACM_ROOT_SUBS_OID |
|
The identifier of the root subscription for the charge activation | |||
| PARTITION_ID |
|
The partition of the subscriber account containing the charge activation |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The identifier of the charge activation |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_CA_MAPPING |
| Definition | The identifier of the subscriber account |
| Type | DECIMAL(28), NOT NULL |
| Definition | The code of the charging reference |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The code of the external account if the account to be charged is external |
| Type | NVARCHAR(256), NULL |
| Definition | The identifier code of the prepaid account if the account to be charged is prepaid |
| Type | NVARCHAR(256), NULL |
| Definition | The code of the first credit limit balance |
| Type | NVARCHAR(256), NULL |
| Definition | The code of the second credit limit balance |
| Type | NVARCHAR(256), NULL |
| Definition | The code of the third credit limit balance |
| Type | NVARCHAR(256), NULL |
| Definition | The identifier of the root subscription for the charge activation |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_ACM_ROOT_SUBS_OID |
| Definition | The partition of the subscriber account containing the charge activation |
| Type | DECIMAL(4), NOT NULL |
The following database indexes are available in the ACTI_CHARGING_MAPPING database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | ACTI_OID |
| Unique | No |
| Partitioned | No |
| Indexed Column(s) | ROOT_SUBS_OID |
| Unique | No |
| Partitioned | Yes |
