Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is used for storing posted Part Usage Cards.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 20565 - Part Usage Card



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| PartUsageCard.Amount || float ||  ||   ||
|| PartUsageCard.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| PartUsageCard.Cost || float ||  ||   ||
|| PartUsageCard.Description || varchar(100) ||  ||   ||
|| PartUsageCard.DoubleTime || float || Hours used for labor parts. ||   ||
|| PartUsageCard.EmployeeID || int || ID of the Employee || Employee.ID ||
|| PartUsageCard.ID || int || Primary Key for the Table ||   ||
|| PartUsageCard.IsActive || bit || Not Used for This Table ||   ||
|| PartUsageCard.IsFromTimeCard || bit || 1 if generated from a Timeclock entry. ||   ||
|| PartUsageCard.IsSystem || bit || Used to Mark Required Records ||   ||
|| PartUsageCard.IsVoided || bit ||  ||   ||
|| PartUsageCard.ModifiedByComputer || varchar(25) || HostName of computer that last modified this record ||   ||
|| PartUsageCard.ModifiedByUser || varchar(25) || Windows User who last modified this record ||   ||
|| PartUsageCard.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| PartUsageCard.OverTime || float || Hours used for labor parts. ||   ||
|| PartUsageCard.PartID || int ||  || [[sql_structure_-_part_table]].ID ||
|| PartUsageCard.PartType || int ||  ||   ||
|| PartUsageCard.PostDate || datetime ||  ||   ||
|| PartUsageCard.SeqID || int ||  ||   ||
|| PartUsageCard.ShiftDiffTime || float || Hours used for labor parts. ||   ||
|| PartUsageCard.StationID || int ||  || [[sql_structure_-_station_table]].ID ||
|| PartUsageCard.StoreID || int || Not Used. ||   ||
|| PartUsageCard.StraightTime || float || Hours used for labor parts. ||   ||
|| PartUsageCard.TransDetailClassTypeID || int ||  ||   ||
|| PartUsageCard.TransDetailID || int ||  || [[sql_structure_-_transdetail_table]].ID ||
|| PartUsageCard.TransHeaderClassTypeID || int ||  ||   ||
|| PartUsageCard.TransHeaderID || int ||  || [[sql_structure_-_transheader_table]].ID ||
|| PartUsageCard.TransModClassTypeID || int ||  ||   ||
|| PartUsageCard.TransModID || int ||  || [[sql_structure_-_transmod_table]].ID ||
|| PartUsageCard.TransPartClassTypeID || int ||  ||   ||
|| PartUsageCard.TransPartID || int ||  || [[sql_structure_-_transpart_table]].ID ||
|| PartUsageCard.UnitID || int ||  || [[sql_structure_-_units_table|SQL Structure - Units Table]].UnitID ||
Related Tables