JDBC Driver for QuickBooks Online

Build 20.0.7654


The 本製品 supports editing and saving custom fields in QuickBooks Online. Custom fields in QuickBooks Online are displayed on all estimates, invoices, sales receipts, refund receipts, and credit memos. Up to three can be added. To create a new custom field, click Your Account -> Company Preferences -> Sales Form Entry and, in the custom fields section, enter the name of the custom field in the Screen Name box.

You can access the custom fields for a record in the CustomFieldAggregate column. This column contains an aggregate of the custom fields, represented as XML entities. To modify a custom field, you will need to directly edit the corresponding XML entity. For example, you can execute an update query similar to the one below:

UPDATE InvoiceLineItems SET CustomFieldAggregate='<CustomField><Name>Custom Field Name</Name><Type>StringType</Type><StringValue>test</StringValue><StringValue></StringValue></CustomField>' WHERE InvoiceId='782' AND Line='1'

You can also supply values for custom fields when inserting. For example:

INSERT INTO InvoiceLineItems (CustomerRef, Line_DetailType#1, Line_SalesItemLineDetail_ItemRef#1, Line_Amount#1, CustomFieldAggregate) VALUES ('4', 'SalesItemLineDetail', '2', 0.01, '<CustomField><DefinitionId>1</DefinitionId><Name>Custom Field Name</Name><Type>StringType</Type><StringValue>test</StringValue></CustomField>')

To clear a custom field, submit the custom field name without a value. For instance:

<CustomField><Name>Custom Field Name</Name><Type>StringType</Type><StringValue></StringValue><StringValue></StringValue></CustomField>
Note: Only string data types are supported for custom fields, so any IntType / IntegerType entered will be handled as a string type.

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