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. 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	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