Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • xxxxx -
    • xxxxx -

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
PayrollPayItem.AccrualAccountClassTypeID int
PayrollPayItem.AccrualAccountID int
PayrollPayItem.AssociatedDeductionID int
PayrollPayItem.AutoCreateBill bit
PayrollPayItem.BillVendorID int
PayrollPayItem.ClassTypeID int Identifier for the Type of Object
PayrollPayItem.EmployerPays bit
PayrollPayItem.ExpenseAccountClassTypeID int
PayrollPayItem.ExpenseAccountID int
PayrollPayItem.ID int Primary Key for the Table
PayrollPayItem.IsActive bit Not Used for This Table
PayrollPayItem.IsBeforeFICA bit
PayrollPayItem.IsBeforeFIT bit
PayrollPayItem.IsBeforeLIT bit
PayrollPayItem.IsBeforeMedicare bit
PayrollPayItem.IsBeforeSIT bit
PayrollPayItem.IsFUTA bit
PayrollPayItem.IsPaidInWages bit
PayrollPayItem.IsPreTax bit
PayrollPayItem.IsRetirementPlan bit
PayrollPayItem.IsStandardDeduction bit
PayrollPayItem.IsSUTA bit
PayrollPayItem.IsSystem bit Used to Mark Required Records
PayrollPayItem.ItemName varchar(50)
PayrollPayItem.MaxDeduction float
PayrollPayItem.MaxWages float
PayrollPayItem.ModifiedByComputer varchar(25) HostName of computer that last modified this record
PayrollPayItem.ModifiedByUser varchar(25) Windows User who last modified this record
PayrollPayItem.ModifiedDate datetime DateTime this Record was last modified
PayrollPayItem.PercentOfWages float
PayrollPayItem.SeqID int
PayrollPayItem.State varchar(50)
PayrollPayItem.StoreID int Not Used.
PayrollPayItem.TaxTableID int
PayrollPayItem.W2Box varchar(50)
PayrollPayItem.W2Code varchar(50)
PayrollPayItem.W2WageOnly bit
PayrollPayItem.WorkersCompCode varchar(50)

Related Tables

You could leave a comment if you were logged in.