JournalCode

Contains journal codes that are used for classification or statutory reporting in certain regions, enabling businesses to meet country-specific accounting requirements.

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	Specifies the unique identifier (Id) for the journal code entity. This value is assigned by QuickBooks Online and used to reference the journal code in other records and operations.
Name	String	False		True	True	Specifies the name representing the journal code. This value is used to identify the journal code in reports, postings, and configuration settings.
Type	String	False		False	False	Specifies the type of this journal code. This classification defines how the journal code behaves. The value cannot be changed once the object is created to ensure data consistency. The allowed values are Expenses, Sales, Bank, Nouveaux, Wages, Cash, Others.
Description	String	False		True	False	Provides a free-form description of the journal code. Use this field to describe the purpose, scope, or usage notes of the journal code for easier identification and management.
Active	Boolean	True		False	False	Indicates whether the journal code entity is currently active. Inactive journal codes are hidden from normal selection lists and excluded from most new financial transactions.
Domain	String	True		False	False	Specifies the domain where the journal code is used. This value distinguishes between company files or environments (such as QuickBooks Online or QuickBooks Online Accountant) that are linked to different operational or data boundaries.
Sparse	Boolean	True		False	False	Indicates whether the journal code entity is sparse. A sparse entity contains only the fields that have changed since the last update, which optimizes data synchronization and reduces payload size during incremental updates. This behavior is especially useful for large data sets that are updated frequently.
SyncToken	String	True		False	False	Specifies the version number of the journal code entity. This version number is used to lock the object for use by one app at a time. When an application modifies an object, its sync token is incremented. Attempts to modify an object specifying an older sync token fail. Only the latest version of the object is maintained by QuickBooks Online.
MetaData_CreateTime	Datetime	True		True	True	Specifies the date and time when the journal code entity was created in the source domain. This value is assigned by the system and is useful for auditing and tracking.
MetaData_LastUpdatedTime	Datetime	True		True	True	Specifies the date and time when the journal code entity was last updated in the source domain. This value is assigned by the system and is useful for auditing and tracking changes.
CustomFieldAggregate	String	False		False	False	Contains an XML aggregate of custom field information that is associated with the journal code entity. This aggregate allows extensions and additional attributes to be stored with the journal code.