JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8479

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479