The following database tables store information related to price lists.

dcs_price_list

This table contains information related to basic price list functionality.

Column

Data Type

Constraint

price_list_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the price list

version

integer

NOT NULL

The integer incremented with each revision to prevent version conflict.

display_name

VARCHAR(254)

NULL

The name of the price list displayed in the ACC.

description

VARCHAR(254)

NULL

The description of the price list displayed in the ACC.

creation_date

TIMESTAMP

NULL

The date the price list was created.

last_mod_date

TIMESTAMP

NULL

The last date the price list was modified.

start_date

TIMESTAMP

NULL

The date that this price list should become active.

end_date

TIMESTAMP

NULL

The date that this price list should become inactive.

locale

INTEGER

NULL

The locale for the price list. For example, en_US.

base_price_list

VARCHAR(40)

NULL

The ID of the base price list. (If a price is not found in the current price list, look in the base price list.)

item_acl

LONG VARCHAR

NULL

The security for the price list.

dcs_complex_price

This table contains information related to complex price list functionality.

Column

Data Type

Constraint

complex_price_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the complex price.

version

INTEGER

NOT NULL

The integer incremented with each revision to prevent version conflict.

item_acl

LONG VARCHAR

NULL

The security for the complex price list.

dcs_price

This table contains information related to the price of a product, a SKU, or a product/SKU pair. The price can be a list price, a bulk price, or a tiered price.

Column

Data Type

Constraint

price_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the price.

version

INTEGER

NOT NULL

The integer incremented with each revision to prevent version conflict.

price_list

VARCHAR(40)

NOT NULL

The unique identifier associated with the price list. References dcs_price_list(price_list_id)

product_id

VARCHAR(40)

NULL

The ID of the product that this price refers to. (optional)

sku_id

VARCHAR(40)

NULL

The ID of the SKU that this price refers to. (optional)

parent_sku_id

VARCHAR(40)

NULL

The ID of the configurable SKU that is a parent of this sku_id. (optional)

pricing_scheme

INTEGER

NOT NULL

The type of price. (LIST_PRICE, BULK_PRICE, TIERED_PRICE).

list_price

DOUBLE PRECISION

NULL

If pricing_scheme is LIST_PRICE, this is the price.

complex_price

VARCHAR(40)

NULL

If pricing_scheme is not LIST_PRICE, this is the ID of the complex price to use. References dcs_complex_price(complex_price_id).

item_acl

LONG VARCHAR NULL

The security for the complex price list.

dcs_price_levels

This table contains information related to which price levels are in each complex price.

Column

Data Type

Constraint

complex_price_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the complex price. References dcs_complex_price(complex_price_id).

price_levels

VARCHAR(40)

NOT NULL

The unique identifier associated with the price level.

sequence_num

INTEGER

NOT NULL

(primary key)

Use to order the price levels.

dcs_price_level

This table contains information related to the price level that is used to price a specific level or tier when using bulk pricing or tiered pricing.

Column

Data Type

Constraint

version

INTEGER

NOT NULL

The integer incremented with each revision to prevent version conflict.

price_level_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the price.

quantity

INTEGER

NOT NULL

The quantity that must be purchased for this price level to take effect.

price

DOUBLE PRECISION

NOT NULL

The unit price of each quantity that is priced with this price level.

item_acl

LONG VARCHAR

NULL

The security for the price level.

dcs_gen_fol_pl

This table contains information related to the folder structure used by the ACC.

Column

Data Type

Constraint

folder_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier of the folder item.

type

INTEGER

NOT NULL

The type of folder.

name

VARCHAR(40)

NOT NULL

The name of the folder that gets display in the ACC.

parent

VARCHAR(40)

NULL

The parent folder of this folder.

description

VARCHAR(254)

NULL

A description of this folder.

item_acl

LONG VARCHAR

NULL

Security information for this folder.

dcs_child_fol_pl

This table contains information related to the child folders of each folder.

Column

Data Type

Constraint

folder_id

VARCHAR(40)

NOT NULL

(primary key)

Unique identifier associated with the folder. References dcs_gen_fol_pl(folder_id).

sequence_num

INTEGER

NOT NULL

(primary key)

This number is used to order the child folders.

child_folder_id

VARCHAR(40)

NOT NULL

The ID of the child folder.

dcs_plfol_chld

This table contains information related to the price lists that are contained in each folder.

Column

Data Type

Constraint

plfol_id

VARCHAR(40)

NOT NULL

(primary key)

References dcs_gen_fol_pl(folder_id).

sequence_num

INTEGER

NOT NULL

(primary key)

Use to order the price lists.

price_list_id

VARCHAR(40)

NOT NULL

The ID of the price list contained in the folder.