Page History: Production ScrapReason (table)

Compare Page Revisions

wikibot ¶

Table	Production.ScrapReason
Description	Manufacturing failure reasons lookup table.

Column	Data Type	Nullable	Default	Description / PK / Index
ScrapReasonID	smallint	not null		Primary key for ScrapReason records. PK_ScrapReason_ScrapReasonID
Name	dbo.Name	not null		Failure description. AK_ScrapReason_Name
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Production.WorkOrder	ScrapReasonID	ScrapReasonID

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name