POQ_TIME: AccountView Inventory quantities over time
read only per partition
- Catalog:
AccountView - Label: Inventory quantities over time
Can only retrieve data.
Table Columns
The columns of the table POQ_TIME are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
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_ |
decimal |
Minimum quantity until next delivery date | |||
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 |
Min. quantity until next del. date, 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 | |||
REC_ID |
varchar2 |
Unique code |