CData BizTalk Adapter for QuickBooks Online 2019 - Online Help
Questions / Feedback?

JournalCode

CData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354

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.

The allowed values are 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

The sync token. This must be specified when executing an update or delete.

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.

CustomFieldAggregate String False false false

Am XML aggregate of custom field information.

Time Datetime True false false

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0