WorkOrder Table (AdventureWorks)

Contains the manufacturing work orders. Work orders control which products are manufactured in the appropriate quantity and in time to meet sales or inventory demands.

WorkOrder Table Definition

The WorkOrder table is contained in the Production schema.

Column

Data type

Nullability

Description

WorkOrderID

int

Not null

Primary key.

ProductID

int

Not null

Product identification number. Foreign key to Product.ProductID.

OrderQty

int

Not null

Product quantity to build.

StockedQty

int

Not null

Quantity built and put in inventory.

ScrappedQty

smallint

Not null

Quantity that failed inspection.

StartDate

datetime

Not null

Work order start date.

EndDate

datetime

Null

Work order end date.

DueDate

datetime

Not null

Work order due date.

ScrapReasonID

smalllint

Null

Reason the product failed inspection.

Foreign key to Production.ScrapReason.

ModifiedDate

datetime

Not null

Date and time the row was last updated.