InventoryQuantityDeltas Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The InventoryQuantityDeltas table contains information about the inventory decrements that occur on the site.
The following table describes the columns in the InventoryQuantityDeltas table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
InventoryCatalogName |
nvarchar(85) |
no |
The name of the inventory catalog. |
ProductCatalogName |
nvarchar(85) |
no |
The name of the mapped product catalog. |
SkuId |
nvarchar(343) |
yes |
The ID of the item. |
SkuVariantId |
nvarchar(256) |
yes |
The ID of the variant item. |
SkuOid |
int |
no |
The OID of the item. This is a primary key. |
DateCreated |
datetime |
no |
The date and time that the item was decremented. |
Quantity |
Decimal(18,0) |
no |
The amount by which the item was decremented. |