Query "Bin Content by Item Tracking"
Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0.
Properties
| Name | Value |
|---|---|
| Caption | Bin Content by Item Tracking |
| QueryType | Normal |
| DataAccessIntent | ReadOnly |
| AboutText | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Location_Code | Warehouse_Entry | Code[10] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Bin_Code | Warehouse_Entry | Code[20] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Item_No | Warehouse_Entry | Code[20] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Variant_Code | Warehouse_Entry | Code[10] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Unit_of_Measure_Code | Warehouse_Entry | Code[10] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Lot_No | Warehouse_Entry | Code[50] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Serial_No | Warehouse_Entry | Code[50] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Package_No | Warehouse_Entry | Code[50] | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |
| Sum_Qty_Base | Warehouse_Entry | Decimal | Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0. |