{$page} 



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 ||
|| PayrollPaycheck.AdvanceAmount || float ||  ||   ||
|| PayrollPaycheck.AdvanceRepaymentAmount || float ||  ||   ||
|| PayrollPaycheck.BaseWages || float ||  ||   ||
|| PayrollPaycheck.BaseWagesOV || bit ||  ||   ||
|| PayrollPaycheck.BenefitTotal || float ||  ||   ||
|| PayrollPaycheck.BonusAmount || float ||  ||   ||
|| PayrollPaycheck.CalcBaseWages || float ||  ||   ||
|| PayrollPaycheck.CheckNumber || varchar(25) ||  ||   ||
|| PayrollPaycheck.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| PayrollPaycheck.CommissionAmount || float ||  ||   ||
|| PayrollPaycheck.DoubleTime || float ||  ||   ||
|| PayrollPaycheck.DoubleTimeWage || float ||  ||   ||
|| PayrollPaycheck.EmployeeID || int || ID of the Employee || Employee.ID ||
|| PayrollPaycheck.EmployeePayrollType || int ||  ||   ||
|| PayrollPaycheck.GrossWages || float ||  ||   ||
|| PayrollPaycheck.HolidayTime || float ||  ||   ||
|| PayrollPaycheck.HolidayTimeWage || float ||  ||   ||
|| PayrollPaycheck.ID || int || Primary Key for the Table ||   ||
|| PayrollPaycheck.IsActive || bit || Not Used for This Table ||   ||
|| PayrollPaycheck.IsSystem || bit || Used to Mark Required Records ||   ||
|| PayrollPaycheck.IsVoided || bit ||  ||   ||
|| PayrollPaycheck.ModifiedByComputer || varchar(25) || HostName of computer that last modified this record ||   ||
|| PayrollPaycheck.ModifiedByUser || varchar(25) || Windows User who last modified this record ||   ||
|| PayrollPaycheck.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| PayrollPaycheck.NetPay || float ||  ||   ||
|| PayrollPaycheck.OptionalEmployeeDeductionTotal || float ||  ||   ||
|| PayrollPaycheck.OptionalEmployerDeductionTotal || float ||  ||   ||
|| PayrollPaycheck.OVBaseWages || float ||  ||   ||
|| PayrollPaycheck.OverTime || float ||  ||   ||
|| PayrollPaycheck.OverTimeWage || float ||  ||   ||
|| PayrollPaycheck.PayrollClassTypeID || int ||  ||   ||
|| PayrollPaycheck.PayrollID || int ||  ||   ||
|| PayrollPaycheck.ProcessedDate || datetime ||  ||   ||
|| PayrollPaycheck.SeqID || int ||  ||   ||
|| PayrollPaycheck.ShiftDiffTime || float ||  ||   ||
|| PayrollPaycheck.ShiftDiffTimeWage || float ||  ||   ||
|| PayrollPaycheck.SickPayTime || float ||  ||   ||
|| PayrollPaycheck.SickPayTimeEarned || float ||  ||   ||
|| PayrollPaycheck.SickPayTimeWage || float ||  ||   ||
|| PayrollPaycheck.SickPayTimeWageEarned || float ||  ||   ||
|| PayrollPaycheck.StandardEmployeeDeductionTotal || float ||  ||   ||
|| PayrollPaycheck.StandardEmployerDeductionTotal || float ||  ||   ||
|| PayrollPaycheck.StoreID || int || Not Used. ||   ||
|| PayrollPaycheck.StraightTime || float ||  ||   ||
|| PayrollPaycheck.StraightTimeWage || float ||  ||   ||
|| PayrollPaycheck.TotalTime || float ||  ||   ||
|| PayrollPaycheck.VacationTime || float ||  ||   ||
|| PayrollPaycheck.VacationTimeEarned || float ||  ||   ||
|| PayrollPaycheck.VacationTimeWage || float ||  ||   ||
|| PayrollPaycheck.VacationTimeWageEarned || float ||  ||   ||
|| PayrollPaycheck.VoidDate || datetime ||  ||   ||
|| PayrollPaycheck.WorkersCompEquivalentWage || float ||  ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]