InventoryLevels

Columns

Name	Type	ReadOnly	Description
InventoryItemId [KEY]	Long	False	The ID of the inventory item that the inventory level belongs to.
LocationId [KEY]	Long	False	The ID of the location that the inventory level belongs to. To find the ID of the location, use the Locations view.
Available	Int	False	The quantity of inventory items available for sale. Returns null if the inventory item is not tracked.
UpdatedAt	Datetime	True	The date and time (ISO 8601 format) when the inventory level was last modified.
Operation	String	False	An operation to apply to the InventoryLevel. Valid values for order: Adjust, Connect, Set. The allowed values are Adjust, Connect, Set.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
RelocateIfNecessary	Boolean	Whether inventory for any previously connected locations will be relocated. This property is ignored when no fulfillment service location is involved. Used in insertions.
DisconnectIfNecessary	Boolean	Whether inventory for any previously connected locations will be set to 0 and the locations disconnected. This property is ignored when no fulfillment service is involved. Used in insertions.