List of values used to filter / join data from a data extract.

Each point represent a Cube

Order extract parameters

  • order_id
  • order_ext_ref
  • order_marking
  • order_contact_id
  • order_pickup_date
  • order_delivery_date
  • order_availability_date
  • outbound_sku_ids Only for incomming orders
  • inbound_sku_ids Only for outgoing orders
  • recipe_ids Only for production orders

Delivery extract parameters

  • order_id
  • order_contact_id
  • order_pickup_date
  • order_delivery_date
  • order_availability_date
  • lot_ids

DeliveryLot extract parameters

  • delivery_lot_sscc_id
  • order_id
  • delivery_id
  • lot_id
  • sku_id

DeliveryLotSscc extract parameters

  • delivery_lot_sscc_id
  • order_id
  • delivery_id
  • sku_id
  • lot_id

OrderInvoice extract parameters

  • invoice_id
  • order_id

Lot extract parameters

  • lot_id
  • sku_id
  • warehouse_location_id

Sku

  • sku_id
  • sku_code
  • auto_recipe_id

B2bProduct extract parameters

  • b2b_product_id
  • sku_ids

Recipe extract parameters

  • recipe_id
  • recipe_ref

Tag extract parameters

  • tag_id
  • tag_name

Partner extract parameters

  • partner_id

TaskOccurrence extract parameters

  • task_occurrence_id
  • task_id
  • collection_model_name
  • collection_entity_id
  • related_model_name
  • related_entity_id

ConnectionEntity extract parameters

  • entity_ref
  • status

TrackerRecord extract parameters

  • record_id
  • record_ref
  • tracked_from
  • tracked_to
  • started_at
  • finished_at
  • tracker_ref
  • free_text_1
  • free_text_2
  • free_int_1
  • free_int_2