StockMovements

Query StockMovements in Sage Business Cloud Accounting.

Table Specific Information

Query the available StockMovements

Select

The driver uses the Sage Accounting API to process search criteria that refer to StockItemId,Search,FromDate,ToDate columns. The driver processes other filters client-side within the driver.

StockItemId supports the '=' operator.
Search supports the '=' operator.
FromDate supports the '=' operator.
ToDate supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM StockMovements WHERE StockItemId = 'abc'
SELECT * FROM StockMovements WHERE Search = 'abc'
SELECT * FROM StockMovements WHERE FromDate = '2018-12-15'
SELECT * FROM StockMovements WHERE ToDate = '2018-12-15'

Insert

INSERT INTO StockMovements (Quantity, CostPrice) VALUES ('7', '12')

Update

Updates are performed based on Id.

UPDATE StockMovements SET Details = 'abc' WHERE Id = '123'

Delete

You must specify the Id of the StockMovements to delete it.

DELETE FROM StockMovements WHERE id = '123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the item
CreatedAt	Datetime	True		The datetime when the item was created
Details	String	False		The transaction details of the stock movement
DisplayedAs	String	False		Display text for the stock movement
Date	Datetime	False		The date the stock movement occurred
MovementNumber	String	False		The movement number of the stock movement
Reference	String	False		The reference of the stock movement
Quantity	String	False		The quantity of the goods adjusted
UpdatedAt	Datetime	True		The datetime when the item was last updated
LegacyId	Int	False		The legacy ID for the item
CostPrice	String	False		The cost per unit of stock purchased
StockItemId	String	False	StockItems.Id	The unique identifier for the item
Search	String	False
FromDate	Datetime	True
ToDate	Datetime	True