Table Schema: mf_delivery_items

This topic describes the columns in the mf_delivery_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
delivery_item_guid uniqueidentifier 1 0 1   0  
delivery_guid uniqueidentifier 0 0 2   0 mf_deliveries.delivery_guid
item_guid uniqueidentifier 0 0 3   0  
site_location_guid uniqueidentifier 0 1 4   0  
delivery_item_line_id smallint 0 1 5   0  
delivery_item_quantity int 0 0 6   0  
delivery_item_description varchar (255) 0 1 7   0  
delivery_item_received tinyint 0 0 8   0  
delivery_item_void tinyint 0 0 9   0  
delivery_item_closed tinyint 0 0 10   0  
lu_dt datetime 0 0 11   0  
cr_dt datetime 0 0 12   0  
lu_guid uniqueidentifier 0 1 13   0  
cr_guid uniqueidentifier 0 1 14   0  

Return to index of tables