The following tables contain information related to ATG Business Commerce product catalog functionality.

dbc_manufacturer

The following table contains information related to manufacturers. Each product that appears in the product catalog can be associated with a particular manufacturer. These tables are used for information purposes by the buyer.

Column

Data Type

Constraint

manufacturer_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of the manufacturer.

manufacturer_name

WVARCHAR(254)

NULL

A string name that identifies the manufacturer.

Description

WVARCHAR(254)

NULL

A short description of this manufacturer.

long_description

LONG WVARCHAR

NULL

A long description of this manufacturer.

Email

VARCHAR(30)

NULL

An e-mail address for this manufacturer.

dbc_measurement

The following table contains information related to the measurements of a particular item.

Column

Data Type

Constraint

sku_id

VARCHAR(40)

NOT NULL

(primary key

The unique SKU ID for an item

unit_of_measure

INT

NULL

The unit of measurement that is used to quantify this item. Meters, liters etc.

quantity

DOUBLE PRECISION

NULL

The quantity of the particular unit of measurement.

dbc_product

The following table contains information related to enterprise commerce extensions to the product definition.

Column

Data Type

Constraint

product_id

VARCHAR(40)

NOT NULL

(primary key

References dcs_product(product_id). The unique repository id of the product.

manufacturer

VARCHAR(40)

NULL

A reference to the manufacturer of this particular product. References dbc_manufacturer(manufacturer_id).

admin_display

VARCHAR(254)

NULL

A display name that is used in the ATG Control Center (ACC).

dbc_sku

The following table contains information related to enterprise commerce extensions to the SKU definition.

Column

Data Type

Constraint

sku_id

VARCHAR(40)

NOT NULL

(primary key

The unique repository id of the SKU. References dcs_sku(sku_id).

manuf_part_num

WVARCHAR(254)

NULL

A String property that represents the manufacturers part number for this SKU.

 
loading table of contents...