CATENTRY_ID | BIGINT NOT NULL | The internal reference number of the catalog
entry. |
MEMBER_ID | BIGINT NOT NULL | The reference number that identifies the owner of
the catalog entry. Along with the PARTNUMBER, these columns are a
unique index. |
ITEMSPC_ID | BIGINT | The specified item that this catalog entry
relates to. This column should only be populated for catalog
entries that are of type "ItemBean", "PackageBean", or
"DynamicKitBean". Specified items are used for fulfillment. |
CATENTTYPE_ID | CHAR (16) NOT NULL | Identifies the type of catalog entry. Foreign key to the CATENTTYPE table. The supported
default types are: ProductBean, VariantBean, ItemBean, PackageBean,
BundleBean and DynamicKitBean. |
PARTNUMBER | VARCHAR (64) NOT NULL | The reference number that identifies the part
number of the catalog entry. Along with the MEMBER_ID, these
columns are a unique index. |
MFPARTNUMBER | VARCHAR (64) | The part number used by the manufacturer to
identify this catalog entry. |
MFNAME | VARCHAR (64) | The name of the manufacturer of this catalog
entry. |
MARKFORDELETE | INTEGER NOT NULL | Indicates if this catalog entry has been marked
for deletion:
0 = No.
1 = Yes. |
URL | VARCHAR (254) | The URL to this catalog entry, which can be used
as a download URL for soft goods. |
FIELD1 | INTEGER | Customizable. |
FIELD2 | INTEGER | Customizable. |
LASTUPDATE | TIMESTAMP | Indicates the last time the catalog entry was
updated. |
FIELD3 | DECIMAL (20,5) | Customizable. |
ONSPECIAL | INTEGER | This flag identifies if this catalog entry is on
special. |
ONAUCTION | INTEGER | This flag identifies if this catalog entry is on
auction. |
FIELD4 | VARCHAR (254) | Customizable. |
FIELD5 | VARCHAR (254) | Customizable. |
BUYABLE | INTEGER | Indicates whether this catalog entry can be
purchased individually: 1=yes and 0=no. |
OID | VARCHAR (64) | Reserved for HCL internal use. |
BASEITEM_ID | BIGINT | The base item to which this catalog entry
relates. This column should only be populated for catalog entries
that are of type ProductBean, PackageBean or DynamicKitBean. Base
items are used for fulfillment. |
STATE | CHAR (1) DEFAULT '1' | Reserved for HCL 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 | Reserved for HCL 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. |
UP_MFNAME | VARCHAR (64) | The equivalent value of the MFNAME column in
upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
UP_MFPARTNUMBER | VARCHAR (64) | The equivalent value of the MFPARTNUMBER column
in upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
UP_PARTNUMBER | VARCHAR (64) | The equivalent value of the PARTNUMBER column in
upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
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. |