This table hold the information related to a CatalogEntry. Examples of CatalogEntries include Products, Items, Packages, and Bundles.
Column Description(s):
Column Name | Column Type | Description |
CATENTRY_ID |
BIGINT NOT NULL |
The internal reference number of the CatalogEntry. |
MEMBER_ID |
BIGINT NOT NULL |
The reference number that identifies the owner of the CatalogEntry. Along with the PARTNUMBER, these columns are a unique index. |
ITEMSPC_ID |
BIGINT |
The SpecifiedItem that this CatalogEntry relates to. This column should only be populated for CatalogEntries that are of type "ItemBean", "PackageBean", or "DynamicKitBean". SpecifiedItems are used for fulfillment. |
CATENTTYPE_ID |
CHAR(16) NOT NULL |
Identifies the type of CatalogEntry. Foreign key to the CATENTTYPE table. The supported default types are: ProductBean, ItemBean, PackageBean, BundleBean and DynamicKitBean. |
PARTNUMBER |
VARCHAR(64) NOT NULL |
The reference number that identifies the part number of the CatalogEntry. Along with the MEMBER_ID, these columns are a unique index. |
MFPARTNUMBER |
VARCHAR(64) |
The part number used by the manufacturer to identify this CatalogEntry. |
MFNAME |
VARCHAR(64) |
The name of the manufacturer of this CatalogEntry. |
MARKFORDELETE |
INTEGER NOT NULL |
Indicates if this CatalogEntry has been marked for deletion:
0 = No.
1 = Yes. |
URL |
VARCHAR(254) |
The URL to this CatalogEntry, which can be used as a download URL for soft goods. |
FIELD1 |
INTEGER |
Customizable. |
FIELD2 |
INTEGER |
Customizable. |
LASTUPDATE |
TIMESTAMP |
Indicates the last time the CatalogEntry was updated. |
FIELD3 |
DECIMAL (20,5) |
Customizable. |
ONSPECIAL |
INTEGER |
This flag identifies if this CatalogEntry is on special. |
ONAUCTION |
INTEGER |
This flag identifies if this CatalogEntry is on auction. |
FIELD4 |
VARCHAR(254) |
Customizable. |
FIELD5 |
VARCHAR(254) |
Customizable. |
BUYABLE |
INTEGER |
Indicates whether this CatalogEntry can be purchased individually: 1=yes and 0=no. |
OID |
VARCHAR(64) |
Reserved for IBM internal use. |
BASEITEM_ID |
BIGINT |
The BaseItem to which this CatalogEntry relates. This column should only be populated for CatalogEntries that are of type ProductBean, PackageBean or DynamicKitBean. BaseItems are used for fulfillment. |
STATE |
CHAR(1) DEFAULT '1' |
Reserved for IBM internal use. |
STARTDATE |
TIMESTAMP |
The date when this catalog entry is introduced. This column is for your interpretation and information only. |
ENDDATE |
TIMESTAMP |
The date when this catalog entry is withdrawn. This column is for your interpretation and information only. |
RANK |
DOUBLE |
Relative search ranking. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
AVAILABILITYDATE |
TIMESTAMP |
The date that the product is available to customers for purchase. This column is for your interpretation and information only. |
LASTORDERDATE |
TIMESTAMP |
The final date that the product is available for order. This is the latest date a customer can order the product. This column is for your interpretation and information only. |
ENDOFSERVICEDATE |
TIMESTAMP |
The date when the product is no longer in service. For example, this date can be the date that a software manufacturer stops providing upgrades for a version of their product. This column is for your interpretation and information only. |
DISCONTINUEDATE |
TIMESTAMP |
The date when the product is discontinued. For example, this date can be the date the manufacturer stops producing the product, or the date your store stops selling the product. It is recommended that this column be used consistently to avoid confusion. This column is for your interpretation and information only. |