CHAPTER4Ordering Products

The previous chapters focused on information about the parties that conduct business and what products they need. This chapter focuses on how parties obtain these products—in other words, the ordering of products.

Businesses need information to answer many questions about orders; they need to know the terms associated with each order. For instance:

  • When is the expected delivery time, and are there consequences for late delivery?
  • Who is responsible for paying for the order?
  • What is the negotiated price for each product that is ordered?
  • What people and organizations are involved in the order?
  • Who placed the order? To whom is the order being shipped?
  • Was there an approved requirement for the order?
  • Were there previous quotes for the order?
  • Were there requests to many vendors to bid for the order?
  • Are there general agreements in place that govern the terms of the order such as special pricing arrangements?

This chapter discusses the following models:

  • Standard order model
  • Order and order items
  • Order parties and contact mechanisms
  • Order adjustments
  • Order status and terms
  • Order Item Associations
  • Requirements
  • Requests
  • Quotes
  • Agreements
  • Agreement items
  • Agreement terms
  • Agreement pricing
  • Agreement to orders

Standard Order Model

Most organizations model orders using the standard data model that is shown throughout many textbooks on data modeling. Figure 4.1 illustrates this standard data model. A SUPPLIER is related to one or more PURCHASE ORDERs, which have ...

Get The Data Model Resource Book, Volume 1 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.