ScrewTurn Wiki

Edit

wikibot

TableProduction.ScrapReason
DescriptionManufacturing failure reasons lookup table.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_ScrapReason_ScrapReasonIDScrapReasonID

Edit

Indexes

IndexTypeColumns
AK_ScrapReason_NameUniqueName

Edit

Detail Tables

Detail TableColumnReferencing Column
Production.WorkOrderScrapReasonIDScrapReasonID

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

Edit

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

Edit

automatically generated

TableProduction.ScrapReason
DescriptionManufacturing failure reasons lookup table.

ColumnData TypeNullableDefaultDescription / PK / Index
ScrapReasonIDsmallintnot null Primary key for ScrapReason records.
PK_ScrapReason_ScrapReasonID
NameNamenot null Failure description.
AK_ScrapReason_Name
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



Detail TableColumnReferencing Column
Production.WorkOrderScrapReasonIDScrapReasonID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.