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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | 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, | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | 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 | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the complex price. References | |
| VARCHAR(40) | NOT NULL |
The unique identifier associated with the price level. | ||
| 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 |
---|---|---|
| INTEGER | NOT NULL |
The integer incremented with each revision to prevent version conflict. | ||
| VARCHAR(40) | NOT NULL |
(primary key) | 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | Unique identifier associated with the folder. References | |
| INTEGER | NOT NULL |
(primary key) | 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| INTEGER | NOT NULL |
(primary key) | Use to order the price lists. | |
| VARCHAR(40) | NOT NULL |
The ID of the price list contained in the folder. |