| #Lines Received |
([transactions_date_time: # Distinct transactions_totalpolines] WHERE ([TRANSACTIONS.transactions_trans_type] = 'RE' OR [TRANSACTIONS.transactions_trans_type] = 'RZ'))
|
| #Lines Put Away |
([transactions_date_time: # Distinct transactions_totalpolines] WHERE [TRANSACTIONS.transactions_trans_type] = 'PA')
|
| #Lines Picked |
([transactions_date_time: # Distinct transactions_totalorders] WHERE ([TRANSACTIONS.transactions_trans_type] = 'IG'))
|
| #Cycle Counts |
([transactions_date_time: # Distinct trans_num] WHERE ([TRANSACTIONS.transactions_trans_type] = 'CS'))
|
| #Orders Dropped |
[transactions_date_time: # Distinct transactions_totalorders] WHERE [TRANSACTIONS.transactions_trans_type]='OD'
|
| #Orders Shipped |
([transactions_date_time: # Distinct transactions_totalorders] WHERE ([TRANSACTIONS.transactions_trans_type] = 'SO'))
|
| #PO Closed |
([transactions_date_time: # Distinct transactions_totalponos] WHERE ([TRANSACTIONS.transactions_trans_type] = 'RC'))
|
| #Products Moved |
([transactions_date_time: # Distinct transactions_abs_num] WHERE ([TRANSACTIONS.transactions_trans_type] = 'MS'))
|
| #Lines Picked |
([transactions_date_time: # Distinct transactions_totaloelines] WHERE ([TRANSACTIONS.transactions_trans_type] = 'IG'))
|
| #Cartons Picked |
([transactions_date_time: # Distinct transactions_pallet_id] WHERE [TRANSACTIONS.transactions_trans_type]='IG')
|
| #Locations Picked |
([transactions_date_time: # Distinct transactions_abs_num] WHERE [TRANSACTIONS.transactions_trans_type]='IG')
|
| #Orders Picked |
([transactions_date_time: # Distinct transactions_totalorders] WHERE ([TRANSACTIONS.transactions_trans_type] = 'IG'))
|
| #Cartons Put Away |
([transactions_date_time: # Distinct transactions_pallet_id] WHERE [TRANSACTIONS.transactions_trans_type]='PA')
|
| #Locations Put Away |
([transactions_date_time: # Distinct transactions_abs_num] WHERE [TRANSACTIONS.transactions_trans_type]='PA')
|
| #POs Put Away |
([transactions_date_time: # Distinct transactions_abs_num] WHERE [TRANSACTIONS.transactions_trans_type]='PA')
|
| #PO Lines Received |
([transactions_date_time: # Distinct transactions_totalpolines] WHERE ([TRANSACTIONS.transactions_trans_type] = 'RE' OR [TRANSACTIONS.transactions_trans_type] = 'RZ'))
|
| #Received POs on the dock |
([transactions_date_time: # Distinct transactions_pallet_id] WHERE (([TRANSACTIONS.transactions_trans_type] = 'RE' OR [TRANSACTIONS.transactions_trans_type] = 'RZ') AND [TRANSACTIONS.transactions_bin_num] LIKE '%dock%'))
|
| #Received Cartons on the dock |
([transactions_date_time: # Distinct transactions_pallet_id] WHERE (([TRANSACTIONS.transactions_trans_type] = 'RE' OR [TRANSACTIONS.transactions_trans_type] = 'RZ') AND [TRANSACTIONS.transactions_bin_num] LIKE '%dock%'))
|
| #POs Received |
([transactions_date_time: # Distinct transactions_totalponos] WHERE ([TRANSACTIONS.transactions_trans_type] = 'RE' OR [TRANSACTIONS.transactions_trans_type] = 'RZ'))
|
| #Received Products on the dock |
([transactions_date_time: # Distinct transactions_abs_num] WHERE ([TRANSACTIONS.transactions_trans_type]='RE' OR [TRANSACTIONS.transactions_trans_type] = 'RZ' )AND [TRANSACTIONS.transactions_bin_num] LIKE 'dock%')
|
| #Products Counted |
([transactions_date_time: # Distinct transactions_abs_num] WHERE ([TRANSACTIONS.transactions_trans_type] = 'CS'))
|
| #Locations Counted |
([transactions_date_time: # transactions_bin_num] WHERE [TRANSACTIONS.transactions_trans_type]='CS')
|
| %Locations Counted |
(([transactions_date_time: # Distinct transactions_bin_num] WHERE [TRANSACTIONS.transactions_trans_type] = 'CS')/[binmst_transaction_date: # Distinct binmst_bin_num])
|
| %Products Counted |
(([transactions_date_time: # Distinct transactions_abs_num] WHERE [TRANSACTIONS.transactions_trans_type] = 'CS')/[transactions_date_time: # Distinct item_abs_num])
|