| CMPRMYOBJ_ID | BIGINT NOT NULL | The primary key for this table. |
| OBJECT_ID | BIGINT NOT NULL DEFAULT 0 | The primary key or unique identifier of the
changed primary business object. |
| UI_OBJECT_NAME | VARCHAR (128) | The UI object name associated to the changed
business object. This object name will be listed in the Change
History capabilities under task groups or tasks of a workspace. For
example, some of the supported catalog UI object names are:
SalesCatalog, CatalogGroup, SalesCatalogGroup,
InheritedCatalogGroup, InheritedSalesCatalogGroup, Product,
ProductSKU, CatalogGroupSKU, Bundle, Kit, InheritedProduct,
InheritedProductSKU, InheritedCatalogGroupSKU, InheritedBundle or
InheritedKit. |
| NOUN | VARCHAR (128) | The noun name for the changed primary object.
This is typically the noun name used for services. The following
are samples of noun names: For example: Catalog, CatalogEntry,
Promotion or Attachment. |
| OBJECTCODE | VARCHAR (254) | The unique object code for the changed primary
business object. The object code is typically the external
identifier for that object. For example, the object code for
CatalogEntry is the PARTNUMBER, and for CatalogGROUP it is the
IDENTIFIER. |
| MEMBER_ID | BIGINT NOT NULL | The member id of the user that performed the last
modification on this changed primary business object. |
| LASTUPDATE | TIMESTAMP | The timestamp of the last modification on this
changed primary business object. |
| ACTION | CHAR (1) NOT NULL DEFAULT 'N' | The action that was performed on the last
modification to the primary business object. The possible values
are:
- U=Update
- N=Create
- D=Delete
|
| STOREENT_ID | BIGINT NOT NULL DEFAULT 0 | The reference number for the store for which the
action on the changed primary object was performed. |
| WORKSPACE | VARCHAR (25) | The identifier for the workspace where the change
on the primary business object was performed. If the change was
performed on the approved content, the value recorded in this
column will be: "IBM_WC_BASE". |
| TASKGRP | VARCHAR (25) | The identifier for the task group where the
change on the primary business object was performed. |
| TASK | VARCHAR (25) | The identifier for the task where the change on
the primary business object was performed. |
| SOURCE | SMALLINT NOT NULL | Reserved for HCL internal use. |
| STATUS | SMALLINT NOT NULL DEFAULT 0 | Reserved for HCL internal use. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |