Design and Architecture
Design Considerations
Scheduled Order - Data View
Current Architecture
New Schedule Type
Existing schedule types:
• Customer Planning – Type 1
• Customer Shipper – Type 2
• Customer Required Ship – Type 3
• Supplier Schedule – Type 4
• Supplier Planning – Type 5
• Supplier Shipping – Type 6
Design Alternative
New Type 7
• Creates gap between schedule types
New Type 4
• Move supplier schedules to 5, 6, and 7
• Large invasive code change
New Data Structure
Design Requirements
Physical requirements:
• New fields
• Job
• Sequence
• Dock
• Line Feed
• New indexes
• By date/sequence for maintenance
• By date/item for planning (required ship schedule [RSS])
• By date/destination/sequence for shipping
Selected Architecture
E-R Diagram
Schema Diagram
