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.