inventory_id
(primary key)

varchar (40)

not null
unique

The unique identifier associated with this inventory.

version

integer

not null

The version of this row. The GSA uses this value.

creation_date

date

null

The date this inventory was created.

start_date

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.

end_date

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.

display_name

varchar (254)

null

The name a user sees when viewing this row.

description

varchar (254)

null

A text description of the inventory.

catalog_ref_id

varchar (40)

not null

The inventory of this SKU in the product catalog.

avail_status

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 stock_level, backorder_level, and preorder_level.

availability_date

date

null

The date on which the inventory is expected to be available.

stock_level

integer

null

The number of items in stock.

backorder_level

integer

null

The number of items that may be backordered.

preorder_level

integer

null

The number of items that may be preorderable.

stock_thresh

integer

null

If the stock_level value dips below this value, a ThresholdReached event is sent.

backorder_thresh

integer

null

If the backorder_level value dips below this value, a ThresholdReached event is sent.

preorder_thresh

integer

null

If the preorder_level value dips below this value, a ThresholdReached event is sent.

location_id

varchar(40)

null

ID of the inventory location, if any.

id
(primary key)

varchar(40)

not null unique

The unique identifier associated with this availability information.

inventory_id

varchar(40)

not null

Inventory item to which the availability information is connected.

version

date

not null

The catalog version of the item.

available_date

date

null

The date on which the inventory will be available.

quantity

int

null

The amount of inventory that will be available on the specified date.