Production ScrapReason (table)

wikibot

TableProduction.ScrapReason
DescriptionManufacturing failure reasons lookup table.

Columns

ColumnData TypeNullableDefaultDescription
ScrapReasonIDsmallintnot null Primary key for ScrapReason records.
Namedbo.Namenot null Failure description.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ScrapReason_ScrapReasonIDScrapReasonID

Indexes

IndexTypeColumns
AK_ScrapReason_NameUniqueName

Detail Tables

Detail TableColumnReferencing Column
Production.WorkOrderScrapReasonIDScrapReasonID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

wikivalues

Table ValuesProduction.ScrapReason

ScrapReasonIDName
1Brake assembly not as ordered
2Color incorrect
4Drill pattern incorrect
5Drill size too large
6Drill size too small
3Gouge in metal
7Handling damage
8Paint process failed
9Primer process failed
10Seat assembly not as ordered
11Stress test failed
12Thermoform temperature too high
13Thermoform temperature too low
14Trim length too long
15Trim length too short
16Wheel misaligned