Query, create, and update information regarding different inventory levels.

Table-Specific Information

Select

To query this table InventoryItemId, LocationId or both should be specified. The supported SQL operators are '=' and 'IN'. The 本製品 processes other filters client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM InventoryLevels WHERE InventoryItemId = '123' 

SELECT * FROM InventoryLevels WHERE InventoryItemId = '123' AND LocationId = '456'

SELECT * FROM InventoryLevels WHERE InventoryItemId IN ('123', '456') AND LocationId IN ('123', '456')

Insert

• Adjust the available quantity of an inventory item at a single location:
  

  INSERT INTO InventoryLevels (InventoryItemId, LocationId, Available, Operation) VALUES (534169354263, 1448280087, 5, 'Adjust')

• Connects an inventory item to a location by creating an inventory level at that location:
  

  INSERT INTO InventoryLevels (InventoryItemId, LocationId, Operation) VALUES (534169354263, 4484497431, 'Connect')

• Sets the inventory level for an inventory item at a location:
  

  INSERT INTO InventoryLevels (InventoryItemId, LocationId, Available, Operation, DisconnectIfNecessary) VALUES (534169354263, 4484497431, 42, 'Set', true)

Delete

You must specify the InventoryItemId and LocationId to delete an inventory level of an inventory item at a location.

DELETE FROM InventoryLevels WHERE InventoryItemId = '153681943' AND LocationId = '45678'

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。