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