SSIS Components for QuickBooks

Build 24.0.9175

PayrollWageItems

Manages QuickBooks Wage Payroll Items, supporting creation and queries to streamline wage-based payroll processing.

Columns

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

The unique identifier for the payroll wage item, used to distinguish this item from others in the system.

Name String False

The name of the payroll wage item, such as 'Hourly Wage' or 'Overtime Pay.' This field is required when creating a new payroll item.

IsActive Boolean False

Indicates whether the payroll wage item is active and available for use in payroll processing. If false, the item is inactive and cannot be used in transactions.

WageType String False

The type of wages associated with this payroll item, such as hourly, salary, or commission. This categorization determines how the wages are calculated and processed.

The allowed values are Bonus, Commission, HourlyOvertime, HourlyRegular, HourlySick, HourlyVacation, SalaryRegular, SalarySick, SalaryVacation.

ExpenseAccountRef_FullName String False

The full name of the expense account where wages associated with this payroll item will be recorded. This account is used to track wage-related expenses in the company’s financial records. Either the account name or ID must be specified when creating the item.

ExpenseAccountRef_ListID String False

Accounts.ID

The unique identifier of the expense account used to record wage expenses for this payroll item. This is an alternative to specifying the full account name and is required when creating the item if the account name is not provided.

TimeCreated Datetime True

The date and time when the payroll wage item was initially created in QuickBooks. This field helps track when the item was added to the system.

TimeModified Datetime True

The date and time when the payroll wage item was last updated in QuickBooks. This information is useful for auditing and ensuring data accuracy.

EditSequence String True

A unique identifier for versioning this payroll wage item, used to detect and prevent conflicts when updating the record.

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