'preorder_receive_reconcile', 'label' => 'Received vs ERP', 'description' => '', 'scope' => 'local', 'source' => 'sql', 'sql' => $aieo_prr_sql, 'registry_id' => 'supplier_orders.receive_reconcile', 'version' => '1', 'per_page' => 25, 'row_key' => 'id', 'default_sort' => array( 'received_at', 'desc' ), 'empty_state' => 'Nothing received yet. Lines appear as pre-orders are marked received in the queue above.', 'columns' => array( array( 'key' => 'id', 'label' => 'ID', 'type' => 'id', 'sortable' => true, 'hidden' => true, ), array( 'key' => 'received_at', 'label' => 'Received at', 'type' => 'datetime', 'width' => '150px', 'nowrap' => true, 'sortable' => true, 'filter' => 'date_range', 'format' => array( 'tz' => 'utc' ), ), array( 'key' => 'branch', 'label' => 'Branch', 'type' => 'text', 'filter' => 'select', ), array( 'key' => 'product', 'label' => 'Product', 'type' => 'text', 'sortable' => true, 'searchable' => true, 'truncate' => 42, 'tooltip' => true, ), array( 'key' => 'sku', 'label' => 'SKU', 'type' => 'code', 'searchable' => true, ), array( 'key' => 'supplier', 'label' => 'Supplier', 'type' => 'text', 'sortable' => true, 'filter' => 'select', 'empty' => '— unresolved —', ), array( 'key' => 'batch_ref', 'label' => 'Batch', 'type' => 'code', 'width' => '130px', 'filter' => 'text', 'empty' => '—', ), array( 'key' => 'requested_qty', 'label' => 'Want', 'type' => 'integer', 'width' => '64px', 'sortable' => true, ), array( 'key' => 'received_qty', 'label' => 'Received', 'type' => 'integer', 'width' => '80px', 'sortable' => true, ), array( 'key' => 'short_qty', 'label' => 'Short', 'type' => 'integer', 'width' => '70px', 'sortable' => true, 'filter' => 'number_range', 'empty_zero' => true, ), array( 'key' => 'erp_stock', 'label' => 'ERP stock now', 'type' => 'decimal', 'width' => '110px', 'sortable' => true, 'format' => array( 'precision' => 0 ), 'empty' => '—', ), ), );