I personally only tend to archive data that's over 2 years old, so at that point the shipments involved and all orders SHOULD be filled. I'd put in some logic to make sure I got flagged if something went horribly awry in that plan though, and just make sure all involved items were both complete and over 2 years old, otherwise they'd wait for everything involved to age correctly.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA