AdventureWorks2019
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.
Created: Modified:
Columns
-
ProductModelID[int] IDENTITY (null,null) 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
Definition
Sample Data
ProductModelID
Name
Instructions
LocationID
SetupHours
MachineHours
LaborHours
LotSize
Step
rowguid
ModifiedDate
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
10
0.5
3
2.5
100
Insert aluminum sheet MS-2341 into the T-85A framing tool.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
10
0.5
3
2.5
100
Attach Trim Jig TJ-26 to the upper and lower right corners of the aluminum sheet.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
10
0.5
3
2.5
100
Using a router with a carbide tip 15, route the aluminum sheet following the jig carefully.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
10
0.5
3
2.5
100
Insert the frame into Forming Tool FT-15 and press Start.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
10
0.5
3
2.5
100
When finished, inspect the forms for defects per Inspection Specification INFS-111.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
10
0.5
3
2.5
100
Remove the frames from the tool and place them in the Completed or Rejected bin as appropriate.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
20
0.15
2
1.75
1
Assemble all frame components following blueprint 1299.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
20
0.15
2
1.75
1
Weld all frame components together as shown in illustration 3
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
20
0.15
2
1.75
1
Inspect all weld joints per Adventure Works Cycles Inspection Specification INFS-208.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
30
NULL
NULL
1
1
Using the standard debur tool, remove all excess material from weld areas.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
30
NULL
NULL
1
1
Using Acme Polish Cream, polish all weld areas.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
Attach a maximum of 20 frames to paint harness ensuring frames are not touching.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
Mix primer PA-529S. Test spray pattern on sample area and correct flow and pattern as required per engineering spec AWC-501.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
Apply thin coat of primer to all surfaces.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
After 30 minutes, touch test for dryness. If dry to touch, lightly sand all surfaces. Remove all surface debris with compressed air.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
Mix paint per manufacturer instructions.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
Test spray pattern on sample area and correct flow and pattern as required per engineering spec AWC-509.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
Apply thin coat of paint to all surfaces.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
After 60 minutes, touch test for dryness. If dry to touch, reapply second coat.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
45
NULL
0.65
0.5
20
Allow paint to cure for 24 hours and inspect per AWC-5015.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
50
0.25
NULL
3
1
Add Seat Assembly.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
50
0.25
NULL
3
1
Add Brake assembly.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
50
0.25
NULL
3
1
Add Wheel Assembly.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
50
0.25
NULL
3
1
Inspect Front Derailleur.
D60ED2A5-C100-4C54-89A1-531404C4A20F
7
HL Touring Frame
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring Frame. Summary: This document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
50
0.25
NULL
3
1
Inspect Rear Derailleur.
D60ED2A5-C100-4C54-89A1-531404C4A20F