OBJECT_CHANGE_NUMBER
Description
The OBJECT_CHANGE_NUMBER table contains details on the last modification performed
on each of the following objects:
- all the objects of the pricing catalog
- public holidays
- counter names dictionary
- VAT rate
- VAT rule
Technical Data
Summary
The OBJECT_CHANGE_NUMBER table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The unique identifier of the object |
| Description |
The unique identifier of the object. It is generated by the SAP CC system for the
objects of the catalog. For other objects, there is the following correspondence:
-1: public holidays
- -2: VAT rate
- -4: VAT rule
- -8: counter names dictionary
|
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_OCN_OID |
VERSION_ID
| Definition |
The identifier of the last change performed on the object. It is determined at database
level and incremented each time a change is performed on any object.
|
| Type |
DECIMAL(28), NULL |
| Available Index |
IX_OCN_VERSION_ID |
OBJECT_TYPE
| Definition |
The type of object |
| Format |
The possible values are:
2: charge, refill logic, and allowance logic
- 3: pricing macro
- 4: offer
- 6: translation table
- 8: public holidays
- 9: VAT rate
- 11: tier table
- 12: charge plan, refill plan, and allowance plan
- 14: refill record class
- 15: mapping table class
- 16: mapping table
- 17: counter names dictionary
- 19: aggregation policy
- 20: product
- 23: chargeable item class and charged item class
- 24: exportable item mapping
- 25: VAT rule
- 26: range table class
- 27: range table
- 30: allowance interface
- 31: allowance event class
- 32: spending status description
- 33: monitoring plan
34: refill item class
|
| Type |
DECIMAL(3), NOT NULL |
LAST_ACTION_TYPE
| Definition |
The type of the last action performed on the object |
| Format |
The possible values are:
1: creation
2: modification
3: deletion
|
| Type |
DECIMAL(1), NOT NULL |
LAST_ACTION_DATE
| Definition |
The date of the last action performed on the object |
| Type |
DATETIME, NOT NULL |
Index Details
The following database indexes are available in the
OBJECT_CHANGE_NUMBER database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_OCN_VERSION_ID
| Indexed Column(s) |
VERSION_ID |
| Unique |
Yes |
| Partitioned |
No |
| Clustered |
No |
| Filegroup |
CATALOG_INDX |
IX_OCN_OID
| Indexed Column(s) |
OID |
| Unique |
Yes |
| Partitioned |
No |
| Clustered |
No |
| Filegroup |
CATALOG_INDX |
