ODBC Driver for QuickBooks Online

Build 22.0.8678

JournalCode

Create, update, delete, and query QuickBooks Journal Codes.

Table Specific Information

Applicable only for France-locale companies (FR locale). JournalCodes may be inserted, queried, or updated via the JournalCode table.

Select

You can retrieve all JournalCode items from the table or a specific one specifying ID. Other filters processed server side are Name, MetaData_CreateTime, MetaData_LastUpdatedTime. You can also order the results by the same fields.

SELECT * FROM JournalCode WHERE Id=4

SELECT * FROM JournalCode WHERE MetaData_LastUpdatedTime='2018-07-26 08:29:22'

SELECT * FROM JournalCode ORDER BY Name ASC

SELECT * FROM JournalCode ORDER BY Id ASC

SELECT * FROM JournalCode ORDER BY MetaData_CreateTime DESC

Insert

To add a JournalCode, there must be at least Name field specified, which must be unique. All the fields of JournalCode which are not readonly can be inserted as well.

INSERT INTO JournalCode (Name) VALUES ('New inserted') 

Update

All the fields of JournalCode which are not readonly can be updated.

UPDATE JournalCode SET Description='New Desc' WHERE Id=4 

Delete

Delete is not supported for the table.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True True

Unique Identifier for a journal code entity.

Name String False True True

A name representing the journal code.

Type String False False False

The type of this journal code. The value cannot be changed once the object is created.

使用できる値は次のとおりです。Expenses, Sales, Bank, Nouveaux, Wages, Cash, Others

Description String False True False

A free-form description of the journal code.

Active Boolean True False False

Wether journal code object is active

Domain String True False False

Sparse Boolean True False False

SyncToken String True False False

Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.

MetaData_CreateTime Datetime True True True

Time the entity was created in the source domain.

MetaData_LastUpdatedTime Datetime True True True

Time the entity was last updated in the source domain.

Time Datetime True False False

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