File_Name: My Database Table Name Indexed Fields Rows 71 Cols 5 Table Format 0 Table Note Field Notes 1=optional Field Types 1 1 1 1 2 Field Formats 0 0 51 51 0 Field Access 0 0 0 0 0 Field Names Child Table Child Field Parent Table Parent Field Optional 1 Inventories Location Location Data Name 0 2 Inventories Material Materials Data Name 0 3 Materials Units Units Name 0 4 Orders Supplier Location Data Name 1 5 Orders Customer Location Data Name 1 6 Orders Status Order Status Name 1 7 Shipments From Location Location Data Name 1 8 Shipments To Location Location Data Name 1 9 Shipments Current Location Location Data Name 1 10 Shipments Status Shipment Status Name 1 11 Shipments Auto Route Yes/No Options Name 1 12 Shipments Item Type Item Types Name 1 13 Shipment Routing Location Location Data Name 1 14 Shipment Routing Customer Location Data Name 1 15 Shipment Routing Item Type Item Types Name 1 16 Orders Priority Priorities Name 1 17 Shipments Priority Priorities Name 1 18 Orders Item Type Item Types Name 1 19 Motor Pools Location Location Data Name 0 20 Motor Pools Vehicle Vehicle Data Name 0 21 Vehicle Data Units Units Name 0 22 Bill of Materials Material Materials Data Name 0 23 Bill of Materials Part Materials Data Name 0 24 Inventories - Handlers Location Location Data Name 1 25 Inventories - Handlers Material Materials Data Name 1 26 Reports Sub-totals Yes/No Name 1 27 Reports Totals Yes/No Name 1 28 Reports Type Report Types Name 1 29 Systems Directory Type System Types Type 1 30 Shift Patterns Directory Start Day Days Day 1 31 Scheduled Maintenance Start Day Days Day 1 32 Scheduled Maintenance Units Time Units Units 1 33 Scheduled Maintenance Cycle Scheduled DT Cycles Cycle 1 34 Materials-Finished Flavor Product Flavors Flavor 1 35 Materials-Finished Size Package Sizes Size 1 36 Changeovers: Flavor From Product Flavors Flavor 1 37 Changeovers: Package Size From Package Sizes Size 1 38 Making Schedule System Systems Directory Name 1 39 Making Schedule Product Materials-Raw Base 1 40 Materials-Raw Flavor Product Flavors Flavor 1 41 Packing Schedule System Systems Directory Name 1 42 Packing Schedule Product Materials-Finished SKU 1 43 Packing Schedule Source Schedule Schedules Directory Name 1 44 Making (Batch) Times Flavor Product Flavors Flavor 1 45 Making (Continuous) Rates Flavor Product Flavors Flavor 0 46 Packing Rates Size Package Sizes Size 0 47 Making 1 Equipment Failures Equipment Master Equipment List Equipment 0 48 Making 2 Equipment Failures Equipment Master Equipment List Equipment 1 49 Packing 1 Equipment Failures Equipment Master Equipment List Equipment 1 50 Packing 2 Equipment Failures Equipment Master Equipment List Equipment 1 51 Packing 3 Equipment Failures Equipment Master Equipment List Equipment 1 52 Packing Schedule 2 System Systems Directory Name 0 53 Packing Schedule 2 Product Materials-Finished SKU 0 54 Making Report Product Materials-Raw Flavor 1 55 Making Report System Systems Directory Name 1 56 Packing Report SKU Materials-Finished SKU 1 57 Packing Report System Systems Directory Name 1 58 Inventories Supplier Location Data Name 1 59 Location Data Type Location Types Name 0 60 Consumption Material Materials Data Name 0 61 Material Trip Times From Location Location Data Name 0 62 Material Trip Times To Location Location Data Name 0 63 Material Routing Plant - US Location Data Name 1 64 Material Routing Supplier 1 Location Data Name 1 65 Material Routing Supplier 2 Location Data Name 1 66 Material Routing Distribution 1 Location Data Name 1 67 Material Routing Distribution 2 Location Data Name 1 68 Material Routing Distribution 3 Location Data Name 1 69 Material Routing Distribution 4 Location Data Name 1 70 Material Routing Distribution 5 Location Data Name 1 71 Material Routing Location Location Data Name 0 Table Name Yes/No Options Rows 2 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 yes 2 no Table Name Table Help Rows 32 Cols 3 Table Format 0 Table Note Field Notes Supply Chain Field Types 1 1 2 Field Formats 0 0 0 Field Access 0 0 0 Field Names Table Name Help Exists 1 Item Types [Supply Chain.HLP/Item_Types_Table] 1 2 Yes/No Options [Supply Chain.HLP/Yes_No_Options_Table] 0 3 Location Data [Supply Chain.HLP/Location Data_Table] 1 4 Container Routing [Supply Chain.HLP/Container_Routing_Table] 0 5 Inventories [Supply Chain.HLP/Inventory_Table] 1 6 Inventories (Ordering) [Supply Chain.HLP/Orders_Table] 1 7 Inventories (Handling) [Supply Chain.HLP/Handling_Table] 0 8 Inventories (Cost) [Supply Chain.HLP/Cost_Table] 0 9 Inventories (Aging) [Supply Chain.HLP/Aging_Table] 0 10 Units [Supply Chain.HLP/Units_Table] 0 11 Material Types [Supply Chain.HLP/Material_Types_Table] 0 12 Brands [Supply Chain.HLP/Brands_Table] 0 13 Materials Data [Supply Chain.HLP/Materials_Data_Table] 0 14 Systems Directory [Supply Chain.HLP/Systems_Directory_Table] 0 15 Production Groups [Supply Chain.HLP/Production_Groups_Table] 0 16 SKU Bill Of Materials [Supply Chain.HLP/SKU_Bill_Of_Materials_Table] 0 17 Bill of Materials [Supply Chain.HLP/Bill_Of_Materials_Table] 1 18 Demand Multipliers [Supply Chain.HLP/Demand_Tables] 1 19 Forecast Distribution [Supply Chain.HLP/Forecast Distribution_Table] 0 20 Base Demand (Per Day) [Supply Chain.HLP/Demand_Tables] 1 21 Forecast [Supply Chain.HLP/Demand_Tables] 1 22 Demand Profile [Supply Chain.HLP/Demand_Profile_Table] 0 23 Container Data [Supply Chain.HLP/Container_Data_Table] 0 24 Containers [Supply Chain.HLP/Containers_Table] 0 25 Container Capacity [Supply Chain.HLP/Container_Capacity_Table] 0 26 Orders [Supply Chain.HLP/Orders_Table] 1 27 Order Status [Supply Chain.HLP/Orders_Table] 1 28 Priorities [Supply Chain.HLP/Priorities_Table] 0 29 Shipments [Supply Chain.HLP/Shipments_Table] 1 30 Shipment Status [Supply Chain.HLP/Shipments_Table] 1 31 Shipment Routing [Supply Chain.HLP/Shipment_Routing_Table] 1 32 Indexed Fields [Supply Chain.HLP/Indexed_Fields_Table] 0 Table Name Location Types Rows 3 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 Supplier 2 Plant 3 Distribution Center Table Name Location Data Rows 8 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Type 1 Plant - US Plant 2 Supplier 1 Supplier 3 Supplier 2 Supplier 4 Distribution 1 Distribution Center 5 Distribution 2 Distribution Center 6 Distribution 3 Distribution Center 7 Distribution 4 Distribution Center 8 Distribution 5 Distribution Center Table Name Material Routing Rows 8 Cols 9 Table Format 0 Table Note Field Notes Destination Destination Destination Destination Destination Destination Destination Destination Field Types 1 1 1 1 1 1 1 1 1 Field Formats 0 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 0 Field Names Location Plant - US Supplier 1 Supplier 2 Distribution 1 Distribution 2 Distribution 3 Distribution 4 Distribution 5 1 Plant - US Distribution 1 Distribution 1 Distribution 1 Distribution 1 Distribution 1 2 Supplier 1 Plant - US 3 Supplier 2 Plant - US 4 Distribution 1 Distribution 1 Distribution 2 Distribution 3 Distribution 3 Distribution 3 5 Distribution 2 Distribution 2 6 Distribution 3 Distribution 3 Distribution 4 Distribution 5 7 Distribution 4 8 Distribution 5 Table Name Material Trip Times Rows 9 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 0 Field Formats 0 0 11 Field Access 0 0 0 Field Names From Location To Location Trip Days 1 Plant - US Distribution 1 0.5 2 Supplier 1 Plant - US 0.5 3 Supplier 2 Plant - US 0.5 4 Distribution 1 Distribution 2 0.5 5 Distribution 1 Distribution 3 0.5 6 Distribution 3 Distribution 4 0.5 7 Distribution 3 Distribution 5 0.5 8 Distribution 1 Distribution 1 0 9 Distribution 3 Distribution 3 0 Table Name Consumption Rows 16 Cols 6 Table Format 0 Table Note Field Notes Indexed to Location Data table Indexed to Materials Data table Field Types 1 0 0 0 0 0 Field Formats 0 20 20 20 20 20 Field Access 0 0 0 0 0 0 Field Names Material Distribution 1 Distribution 2 Distribution 3 Distribution 4 Distribution 5 1 SKU 1 500 250 500 250 500 2 SKU 2 500 250 500 250 500 3 SKU 3 500 250 500 250 500 4 SKU 4 500 250 500 250 500 5 SKU 5 500 250 500 250 500 6 SKU 6 500 250 500 250 500 7 SKU 7 500 250 500 250 500 8 SKU 8 500 250 500 250 500 9 SKU 9 250 500 250 500 250 10 SKU 10 250 500 250 500 250 11 SKU 11 250 500 250 500 250 12 SKU 12 250 500 250 500 250 13 SKU 13 250 500 250 500 250 14 SKU 14 250 500 250 500 250 15 SKU 15 250 500 250 500 250 16 SKU 16 250 500 250 500 250 Table Name Inventories Rows 104 Cols 14 Table Format 0 Table Note Field Notes Indexed to Location Data table Indexed to Materials Data table Orders placed to supplier of this material not yet delivered Specify the inventory level which will trigger an order Orders placed from customers of this material/location Field Types 1 1 0 0 0 0 1 0 0 0 0 0 0 0 Field Formats 0 0 20 20 20 20 0 20 20 20 20 20 20 20 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Location Material Initial Amount Current Amount Amount Out Amount on Order Supplier Order Point Unfilled Orders Average Contents Maximum Contents Minimum Contents Time of Last Change Time to Fill Order 1 Plant - US SKU 1 20000 0 0 0 0 0 0 0 0 0 0 2 Plant - US SKU 2 20000 0.42 0.42 0 0 0 0 0 0 0 0 3 Plant - US SKU 3 20000 0.42 0.42 0 0 0 0 0 0 0 0 4 Plant - US SKU 4 20000 0.26 0.26 0 0 0 0 0 0 0 0 5 Plant - US SKU 5 20000 0.26 0.26 0 0 0 0 0 0 0 0 6 Plant - US SKU 6 20000 0.26 0.26 0 0 0 0 0 0 0 0 7 Plant - US SKU 7 20000 0.26 0.26 0 0 0 0 0 0 0 0 8 Plant - US SKU 8 20000 0.26 0.26 0 0 0 0 0 0 0 0 9 Plant - US SKU 9 20000 0.26 0.26 0 0 0 0 0 0 0 0 10 Plant - US SKU 10 20000 0.26 0.26 0 0 0 0 0 0 0 0 11 Plant - US SKU 11 20000 0.26 0.26 0 0 0 0 0 0 0 0 12 Plant - US SKU 12 20000 0.26 0.26 0 0 0 0 0 0 0 0 13 Plant - US SKU 13 20000 0.26 0.26 0 0 0 0 0 0 0 0 14 Plant - US SKU 14 20000 0.26 0.26 0 0 0 0 0 0 0 0 15 Plant - US SKU 15 20000 0.26 0.26 0 0 0 0 0 0 0 0 16 Plant - US SKU 16 20000 0.26 0.26 0 0 0 0 0 0 0 0 17 Plant - US Base A 200000 0.26 0.26 0 Supplier 1 150000 0 0 0 0 0 0 18 Plant - US Base B 200000 0.26 0.26 0 Supplier 2 150000 0 0 0 0 0 0 19 Plant - US Base C 200000 0.26 0.26 0 Supplier 1 150000 0 0 0 0 0 0 20 Plant - US Base D 200000 0.26 0.26 0 Supplier 2 150000 0 0 0 0 0 0 21 Supplier 1 Base A 10000000 0.26 0.26 0 0 0 0 0 0 0 0 22 Supplier 2 Base B 10000000 0.26 0.26 0 0 0 0 0 0 0 0 23 Supplier 1 Base C 10000000 0.26 0.26 0 0 0 0 0 0 0 0 24 Supplier 2 Base D 10000000 0.26 0.26 0 0 0 0 0 0 0 0 25 Distribution 1 SKU 1 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 26 Distribution 1 SKU 2 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 27 Distribution 1 SKU 3 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 28 Distribution 1 SKU 4 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 29 Distribution 1 SKU 5 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 30 Distribution 1 SKU 6 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 31 Distribution 1 SKU 7 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 32 Distribution 1 SKU 8 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 33 Distribution 1 SKU 9 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 34 Distribution 1 SKU 10 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 35 Distribution 1 SKU 11 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 36 Distribution 1 SKU 12 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 37 Distribution 1 SKU 13 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 38 Distribution 1 SKU 14 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 39 Distribution 1 SKU 15 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 40 Distribution 1 SKU 16 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 41 Distribution 2 SKU 1 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 42 Distribution 2 SKU 2 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 43 Distribution 2 SKU 3 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 44 Distribution 2 SKU 4 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 45 Distribution 2 SKU 5 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 46 Distribution 2 SKU 6 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 47 Distribution 2 SKU 7 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 48 Distribution 2 SKU 8 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 49 Distribution 2 SKU 9 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 50 Distribution 2 SKU 10 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 51 Distribution 2 SKU 11 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 52 Distribution 2 SKU 12 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 53 Distribution 2 SKU 13 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 54 Distribution 2 SKU 14 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 55 Distribution 2 SKU 15 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 56 Distribution 2 SKU 16 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 57 Distribution 3 SKU 1 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 58 Distribution 3 SKU 2 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 59 Distribution 3 SKU 3 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 60 Distribution 3 SKU 4 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 61 Distribution 3 SKU 5 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 62 Distribution 3 SKU 6 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 63 Distribution 3 SKU 7 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 64 Distribution 3 SKU 8 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 65 Distribution 3 SKU 9 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 66 Distribution 3 SKU 10 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 67 Distribution 3 SKU 11 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 68 Distribution 3 SKU 12 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 69 Distribution 3 SKU 13 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 70 Distribution 3 SKU 14 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 71 Distribution 3 SKU 15 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 72 Distribution 3 SKU 16 1000 0.26 0.26 0 Plant - US 1000 0 0 0 0 0 0 73 Distribution 4 SKU 1 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 74 Distribution 4 SKU 2 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 75 Distribution 4 SKU 3 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 76 Distribution 4 SKU 4 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 77 Distribution 4 SKU 5 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 78 Distribution 4 SKU 6 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 79 Distribution 4 SKU 7 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 80 Distribution 4 SKU 8 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 81 Distribution 4 SKU 9 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 82 Distribution 4 SKU 10 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 83 Distribution 4 SKU 11 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 84 Distribution 4 SKU 12 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 85 Distribution 4 SKU 13 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 86 Distribution 4 SKU 14 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 87 Distribution 4 SKU 15 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 88 Distribution 4 SKU 16 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 89 Distribution 5 SKU 1 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 90 Distribution 5 SKU 2 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 91 Distribution 5 SKU 3 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 92 Distribution 5 SKU 4 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 93 Distribution 5 SKU 5 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 94 Distribution 5 SKU 6 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 95 Distribution 5 SKU 7 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 96 Distribution 5 SKU 8 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 97 Distribution 5 SKU 9 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 98 Distribution 5 SKU 10 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 99 Distribution 5 SKU 11 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 100 Distribution 5 SKU 12 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 101 Distribution 5 SKU 13 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 102 Distribution 5 SKU 14 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 103 Distribution 5 SKU 15 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 104 Distribution 5 SKU 16 2000 0.26 0.26 0 Plant - US 2000 0 0 0 0 0 0 Table Name Inventories - Handlers Rows 104 Cols 7 Table Format 0 Table Note Field Notes Indexed to Location Data table Indexed to Materials Data table Model puts number of block handling consumption for each inventory Model puts number of block placing orders for each inventory Model puts number of block filling orders for each inventory Model puts number of block assigning orders for each inventory Model puts number of block assembling orders for each inventory Field Types 1 1 2 2 2 2 2 Field Formats 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 Field Names Location Material Consumption Block Check Inventory Block Fill Order Block Assign Order Block Assemble Order Block 1 Plant - US SKU 1 0 0 0 0 0 2 Plant - US SKU 2 0 0 0 0 0 3 Plant - US SKU 3 0 0 0 0 0 4 Plant - US SKU 4 0 0 0 0 0 5 Plant - US SKU 5 0 0 0 0 0 6 Plant - US SKU 6 0 0 0 0 0 7 Plant - US SKU 7 0 0 0 0 0 8 Plant - US SKU 8 0 0 0 0 0 9 Plant - US SKU 9 0 0 0 0 0 10 Plant - US SKU 10 0 0 0 0 0 11 Plant - US SKU 11 0 0 0 0 0 12 Plant - US SKU 12 0 0 0 0 0 13 Plant - US SKU 13 0 0 0 0 0 14 Plant - US SKU 14 0 0 0 0 0 15 Plant - US SKU 15 0 0 0 0 0 16 Plant - US SKU 16 0 0 0 0 0 17 Plant - US Base A 0 0 0 0 0 18 Plant - US Base B 0 0 0 0 0 19 Plant - US Base C 0 0 0 0 0 20 Plant - US Base D 0 0 0 0 0 21 Supplier 1 Base A 0 0 0 0 0 22 Supplier 2 Base B 0 0 0 0 0 23 Supplier 1 Base C 0 0 0 0 0 24 Supplier 2 Base D 0 0 0 0 0 25 Distribution 1 SKU 1 0 0 0 0 0 26 Distribution 1 SKU 2 0 0 0 0 0 27 Distribution 1 SKU 3 0 0 0 0 0 28 Distribution 1 SKU 4 0 0 0 0 0 29 Distribution 1 SKU 5 0 0 0 0 0 30 Distribution 1 SKU 6 0 0 0 0 0 31 Distribution 1 SKU 7 0 0 0 0 0 32 Distribution 1 SKU 8 0 0 0 0 0 33 Distribution 1 SKU 9 0 0 0 0 0 34 Distribution 1 SKU 10 0 0 0 0 0 35 Distribution 1 SKU 11 0 0 0 0 0 36 Distribution 1 SKU 12 0 0 0 0 0 37 Distribution 1 SKU 13 0 0 0 0 0 38 Distribution 1 SKU 14 0 0 0 0 0 39 Distribution 1 SKU 15 0 0 0 0 0 40 Distribution 1 SKU 16 0 0 0 0 0 41 Distribution 2 SKU 1 0 0 0 0 0 42 Distribution 2 SKU 2 0 0 0 0 0 43 Distribution 2 SKU 3 0 0 0 0 0 44 Distribution 2 SKU 4 0 0 0 0 0 45 Distribution 2 SKU 5 0 0 0 0 0 46 Distribution 2 SKU 6 0 0 0 0 0 47 Distribution 2 SKU 7 0 0 0 0 0 48 Distribution 2 SKU 8 0 0 0 0 0 49 Distribution 2 SKU 9 0 0 0 0 0 50 Distribution 2 SKU 10 0 0 0 0 0 51 Distribution 2 SKU 11 0 0 0 0 0 52 Distribution 2 SKU 12 0 0 0 0 0 53 Distribution 2 SKU 13 0 0 0 0 0 54 Distribution 2 SKU 14 0 0 0 0 0 55 Distribution 2 SKU 15 0 0 0 0 0 56 Distribution 2 SKU 16 0 0 0 0 0 57 Distribution 3 SKU 1 0 0 0 0 0 58 Distribution 3 SKU 2 0 0 0 0 0 59 Distribution 3 SKU 3 0 0 0 0 0 60 Distribution 3 SKU 4 0 0 0 0 0 61 Distribution 3 SKU 5 0 0 0 0 0 62 Distribution 3 SKU 6 0 0 0 0 0 63 Distribution 3 SKU 7 0 0 0 0 0 64 Distribution 3 SKU 8 0 0 0 0 0 65 Distribution 3 SKU 9 0 0 0 0 0 66 Distribution 3 SKU 10 0 0 0 0 0 67 Distribution 3 SKU 11 0 0 0 0 0 68 Distribution 3 SKU 12 0 0 0 0 0 69 Distribution 3 SKU 13 0 0 0 0 0 70 Distribution 3 SKU 14 0 0 0 0 0 71 Distribution 3 SKU 15 0 0 0 0 0 72 Distribution 3 SKU 16 0 0 0 0 0 73 Distribution 4 SKU 1 0 0 0 0 0 74 Distribution 4 SKU 2 0 0 0 0 0 75 Distribution 4 SKU 3 0 0 0 0 0 76 Distribution 4 SKU 4 0 0 0 0 0 77 Distribution 4 SKU 5 0 0 0 0 0 78 Distribution 4 SKU 6 0 0 0 0 0 79 Distribution 4 SKU 7 0 0 0 0 0 80 Distribution 4 SKU 8 0 0 0 0 0 81 Distribution 4 SKU 9 0 0 0 0 0 82 Distribution 4 SKU 10 0 0 0 0 0 83 Distribution 4 SKU 11 0 0 0 0 0 84 Distribution 4 SKU 12 0 0 0 0 0 85 Distribution 4 SKU 13 0 0 0 0 0 86 Distribution 4 SKU 14 0 0 0 0 0 87 Distribution 4 SKU 15 0 0 0 0 0 88 Distribution 4 SKU 16 0 0 0 0 0 89 Distribution 5 SKU 1 0 0 0 0 0 90 Distribution 5 SKU 2 0 0 0 0 0 91 Distribution 5 SKU 3 0 0 0 0 0 92 Distribution 5 SKU 4 0 0 0 0 0 93 Distribution 5 SKU 5 0 0 0 0 0 94 Distribution 5 SKU 6 0 0 0 0 0 95 Distribution 5 SKU 7 0 0 0 0 0 96 Distribution 5 SKU 8 0 0 0 0 0 97 Distribution 5 SKU 9 0 0 0 0 0 98 Distribution 5 SKU 10 0 0 0 0 0 99 Distribution 5 SKU 11 0 0 0 0 0 100 Distribution 5 SKU 12 0 0 0 0 0 101 Distribution 5 SKU 13 0 0 0 0 0 102 Distribution 5 SKU 14 0 0 0 0 0 103 Distribution 5 SKU 15 0 0 0 0 0 104 Distribution 5 SKU 16 0 0 0 0 0 Table Name Materials Directory Rows 2 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Materials-Raw 0 2 Materials-Finished 0 Table Name Materials-Raw Rows 4 Cols 2 Table Format 0 Table Note Field Notes Parent Field Index=Product Flavors;Flavor Field Types 1 1 Field Formats 0 10 Field Access 0 0 Field Names Base Flavor 1 Base A Chocolate 2 Base B Vanilla 3 Base C Strawberry 4 Base D Raspberry Crunch Table Name Materials-Finished Rows 16 Cols 3 Table Format 0 Table Note Field Notes Parent Field Index=Product Flavors;Flavor Index=Package Sizes;Size Field Types 1 1 1 Field Formats 0 10 0 Field Access 0 0 0 Field Names SKU Flavor Size 1 SKU 1 Chocolate Small 2 SKU 2 Chocolate Medium 3 SKU 3 Chocolate Large 4 SKU 4 Chocolate Extra Large 5 SKU 5 Vanilla Small 6 SKU 6 Vanilla Medium 7 SKU 7 Vanilla Large 8 SKU 8 Vanilla Extra Large 9 SKU 9 Strawberry Small 10 SKU 10 Strawberry Medium 11 SKU 11 Strawberry Large 12 SKU 12 Strawberry Extra Large 13 SKU 13 Raspberry Crunch Small 14 SKU 14 Raspberry Crunch Medium 15 SKU 15 Raspberry Crunch Large 16 SKU 16 Raspberry Crunch Extra Large Table Name Package Sizes Rows 4 Cols 3 Table Format 0 Table Note Field Notes Parent Field Field Types 1 2 2 Field Formats 0 0 0 Field Access 0 0 0 Field Names Size Weight (oz) Cans per Case 1 Small 8 24 2 Medium 16 16 3 Large 24 12 4 Extra Large 48 6 Table Name Product Flavors Rows 4 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 10 12 Field Access 0 0 Field Names Flavor Code 1 Chocolate 0 2 Vanilla 0 3 Strawberry 0 4 Raspberry Crunch 0 Table Name Materials Data Rows 20 Cols 3 Table Format 0 Table Note Field Notes Inventories are in units defined for this material Field Types 1 1 0 Field Formats 0 0 20 Field Access 0 0 0 Field Names Name Units Pounds per Unit 1 Base A pounds 0 2 Base B pounds 0 3 Base C pounds 0 4 Base D pounds 0 5 SKU 1 pounds 0 6 SKU 2 pounds 0 7 SKU 3 pounds 0 8 SKU 4 pounds 0 9 SKU 5 pounds 0 10 SKU 6 pounds 0 11 SKU 7 pounds 0 12 SKU 8 pounds 0 13 SKU 9 pounds 0 14 SKU 10 pounds 0 15 SKU 11 pounds 0 16 SKU 12 pounds 0 17 SKU 13 pounds 0 18 SKU 14 pounds 0 19 SKU 15 pounds 0 20 SKU 16 pounds 0 Table Name Units Rows 4 Cols 1 Table Format 0 Table Note Field Notes Provides choice list for the units of materials Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 pounds 2 each 3 bag 4 cases Table Name Bill of Materials Rows 16 Cols 4 Table Format 0 Table Note Field Notes Field Types 1 1 0 1 Field Formats 0 0 50 10 Field Access 0 0 0 0 Field Names Material Part Quantity Flavor 1 SKU 1 Base A 1 Chocolate 2 SKU 2 Base A 1 Chocolate 3 SKU 3 Base A 1 Chocolate 4 SKU 4 Base A 1 Chocolate 5 SKU 5 Base B 1 Vanilla 6 SKU 6 Base B 1 Vanilla 7 SKU 7 Base B 1 Vanilla 8 SKU 8 Base B 1 Vanilla 9 SKU 9 Base C 1 Strawberry 10 SKU 10 Base C 1 Strawberry 11 SKU 11 Base C 1 Strawberry 12 SKU 12 Base C 1 Strawberry 13 SKU 13 Base D 1 Raspberry Crunch 14 SKU 14 Base D 1 Raspberry Crunch 15 SKU 15 Base D 1 Raspberry Crunch 16 SKU 16 Base D 1 Raspberry Crunch Table Name Vehicle Data Rows 1 Cols 3 Table Format 0 Table Note Field Notes Inventories are in units defined for this material Field Types 1 1 2 Field Formats 0 20 20 Field Access 0 0 0 Field Names Name Units Pounds per Unit 1 Truck pounds 10000 Table Name Motor Pools Rows 1 Cols 11 Table Format 0 Table Note Field Notes Indexed to Location Data table Indexed to Materials Data table Optional. May be determined by model. Pass doConsumption message to this block. (Model variable) Pass doCheckInventory message to this block. (Model variable) Pass do FillOrder message to this block. (Model Variable) Pass doAssignOrder message to this block. (Model Variable) Pass doAssignOrder message to this block. (Model Variable) Pass doAssignOrder message to this block. (Model Variable) Field Types 1 1 0 0 1 2 2 2 2 2 0 Field Formats 0 61 20 20 51 0 0 0 0 0 20 Field Access 0 0 0 0 0 0 0 0 0 0 0 Field Names Location Vehicle Initial Amount Current Amount Supplier Consumption Block Check Inventory Block Fill Order Block Assign Order Block Assemble Order Block Amount on Order 1 Distribution 1 Truck 1 0 0 0 0 0 0 0 0 Table Name Orders Rows 1 Cols 15 Table Format 0 Table Note Field Notes All fields filled out by the model Time each order was placed Time each order was assigned Time each order was assigned Field Types 2 1 1 1 1 1 0 0 0 0 1 2 0 0 0 Field Formats 0 20 20 20 20 20 20 20 20 20 20 20 61 61 61 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Order Number Customer Supplier Item Type Item Priority Order Amount Amount Assigned Amount Filled Amount Delivered Status First Shipment Number Time placed Time Assigned Time of Last Change 1 1 0 0 0 0 0 0 36161 36161 0 Table Name Order Status Rows 8 Cols 2 Table Format 0 Table Note Field Notes Provides choice list for the units of materials Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 placing Placed with a delay 2 placed Placed and awaits assignment 3 assigning Assigned with a delay 4 assigned Assigned and awaits being filled 5 filling Partially filled 6 filled filled 7 delivering partially delivered 8 delivered delivered Table Name Priorities Rows 3 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 urgent 0 2 regular 0 3 assigning 0 Table Name Shipments Rows 1 Cols 19 Table Format 0 Table Note Field Notes All fields filled out by the model Indexed to Location Data table Indexed to Location Data table This is the index number of the specific instance of the shipment type. E.g. type is material, instance is material 1. Indexed to Location Data table If this shipment has parts, pointer to first part. If this shipment is a part, pointer to next part. Part of what shipment A shipment becomes ready when filling and routing are completed. The model will tie shipments to the orders that generated them Field Types 2 1 1 1 0 0 1 1 1 2 2 2 1 1 2 2 0 0 0 Field Formats 0 20 20 20 20 52 20 20 20 20 20 20 20 20 0 0 61 61 61 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Shipment Number From Location To Location Priority Amount Percent Full Item Type Item Current Location First Part Next Part Part Of Status Auto Route Order Number Next Shipment in Order Time Created Time Delivered Time of Last Change 1 1 0 0 0 0 0 0 Ready no 1 1 36161 36161 36162 Table Name Shipment Status Rows 3 Cols 2 Table Format 0 Table Note Field Notes Provides choice list for the units of materials Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Ready Ready to be Routed 2 Filling Other shipments may be added to it, so don not route 3 Routing On the way somewhere, or being loaded or unloaded. Table Name Item Types Rows 2 Cols 4 Table Format 0 Table Note Field Notes Provides choice list for shipments Field Types 1 1 1 1 Field Formats 0 0 0 0 Field Access 0 0 0 0 Field Names Name Data Table Inventory Table Bill of Materials Table 1 material Materials Data Inventories 0 2 vehicle Vehicle Data Motor Pools 0 Table Name Shipment Routing Rows 1 Cols 6 Table Format 0 Table Note Field Notes material, container, vehicle etc material, container, vehicle etc Specific material, container vehicle, etc If blank, applies to all If blank, applies to all Pass doRouteShipment message to this block Field Types 1 1 1 1 1 2 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Priority Item Type Item Location Customer Routing Block 1 regular material 0 Plant - US 0 Table Name Surge Capacity Rows 4 Cols 2 Table Format 0 Table Note Field Notes Field Types 2 0 Field Formats 0 20 Field Access 0 0 Field Names Bin Capacity 1 1 50000 2 2 50000 3 3 50000 4 4 50000 Table Name Source/Bin Compatibility Rows 4 Cols 3 Table Format 0 Table Note Field Notes Max Flow Max Flow Field Types 2 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names Bin Source 1 Source 2 1 1 1000 1000 2 2 1000 1000 3 3 1000 1000 4 4 1000 1000 Table Name Bin/User Compatibility Rows 4 Cols 7 Table Format 0 Table Note Field Notes Max Flow Max Flow Max Flow Max Flow Max Flow Max Flow Field Types 2 0 0 0 0 0 0 Field Formats 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 Field Names Bin User 1 User 2 User 3 User 4 User 5 User 6 1 1 100000 100000 100000 100000 100000 100000 2 2 100000 100000 100000 100000 100000 100000 3 3 100000 100000 100000 100000 100000 100000 4 4 100000 100000 100000 100000 100000 100000 Table Name Systems Directory Rows 5 Cols 3 Table Format 0 Table Note Field Notes Parent Field Index=System Types;Type Field Types 1 1 1 Field Formats 0 0 0 Field Access 0 0 0 Field Names Name Description Type 1 Making 1 Making 2 Making 2 Making 3 Packing 1 Packing 4 Packing 2 Packing 5 Packing 3 Packing Table Name System Types Rows 2 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Type Description 1 Making 2 Packing Table Name Schedules Directory Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Making Schedule 2 Packing Schedule 3 Packing Schedule 2 0 Table Name Making Schedule Rows 8 Cols 6 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Index=Materials-Raw;Base Field Types 2 1 1 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Production Run System Product Start Time End Time Goal 1 1 Making 1 Base A 0 720 500000 2 2 Making 2 Base B 720 1440 500000 3 3 Making 1 Base C 1440 2160 500000 4 4 Making 2 Base D 2160 2880 500000 5 5 Making 1 Base A 2880 3600 500000 6 6 Making 2 Base B 3600 4320 500000 7 7 Making 1 Base C 4320 5040 500000 8 8 Making 2 Base D 5040 5760 500000 Table Name Packing Schedule Rows 24 Cols 8 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Index=Schedules Directory;Name Index=Materials-Finished;SKU Field Types 2 1 1 2 1 0 0 0 Field Formats 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 Field Names Production Run System Source Schedule Source Run Product Start Time End Time Goal 1 1 Packing 1 Making Schedule 1 SKU 1 0 720 2000 2 2 Packing 2 Making Schedule 1 SKU 3 0 720 2000 3 3 Packing 3 Making Schedule 1 SKU 2 0 720 2000 4 4 Packing 1 Making Schedule 2 SKU 5 720 1440 2000 5 5 Packing 2 Making Schedule 2 SKU 6 720 1440 2000 6 6 Packing 3 Making Schedule 2 SKU 7 720 1440 2000 7 7 Packing 1 Making Schedule 3 SKU 12 1440 2160 2000 8 8 Packing 2 Making Schedule 3 SKU 9 1440 2160 2000 9 9 Packing 3 Making Schedule 3 SKU 11 1440 2160 2000 10 10 Packing 1 Making Schedule 4 SKU 13 2160 2880 2000 11 11 Packing 2 Making Schedule 4 SKU 16 2160 2880 2000 12 12 Packing 3 Making Schedule 4 SKU 14 2160 2880 2000 13 13 Packing 1 Making Schedule 5 SKU 1 2880 3600 2000 14 14 Packing 2 Making Schedule 5 SKU 4 2880 3600 2000 15 15 Packing 3 Making Schedule 5 SKU 2 2880 3600 2000 16 16 Packing 1 Making Schedule 6 SKU 5 3600 4320 2000 17 17 Packing 2 Making Schedule 6 SKU 6 3600 4320 2000 18 18 Packing 3 Making Schedule 6 SKU 7 3600 4320 2000 19 19 Packing 1 Making Schedule 7 SKU 10 4320 5040 2000 20 20 Packing 2 Making Schedule 7 SKU 9 4320 5040 2000 21 21 Packing 3 Making Schedule 7 SKU 12 4320 5040 2000 22 22 Packing 1 Making Schedule 8 SKU 14 5040 5760 2000 23 23 Packing 2 Making Schedule 8 SKU 15 5040 5760 2000 24 24 Packing 3 Making Schedule 8 SKU 16 5040 5760 2000 Table Name Packing Schedule 2 Rows 24 Cols 6 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Index=Materials-Finished;SKU Field Types 2 1 1 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Production Run System Product Start Time End Time Goal 1 1 Packing 1 SKU 1 0 1300 2000 2 2 Packing 2 SKU 3 0 1300 2000 3 3 Packing 3 SKU 2 0 1300 2000 4 4 Packing 1 SKU 5 1900 3200 2000 5 5 Packing 2 SKU 6 1900 3200 2000 6 6 Packing 3 SKU 7 1900 3200 2000 7 7 Packing 1 SKU 12 3800 5100 2000 8 8 Packing 2 SKU 9 3800 5100 2000 9 9 Packing 3 SKU 11 3800 5100 2000 10 10 Packing 1 SKU 13 5700 7000 2000 11 11 Packing 2 SKU 16 5700 7000 2000 12 12 Packing 3 SKU 14 5700 7000 2000 13 13 Packing 1 SKU 1 7600 8900 2000 14 14 Packing 2 SKU 4 7600 8900 2000 15 15 Packing 3 SKU 2 7600 8900 2000 16 16 Packing 1 SKU 5 9500 10800 2000 17 17 Packing 2 SKU 6 9500 10800 2000 18 18 Packing 3 SKU 7 9500 10800 2000 19 19 Packing 1 SKU 10 11400 12700 2000 20 20 Packing 2 SKU 9 11400 12700 2000 21 21 Packing 3 SKU 12 11400 12700 2000 22 22 Packing 1 SKU 14 13300 14600 2000 23 23 Packing 2 SKU 15 13300 14600 2000 24 24 Packing 3 SKU 16 13300 14600 2000 Table Name Start Modes Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Modes Description 1 Start Time Specified start time. 2 When Ready When setup complete from prior run. 3 Users Start When any user run has started. Table Name End Modes Rows 8 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Modes Description 1 Next ST End at next start time. 2 End Time Specified end time. 3 Goal Use the specified goal. 4 1st of ET & goal First of end time and goal. 5 1st of ST & goal First of start time of next run and goal. 6 2nd of ET & goal Second of end time and goal. 7 Users Goals met All user goals are met. 8 Source Empty End when source is empty. Table Name Holiday Schedule Rows 12 Cols 2 Table Format 0 Table Note Field Notes Field Types 0 1 Field Formats 61 0 Field Access 0 0 Field Names Date Description 1 35796 New Years Day 2 35810 MLK Day 3 35842 Presidents Day 4 35907 Secretaries Day 5 35940 Memorial Day 6 35956 Shavout Day 7 35980 Independence Day 8 36024 Full Moon! 9 36038 Labor Day 10 36099 Halloween 11 36125 Thanksgiving 12 36154 Christmas Day Table Name Making (Batch) Times Rows 4 Cols 7 Table Format 0 Table Note Field Notes Index=Product Flavors;Flavor Field Types 1 0 0 0 0 0 0 Field Formats 10 10 10 10 10 10 10 Field Access 0 0 0 0 0 0 0 Field Names Flavor Pump Batch Size Mixing Agglomerator Pre-Dryer Final Dryer 1 Chocolate 1000 47000 10 9 4704 4704 2 Vanilla 1000 51000 10 11 5125 5125 3 Strawberry 1100 60000 11 10.5 5557 5557 4 Raspberry Crunch 800 50000 8 9 6398 6398 Table Name Making (Continuous) Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes Index=Product Flavors;Flavor Field Types 1 0 0 0 0 Field Formats 10 10 10 10 10 Field Access 0 0 0 0 0 Field Names Flavor Mixing Agglomerator Pre-Dryer Final Dryer 1 Chocolate 4704 4704 4704 4704 2 Vanilla 5125 5125 5125 5125 3 Strawberry 5557 5557 5557 5557 4 Raspberry Crunch 6398 6398 6398 6398 Table Name Packing Rates Rows 4 Cols 6 Table Format 0 Table Note Field Notes Index=Package Sizes;Size Field Types 1 0 0 0 0 0 Field Formats 0 10 10 10 10 10 Field Access 0 0 0 0 0 0 Field Names Size Container Supply Filler Sealer Conveyor Case Packer 1 Small 1000 1000 1000 1000 1000 2 Medium 800 800 800 800 800 3 Large 600 600 600 600 600 4 Extra Large 500 500 500 500 500 Table Name Master Equipment List Rows 9 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 10 10 Field Access 0 0 Field Names Equipment Description 1 Mixer 0 2 Agglomerator 0 3 Pre-Dryer 0 4 Final Dryer 0 5 Container Supply 0 6 Filler 0 7 Sealer 0 8 Conveyor 0 9 Case Packer 0 Table Name Making 1 Equipment Failures Rows 4 Cols 3 Table Format 0 Table Note Field Notes Index=Master Equipment List; Equipment Field Types 1 0 0 Field Formats 10 12 12 Field Access 0 0 0 Field Names Equipment TBF TTR 1 Mixer [exponential,10000,,,,) "[normal,10,1,,,]" 2 Agglomerator "[exponential,10000,,,,]" "[normal,10,1,,,]" 3 Pre-Dryer "[exponential,10000,,,,]" "[normal,10,1,,,]" 4 Final Dryer "[exponential,10000,,,,]" "[normal,10,1,,,]" Table Name Making 2 Equipment Failures Rows 4 Cols 3 Table Format 0 Table Note Field Notes Index=Master Equipment List; Equipment Field Types 1 0 0 Field Formats 10 12 12 Field Access 0 0 0 Field Names Equipment TBF TTR 1 Mixer "[exponential,10000,,,,]" "[normal,10,1,,,]" 2 Agglomerator "[exponential,10000,,,,]" "[normal,10,1,,,]" 3 Pre-Dryer "[exponential,10000,,,,]" "[normal,10,1,,,]" 4 Final Dryer "[exponential,10000,,,,]" "[normal,10,1,,,]" Table Name Packing 1 Equipment Failures Rows 5 Cols 3 Table Format 0 Table Note Field Notes Index=Master Equipment List; Equipment Field Types 1 0 0 Field Formats 10 12 12 Field Access 0 0 0 Field Names Equipment TBF TTR 1 Container Supply "[exponential,10000,,,,]" "[normal,10,1,,,]" 2 Filler "[exponential,10000,,,,]" "[normal,10,1,,,]" 3 Sealer "[exponential,10000,,,,]" "[normal,10,1,,,]" 4 Conveyor "[exponential,10000,,,,]" "[normal,10,1,,,]" 5 Case Packer "[exponential,10000,,,,]" "[normal,10,1,,,]" Table Name Packing 2 Equipment Failures Rows 5 Cols 3 Table Format 0 Table Note Field Notes Index=Master Equipment List; Equipment Field Types 1 0 0 Field Formats 10 12 12 Field Access 0 0 0 Field Names Equipment TBF TTR 1 Container Supply "[exponential,10000,,,,]" "[normal,10,1,,,]" 2 Filler "[exponential,10000,,,,]" "[normal,10,1,,,]" 3 Sealer "[exponential,10000,,,,]" "[normal,10,1,,,]" 4 Conveyor "[exponential,10000,,,,]" "[normal,10,1,,,]" 5 Case Packer "[exponential,10000,,,,]" "[normal,10,1,,,]" Table Name Packing 3 Equipment Failures Rows 5 Cols 3 Table Format 0 Table Note Field Notes Index=Master Equipment List; Equipment Field Types 1 0 0 Field Formats 10 12 12 Field Access 0 0 0 Field Names Equipment TBF TTR 1 Container Supply "[exponential,10000,,,,]" "[normal,10,1,,,]" 2 Filler "[exponential,10000,,,,]" "[normal,10,1,,,]" 3 Sealer "[exponential,10000,,,,]" "[normal,10,1,,,]" 4 Conveyor "[exponential,10000,,,,]" "[normal,10,1,,,]" 5 Case Packer "[exponential,10000,,,,]" "[normal,10,1,,,]" Table Name Scheduled DT Directory Rows 1 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 1 Field Formats 0 0 0 Field Access 0 0 0 Field Names Name Type Description 1 Scheduled Maintenance 0 Table Name Scheduled Maintenance Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=Days;Day Index=Time Units;Units Index=Scheduled DT Cycles;Cycle Field Types 1 0 0 1 1 1 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Start Day Time Duration Units Cycle Description 1 Mon 8 2 hours Bi-Weekly Wash Down Table Name Scheduled DT Cycles Rows 7 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Cycle Description 1 Once only no cycle 2 Shift (8 hrs) every eight hours 3 Shift (10 hrs) every ten hours 4 Shift (12 hrs) every twelve hours 5 Daily every twenty-four hours 6 Weekly every seven days 7 Bi-Weekly every fourteen days Table Name Time Units Rows 5 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Units Description 1 seconds 0 2 minutes 0 3 hours 0 4 days 0 5 weeks 0 Table Name Changeovers Directory Rows 2 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 1 Field Formats 0 0 0 Field Access 0 0 0 Field Names Table Attribute Lookup Table Attribute Lookup Field 1 Changeovers: Flavor Materials-Finished Flavor 2 Changeovers: Package Size Materials-Finished Size Table Name Changeovers: Flavor Rows 4 Cols 5 Table Format 0 Table Note Field Notes Index=Product Flavors;Flavor Field Types 1 0 0 0 0 Field Formats 10 12 12 12 12 Field Access 0 0 0 0 0 Field Names From Chocolate Vanilla Strawberry Raspberry Crunch 1 Chocolate 0 10 10 10 2 Vanilla 10 0 10 10 3 Strawberry 10 10 0 10 4 Raspberry Crunch 10 10 10 0 Table Name Changeovers: Package Size Rows 4 Cols 5 Table Format 0 Table Note Field Notes Index=Package Sizes;Size Field Types 1 0 0 0 0 Field Formats 10 12 12 12 12 Field Access 0 0 0 0 0 Field Names From small medium large extra large 1 Small 0 10 10 10 2 Medium 10 0 10 10 3 Large 10 10 0 10 4 Extra Large 10 10 10 0 Table Name Shift Patterns Directory Rows 2 Cols 4 Table Format 0 Table Note Field Notes Index=Days;Day Field Types 1 1 0 1 Field Formats 0 0 0 0 Field Access 0 0 0 0 Field Names Name Start Day start hour Description 1 5 Days 3 Shifts Mon 1 2 7 Days 3 Shifts Mon 1 Table Name 5 Days 3 Shifts Rows 7 Cols 3 Table Format 0 Table Note Field Notes Field Types 0 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names 1 2 3 1 8 8 8 2 8 8 8 3 8 8 8 4 8 8 8 5 8 8 8 6 -8 -8 -8 7 -8 -8 -8 Table Name 7 Days 3 Shifts Rows 7 Cols 3 Table Format 0 Table Note Field Notes Field Types 0 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names 1 2 3 1 8 8 8 2 8 8 8 3 8 8 8 4 8 8 8 5 8 8 8 6 8 8 8 7 8 8 8 Table Name Days Rows 7 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Day 1 Mon 2 Tue 3 Wed 4 Thu 5 Fri 6 Sat 7 Sun Table Name Report Types Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Raw Data In order of Production Run start. 2 Sorted Sorted by field from left to right. 3 Consolidated 0 Table Name Reports Rows 11 Cols 4 Table Format 0 Table Note Field Notes Index=Report Types;Name Index=Yes/No;Name Index=Yes/No;Name Field Types 1 1 1 1 Field Formats 0 0 0 0 Field Access 0 0 0 0 Field Names Name Type Totals Sub-Totals 1 Making Report Sorted yes no 2 Packing Report Sorted 3 3 unused 4 4 unused 5 5 unused 6 6 unused 7 7 unused 8 8 unused 9 9 unused 10 10 unused 11 11 unused Table Name Making Report Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=System Directory;Name Index=Materials -Raw;Flavor Field Types 2 1 1 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Run System Product Quantity Start Time End Time 1 0 0 0 0 Table Name Packing Report Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=System Directory;Name Index=Materials-Finished;SKU Field Types 2 1 1 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Run System SKU Quantity Start Time End Time 1 0 0 0 0 Table Name Yes/no Rows 2 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 yes 2 no Table Name Start Date Rows 1 Cols 1 Table Format 0 Table Note Field Notes Make this a Monday always. Field Types 2 Field Formats 61 Field Access 0 Field Names Start Date 1 36010 Table Name Initial Inventory Rows 105 Cols 2 Table Format 0 Table Note Field Notes Listed in same order as for SKU table. At the start of the model. Corresponds to Time 0. Field Types 1 2 Field Formats 0 12 Field Access 0 0 Field Names SKU MSU 1 SKU1 0 2 SKU2 0 3 SKU3 0 4 SKU4 0 5 SKU5 0 6 SKU6 0 7 SKU7 0 8 SKU8 0 9 SKU9 0 10 SKU10 0 11 SKU11 0 12 SKU12 0 13 SKU13 0 14 SKU14 0 15 SKU15 0 16 SKU16 0 17 SKU17 0 18 SKU18 0 19 SKU19 0 20 SKU20 0 21 SKU21 0 22 SKU22 0 23 SKU23 0 24 SKU24 0 25 SKU25 0 26 SKU26 0 27 SKU27 0 28 SKU28 0 29 SKU29 0 30 SKU30 0 31 SKU31 0 32 SKU32 0 33 SKU33 0 34 SKU34 0 35 SKU35 0 36 SKU36 0 37 SKU37 0 38 SKU38 0 39 SKU39 0 40 SKU40 0 41 SKU41 0 42 SKU42 0 43 SKU43 0 44 SKU44 0 45 SKU45 0 46 SKU46 0 47 SKU47 0 48 SKU48 0 49 SKU49 0 50 SKU50 0 51 SKU51 0 52 SKU52 0 53 SKU53 0 54 SKU54 0 55 SKU55 0 56 SKU56 0 57 SKU57 0 58 SKU58 0 59 SKU59 0 60 SKU60 0 61 SKU61 0 62 SKU62 0 63 SKU63 0 64 SKU64 0 65 SKU65 0 66 SKU66 0 67 SKU67 0 68 SKU68 0 69 SKU69 0 70 SKU70 0 71 SKU71 0 72 SKU72 0 73 SKU73 0 74 SKU74 0 75 SKU75 0 76 SKU76 0 77 SKU77 0 78 SKU78 0 79 SKU79 0 80 SKU80 0 81 SKU81 0 82 SKU82 0 83 SKU83 0 84 SKU84 0 85 SKU85 0 86 SKU86 0 87 SKU87 0 88 SKU88 0 89 SKU89 0 90 SKU90 0 91 SKU91 0 92 SKU92 0 93 SKU93 0 94 SKU94 0 95 SKU95 0 96 SKU96 0 97 SKU97 0 98 SKU98 0 99 SKU99 0 100 SKU100 0 101 SKU101 0 102 SKU102 0 103 SKU103 0 104 SKU104 0 105 SKU105 0 EndofFile