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 |