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 | Description |
|---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the price list. |
| integer | not null | The integer incremented with each revision to prevent version conflict. |
| varchar(254) | null | The name of the price list displayed in the ACC. |
| varchar(254) | null | The description of the price list displayed in the ACC. |
| timestamp | null | The date the price list was created. |
| timestamp | null | The last date the price list was modified. |
| timestamp | null | The date that this price list should become active. |
| timestamp | null | The date that this price list should become inactive. |
| integer | null | The locale for the price list. For example, en_US. |
| 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.) |
| 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 | Description |
|---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the complex price. |
| integer | not null | The integer incremented with each revision to prevent version conflict. |
| 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 | Description |
|---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the price. |
| integer | not null | The integer incremented with each revision to prevent version conflict. |
| varchar(40) | not null | The unique identifier associated with the price list. References |
| varchar(40) | null | The ID of the product that this price refers to. (optional) |
| varchar(40) | null | The ID of the SKU that this price refers to. (optional) |
| varchar(40) | null | The ID of the configurable SKU that is a parent of this sku_id. (optional) |
| integer | not null | The type of price. (LIST_PRICE, BULK_PRICE, TIERED_PRICE). |
| double precision | null | If |
| varchar(40) | null | If |
| 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 | Description |
|---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the complex price. References |
| varchar(40) | not null | The unique identifier associated with the price level. |
| integer | not null | 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 | Description |
|---|---|---|---|
| integer | not null | The integer incremented with each revision to prevent version conflict. |
| varchar(40) | not null | The unique identifier associated with the price. |
| integer | not null | The quantity that must be purchased for this price level to take effect. |
| double precision | not null | The unit price of each quantity that is priced with this price level. |
| 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 | Description |
|---|---|---|---|
| varchar(40) | not null | The unique identifier of the folder item. |
| integer | not null | The type of folder. |
| varchar(40) | not null | The name of the folder that gets display in the ACC. |
| varchar(40) | null | The parent folder of this folder. |
| varchar(254) | null | A description of this folder. |
| 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 | Description |
|---|---|---|---|
| varchar(40) | not null | Unique identifier associated with the folder. References |
| integer | not null | This number is used to order the child folders. |
| 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 | Description |
|---|---|---|---|
| varchar(40) | not null | References |
| integer | not null | Use to order the price lists. |
| varchar(40) | not null | The ID of the price list contained in the folder. |
