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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of the manufacturer. | |
| WVARCHAR(254) | NULL |
A string name that identifies the manufacturer. | ||
| WVARCHAR(254) | NULL |
A short description of this manufacturer. | ||
| LONG WVARCHAR | NULL |
A long description of this manufacturer. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key | The unique SKU ID for an item | |
| INT | NULL |
The unit of measurement that is used to quantify this item. Meters, liters etc. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key | References | |
| VARCHAR(40) | NULL |
A reference to the manufacturer of this particular product. References | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key | The unique repository id of the SKU. References | |
| WVARCHAR(254) | NULL |
A String property that represents the manufacturers part number for this SKU. |