Data Quality

A.5 Simple Data Rules

269

A.5 Simple Data Rules

The following are examples of rules that apply to a single business object and

often only to a single row of data.

Table:

Description:

Rule Logic:

INVENTORY

Quantity on order cannot be less than minimum-order quantity.

MIN_QUANTITY_ORDER <= QUANTITY_ONORDER

Table:

Description:

Rule Logic:

INVENTORY_HISTORY

If number of orders placed is zero, the quantity ordered must also be zero.

IF NUM_ORDERS PLACED - 0 THEN QUANTITY_ORDERED - 0

Table:

Description:

Rule Logic:

Note:

SUPPLIERS

The date a supplier is established must not be later than the last order placed

with this supplier. Both ...