CATENTRY
This table holds the information related to a catalog entry. Examples of catalog entries include products, items, packages, and bundles.
Column Descriptions:
Name Type Description 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, 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 IBM 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 IBM internal use. STARTDATE TIMESTAMP The date when this catalog entry is introduced. This column is for our interpretation and information only. ENDDATE TIMESTAMP The date when this catalog entry is withdrawn. This column is for our interpretation and information only. RANK DOUBLE Reserved for IBM internal use. AVAILABILITYDATE TIMESTAMP The date that the product is available to customers for purchase. This column is for our 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 our 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 our 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 the store stops selling the product. It is recommended that this column be used consistently to avoid confusion. This column is for our 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.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> CATENTRY_ID Primary Key I0000064 PARTNUMBER+MEMBER_ID Unique Index I0000065 CATENTRY_ID+MARKFORDELETE Non-Unique Index I0000305 BUYABLE+CATENTRY_ID+CATENTTYPE_ID Non-Unique Index I0000375 RANK Non-Unique Index I0000518 CATENTTYPE_ID Non-Unique Index I0000519 MEMBER_ID Non-Unique Index I263103 CATENTRY_ID+CATENTTYPE_ID Non-Unique Index I263121 ITEMSPC_ID Non-Unique Index I263122 BASEITEM_ID Non-Unique Index IPF00003 UP_PARTNUMBER Non-Unique Index IPF00020 UP_MFNAME Non-Unique Index IPF00021 UP_MFPARTNUMBER Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_201 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade F_202 BASEITEM_ID BASEITEM BASEITEM_ID Cascade F_203 MEMBER_ID MEMBER MEMBER_ID Cascade F_204 CATENTTYPE_ID CATENTTYPE CATENTTYPE_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_1061 CATENTRY_ID DKPDCREL CATENTRY_ID Cascade F_1151 CATENTRY_ID DKOFFER KIT_ID Cascade F_1152 CATENTRY_ID DKOFFER CATENTRY_ID Cascade F_1155 CATENTRY_ID DKADJMNT KIT_ID Cascade F_1156 CATENTRY_ID DKADJMNT CATENTRY_ID Cascade F_1182 CATENTRY_ID DKPDCCOMPLIST CATENTRY_ID Cascade F_1185 CATENTRY_ID DKPDCCATENTREL CATENTRY_ID Cascade F_186 CATENTRY_ID CATCLSFCOD CATENTRY_ID Cascade F_189 CATENTRY_ID CATCONFINF CATENTRY_ID Cascade F_192 CATENTRY_ID CATENCALCD CATENTRY_ID Cascade F_194 CATENTRY_ID CATENTATTR CATENTRY_ID Cascade F_196 CATENTRY_ID CATENTDESC CATENTRY_ID Cascade F_199 CATENTRY_ID CATENTREL CATENTRY_ID_PARENT Cascade F_200 CATENTRY_ID CATENTREL CATENTRY_ID_CHILD Cascade F_205 CATENTRY_ID CATENTSHIP CATENTRY_ID Cascade F_214 CATENTRY_ID CATGPENREL CATENTRY_ID Cascade F_274 CATENTRY_ID CPPMNPROD CATENTRY_ID Cascade F_303 CATENTRY_ID DISPENTREL CATENTRY_ID Cascade F_3566 CATENTRY_ID CATENTRYATTR CATENTRY_ID Cascade F_3581 CATENTRY_ID INVAVL CATENTRY_ID Cascade F_3586 CATENTRY_ID INVCNFREL CATENTRY_ID Cascade F_3622 CATENTRY_ID INSRULECATENT CATENTRY_ID Cascade F_3644 CATENTRY_ID CATENTSUBS CATENTRY_ID Cascade F_3646 CATENTRY_ID SUBSCRIPTION CATENTRY_ID Cascade F_3656 CATENTRY_ID SUBSCRTEMPLATE CATENTRY_ID Cascade F_3658 CATENTRY_ID SUBSCRTMPLITEMLIST CATENTRY_ID Cascade F_3694 CATENTRY_ID DKOFFERADJMNT KIT_ID Cascade F_3695 CATENTRY_ID DKOFFERADJMNT CATENTRY_ID Cascade F_3721 CATENTRY_ID CATENTDESCOVR CATENTRY_ID Cascade F_3773 CATENTRY_ID CEDISPCONF CATENTRY_ID Cascade F_378 CATENTRY_ID ICTPRICES CATENTRY_ID Cascade F_3785 CATENTRY_ID CATENTRY_EXTERNAL_CONTENT_REL CATENTRY_ID Cascade F_382 CATENTRY_ID IITEM CATENTRY_ID Cascade F_395 CATENTRY_ID INVENTORY CATENTRY_ID Cascade F_419 CATENTRY_ID LISTPRICE CATENTRY_ID Cascade F_431 CATENTRY_ID MASSOCCECE CATENTRY_ID_FROM Cascade F_432 CATENTRY_ID MASSOCCECE CATENTRY_ID_TO Cascade F_468 CATENTRY_ID OFFER CATENTRY_ID Cascade F_475 CATENTRY_ID OICOMPLIST CATENTRY_ID Cascade F_505 CATENTRY_ID ORDERITEMS CATENTRY_ID Cascade F_568 CATENTRY_ID PATTRPROD CATENTRY_ID Cascade F_588 CATENTRY_ID PKGATTR CATENTRY_ID Cascade F_592 CATENTRY_ID PKGATTRVAL CATENTRY_ID Cascade F_594 CATENTRY_ID PKGITEMREL CATENTRY_ID_ITEM Cascade F_595 CATENTRY_ID PKGITEMREL CATENTRY_ID_PKG Cascade F_596 CATENTRY_ID PKGITEMREL CATENTRY_ID_PARENT Cascade F_629 CATENTRY_ID PRSETCEREL CATENTRY_ID Cascade F_630 CATENTRY_ID PURCHASELT CATENTRY_ID Cascade F_681 CATENTRY_ID RFQPROD CATENTRY_ID Cascade F_686 CATENTRY_ID RFQRSPPROD CATENTRY_ID Cascade F_69 CATENTRY_ID ATTRIBUTE CATENTRY_ID Cascade F_708 CATENTRY_ID RMAITEM CATENTRY_ID Cascade F_714 CATENTRY_ID RMAITEMCMP CATENTRY_ID Cascade F_74 CATENTRY_ID ATTRVALUE CATENTRY_ID Cascade F_781 CATENTRY_ID STORECENT CATENTRY_ID Cascade F_83 CATENTRY_ID AUCTION CATENTRY_ID Cascade
Related reference
Attribute data model
Calculation code - indirect attachment data model
Catalog data model
Catalog entry data model
Catalog group data model
Fulfillment data model
Interest item data model
Merchandising association data model
Messaging extension data model
Offers data model
Order management - RMAitem data model
Order item data model
Order item - allocated data model
Order item - backordered data model
Order trading agreement data model
Package data model
Request for Quote (RFQ) data model
User traffic data model