CATENTRY

This table holds the information related to a catalog entry. Examples of catalog entries include products, items, packages, and bundles.

Column Descriptions:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe internal reference number of the catalog entry.
MEMBER_IDBIGINT NOT NULLThe reference number that identifies the owner of the catalog entry. Along with the PARTNUMBER, these columns are a unique index.
ITEMSPC_IDBIGINTThe 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_IDCHAR (16) NOT NULLIdentifies the type of catalog entry. Foreign key to the CATENTTYPE table. The supported default types are: ProductBean, VariantBean, ItemBean, PackageBean, BundleBean and DynamicKitBean.
PARTNUMBERVARCHAR (64) NOT NULLThe reference number that identifies the part number of the catalog entry. Along with the MEMBER_ID, these columns are a unique index.
MFPARTNUMBERVARCHAR (64)The part number used by the manufacturer to identify this catalog entry.
MFNAMEVARCHAR (64)The name of the manufacturer of this catalog entry.
MARKFORDELETEINTEGER NOT NULLIndicates if this catalog entry has been marked for deletion: 0 = No. 1 = Yes.
URLVARCHAR (254)The URL to this catalog entry, which can be used as a download URL for soft goods.
FIELD1INTEGERCustomizable.
FIELD2INTEGERCustomizable.
LASTUPDATETIMESTAMPIndicates the last time the catalog entry was updated.
FIELD3DECIMAL (20,5)Customizable.
ONSPECIALINTEGERThis flag identifies if this catalog entry is on special.
ONAUCTIONINTEGERThis flag identifies if this catalog entry is on auction.
FIELD4VARCHAR (254)Customizable.
FIELD5VARCHAR (254)Customizable.
BUYABLEINTEGERIndicates whether this catalog entry can be purchased individually: 1=yes and 0=no.
OIDVARCHAR (64)Reserved for HCL internal use.
BASEITEM_IDBIGINTThe 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.
STATECHAR (1) DEFAULT '1'Reserved for HCL internal use.
STARTDATETIMESTAMPThe date when this catalog entry is introduced. This column is for your interpretation and information only.
ENDDATETIMESTAMPThe date when this catalog entry is withdrawn. This column is for your interpretation and information only.
RANKDOUBLEReserved for HCL internal use.
AVAILABILITYDATETIMESTAMPThe date that the product is available to customers for purchase. This column is for your interpretation and information only.
LASTORDERDATETIMESTAMPThe 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.
ENDOFSERVICEDATETIMESTAMPThe 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.
DISCONTINUEDATETIMESTAMPThe 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_MFNAMEVARCHAR (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_MFPARTNUMBERVARCHAR (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_PARTNUMBERVARCHAR (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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATENTRY_IDPrimary Key
I0000064PARTNUMBER+MEMBER_IDUnique Index
I0000065CATENTRY_ID+MARKFORDELETENon-Unique Index
I0000305BUYABLE+CATENTRY_ID+CATENTTYPE_IDNon-Unique Index
I0000375RANKNon-Unique Index
I0000518CATENTTYPE_IDNon-Unique Index
I0000519MEMBER_IDNon-Unique Index
I263103CATENTRY_ID+CATENTTYPE_IDNon-Unique Index
I263121ITEMSPC_IDNon-Unique Index
I263122BASEITEM_IDNon-Unique Index
IPF00003UP_PARTNUMBERNon-Unique Index
IPF00020UP_MFNAMENon-Unique Index
IPF00021UP_MFPARTNUMBERNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_201ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_202BASEITEM_IDBASEITEMBASEITEM_IDCascade
F_203MEMBER_IDMEMBERMEMBER_IDCascade
F_204CATENTTYPE_IDCATENTTYPECATENTTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1061CATENTRY_IDDKPDCRELCATENTRY_IDCascade
F_1151CATENTRY_IDDKOFFERKIT_IDCascade
F_1152CATENTRY_IDDKOFFERCATENTRY_IDCascade
F_1155CATENTRY_IDDKADJMNTKIT_IDCascade
F_1156CATENTRY_IDDKADJMNTCATENTRY_IDCascade
F_1182CATENTRY_IDDKPDCCOMPLISTCATENTRY_IDCascade
F_1185CATENTRY_IDDKPDCCATENTRELCATENTRY_IDCascade
F_186CATENTRY_IDCATCLSFCODCATENTRY_IDCascade
F_189CATENTRY_IDCATCONFINFCATENTRY_IDCascade
F_192CATENTRY_IDCATENCALCDCATENTRY_IDCascade
F_194CATENTRY_IDCATENTATTRCATENTRY_IDCascade
F_196CATENTRY_IDCATENTDESCCATENTRY_IDCascade
F_199CATENTRY_IDCATENTRELCATENTRY_ID_PARENTCascade
F_200CATENTRY_IDCATENTRELCATENTRY_ID_CHILDCascade
F_205CATENTRY_IDCATENTSHIPCATENTRY_IDCascade
F_214CATENTRY_IDCATGPENRELCATENTRY_IDCascade
F_274CATENTRY_IDCPPMNPRODCATENTRY_IDCascade
F_303CATENTRY_IDDISPENTRELCATENTRY_IDCascade
F_3566CATENTRY_IDCATENTRYATTRCATENTRY_IDCascade
F_3581CATENTRY_IDINVAVLCATENTRY_IDCascade
F_3586CATENTRY_IDINVCNFRELCATENTRY_IDCascade
F_3622CATENTRY_IDINSRULECATENTCATENTRY_IDCascade
F_3644CATENTRY_IDCATENTSUBSCATENTRY_IDCascade
F_3646CATENTRY_IDSUBSCRIPTIONCATENTRY_IDCascade
F_3656CATENTRY_IDSUBSCRTEMPLATECATENTRY_IDCascade
F_3658CATENTRY_IDSUBSCRTMPLITEMLISTCATENTRY_IDCascade
F_3694CATENTRY_IDDKOFFERADJMNTKIT_IDCascade
F_3695CATENTRY_IDDKOFFERADJMNTCATENTRY_IDCascade
F_3721CATENTRY_IDCATENTDESCOVRCATENTRY_IDCascade
F_3773CATENTRY_IDCEDISPCONFCATENTRY_IDCascade
F_378CATENTRY_IDICTPRICESCATENTRY_IDCascade
F_3785CATENTRY_IDCATENTRY_EXTERNAL_CONTENT_RELCATENTRY_IDCascade
F_382CATENTRY_IDIITEMCATENTRY_IDCascade
F_395CATENTRY_IDINVENTORYCATENTRY_IDCascade
F_419CATENTRY_IDLISTPRICECATENTRY_IDCascade
F_431CATENTRY_IDMASSOCCECECATENTRY_ID_FROMCascade
F_432CATENTRY_IDMASSOCCECECATENTRY_ID_TOCascade
F_468CATENTRY_IDOFFERCATENTRY_IDCascade
F_475CATENTRY_IDOICOMPLISTCATENTRY_IDCascade
F_505CATENTRY_IDORDERITEMSCATENTRY_IDCascade
F_568CATENTRY_IDPATTRPRODCATENTRY_IDCascade
F_588CATENTRY_IDPKGATTRCATENTRY_IDCascade
F_592CATENTRY_IDPKGATTRVALCATENTRY_IDCascade
F_594CATENTRY_IDPKGITEMRELCATENTRY_ID_ITEMCascade
F_595CATENTRY_IDPKGITEMRELCATENTRY_ID_PKGCascade
F_596CATENTRY_IDPKGITEMRELCATENTRY_ID_PARENTCascade
F_629CATENTRY_IDPRSETCERELCATENTRY_IDCascade
F_630CATENTRY_IDPURCHASELTCATENTRY_IDCascade
F_681CATENTRY_IDRFQPRODCATENTRY_IDCascade
F_686CATENTRY_IDRFQRSPPRODCATENTRY_IDCascade
F_69CATENTRY_IDATTRIBUTECATENTRY_IDCascade
F_708CATENTRY_IDRMAITEMCATENTRY_IDCascade
F_714CATENTRY_IDRMAITEMCMPCATENTRY_IDCascade
F_74CATENTRY_IDATTRVALUECATENTRY_IDCascade
F_781CATENTRY_IDSTORECENTCATENTRY_IDCascade
F_83CATENTRY_IDAUCTIONCATENTRY_IDCascade