Database Table

Attribute

Period

Product

Resource

Customer

Location

Supplier

Transportation Mode

Bill Of Material

ProductLocation

Maximum # of Source Locations

x

x

x

ProductLocation

Maximum # of Destination Locations

x

x

x

ProductLocation

Minimum # of Open Locations

x

x

x

ProductLocation

Maximum # of Open Locations

x

x

x

BillOfResource

Minimum Capacity

x

x

x

x

BillOfResource

Maximum Capacity

x

x

x

x

BillOfResource

Force Open

x

x

x

x

BillOfResource

BOM Variable Cost

x

x

x

x

BillOfResource

Open as Group

x

TransportationTypeProduct

Minimum Capacity

x

x

x

x

TransportationTypeProduct

Maximum Capacity

x

x

x

x

TransportationTypeProduct

Base Case Volume

x

x

x

x

TransportationTypeProduct

Force Open

x

x

x

x

TransportationTypeProduct

Take Or Pay Volume

x

x

x

x

TransportationTypeProduct

Take Or Pay Fixed Cost

x

SupplierProductStep

Variable Cost

x

x

x

x

SupplierProductStep

Minimum Capacity

x

x

x

x

SupplierProductStep

Maximum Capacity

x

x

x

x

SupplierProductStep

Force Open

x

x

x

x

SupplierProductStep

Variable Cost is for all steps

x

x

x

x

SupplierProductStep

Open as Group

x

ResourceProductStep

Variable Cost

x

x

x

x

ResourceProductStep

Minimum Capacity

x

x

x

x

ResourceProductStep

Maximum Capacity

x

x

x

x

ResourceProductStep

Force Open

x

x

x

x

ResourceProductStep

Variable Cost is for all steps

x

x

x

x

ResourceProductStep

Open as Group

x

ResourceProductStep

Minimum Capacity (Inventory)

x

ResourceProductStep

Maximum Capacity (Inventory)

x

ResourceProductStep

Target (Inventory)

x

ResourceProductStep

Variable Cost (Inventory)

x

TransportationTypeProductStep

Cost Per UOM

x

x

x

x

TransportationTypeProductStep

Minimum Capacity

x

x

x

x

TransportationTypeProductStep

Maximum Capacity

x

x

x

x

TransportationTypeProductStep

Force Open

x

x

x

x

TransportationTypeProductStep

Variable Cost is for all steps

x

x

x

x

SupplierStep

Variable Cost

x

x

x

SupplierStep

Minimum Capacity

x

x

x

SupplierStep

Maximum Capacity

x

x

x

SupplierStep

Variable Cost is for all steps

x

x

x

SupplierStep

Open as Group

x

SupplierStep

Minimum # of Open Suppliers

x

x

x

SupplierStep

Maximum # of Open Suppliers

x

x

x

SupplierStep

Limit Openings

x

SupplierStep

Maximum Openings

x

SupplierStep

Limit Closings

x

SupplierStep

Maximum Closings

x

ResourceStep

Variable Cost

x

x

x

ResourceStep

Minimum Capacity

x

x

x

ResourceStep

Maximum Capacity

x

x

x

ResourceStep

Variable Cost is for all steps

x

x

x

ResourceStep

Open as Group

x

ResourceStep

Limit Openings

x

x

ResourceStep

Maximum Openings

x

x

ResourceStep

Limit Closings

x

x

ResourceStep

Maximum Closings

x

x

ResourceStep

Minimum # of Open Productions

x

x

x

ResourceStep

Maximum # of Open Productions

x

x

x

ResourceStep

Minimum # of Open Warehouses

x

x

x

ResourceStep

Maximum # of Open Warehouses

x

x

x

SupplierProductRatio

Minimum Ratio

x

x

x

x

SupplierProductRatio

Maximum Ratio

x

x

x

x

ResourceProductRatio

Minimum Ratio

x

x

x

x

ResourceProductRatio

Maximum Ratio

x

x

x

x

BillOfResourceRatio

Minimum Ratio

x

x

x

x

BillOfResourceRatio

Maximum Ratio

x

x

x

x

TransProductRatio

Minimum Ratio

x

x

x

x

TransProductRatio

Maximum Ratio

x

x

x

x

CustomerProduct

Minimum Fulfillment Rate

x

x

x

x

CustomerProduct

Maximum # of Source Locations

x

x

x

x

CustomerProduct

Minimum Lead Time Adherence

x

x

x

x