ScrapReason Table (AdventureWorks)
In a lookup table that contains the reasons for manufacturing failures.
ScrapReason Table Definition
The ScrapReason table is contained in the Production schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
ScrapReasonID |
smallint |
Not null |
Primary key. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Failure description. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Product Table (AdventureWorks)
WorkOrder Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary