InventoryDeletedItems Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The InventoryDeletedItems table contains information about the inventory items that have been deleted.

The following table describes the columns in the InventoryDeletedItems table.

Column name

Type

Allow null

Description

InventoryCatalogName

nvarchar(85)

no

The name of the inventory catalog.

ProductCatalogName

nvarchar(85)

yes

The name of the mapped product catalog.

SkuId

nvarchar(343)

yes

The ID of the deleted item.

SkuVariantId

nvarchar(256)

yes

The ID of the deleted variant.

SkuOid

int

no

The OID of the deleted item.

Type

smallint

no

The type of the deleted item.

DeletedDate

datetime

no

The date and time the item was deleted.

See Also

Other Resources

Inventory System Database Tables

Catalog System Database Tables