Column | Data Type | Nullable | Default | Description |
WorkOrderID | int | not null | | Primary key. Foreign key to WorkOrder.WorkOrderID. |
ProductID | int | not null | | Primary key. Foreign key to Product.ProductID. |
OperationSequence | smallint | not null | | Primary key. Indicates the manufacturing process sequence. |
LocationID | smallint | not null | | Manufacturing location where the part is processed. Foreign key to Location.LocationID. |
ScheduledStartDate | datetime | not null | | Planned manufacturing start date. |
ScheduledEndDate | datetime | not null | | Planned manufacturing end date. |
ActualStartDate | datetime | null | | Actual start date. |
ActualEndDate | datetime | null | | Actual end date. |
ActualResourceHrs | decimal(9, 4) | null | | Number of manufacturing hours used. |
PlannedCost | money | not null | | Estimated manufacturing cost. |
ActualCost | money | null | | Actual manufacturing cost. |
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |