Column Descriptions
| Column Name
| Column 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 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 IBM internal use.
|
| 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. IBM recommends that this column be used consistently to avoid confusion. This column is for your interpretation and information only.
|