Tableau Connector for NetSuite

Build 25.0.9434

employeeEarning

Records employee earnings, including salary, bonuses, or commissions, used for payroll and tax purposes.

Columns

Name Type References Description
defaultearning Boolean Indicates whether the earning is set as the default for the employee, typically used to identify standard earnings.
defaulthours Double The default number of hours associated with the earning, often used for payroll calculations when no other hours are specified.
effectivedate Date The date when the earning record or change becomes effective, marking the start of its application in the payroll cycle.
employee String The employee associated with the earning record, used to identify the individual receiving the earnings.
expirationdate Date The date when the earning expires or becomes no longer valid, typically used for time-sensitive earnings or bonuses.
inactive Boolean Indicates whether the earning record is marked as inactive, meaning it is no longer in use or applicable in the current payroll cycle.
payrate Double The rate associated with the earning, typically indicating the amount paid per unit (for example, hourly rate or salary rate).
payrollitem String The specific payroll item associated with the earning, often referring to a type of pay such as 'Bonus' or 'Overtime'.
paytype String The type of pay item, used to categorize the earning (for example, 'Hourly', 'Salary', 'Commission').
primaryearning Boolean Indicates whether this earning is the primary or most significant earning for the employee, typically used for regular pay.

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