EmployeeEarnings

Create, Update, Query, and Delete QuickBooks Employee Earnings. Note that Employees cannot be created using this table.

Table Specific Information

In order to add an EmployeeEarnings entry, specify the EmployeeId in the Insert statement. If you instead specify the Name of the Employee, the RSSBus ADO.NET Provider for QuickBooks will attempt to add a new Employee. For example:

Select

QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or '=' comparison. The available columns for Employees are Id, Name and IsActive. In addition, the pseudo-columns ActiveStatus, StartModifiedDate, EndModifiedDate, StartTxnDate, and EndTxnDate may also be specified.

Insert

INSERT INTO EmployeeEarnings (EmployeeId, EarningsWageName, EarningsRate) VALUES ('370000-933272659', 'Regular Pay', 21.32)

The ID's for the EmployeeEarnings table operate a bit differently than LineItems. Unlike LineItems, QuickBooks does not return a unique ID for employee earnings. Instead, each employee earnings entry is returned in a specific order for an employee, and they can be updated in that order back to QuickBooks. To give the employee earnings unique ID's, we have appended the index number of each employee earnings entry to the ID. It will be up to the programmer to ensure that any modifications to employee entries through the QuickBooks UI or another application between a Select and an Update call are handled.

QuickBooks Online

The QuickBooks Online API does not support updates to Employees. In addition, Earnings, SickHours, VacationHours, EmployeeType, Gender, and SSN are not supported by the QuickBooks Online API.

Columns

Name	Type	Description	ReadOnly
ID [KEY]	String	The unique identifier in the format EmployeeId|EmployeeEarningsId.	True
Name	String	The name of the employee.	True
EmployeeId	String	The Id of the employee. This is required to have a value when inserting.	True
EarningsId	String	The Id of the employee earnings entry.	True
EarningsWageID	String	A reference id to the wage. Used for payroll.	False
EarningsWageName	String	The wage name. This is required to have a value when inserting.	False
EarningsRate	Double	Employee Earnings rate. Used for payroll.	False
EarningsRatePercent	String	Employee Earnings ratepercent. Used for payroll.	False
TimeModified	Datetime	When the Item was last modified.	True
TimeCreated	Datetime	When the Item was created.	True

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
ActiveStatus	String	The status of the customers included in the results. The allowed values are ACTIVE, INACTIVE, ALL, NA. The default value is ALL.
StartTxnDate	String	Earliest transaction date to search for.
EndTxnDate	String	Latest transaction date to search for.
StartModifiedDate	String	Earliest modified date to search for.
EndModifiedDate	String	Latest modified date to search for.