Production.vProductModelInstructions

View: 'Production.vProductModelInstructions', Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.

Field Name Type and Size

ProductModelID int identity NOT NULL

Name Name NOT NULL

Instructions nvarchar(max) NULL

LocationID int NULL

SetupHours decimal(9,4) NULL

MachineHours decimal(9,4) NULL

LaborHours decimal(9,4) NULL

LotSize int NULL

Step nvarchar(1024) NULL

rowguid uniqueidentifier NOT NULL

ModifiedDate datetime NOT NULL

Field Name	Type and Size
ProductModelID	int identity NOT NULL
Name	Name NOT NULL
Instructions	nvarchar(max) NULL
LocationID	int NULL
SetupHours	decimal(9,4) NULL
MachineHours	decimal(9,4) NULL
LaborHours	decimal(9,4) NULL
LotSize	int NULL
Step	nvarchar(1024) NULL
rowguid	uniqueidentifier NOT NULL
ModifiedDate	datetime NOT NULL