Tables for Customer Tracking

PO Table

Fields that were previously noted as not being used are now being used.

SO_Line and PO_Line Tables

• Fields that were previously noted as not being used are now being used.

• The following constraints were added to the min_qty and max_qty fields:

  • The min_qty value must be less than or equal to the quantity field value.

  • The max_qty value must either be null or be greater than or equal to the quantity field value.