Table Schema: mf_inventory_lots

This topic describes the columns in the mf_inventory_lots table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
inventory_lot_guid uniqueidentifier 1 0 1   0  
inventory_guid uniqueidentifier 0 0 2   0 mf_inventories.inventory_guid
item_guid uniqueidentifier 0 0 3   0 mf_items.item_guid
purchase_order_item_guid uniqueidentifier 0 1 4   0  
inventory_lot_id varchar (50) 0 0 5   0  
inventory_lot_label varchar (50) 0 0 6   0  
inventory_lot_label_short varchar (255) 0 0 7   0  
inventory_lot_description varchar (255) 0 0 8   0  
inventory_lot_quantity int 0 0 9   0  
inventory_lot_quantity_on_hand int 0 0 10   0  
inventory_lot_quantity_on_hold int 0 0 11   0  
inventory_lot_quantity_allocated int 0 0 12   0  
inventory_lot_birth_date datetime 0 1 13   0  
inventory_lot_putaway_date datetime 0 1 14   0  
inventory_lot_expiration_date datetime 0 1 15   0  
inventory_lot_available_date datetime 0 1 16   0  
lu_dt datetime 0 1 17   0  
cr_dt datetime 0 1 18   0  
lu_guid uniqueidentifier 0 1 19   0  
cr_guid uniqueidentifier 0 1 20   0  

Return to index of tables