Oracle ATG Web Commerce uses the following tables to store inventory information:
dcs_inventory
This table stores all the inventory information for each SKU in the product catalog.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE |
(primary key) | The unique identifier associated with this inventory. | |
| INTEGER | NOT NULL |
The version of this row. The GSA uses this value. | ||
| DATE | NULL |
The date this inventory was created. | ||
| DATE | NULL |
The date on which this inventory will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database. | ||
| DATE | NULL |
The last date on which this inventory will be available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database. | ||
| VARCHAR(254) | NULL |
The name a user sees when viewing this row. | ||
| VARCHAR(254) | NULL |
A text description of the inventory. | ||
| VARCHAR(40) | NOT NULL |
The inventory of this SKU in the product catalog. | ||
| INTEGER | NOT NULL |
Indicates whether this inventory is in stock, out of stock, backorderable, preorderable, or if the value should be derived at runtime based on | ||
| DATE | NULL |
The date on which the inventory is expected to be available. | ||
| INTEGER | NULL |
The number of items in stock. | ||
| INTEGER | NULL |
The number of items that may be backordered. | ||
| INTEGER | NULL |
The number of items that may be preorderable. | ||
| INTEGER | NULL |
If the | ||
| INTEGER | NULL |
If the | ||
| INTEGER | NULL |
If the |