{{ config(materialized='table') }}

SELECT
  site_id,
  cus_cust_id,
  warehouse_id,
  cus_cust_id,
  seller_state,
  appointment_date,
  slot_hour,
  dow,                      
  min_appointment_ts,
  min_arrival_ts,
  arrival_delay_min,        
  on_time_flag,
  inventory_id,
  last_inb_status
FROM {{ ref('stg_inbound_operations') }}
WHERE min_appointment_ts IS NOT NULL
