Excel Add-In for QuickBooks

Build 21.0.7930

WorkersCompCodeLines

Query QuickBooks Workers Comp Code entries by line. Requires QBXML Version 7.0 or higher.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier.

WorkersCompCodeId String False 255

The primary key of the workes comp code.

Name String False 13

The name of the workers comp code. This is required to have a value when inserting.

Desc String False 31

The description of the workers comp code.

CurrentRate Double False

Indicates the workers comp insurance premium rate that is currently in effect for the current comp code. If the code doesn't have a current effective date--that is, it has a future date only, then this field is empty.

CurrentEffectiveDate Datetime False

Indicates the date at which the workers' compensation code went into effect. This field contains a value only if the code is currently in effect. If the code has only a future date, then this field is empty.

NextRate Double False

Indicates the workers comp insurance premium rate that will occur after the current rate and effective date.

NextEffectiveDate Datetime False

Indicates the the first effective date that will occur after the current effective date.

RateHistory_Rate Double False

The rate of the workers comp code.

RateHistory_EffectiveDate Datetime False

Specifies the date at which the workers comp code and the related premium goes into effect.

IsActive Boolean False

Whether or not the workers comp code is active.

TimeCreated Datetime True

The datetime the entry was made.

TimeModified Datetime True

The last datetime the entry was modified.

EditSequence String True

An identifier used for versioning for this copy of the object.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930