File_Name: Simple SC Demo Table Name Excel Tabs Rows 28 Cols 2 Table Format 0 Table Note Each table and its associated tab are defined here. [Help:C:\Extend5\Help\SDI Industry Help.hlp/Tabs] Field Notes Select table and use DB Menu|Go to Selected Table Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Tab Name Tab Item 1 Table Outline Excel Tabs 2 Database Structure Indexed Fields 3 Model Structure Item Types 4 Model Structure Location Data 5 Model Structure Order Status 6 Model Structure Priorities 7 Model Structure Shipment Status 8 Model Structure Storage and Handling Costs Units 9 Model Structure Table Help 10 Model Structure Units 11 Model Structure Yes/No Options 12 Model Data Bill of Materials 13 Model Data Demand Multipliers 14 Model Data Demand Profile 15 Model Data Forecast Distribution 16 Model Data Inventories 17 Model Data Inventories (A. Ordering) 18 Model Data Inventories (Age) 19 Model Data Inventories (B. Ordering Calculations) 20 Model Data Inventories (Costs) 21 Model Data Inventories (Filling Orders) 22 Model Data Location Data 23 Model Data Material Trip Costs 24 Model Data Materials Data 25 Model Data Storage and Handling Costs 26 Model Data Total Materials Report 27 Model Data Base Demand 28 Model Data Planned Orders Table Name Indexed Fields Rows 51 Cols 6 Table Format 0 Table Note [Help:C:\Extend5\Help\SDI Industry Help.hlp/Indexed_Fields_Table] Field Notes Field Types 1 1 1 1 2 1 Field Formats 0 0 51 51 0 0 Field Access 0 0 0 0 0 0 Field Names Child Table Child Field Parent Table Parent Field Optional Type 1 Base Demand Product Materials Data Name 1 2 Bill of Materials Material Materials Data Name 1 3 Bill of Materials Part 1 Materials Data Name 1 4 Bill of Materials Part 2 Materials Data Name 1 5 Demand Multipliers Product Materials Data Name 1 6 Forecast Distribution Product Materials Data Name 1 7 Inventories (A. Ordering) Location Location Data Name 1 8 Inventories (A. Ordering) Material Materials Data Name 1 9 Inventories (A. Ordering) Supplier Location Data Name 1 10 Inventories (Age) Location Location Data Name 1 11 Inventories (Age) Material Materials Data Name 1 12 Inventories (B. Ordering Calculations) Location Location Data Name 1 13 Inventories (B. Ordering Calculations) Material Materials Data Name 1 14 Inventories (Costs) Location Location Data Name 1 15 Inventories (Costs) Material Materials Data Name 1 16 Inventories (Filling Orders) Location Location Data Name 1 17 Inventories (Filling Orders) Material Materials Data Name 1 18 Inventories (Required Fields) Location Location Data Name 1 19 Inventories (Required Fields) Material Materials Data Name 1 20 Inventories Location Location Data Name 1 21 Inventories Material Materials Data Name 1 22 Material Trip Costs Point of Origin Location Data Name 1 23 Materials Data Units Units Name 1 24 Orders Customer Location Data Name 1 25 Orders Item Type Item Types Name 1 26 Orders Priority Priorities Name 1 27 Orders Status Order Status Name 1 28 Orders Supplier Location Data Name 1 29 Route Blocks Location Location Data Name 1 30 Shipment Routing Customer Location Data Name 1 31 Shipment Routing Item Type Item Types Name 1 32 Shipment Routing Location Location Data Name 1 33 Shipment Routing Priority Priorities Name 1 34 Shipments Current Location Location Data Name 1 35 Shipments From Location Location Data Name 1 36 Shipments Item Type Item Types Name 1 37 Shipments Item Materials Data Name 1 38 Shipments Priority Priorities Name 1 39 Shipments Status Shipment Status Name 1 40 Shipments To Location Location Data Name 1 41 Simulation Setup Time Units Simulation Time Units Model Time Unit 1 42 Standard Bill of Materials Output Materials Data Name 1 43 Standard Bill of Materials Part Materials Data Name 1 44 Standard Bill of Materials Primary Yes/No Options Name 1 45 Storage and Handling Costs Units Units Units Name 1 46 Storage and Handling Costs Location Location Data Name 1 47 Material Trip Times From Location Location Data Name 1 48 Material Trip Times To Location Location Data Name 1 49 Planned Orders Customer Location Data Name 1 50 Planned Orders Supplier Location Data Name 1 51 Planned Orders Material Materials Data Name 1 Table Name Item Types Rows 1 Cols 7 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Item_Types_Table] Field Notes Field Types 1 1 1 1 1 1 1 Field Formats 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 Field Names Name Data Table Inventory Table Bill of Materials Table Warehousing Costs Table Trip Costs Table Total Items Reports 1 material Materials Data Inventories Bill of Materials Storage and Handling Costs Material Trip Costs Total Materials Report Table Name Location Data Rows 3 Cols 2 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Location_Data_Table] Field Notes Field Types 1 0 Field Formats 0 20 Field Access 0 0 Field Names Name Current Materials in Stock 1 Customer 1 2000 2 Plant 1 3000 3 Supplier 1 10000000 Table Name Order Status Rows 8 Cols 2 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Order_Status_Table] Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 placing 2 placed 3 assigning 4 assigned 5 filling 6 filled 7 delivering 8 delivered Table Name Priorities Rows 3 Cols 2 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Priorities_Table] Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Urgent 2 Regular 3 Low Table Name Shipment Status Rows 7 Cols 2 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Shipment_Status_Table] Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Ready 2 Filling 3 Routing 4 Delivered 5 Loading 6 Loaded 7 Unloading Table Name Storage and Handling Costs Units Rows 1 Cols 1 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Storage_and_Handling_Costs] Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names Units 1 Pallets Table Name Table Help Rows 2 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 2 Field Formats 0 0 0 Field Access 0 0 0 Field Names Table Name Help Exists 1 Standard Bill of Materials [Supply Chain.hlp/Bill_Of_Materials] 1 2 Shipment Status [Supply Chain.hlp/Shipment_Status_Table] 1 Table Name Units Rows 3 Cols 1 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Units_Table] Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 pounds 2 cases 3 Pallets Table Name Yes/No Options Rows 2 Cols 1 Table Format 0 Table Note [Help:C:\Extend5\Help\SUPPLY CHAIN HELP.HLP/Yes_No_Options_Table] Field Notes Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 yes 2 no Table Name Bill of Materials Rows 2 Cols 5 Table Format 0 Table Note Field Notes Field Types 1 1 0 1 0 Field Formats 0 0 0 0 50 Field Access 0 0 0 0 0 Field Names Material Part 1 Quantity Part 2 Quantity 5 1 Material 1 Raw Material 1 2 0 2 Material 2 Raw Material 1 2 0 Table Name Demand Multipliers Rows 2 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 0 Field Formats 0 12 Field Access 0 0 Field Names Product Customer 1 1 Material 1 1 2 Material 2 3 Table Name Demand Profile Rows 3 Cols 2 Table Format 0 Table Note Field Notes Field Types 2 0 Field Formats 61 12 Field Access 0 0 Field Names Effective Date All Materials 1 36281 1 2 36296 3 3 36301 1 Table Name Forecast Distribution Rows 2 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 0 Field Formats 0 12 Field Access 0 0 Field Names Product Customer 1 1 Material 1 "[Normal;1;0.1]" 2 Material 2 "[Normal;1;0.1]" Table Name Inventories Rows 6 Cols 11 Table Format 0 Table Note Field Notes Field Types 1 1 0 0 0 0 0 0 0 0 0 Field Formats 0 0 20 20 20 20 20 20 20 20 20 Field Access 0 0 0 0 0 0 0 0 0 0 0 Field Names Location Material Initial Amount Current Amount Amount In Amount Out Minimum Contents Average Contents Maximum Contents Push Order Point Push Order Amount 1 Customer 1 Material 1 1000 1000 0 0 1000 1000 1000 0 0 2 Customer 1 Material 2 1000 1000 0 0 1000 1000 1000 0 0 3 Plant 1 Material 1 1000 1000 0 0 1000 1000 1000 0 0 4 Plant 1 Material 2 1000 1000 0 0 1000 1000 1000 0 0 5 Plant 1 Raw Material 1 1000 1000 0 0 1000 1000 1000 0 0 6 Supplier 1 Raw Material 1 10000000 10000000 0 0 10000000 10000000 10000000 9990000 500 Table Name Inventories (A. Ordering) Rows 6 Cols 7 Table Format 0 Table Note Field Notes Field Types 1 1 1 0 0 0 0 Field Formats 0 0 0 20 20 20 20 Field Access 0 0 0 0 0 0 0 Field Names Location Material Supplier Target Level Safety Level Maximum Order Minimum Order 1 Customer 1 Material 1 Plant 1 0 1 1 1 2 Customer 1 Material 2 Plant 1 0 1 1 1 3 Plant 1 Material 1 Plant 1 0 1 1 1 4 Plant 1 Material 2 Plant 1 0 0 0 0 5 Plant 1 Raw Material 1 Supplier 1 0 0 0 0 6 Supplier 1 Raw Material 1 0 0 0 0 Table Name Inventories (Age) Rows 6 Cols 6 Table Format 0 Table Note Field Notes Field Types 1 1 0 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Location Material Initial Age Current Average Age Cumulative Average Age Multiplier 1 Customer 1 Material 1 0 0 0 1 2 Customer 1 Material 2 0 0 0 1 3 Plant 1 Material 1 0 0 0 1 4 Plant 1 Material 2 0 0 0 1 5 Plant 1 Raw Material 1 0 0 0 1 6 Supplier 1 Raw Material 1 0 0 0 0 Table Name Inventories (B. Ordering Calculations) Rows 6 Cols 7 Table Format 0 Table Note Field Notes Field Types 1 1 0 0 0 0 0 Field Formats 0 0 0 20 20 20 20 Field Access 0 0 0 0 0 0 0 Field Names Location Material Forecast Daily Demand Amount on Order Time to Fill Order Order Point Order Amount 1 Customer 1 Material 1 0 0 0 0 0 2 Customer 1 Material 2 0 0 0 0 0 3 Plant 1 Material 1 0 0 0 0 0 4 Plant 1 Material 2 0 0 0 0 0 5 Plant 1 Raw Material 1 0 0 0 0 0 6 Supplier 1 Raw Material 1 0 0 0 0 0 Table Name Inventories (Costs) Rows 6 Cols 8 Table Format 0 Table Note Field Notes Field Types 1 1 0 0 0 0 0 0 Field Formats 0 0 42 42 42 42 42 42 Field Access 0 0 0 0 0 0 0 0 Field Names Location Material Initial Cost Cost per Order Cost per Item Delivered Current Average Cost Cumulative Average Cost Value 1 Customer 1 Material 1 1 100 0.01 1 1 1000 2 Customer 1 Material 2 1 100 0.01 1 1 1000 3 Plant 1 Material 1 1 100 0.01 1 1 1000 4 Plant 1 Material 2 1 100 0.01 1 1 1000 5 Plant 1 Raw Material 1 0.5 100 0.01 0.5 0.5 500 6 Supplier 1 Raw Material 1 0.5 100 0.01 0.5 0.5 5000000 Table Name Inventories (Filling Orders) Rows 6 Cols 7 Table Format 0 Table Note Field Notes Field Types 1 1 0 2 0 0 0 Field Formats 0 0 20 20 51 51 51 Field Access 0 0 0 0 0 0 0 Field Names Location Material Unfilled Orders Total Orders Percent of Orders Filled Percent Out of Stock Clear Unfilled Orders 1 Customer 1 Material 1 0 0 0 0 0 2 Customer 1 Material 2 0 0 0 0 0 3 Plant 1 Material 1 0 0 0 0 0 4 Plant 1 Material 2 0 0 0 0 0 5 Plant 1 Raw Material 1 0 0 0 0 0 6 Supplier 1 Raw Material 1 0 0 0 0 0 Table Name Location Data Rows 3 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 0 Field Formats 0 20 Field Access 0 0 Field Names Name Current Materials in Stock 1 Customer 1 2000 2 Plant 1 3000 3 Supplier 1 10000000 Table Name Material Trip Costs Rows 2 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 0 0 Field Formats 0 42 42 Field Access 0 0 0 Field Names Point of Origin Plant 1 Customer 1 1 Supplier 1 0 0 2 Plant 1 0 0 Table Name Materials Data Rows 3 Cols 4 Table Format 0 Table Note Field Notes Field Types 1 1 2 2 Field Formats 0 0 20 20 Field Access 0 0 0 0 Field Names Name Units Pounds per Unit Units per Pallet 1 Material 1 cases 1 400 2 Material 2 cases 1 400 3 Raw Material 1 pounds 1 800 Table Name Storage and Handling Costs Rows 3 Cols 6 Table Format 0 Table Note Field Notes Field Types 1 0 0 0 0 0 Field Formats 0 42 42 42 42 42 Field Access 0 0 0 0 0 0 Field Names Location Receiving Cost Storage Overhead Storage Cost Per Day Shipping Cost Current Daily Cost 1 Supplier 1 0 0 0 0 0 2 Customer 1 0 0 0 0 0 3 Plant 1 0 0 0 0 0 Table Name Total Materials Report Rows 4 Cols 9 Table Format 0 Table Note Field Notes Field Types 1 0 0 0 0 0 0 0 0 Field Formats 0 0 0 0 0 0 42 42 42 Field Access 0 0 0 0 0 0 0 0 0 Field Names Material Initial Amount Current Total Amount Average Amount In Inventories In Transit Value in Inventories Value in Transit Total Value 1 Totals 12002000 12002000 0 12002000 0 7002500 0 7002500 2 Material 1 2000 2000 0 2000 0 2000 0 2000 3 Material 2 2000 2000 0 2000 0 2000 0 2000 4 Raw Material 1 11998000 11998000 0 11998000 0 6998500 0 6998500 Table Name Base Demand Rows 2 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 0 Field Formats 0 12 Field Access 0 0 Field Names Product Customer 1 1 Material 1 50 2 Material 2 50 Table Name Material Trip Times Rows 2 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names From Location To Location Trip Days 1 Plant 1 Customer 1 "[Normal;4.583;0.5]" 2 Supplier 1 Plant 1 "[Normal;4.583;0.5]" Table Name Planned Orders Rows 3 Cols 7 Table Format 0 Table Note Scheduled order streams: recurring or one-shot Field Notes Field Types 1 1 1 2 2 0 0 Field Formats 0 0 0 61 61 20 20 Field Access 0 0 0 0 0 0 0 Field Names Customer Supplier Material Start Date Stop Date Quantity Interval 1 Customer 1 Plant 1 Material 1 36286 36306 200 7 2 Plant 1 Supplier 1 Raw Material 1 36291 0 500 0 3 Plant 1 Supplier 1 Raw Material 1 36296 36341 300 14 EndofFile