Power BI Connector for QuickBooks

Build 23.0.8839

WorkersCompCodes

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

Columns

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

The unique identifier.

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 String False

The rate of the workers comp code.

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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839