CustomFieldItems

Create, Update and Query the Custom Field Items in QuickBooks Time.

Table Specific Information

Select

The 本製品 uses the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the 本製品.

Id supports the =, IN operators.
CustomFieldId supports the =, IN operators.
Name supports the =, LIKE operators.
Active supports the = operator.
LastModified supports the <, <=, >, >= operators.
SupplementalData supports the = operator.

For example, the following queries are processed server-side:

SELECT * FROM CustomFieldItems WHERE CustomFieldId = 1140610
SELECT * FROM CustomFieldItems WHERE CustomFieldId = 1140610 AND Id = 11531340

Insert

When executing INSERT queries, specify the CustomFieldId, Name and ShortCode columns. The columns that are not required can be inserted optionally. The following is an example of how to insert into this table:

INSERT INTO CustomFieldItems (CustomFieldId, Name, ShortCode) VALUES (1140610, 'testField', 'cf')

Update

When executing UPDATE queries, specify the Id in the WHERE clause. For example:

UPDATE CustomFieldItems SET Name = 'yogesh_customfield', ShortCode = 'ycf' WHERE Id = '15011650'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id of the Custom Field Item.
CustomFieldId	Integer	True	Id of the Custom Field that Item belongs to.
Name	String	False	Name of the customfielditem.
Active	Boolean	False	Boolean value. If true, the custom field item is active and if false, the custom field item is archive.
ShortCode	String	False	This is a shortened code or alias that is associated with the customfield item. It may only consist of letters and numbers.
LastModified	Datetime	True	Date/time when this custom field item was last modified.
RequiredCustomFields	String	True	Ids of Custom fields that should be displayed when this custom field item is selected on a timecard.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
SupplementalData	Boolean	Default value is 'yes'. Indicates whether supplemental data should be specified.