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
You could leave a comment if you were logged in.