03 Supply Chain Demo
Indexed Fields
5 fields × 71 records
| # | Child TableS | Child FieldS | Parent TableS | Parent FieldS | OptionalI |
|---|---|---|---|---|---|
| 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 |