JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8462

JournalCodes

Query JournalCodes in Sage Business Cloud Accounting.

Table Specific Information

Query the available JournalCodes

Select

The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince column. The driver processes other filters client-side within the driver.

  • UpdatedOrCreatedSince supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM JournalCodes WHERE UpdatedOrCreatedSince='2018-12-15'

Update

Updates are performed based on Id.

UPDATE JournalCodes SET Name='abc' WHERE Id='123'

Delete

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

DELETE FROM JournalCodes 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

DisplayedAs String False

The name of the resource

Name String False

The name of the journal code

Code String False

The code of the journal code

Reserved Bool False

Indicates whether the journal code is reserved

UpdatedAt Datetime True

The datetime when the item was last updated

LegacyId Int False

The legacy ID for the item

ControlName String False

The control name of the journal code

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