| Table T_Replenish |
| PRIMARY KEY | ||
|
AD_PInstance_ID
NUMBER (10, 0) NOT NULL | AD_PInstance | |
|
M_Warehouse_ID
NUMBER (10, 0) NOT NULL | M_Warehouse | |
|
M_Product_ID
NUMBER (10, 0) NOT NULL | M_Product | |
|
AD_Client_ID
NUMBER (10, 0) NOT NULL | ||
|
AD_Org_ID
NUMBER (10, 0) NOT NULL | ||
|
QtyOnHand
NUMBER default: 0 | Total of M_Movements.MovementQty | |
|
QtyReserved
NUMBER default: 0 | Total of M_Reservation.ReservationQty | |
|
QtyOrdered
NUMBER default: 0 | ||
|
ReplenishType
CHAR (1) NOT NULL | ||
|
Level_Min
NUMBER default: 0 NOT NULL | ||
|
Level_Max
NUMBER default: 0 NOT NULL | ||
|
C_BPartner_ID
NUMBER (10, 0) | ||
|
Order_Min
NUMBER default: 0 | ||
|
Order_Pack
NUMBER default: 0 | ||
|
QtyToOrder
NUMBER default: 0 | ||
FOREIGN KEY ADPInstance_TReplenish: AD_PInstance_ID => AD_PInstance MProduct_TReplenish: M_Product_ID => M_Product MWarehouse_TReplenish: M_Warehouse_ID => M_Warehouse | ||