# WHS_QTY: Inventory quantities warehouses - Name: `WHS_QTY` - Catalog: `AccountView` - Label: Inventory quantities warehouses - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `WHS_QTY` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ART_CODE` | `string(15)` | Article Code | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `QTY_ACT` | `decimal` | Quantity processed | ☐ | | | `QTY_AVAIL` | `decimal` | Quantity available | ☐ | | | `QTY_ECON` | `decimal` | Quantity economic | ☐ | | | `QTY_FREE` | `decimal` | Quantity free | ☐ | | | `QTY_JOUR` | `decimal` | Quantity deferred | ☐ | | | `QTY_MFG` | `decimal` | Quantity in process | ☐ | | | `QTY_PO` | `decimal` | Quantity ordered (purchase) | ☐ | | | `QTY_RECD` | `decimal` | Quantity received (purchase) | ☐ | | | `QTY_RES` | `decimal` | Quantity reserved | ☐ | | | `QTY_SBO` | `decimal` | Quantity on backorder (sales) | ☐ | | | `QTY_SHIP` | `decimal` | Quantity shipped (sales) | ☐ | | | `QTY_SO` | `decimal` | Quantity on order (sales) | ☐ | | | `QTY_TBJ` | `decimal` | Number of stock movements | ☐ | | | `QTY_TECH` | `decimal` | Quantity technical | ☐ | | | `QTY_WIP` | `decimal` | Quantity in work in progress | ☐ | | | `QTYB_ACT` | `decimal` | Quantity processed, blocked | ☐ | | | `QTYB_AVAIL` | `decimal` | Quantity available, blocked | ☐ | | | `QTYB_ECON` | `decimal` | Quantity economic, blocked | ☐ | | | `QTYB_FREE` | `decimal` | Quantity free, blocked | ☐ | | | `QTYB_JOUR` | `decimal` | Quantity deferred, blocked | ☐ | | | `QTYB_MFG` | `decimal` | Quantity in process, blocked | ☐ | | | `QTYB_PO` | `decimal` | Quantity ordered, blocked (purchase) | ☐ | | | `QTYB_RECD` | `decimal` | Quantity received, blocked (purchase) | ☐ | | | `QTYB_RES` | `decimal` | Quantity reserved, blocked | ☐ | | | `QTYB_SBO` | `decimal` | Quantity on backorder, blocked (sales) | ☐ | | | `QTYB_SHIP` | `decimal` | Quantity shipped, blocked (sales) | ☐ | | | `QTYB_SO` | `decimal` | Quantity on order, blocked (sales) | ☐ | | | `QTYB_TBJ` | `decimal` | Number of stock movements, blocked | ☐ | | | `QTYB_TECH` | `decimal` | Quantity technical, blocked | ☐ | | | `QTYB_WIP` | `decimal` | Quantity in work in progress, blocked | ☐ | | | `QTYF_ACT` | `decimal` | Quantity processed, not blocked | ☐ | | | `QTYF_AVAIL` | `decimal` | Quantity available, not blocked | ☐ | | | `QTYF_ECON` | `decimal` | Quantity economic, not blocked | ☐ | | | `QTYF_FREE` | `decimal` | Quantity free, not blocked | ☐ | | | `QTYF_JOUR` | `decimal` | Quantity deferred, not blocked | ☐ | | | `QTYF_MFG` | `decimal` | Quantity in process, not blocked | ☐ | | | `QTYF_PO` | `decimal` | Quantity ordered, not blocked (purchase) | ☐ | | | `QTYF_RECD` | `decimal` | Quantity received, not blocked (purchase) | ☐ | | | `QTYF_RES` | `decimal` | Quantity reserved, not blocked | ☐ | | | `QTYF_SBO` | `decimal` | Quantity on backorder, not blocked (sales) | ☐ | | | `QTYF_SHIP` | `decimal` | Quantity shipped, not blocked (sales) | ☐ | | | `QTYF_SO` | `decimal` | Quantity on order, not blocked (sales) | ☐ | | | `QTYF_TBJ` | `decimal` | Number of stock movements, not blocked | ☐ | | | `QTYF_TECH` | `decimal` | Quantity technical, not blocked | ☐ | | | `QTYF_WIP` | `decimal` | Quantity in work in progress, not blocked | ☐ | | | `WHS_CODE` | `string(5)` | Warehouse code | ☐ | |