Difference between revisions of "Production.ScrapReason (table)"

From dbscript Online Help
Jump to: navigation, search
Line 54: Line 54:
 
| ScrapReasonID
 
| ScrapReasonID
 
|}
 
|}
 
 
 
 
== wikivalues ==
 
== wikivalues ==
  

Revision as of 15:34, 3 January 2009

wikibot

Table Production.ScrapReason


Column Data Type Nullable Default PK Index
ScrapReasonID smallint not null PK_ScrapReason_ScrapReasonID
Name dbo.Name not null AK_ScrapReason_Name
ModifiedDate datetime not null (getdate())


Detail Table Column Referencing Column
Production.WorkOrder ScrapReasonID ScrapReasonID

wikivalues

Table Values Production.ScrapReason


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