SCIS default derived data rules - IBM/intelligence-suite-supply-chain-solutions GitHub Wiki
Order and shipment status
See Order and shipment KPI calculations for more information
Calculate shipment status on Shipment
- rule: dd-shipment-status-by-date.json
- output fields: Shipment.statusByDate
- name: "Shipment-statusByDate" - e60f2d67-5634-47b8-880c-ed669b555ab0
Calculate shipment status on ShipmentLine
- rule: dd-shipmentline-status-by-date.json
- output fields: ShipmentLine.statusByDate
- name: "shipmenLine_statusByDate_rule" - 81616545-0866-4a46-bb92-1c2539d8c20b
Calculate shipment status on Order
- rule: dd-order-shipment-status-by-date.json
- output fields: Order.shipmentStatusByDate
- name: "Order-shipmentStatusByDate" - e399270e-8789-4e36-8841-bd71d23b38e8
Calculate shipment status on OrderLine
- rule: dd-orderline-shipment-status-by-date.json
- output fields: OrderLine.shipmentStatusByDate
- name: "Orderline.shipmentStatusByDate" - 72f29144-bfcb-45d3-b896-38e3095499a4
Calculate delivery status on Order
- rule: dd-order-delivery-status-by-date.json
- output fields: Order.deliveryStatusByDate
- name: "Order-deliveryStatusByDate" - e534c5d9-4652-42d1-8340-91e7108b5cc5
Calculate delivery status on OrderLine
- rule: dd-orderline-delivery-status-by-date.json
- output fields: OrderLine.deliveryStatusByDate
- name: "OrderLine-deliveryStatusByDate" - 82fcbd0c-98ee-438a-8f18-ca98b8fc1cb5-
Order and shipment delay
See Order and shipment KPI calculations for more information
Calculate various days late on Order
- rule: dd-order-delays.json
- output fields:
- Order.plannedShipDelay
- Order.plannedDeliveryDelay
- Order.actualShipDelay
- Order.estimatedDeliveryDelay
- Order.actualDeliveredDelay
- name: "CaculateLateOrder" - 8bd65191-782e-4360-b82a-d7f31d51bf29
Calculate various days late on OrderLine
- rule: dd-orderline-delays.json
- output fields:
- OrderLine.plannedShipDelay
- OrderLine.plannedDeliveryDelay
- OrderLine.actualShipDelay
- OrderLine.estimatedDeliveryDelay
- OrderLine.actualDeliveredDelay
- name: "Late Order Lines" - da579187-0259-4d4e-8897-e8642b818192
Calculate various days late on Shipment
- rule: dd-shipment-delays.json
- output fields:
- Shipment.estimatedDeliveryDelay
- Shipment.predictedDeliveryDelay
- Shipment.actualDeliveryDelay
- name: "delivered_rule_late_shipment" - d8023940-5699-4943-a5be-67ef98680f46
Shipments in transit count
See Order and shipment KPI calculations for more information
Count number of shipments in status on Order
- rule: dd-order-shipments-in-transit.json
- output fields: Order.shipmentsInTransit
- name: "order_shipmentsInTransit_rule" - d0c1573a-d83f-4ce8-be70-828faa9304de
Count number of shipments in status on OrderLine
- rule: dd-orderline-shipments-in-transit.json
- output fields: OrderLine.shipmentsInTransit
- name: "orderLine_shipmentsInTransit_rule" - 31be1fa1-2607-4ce8-bbf3-d20ad02bfd69
Inventory measurements to thresholds
Calculate quantity / days of supply above and below thresholds
- rule: dd-inventory-above-below.json
- output fields:
- quantityAboveUpperThreshold = quantity - quantityUpperThreshold
- quantityBelowLowerThreshold = quantityLowerThreshold - quantity
- daysOfSupplyAboveUpperThreshold = daysOfSupply - daysOfSupplyUpperThreshold
- daysOfSupplyBelowLowerThreshold = daysOfSupplyLowerThreshold - daysOfSupply
- name: "Inventory Update Threshold" - f00c583d-ddc2-4365-9030-2330982fb8a2
Order allocation
Calculate product measurements based on allocation to orders
- rule: dd-product-allocation-metrics.json
- output fields:
- Product.shortageRevenue
- Product.quantityNeeded
- Product.quantityAllocated
- name: "Product Combined rule" - 195887d3-9053-4c88-9d12-d8d7b202b1d5
Calculate open quantity a product on OrderLine
- rule: dd-orderline-open-quantity.json
- output fields: OrderLine.openQuantity
- name: "Order.OrderLine.openQuantity" - 022a0d53-110a-4a01-80f7-0c5d41b8acc7
Calculate a product shortage on an OrderAllocation
- rule: dd-orderallocation-quantity-short.json
- output fields: OrderAllocation.quantityShort
- name: "Product OrderAllocation quantityShort" - 07f1d0e0-e8d9-4b84-a8c7-bbdefce1bb78