WHS_QTY: AccountView Inventory quantities warehouses
read only per partition
- Katalog:
AccountView - Label: Inventory quantities warehouses
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle WHS_QTY sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ART_ |
varchar2 |
Artikelcode | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
QTY_ |
decimal |
Quantity processed | |||
QTY_ |
decimal |
Quantity available | |||
QTY_ |
decimal |
Quantity economic | |||
QTY_ |
decimal |
Quantity free | |||
QTY_ |
decimal |
Quantity deferred | |||
QTY_ |
decimal |
Quantity in process | |||
QTY_PO |
decimal |
Quantity ordered (purchase) | |||
QTY_ |
decimal |
Quantity received (purchase) | |||
QTY_ |
decimal |
Quantity reserved | |||
QTY_ |
decimal |
Quantity on backorder (sales) | |||
QTY_ |
decimal |
Quantity shipped (sales) | |||
QTY_SO |
decimal |
Quantity on order (sales) | |||
QTY_ |
decimal |
Number of stock movements | |||
QTY_ |
decimal |
Quantity technical | |||
QTY_ |
decimal |
Quantity in work in progress | |||
QTYB_ |
decimal |
Quantity processed, blocked | |||
QTYB_ |
decimal |
Quantity available, blocked | |||
QTYB_ |
decimal |
Quantity economic, blocked | |||
QTYB_ |
decimal |
Quantity free, blocked | |||
QTYB_ |
decimal |
Quantity deferred, blocked | |||
QTYB_ |
decimal |
Quantity in process, blocked | |||
QTYB_ |
decimal |
Quantity ordered, blocked (purchase) | |||
QTYB_ |
decimal |
Quantity received, blocked (purchase) | |||
QTYB_ |
decimal |
Quantity reserved, blocked | |||
QTYB_ |
decimal |
Quantity on backorder, blocked (sales) | |||
QTYB_ |
decimal |
Quantity shipped, blocked (sales) | |||
QTYB_ |
decimal |
Quantity on order, blocked (sales) | |||
QTYB_ |
decimal |
Number of stock movements, blocked | |||
QTYB_ |
decimal |
Quantity technical, blocked | |||
QTYB_ |
decimal |
Quantity in work in progress, blocked | |||
QTYF_ |
decimal |
Quantity processed, not blocked | |||
QTYF_ |
decimal |
Quantity available, not blocked | |||
QTYF_ |
decimal |
Quantity economic, not blocked | |||
QTYF_ |
decimal |
Quantity free, not blocked | |||
QTYF_ |
decimal |
Quantity deferred, not blocked | |||
QTYF_ |
decimal |
Quantity in process, not blocked | |||
QTYF_ |
decimal |
Quantity ordered, not blocked (purchase) | |||
QTYF_ |
decimal |
Quantity received, not blocked (purchase) | |||
QTYF_ |
decimal |
Quantity reserved, not blocked | |||
QTYF_ |
decimal |
Quantity on backorder, not blocked (sales) | |||
QTYF_ |
decimal |
Quantity shipped, not blocked (sales) | |||
QTYF_ |
decimal |
Quantity on order, not blocked (sales) | |||
QTYF_ |
decimal |
Number of stock movements, not blocked | |||
QTYF_ |
decimal |
Quantity technical, not blocked | |||
QTYF_ |
decimal |
Quantity in work in progress, not blocked | |||
WHS_ |
varchar2 |
Warehouse code |