Source-derived document; reported behaviour, inference and evidence gaps are identified in the text.

Return to: C06 — Conceptual Information Model — topic detail

Orders extract

Data: Orders extract

The displayed orders.unl excerpt contains 15 records with ten pipe-separated positions and no visible header. Order identifiers range from 1001 through 1015. Dates in the second position use MM/DD/YYYY and show 1989 dates. The fourth position contains delivery text such as ups, via ups, other notes, or an empty value; the fifth contains y or n; and the sixth contains mixed-format purchase-order-like identifiers such as B77836, Q13557, and 429Q. E0009

The seventh and tenth positions contain date-like values when populated, with the seventh empty for record 1006 and the tenth empty for several records. The eighth and ninth positions contain decimal values with one fractional digit, including 20.4 and 10.0. Empty fourth positions are visible for records 1007 and 1012; empty tenth positions are visible for records 1004, 1006, 1007, and 1012. E0009