SSIS Components for QuickBooks

Build 24.0.9175

WorkersCompCodeLines

Queries QuickBooks Workers Compensation Code details by line item, providing insight into specific payroll classifications.

Columns

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

The unique identifier of the workers' compensation code line item.

WorkersCompCodeId String False 255

The unique identifier of the workers' compensation code this line belongs to. Serves as the primary key for the workers' compensation code.

Name String False 13

The name of the workers' compensation code. This field is required when inserting new records.

Desc String False 31

A description of the workers' compensation code, providing context or details about its purpose.

CurrentRate Double False

The workers' compensation insurance premium rate currently in effect for this code. This field is empty if no current rate exists and the code only has a future effective date.

CurrentEffectiveDate Datetime False

The date when the current workers' compensation rate became effective. This field only contains a value if the code is currently in effect; otherwise, it remains empty.

NextRate Double False

The future workers' compensation insurance premium rate that will become effective after the current rate expires.

NextEffectiveDate Datetime False

The date when the next workers' compensation rate becomes effective, succeeding the current rate's expiration date.

RateHistory_Rate Double False

The historical premium rate for the workers' compensation code. Useful for tracking past rate changes.

RateHistory_EffectiveDate Datetime False

The effective date corresponding to the historical workers' compensation premium rate. This provides a timeline of rate changes.

IsActive Boolean False

Indicates whether the workers' compensation code is active and in use.

TimeCreated Datetime True

The date and time when this workers' compensation code line item was created.

TimeModified Datetime True

The date and time when this workers' compensation code line item was last modified.

EditSequence String True

A versioning identifier for this workers' compensation code line item, used to track revisions.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175