OBJECT_CHANGE_NUMBER

Definition

The OBJECT_CHANGE_NUMBER table contains details on the last performed modifications

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

Schema Version	5.0.6
Partitioned	No

Summary

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

Name	IX	Definition
OID	IX_OCN_OID	The unique identifier of the object More...
VERSION_ID	IX_OCN_VERSION_ID	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.
OBJECT_TYPE		The type of object More...
LAST_ACTION_TYPE		The type of the last action performed on the object More...
LAST_ACTION_DATE		The date of the last action performed on the object

Column Details

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

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	SECONDDATE, 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

IX_OCN_OID

Indexed Column(s)	OID
Unique	Yes
Partitioned	No