InventorySkus Table
The InventorySkus table contains information about the Skus in the inventory catalog to which this table refers. There is a default InventorySkus Table that is named Default_InventorySkus.
If you create additional inventory catalogs, the Catalog System creates a table for each catalog when it creates the catalog. The table name has the format <InventoryCatalogName>_InventorySkus. The columns of this table depend on the properties you have defined. If you add properties, columns for those properties will be in the InventorySkus table.
The following table describes the default columns in the InventorySkus table and the Default_InventorySkus table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
SkuOid |
uniqueidentifier |
no |
The OID of the SKU. This is a primary key. |
InventoryCatalogName |
nvarchar(85) |
yes |
The name of the inventory catalog. |
ProductCatalogName |
nvarchar(85) |
yes |
The name of the product catalog. |
SkuId |
nvarchar(343) |
yes |
The ID of the SKU. |
SkuVariantId |
nvarchar(256) |
yes |
The ID of the variant SKU. |
Backorderable |
bit |
yes |
Specifies whether the SKU can be backordered. |
Preorderable |
bit |
yes |
Specifies whether the SKU can be preordered. |
Status |
smallint |
yes |
The current inventory status of the SKU. |
OnHandQuantity |
decimal(18,0) |
yes |
The current quantity available. |
ExcessOnHandQuantity |
decimal(18,0) |
yes |
The value greater than which the inventory is in excess. |
ReorderPoint |
decimal(18,0) |
yes |
The point at which the inventory should be reordered. |
TargetQuantity |
decimal(18,0) |
yes |
The amount of inventory you want to keep based on buying patterns. |
BackorderLimit |
decimal(18,0) |
yes |
The value lower than the Effective Stockout Threshold beyond which it is not prudent to take back-orders. |
PreorderLimit |
decimal(18,0) |
yes |
The value lower than the Effective Stockout Threshold beyond which it is not prudent to take pre-orders. |
StockOutThreshold |
decimal(18,0) |
yes |
A value that the SKU quantity must be greater than or equal to for the SKU item to be considered in stock. |
PreorderAvailabilityDate |
datetime |
yes |
The earliest date when the pre-ordered SKU will be available for shipping. |
BackOrderAvailabilityDate |
datetime |
yes |
The earliest date when the back-ordered SKU will be available for shipping. |
LastRestocked |
datetime |
yes |
Date when the inventory was last restocked. |
UnitOfMeasure |
nvarchar(20) |
yes |
The unit of measure used for the SKU. |
Memo |
nvarchar(20) |
yes |
User-defined notes. |
SkuLastModified |
datetime |
yes |
Date and time the SKU was last modified. |
SkuTimestamp |
timestamp |
no |
The timestamp of the SKU. |
SkuExportReady |
bit |
yes |
Specifies whether the SKU is ready to be exported. |