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 |